Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.199 ms
Record Count: 21
Cached: Yes
Cache Type: timespan
Datasource: newccar
Lazy: No
SQL:
SELECT long_value, display, url, GROUP_CONCAT(short_value SEPARATOR ',') AS areas FROM L_Area_Lookup GROUP BY display ORDER BY display ASC
long_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A
Query
Template: /themes/irishoward/page_templates/mls.cfm:75
Execution Time: 2.82 ms
Record Count: 21
Cached: No
Datasource: newccar
Lazy: No
SQL:
SELECT long_value, display, url, GROUP_CONCAT(short_value SEPARATOR ',') AS areas FROM L_Area_Lookup GROUP BY display ORDER BY display ASC
long_valuedisplayurlareas
154A Andrews Are--includes city oAndrewsandrews54A
217A Aynor Area--central includesAynoraynor17A,12A,13A
325B Conway Area--between Wacc. RConwayconway25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B
409A Conway to Longs Area--BetweeConway to Longsconway-to-longs09A,09B
510A Conway to Myrtle Beach Area-Conway to Myrtle Beachconway-to-myrtle-beach10A
627A Garden City Mainland & PenniGarden Citygarden-city27A,28C
748A Georgetown Area--Belle IsleGeorgetowngeorgetown48A,52A,53A,46A,50A,47A,49A,51A
841A Pawleys Island Area-LitchfieLitchfield Beachlitchfield-beach41A,42A
904B Little River Area--North ofLittle Riverlittle-river04B,04A
1003A Longs to Little River Area--Longs to Little Riverlongs-to-little-river03A
1102A Loris Area--central includesLorisloris02A,05A,01A
1206A Loris to Conway Area--SouthLoris to Conwayloris-to-conway06A,08A
1307A Loris to Longs Area--South oLoris to Longsloris-to-longs07A,03B
1427B Murrells Inlet - Horry CountMurrells Inletmurrells-inlet27B,40A
1525A Myrtle Beach Area--west of SMyrtle Beachmyrtle-beach25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B
1631B North CarolinaNorth Carolinanorth-carolina31B
1711D North Myrtle Beach Area--AtlNorth Myrtle Beachnorth-myrtle-beach11D,10C,11A,11C,11B,11F,11E
1831A Other counties in South CaroOther Countiesother-counties31A
1931C Not in South Carolina or NorOther Statesother-states31C
2045A Pawleys Island AreaPawleys Islandpawleys-island45A,43A,44A,45B
2128B Surfside Area-Glensbay to GCSurfsidesurfside28B,29A,29B,28A

Find Your New Home

Search for properties

9650 Shore Dr.

Myrtle Beach

$599,000

Property Type: condo

MLS: 2522034

Status: ACTIVE

4800 S Ocean Blvd.

North Myrtle Beach

$160,500

Property Type: condo

MLS: 2522091

Status: ACTIVE

1900 Culbertson Ave.

Myrtle Beach

$413,000

Property Type: townhouse

MLS: 2522330

Status: ACTIVE

6000 N Ocean Blvd.

North Myrtle Beach

$235,000

Property Type: condo

MLS: 2521859

Status: ACTIVE

1356 Glenns Bay Rd.

Surfside Beach

$179,000

Property Type: condo

MLS: 2521839

Status: ACTIVE

1029 Ray Costin Way

Murrells Inlet

$495,000

Property Type: condo

MLS: 2521842

Status: ACTIVE

618 Waterway Village Blvd.

Myrtle Beach

$244,900

Property Type: condo

MLS: 2521846

Status: ACTIVE

5507 N Ocean Blvd.

Myrtle Beach

$399,900

Property Type: condo

MLS: 2521938

Status: ACTIVE

5300 N Ocean Blvd.

Myrtle Beach

$432,500

Property Type: condo

MLS: 2522029

Status: ACTIVE

2504 N Ocean Blvd.

Myrtle Beach

$399,000

Property Type: condo

MLS: 2521775

Status: ACTIVE

501 S Ocean Blvd.

North Myrtle Beach

$170,000

Property Type: condo

MLS: 2521783

Status: ACTIVE

3015 Old Bryan Dr.

Myrtle Beach

$189,999

Property Type: condo

MLS: 2521786

Status: ACTIVE

1011 Menorca Ct.

Little River

$331,900

Property Type: condo

MLS: 2521808

Status: ACTIVE

1013 Menorca Ct.

Little River

$331,900

Property Type: condo

MLS: 2521811

Status: ACTIVE

1017 Menorca Ct.

Little River

$331,900

Property Type: condo

MLS: 2521812

Status: ACTIVE

