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

6001- L40 S Kings Hwy.

Myrtle Beach

$228,000

Property Type: manufactured leased land

MLS: 2420670

Status: ACTIVE

8111 Laurel Ash Ave.

Myrtle Beach

$939,173

Property Type: detached

MLS: 2420734

Status: ACTIVE

8111 Laurel Ash Ave.

Myrtle Beach

$939,173

Property Type: detached

MLS: 2420734

Status: ACTIVE

3412 Holly Loop

Conway

$325,000

Property Type: detached

MLS: 2420743

Status: ACTIVE

1168 St. John Rd.

Galivants Ferry

$249,900

Property Type: detached

MLS: 2420610

Status: ACTIVE

3412 Westminster Dr.

Myrtle Beach

$749,900

Property Type: detached

MLS: 2420519

Status: ACTIVE

9318 Cove Dr.

Myrtle Beach

$2,549,000

Property Type: detached

MLS: 2420361

Status: ACTIVE

9318 Cove Dr.

Myrtle Beach

$2,549,000

Property Type: detached

MLS: 2420361

Status: ACTIVE

TBD1 Mineral Springs Rd.

Conway

$312,900

Property Type: detached

MLS: 2420172

Status: ACTIVE

6 Cottage Dr.

Murrells Inlet

$839,900

Property Type: detached

MLS: 2420080

Status: ACTIVE

355 Foxtail Dr.

Longs

$422,500

Property Type: detached

MLS: 2420197

Status: ACTIVE

6001 S Kings Hwy.

Myrtle Beach

$549,000

Property Type: detached leased land

MLS: 2419665

Status: ACTIVE

6001-N37 S Kings Hwy.

Myrtle Beach

$469,900

Property Type: detached leased land

MLS: 2419982

Status: ACTIVE

238 Marauder Dr.

Longs

$310,000

Property Type: detached

MLS: 2419491

Status: ACTIVE

6001-1573 S Kings Hwy.

Myrtle Beach

$279,900

Property Type: detached leased land

MLS: 2419610

Status: ACTIVE

214 26th Ave. S

Myrtle Beach

$499,900

Property Type: detached

MLS: 2418959

Status: ACTIVE

1237 Clipper Rd.

North Myrtle Beach

$522,900

Property Type: detached

MLS: 2418587

Status: ACTIVE

TBB44 Privetts Rd.

Conway

$347,900

Property Type: detached

MLS: 2418500

Status: ACTIVE

TBD 52 Privetts Rd.

Conway

$340,900

Property Type: detached

MLS: 2418503

Status: ACTIVE

TBD22 Privetts Rd.

Conway

$321,900

Property Type: detached

MLS: 2418505

Status: ACTIVE

2500 Newton Rd.

Aynor

$169,900

Property Type: manufactured with land

MLS: 2418439

Status: ACTIVE

2494 Newton Rd.

Aynor

$171,900

Property Type: manufactured with land

MLS: 2418446

Status: ACTIVE

1907 S Waccamaw Dr.

Garden City Beach

$4,199,000

Property Type: detached

MLS: 2418372

Status: ACTIVE

1919 South Waccamaw Dr.

Garden City Beach

$1,999,900

Property Type: detached

MLS: 2418262

Status: ACTIVE

2247 Sand Dunes Dr.

Myrtle Beach

$699,995

Property Type: detached

MLS: 2418092

Status: ACTIVE

312 13th Ave. S

Surfside Beach

$395,000

Property Type: detached

MLS: 2417596

Status: ACTIVE

2403 Park St.

North Myrtle Beach

$415,000

Property Type: detached

MLS: 2417506

Status: ACTIVE

108 Hallandale Lane

Murrells Inlet

$462,825

Property Type: semi-detached

MLS: 2417573

Status: ACTIVE

6001-C21 S Kings Hwy.

Myrtle Beach

$910,000

Property Type: detached leased land

MLS: 2417687

Status: ACTIVE

123 Shetland Woods Dr.

Myrtle Beach

$175,000

Property Type: manufactured leased land

MLS: 2417428

Status: ACTIVE

919A N Waccamaw Dr.

Murrells Inlet

$1,200,000

Property Type: semi-detached

MLS: 2417460

Status: ACTIVE

4524 Landing Rd.

Little River

$1,145,000

Property Type: detached

MLS: 2417392

Status: ACTIVE

512 Sheepbridge Way

Loris

$349,900

Property Type: detached

MLS: 2417118

Status: ACTIVE

5188 Country Pine Dr.

Myrtle Beach

$474,900

Property Type: detached

MLS: 2417154

Status: ACTIVE

800 E Madison St.

Dillon

$234,500

Property Type: detached

MLS: 2417188

Status: ACTIVE

6001 - N-45 S Kings Hwy.

Myrtle Beach

$279,900

Property Type: manufactured leased land

MLS: 2417058

Status: ACTIVE

3177 Holly Loop

Conway

$290,000

Property Type: detached

MLS: 2416726

Status: ACTIVE

1656 Mason Circle

Surfside Beach

$480,000

Property Type: manufactured leased land

MLS: 2416613

Status: ACTIVE

157 Blue Jacket Dr.

Galivants Ferry

$245,000

Property Type: detached

MLS: 2416504

Status: ACTIVE

2100 Highway 15

Myrtle Beach

$85,000

Property Type: manufactured leased land

MLS: 2416403

Status: ACTIVE

6001 - 1795 S Kings Hwy.

Myrtle Beach

$209,900

Property Type: manufactured leased land

MLS: 2416438

Status: ACTIVE

6001 - MH202 S Kings Hwy.

Myrtle Beach

$429,000

Property Type: manufactured leased land

MLS: 2416335

Status: ACTIVE

6001-5137 S Kings Hwy.

Myrtle Beach

$259,000

Property Type: detached leased land

MLS: 2416099

Status: ACTIVE

1409 Arbor Rd.

Loris

$950,000

Property Type: detached

MLS: 2416008

Status: ACTIVE

1015 Oak Meadow Dr.

Conway

$309,990

Property Type: detached

MLS: 2415999

Status: ACTIVE

1817 Woodstork Dr.

Conway

$943,110

Property Type: detached

MLS: 2416407

Status: ACTIVE

252 Timber Run Dr.

Georgetown

$289,900

Property Type: detached

MLS: 2415544

Status: ACTIVE

189 Brown Pelican Loop

Pawleys Island

$553,000

Property Type: detached

MLS: 2415081

Status: ACTIVE

205 Brush Ct.

Little River

$589,999

Property Type: detached

MLS: 2414870

Status: ACTIVE

1738 Cenith Dr.

North Myrtle Beach

$497,850

Property Type: detached

MLS: 2414445

Status: ACTIVE

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