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

1012 Cadbury Ct.

Conway

$275,000

Property Type: detached

MLS: 2602373

Status: ACTIVE

Just Listed

2115 Ridgedale Dr.

Conway

$339,900

Property Type: detached

MLS: 2602320

Status: ACTIVE

Just Listed

53 Crooked Island Circle

Murrells Inlet

$74,000

Property Type: manufactured leased land

MLS: 2602300

Status: ACTIVE

Just Listed

2427 Huntington Circle

Conway

$212,000

Property Type: manufactured with land

MLS: 2602301

Status: ACTIVE

Just Listed

329 Kauffman St.

Georgetown

$618,000

Property Type: detached

MLS: 2602302

Status: ACTIVE

Just Listed

1506 Coastal Cove Ln

Calabash

$1,149,530

Property Type: detached

MLS: 2602303

Status: ACTIVE

Just Listed

3801 Tyford Ct.

Myrtle Beach

$449,950

Property Type: detached

MLS: 2602308

Status: ACTIVE

Just Listed

137 Zostera Dr.

Little River

$439,900

Property Type: detached

MLS: 2602315

Status: ACTIVE

Just Listed

892 Wild Leaf Loop

Conway

$375,000

Property Type: detached

MLS: 2602317

Status: ACTIVE

Just Listed

4504 Riverside Ln.

Murrells Inlet

$1,579,000

Property Type: detached

MLS: 2602322

Status: ACTIVE

Just Listed

1008 Stilt Ct.

Conway

$549,900

Property Type: detached

MLS: 2602324

Status: ACTIVE

Just Listed

1112 Carolina Cove

North Myrtle Beach

$299,000

Property Type: manufactured with land

MLS: 2602325

Status: ACTIVE

Just Listed

1517 Norris Ave.

North Myrtle Beach

$84,500

Property Type: manufactured leased land

MLS: 2602330

Status: ACTIVE

Just Listed

6001- 1027 S Kings Hwy.

Myrtle Beach

$710,000

Property Type: detached leased land

MLS: 2602336

Status: ACTIVE

Just Listed

315 Hangar Ct.

Myrtle Beach

$120,000

Property Type: manufactured leased land

MLS: 2602338

Status: ACTIVE

Just Listed

209 Highmeadow Ln.

Aynor

$395,000

Property Type: detached

MLS: 2602343

Status: ACTIVE

Just Listed

916 Brinkley St.

Georgetown

$199,900

Property Type: detached

MLS: 2602344

Status: ACTIVE

Just Listed

5054 Yellowstone Dr.

Conway

$329,990

Property Type: detached

MLS: 2602345

Status: ACTIVE

Just Listed

6001-N20A South Kings Hwy.

Myrtle Beach

$184,900

Property Type: manufactured leased land

MLS: 2602347

Status: ACTIVE

Just Listed

2805 Green Pond Circle

Conway

$259,800

Property Type: detached

MLS: 2602348

Status: ACTIVE

Just Listed

1404 Beach Way Ln.

North Myrtle Beach

$479,460

Property Type: detached

MLS: 2602349

Status: ACTIVE

Just Listed

8006 Bear Claw Way

Conway

$335,440

Property Type: detached

MLS: 2602350

Status: ACTIVE

Just Listed

112 B 11th Ave. S

Surfside Beach

$1,425,000

Property Type: detached

MLS: 2602352

Status: ACTIVE

Just Listed

827 Western Rail Way

Loris

$301,930

Property Type: detached

MLS: 2602353

Status: ACTIVE

Just Listed

8018 Bear Claw Way

Conway

$341,990

Property Type: detached

MLS: 2602354

Status: ACTIVE

Just Listed

831 Western Rail Way

Loris

$282,640

Property Type: detached

MLS: 2602355

Status: ACTIVE

Just Listed

839 Western Rail Way

Loris

$294,040

Property Type: detached

MLS: 2602356

Status: ACTIVE

Just Listed

505 Night Heron Ct.

Murrells Inlet

$349,000

Property Type: detached

MLS: 2602357

Status: ACTIVE

Just Listed

8031 Bear Claw Way

Conway

$321,990

Property Type: detached

MLS: 2602359

Status: ACTIVE

Just Listed

3200 Visionary Dr.

Myrtle Beach

$444,900

Property Type: detached

MLS: 2602361

Status: ACTIVE

Just Listed

815 Willow Trace

Myrtle Beach

$359,000

Property Type: detached

MLS: 2602365

Status: ACTIVE

Just Listed

134 Cypress Hollow Dr.

Little River

$269,900

Property Type: detached with hpr

MLS: 2602366

Status: ACTIVE

Just Listed

1395 McMaster Dr.

Myrtle Beach

$629,900

Property Type: detached

MLS: 2602370

Status: ACTIVE

Just Listed

11036 Highway 707

Murrells Inlet

$825,000

Property Type: detached

MLS: 2602371

Status: ACTIVE

Just Listed

151 Coral Beach Circle

Myrtle Beach

$419,000

Property Type: detached

MLS: 2602375

Status: ACTIVE

Just Listed

1640 Littleleaf Loop

North Myrtle Beach

$659,000

Property Type: detached

MLS: 2602376

Status: ACTIVE

Just Listed

3013 Berry Bush Way

Conway

$500,375

Property Type: detached

MLS: 2602377

Status: ACTIVE

Just Listed

501 Hogwart Ln.

Longs

$329,900

Property Type: detached

MLS: 2602380

Status: ACTIVE

Just Listed

941 W Ocean Blvd.

Holden Beach

$1,575,000

Property Type: detached

MLS: 2602272

Status: ACTIVE

Just Listed

3111 Sutherland Dr.

Little River

$450,000

Property Type: detached

MLS: 2602270

Status: ACTIVE

Just Listed

300 Rolling Ridge Dr.

Longs

$214,000

Property Type: manufactured with land

MLS: 2602273

Status: ACTIVE

Just Listed

313 Babylon Pine Dr.

Myrtle Beach

$794,500

Property Type: detached

MLS: 2602275

Status: ACTIVE

Just Listed

1802 Sunrise Dr.

Surfside Beach

$320,000

Property Type: manufactured leased land

MLS: 2602277

Status: ACTIVE

Just Listed

TBD Grassland Ln.

Georgetown

$560,630

Property Type: detached

MLS: 2602278

Status: ACTIVE

Just Listed

1142 SeaChase Way

North Myrtle Beach

$444,900

Property Type: detached

MLS: 2602279

Status: ACTIVE

Just Listed

3135 Fair Ridge Way

Conway

$369,900

Property Type: detached

MLS: 2602280

Status: ACTIVE

Just Listed

3557 Bristol Ln.

Myrtle Beach

$279,000

Property Type: detached with hpr

MLS: 2602283

Status: ACTIVE

Just Listed

736 Crystal Water Way

Myrtle Beach

$749,000

Property Type: detached

MLS: 2602287

Status: ACTIVE

Just Listed

1464 Winding Creek Way

Myrtle Beach

$464,995

Property Type: detached

MLS: 2602292

Status: ACTIVE

Just Listed

815 North Congdon St.

Georgetown

$240,000

Property Type: detached

MLS: 2602293

Status: ACTIVE

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