302 71st Ave. N

Myrtle Beach

$319,900

Property Type: condo

MLS: 2521813

Status: ACTIVE

1020 Menorca Ct.

Little River

$344,900

Property Type: condo

MLS: 2521815

Status: ACTIVE

1008 Menorca Ct.

Little River

$339,900

Property Type: condo

MLS: 2521817

Status: ACTIVE

1004 Menorca Ct.

Little River

$334,900

Property Type: condo

MLS: 2521818

Status: ACTIVE

1111 Blue Stem Dr.

Pawleys Island

$289,000

Property Type: condo

MLS: 2521821

Status: ACTIVE

3923 Gladiola Ct.

Myrtle Beach

$148,500

Property Type: condo

MLS: 2521826

Status: ACTIVE

129 Ashley Park Dr.

Myrtle Beach

$175,000

Property Type: condo

MLS: 2521827

Status: ACTIVE

5750 Oyster Catcher Dr.

North Myrtle Beach

$252,900

Property Type: condo

MLS: 2521877

Status: ACTIVE

3513 S Ocean Blvd.

North Myrtle Beach

$399,900

Property Type: condo

MLS: 2521743

Status: ACTIVE

502 48th Ave. S

North Myrtle Beach

$414,900

Property Type: condo

MLS: 2521687

Status: ACTIVE

5801 Oyster Catcher Dr.

North Myrtle Beach

$249,900

Property Type: condo

MLS: 2521642

Status: ACTIVE

4440 Lady Banks Ln.

Murrells Inlet

$279,900

Property Type: condo

MLS: 2521649

Status: ACTIVE

1701 Yaupon Dr.

Myrtle Beach

$220,000

Property Type: condo

MLS: 2521652

Status: ACTIVE

116 South Waccamaw Dr.

Garden City Beach

$249,900

Property Type: condo

MLS: 2521655

Status: ACTIVE

118 Old Course Rd.

Murrells Inlet

$319,000

Property Type: condo

MLS: 2521664

Status: ACTIVE

549 White River Dr.

Myrtle Beach

$169,900

Property Type: condo

MLS: 2521675

Status: ACTIVE

1100 Possum Trot Rd.

North Myrtle Beach

$117,999

Property Type: condo

MLS: 2521677

Status: ACTIVE

641 Botany Loop

Murrells Inlet

$399,000

Property Type: townhouse

MLS: 2521679

Status: ACTIVE

205 74th Ave. N

Myrtle Beach

$329,900

Property Type: condo

MLS: 2521683

Status: ACTIVE

2364 Elowen Ln.

Longs

$321,865

Property Type: townhouse

MLS: 2521689

Status: ACTIVE

5511 Ocean Blvd. N

Myrtle Beach

$219,900

Property Type: condo

MLS: 2521691

Status: ACTIVE

2366 Elowen Ln.

Longs

$322,860

Property Type: townhouse

MLS: 2521692

Status: ACTIVE

2372 Elowen Ln.

Longs

$368,355

Property Type: townhouse

MLS: 2521694

Status: ACTIVE

3700 Golf Colony Lane

Little River

$159,000

Property Type: condo

MLS: 2521696

Status: ACTIVE

1001 Menorca Ct.

Little River

$331,900

Property Type: condo

MLS: 2521697

Status: ACTIVE

9650 Shore Dr.

Myrtle Beach

$624,900

Property Type: condo

MLS: 2521707

Status: ACTIVE

606 S 7th Ave.

North Myrtle Beach

$260,000

Property Type: condo

MLS: 2521710

Status: ACTIVE

1207 S Ocean Blvd. S

Myrtle Beach

$60,000

Property Type: condo

MLS: 2521714

Status: ACTIVE

191 Maison Dr.

Myrtle Beach

$239,900

Property Type: condo

MLS: 2521716

Status: ACTIVE

4503 W Harbour Ct.

Little River

$239,900

Property Type: condo

MLS: 2521721

Status: ACTIVE

320 Kiskadee Loop

Conway

$239,900

Property Type: condo

MLS: 2521723

Status: ACTIVE

1205 S Ocean Blvd.

Myrtle Beach

$76,999

Property Type: condo

MLS: 2521727

Status: ACTIVE

5905 Highway 17 South

Myrtle Beach

$79,800

Property Type: condo

MLS: 2521732

Status: ACTIVE

2090 Cross Gate Blvd

Surfside Beach

$172,800

Property Type: condo

MLS: 2521734

Status: ACTIVE

1819 N Ocean Blvd.

North Myrtle Beach

$469,900

Property Type: condo

MLS: 2521757

Status: ACTIVE

Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.