Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.192 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: 0.398 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

407 21st Ave. N

North Myrtle Beach

$639,900

Property Type: detached

MLS: 2522400

Status: ACTIVE

6001- MH178 S Kings Hwy.

Myrtle Beach

$375,000

Property Type: manufactured leased land

MLS: 2522472

Status: ACTIVE

6001 - G5 S Kings Hwy.

Myrtle Beach

$599,000

Property Type: detached leased land

MLS: 2522392

Status: ACTIVE

4853 Highway 17

Murrells Inlet

$3,400,000

Property Type: detached

MLS: 2522678

Status: ACTIVE

4890 Highway 319

Aynor

$249,900

Property Type: detached

MLS: 2522269

Status: ACTIVE

5803 Country Club Dr.

Myrtle Beach

$849,900

Property Type: detached

MLS: 2522274

Status: ACTIVE

2948 Moss Bridge Ln.

Myrtle Beach

$699,000

Property Type: detached

MLS: 2522286

Status: ACTIVE

6001 - 1222 S Kings Hwy.

Myrtle Beach

$259,000

Property Type: detached leased land

MLS: 2522288

Status: ACTIVE

1412 Winddrift Ct.

Surfside Beach

$449,000

Property Type: detached

MLS: 2522289

Status: ACTIVE

9060 Binnicker Dr.

Murrells Inlet

$689,000

Property Type: detached

MLS: 2522307

Status: ACTIVE

313 Basswood Ct.

Conway

$331,900

Property Type: detached

MLS: 2522311

Status: ACTIVE

1112 Carolina Cove

North Myrtle Beach

$350,000

Property Type: manufactured with land

MLS: 2522312

Status: ACTIVE

1860 Villena Dr.

Myrtle Beach

$535,500

Property Type: detached

MLS: 2522318

Status: ACTIVE

196 Gray Owl Dr.

Conway

$284,900

Property Type: detached

MLS: 2522326

Status: ACTIVE

196 Gray Owl Dr.

Conway

$284,900

Property Type: detached

MLS: 2522326

Status: ACTIVE

116 Furnies Place

Loris

$454,990

Property Type: detached

MLS: 2522331

Status: ACTIVE

1098 Ridgeford Dr.

Conway

$376,500

Property Type: detached

MLS: 2522332

Status: ACTIVE

1124 Tibetan St.

Conway

$316,905

Property Type: detached

MLS: 2522359

Status: ACTIVE

1073 Hyatt Ave.

Murrells Inlet

$220,000

Property Type: manufactured with land

MLS: 2522369

Status: ACTIVE

8317 Dunes Ridge Place

Sunset Beach

$460,000

Property Type: detached

MLS: 2522372

Status: ACTIVE

1275 Boswell Ct.

Conway

$385,000

Property Type: detached

MLS: 2522375

Status: ACTIVE

609 B 3rd Ave. S

North Myrtle Beach

$339,000

Property Type: detached

MLS: 2522379

Status: ACTIVE

1079 Waterway Ln.

Myrtle Beach

$599,900

Property Type: detached

MLS: 2522386

Status: ACTIVE

619 Winnow Way

Georgetown

$414,000

Property Type: detached

MLS: 2522467

Status: ACTIVE

8 Martinique Dr.

Myrtle Beach

$579,000

Property Type: detached

MLS: 2522764

Status: ACTIVE

1077 Palm DR Palm Dr.

Conway

$60,000

Property Type: manufactured leased land

MLS: 2522639

Status: ACTIVE

601 S 4th Ave.

Dillon

$149,000

Property Type: detached

MLS: 2522212

Status: ACTIVE

2079 Locust Ridge Dr.

Shallotte

$344,705

Property Type: detached

MLS: 2522214

Status: ACTIVE

2273 Starduster Ln.

Little River

$995,000

Property Type: detached

MLS: 2522135

Status: ACTIVE

60 Rose Bud Ct.

Murrells Inlet

$850,000

Property Type: detached

MLS: 2522136

Status: ACTIVE

9675 Stillwater Ct.

Myrtle Beach

$598,900

Property Type: detached with hpr

MLS: 2522147

Status: ACTIVE

1520 St. George Ln.

Myrtle Beach

$216,500

Property Type: detached

MLS: 2522152

Status: ACTIVE

3255 Red Bluff Rd.

Loris

$319,900

Property Type: detached

MLS: 2522154

Status: ACTIVE

3255 Red Bluff Rd.

Loris

$319,900

Property Type: detached

MLS: 2522154

Status: ACTIVE

3255 Red Bluff Rd.

Loris

$319,900

Property Type: detached

MLS: 2522154

Status: ACTIVE

3255 Red Bluff Rd.

Loris

$319,900

Property Type: detached

MLS: 2522154

Status: ACTIVE

673 Tidal Point Ln.

Myrtle Beach

$494,000

Property Type: detached

MLS: 2522164

Status: ACTIVE

4464 East Coast Ln.

Shallotte

$295,990

Property Type: detached

MLS: 2522168

Status: ACTIVE

6001 - MH89B South Kings Hwy.

Myrtle Beach

$749,900

Property Type: detached leased land

MLS: 2522172

Status: ACTIVE

709 Bramble Way

Conway

$299,990

Property Type: detached

MLS: 2522175

Status: ACTIVE

701 Bramble Way

Conway

$289,990

Property Type: detached

MLS: 2522176

Status: ACTIVE

537 Briarfield Loop

Conway

$304,990

Property Type: detached

MLS: 2522177

Status: ACTIVE

5508 Leatherleaf Dr.

North Myrtle Beach

$919,000

Property Type: detached

MLS: 2522180

Status: ACTIVE

184 Rose Water Loop

Myrtle Beach

$320,000

Property Type: semi-detached

MLS: 2522185

Status: ACTIVE

6125 R C Sarvis Ln.

Myrtle Beach

$2,200,000

Property Type: detached

MLS: 2522199

Status: ACTIVE

9530 Potters Pass Dr.

Longs

$429,965

Property Type: detached

MLS: 2522202

Status: ACTIVE

600 Shallow Cove Dr.

Conway

$259,900

Property Type: detached

MLS: 2522203

Status: ACTIVE

598 Shallow Cove Dr.

Conway

$269,900

Property Type: detached

MLS: 2522204

Status: ACTIVE

596 Shallow Cove Dr.

Conway

$258,900

Property Type: detached

MLS: 2522205

Status: ACTIVE

477 Ayrhill Loop

Myrtle Beach

$539,900

Property Type: detached

MLS: 2522215

Status: ACTIVE

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