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

1450 Powhaton Dr.

Myrtle Beach

$415,000

Property Type: detached with hpr

MLS: 2522497

Status: ACTIVE

Just Listed

446 Deer Watch Circle

Longs

$229,000

Property Type: detached

MLS: 2526559

Status: ACTIVE

Just Listed

TBD Sea Breeze Way

Longs

$404,950

Property Type: detached

MLS: 2526560

Status: ACTIVE

Just Listed

125 Teddy Bear Circle

Conway

$330,950

Property Type: detached

MLS: 2526561

Status: ACTIVE

Just Listed

746 Gumbo Limbo Ln.

Myrtle Beach

$319,000

Property Type: detached

MLS: 2526563

Status: ACTIVE

Just Listed

308 Safari Ln

Conway

$89,000

Property Type: manufactured leased land

MLS: 2526564

Status: ACTIVE

Just Listed

6001-5417 S Kings Hwy.

Myrtle Beach

$512,000

Property Type: detached leased land

MLS: 2526565

Status: ACTIVE

Just Listed

5053 Yellowstone Dr.

Conway

$345,935

Property Type: detached

MLS: 2526566

Status: ACTIVE

Just Listed

5081 Yellowstone Dr.

Conway

$341,890

Property Type: detached

MLS: 2526568

Status: ACTIVE

Just Listed

4962 Westwind Dr.

Myrtle Beach

$439,500

Property Type: detached

MLS: 2526573

Status: ACTIVE

Just Listed

7168 Shooting Star Way

Myrtle Beach

$455,795

Property Type: detached

MLS: 2526576

Status: ACTIVE

Just Listed

135 Honey Jar Way

Longs

$329,900

Property Type: detached

MLS: 2526577

Status: ACTIVE

Just Listed

109 Lakeside Crossing Dr.

Conway

$237,500

Property Type: manufactured leased land

MLS: 2526578

Status: ACTIVE

Just Listed

1313 SeaChase Way

North Myrtle Beach

$484,700

Property Type: detached

MLS: 2526579

Status: ACTIVE

Just Listed

508 Vermillion Dr.

Little River

$369,900

Property Type: detached

MLS: 2526580

Status: ACTIVE

Just Listed

86 Wickham Ct.

Pawleys Island

$520,000

Property Type: detached

MLS: 2526584

Status: ACTIVE

Just Listed

1703 King Oaks Loop

Conway

$240,500

Property Type: detached

MLS: 2526585

Status: ACTIVE

Just Listed

1101 Lauryn Oak Loop

Longs

$271,990

Property Type: detached

MLS: 2526587

Status: ACTIVE

Just Listed

420 Feathergrass Way

Little River

$508,900

Property Type: detached

MLS: 2526588

Status: ACTIVE

Just Listed

789 Choctaw Dr.

Conway

$390,120

Property Type: detached

MLS: 2526589

Status: ACTIVE

Just Listed

1093 Lauryn Oak Loop

Longs

$259,990

Property Type: detached

MLS: 2526591

Status: ACTIVE

Just Listed

1089 Lauryn Oak Loop

Little River

$289,990

Property Type: detached

MLS: 2526592

Status: ACTIVE

Just Listed

1085 Lauryn Oak Loop

Longs

$268,990

Property Type: detached

MLS: 2526593

Status: ACTIVE

Just Listed

342 Red Fox Rd.

Myrtle Beach

$284,900

Property Type: detached

MLS: 2526594

Status: ACTIVE

Just Listed

1072 Lauryn Oak Loop

Longs

$247,990

Property Type: detached

MLS: 2526596

Status: ACTIVE

Just Listed

1076 Lauryn Oak Loop

Little River

$259,990

Property Type: detached

MLS: 2526598

Status: ACTIVE

Just Listed

204 Chain Fern Ct

Longs

$359,990

Property Type: detached

MLS: 2526599

Status: ACTIVE

Just Listed

200 Chain Fern Ct

Longs

$319,990

Property Type: detached

MLS: 2526600

Status: ACTIVE

Just Listed

362 Acosta Circle

Conway

$330,750

Property Type: detached

MLS: 2526601

Status: ACTIVE

Just Listed

2830 Stellar Loop

Myrtle Beach

$425,000

Property Type: detached

MLS: 2526602

Status: ACTIVE

Just Listed

105 Red Cedar Ct

Longs

$354,990

Property Type: detached

MLS: 2526603

Status: ACTIVE

Just Listed

108 Red Cedar Ct

Longs

$333,990

Property Type: detached

MLS: 2526604

Status: ACTIVE

Just Listed

3149 Visionary Dr.

Myrtle Beach

$497,900

Property Type: detached

MLS: 2526609

Status: ACTIVE

Just Listed

3154 Visionary Dr.

Myrtle Beach

$461,900

Property Type: detached

MLS: 2526611

Status: ACTIVE

Just Listed

1837 Orchard Dr.

Myrtle Beach

$499,900

Property Type: detached

MLS: 2526448

Status: ACTIVE

Just Listed

891 Helms Way

Conway

$350,000

Property Type: detached

MLS: 2526551

Status: ACTIVE

Just Listed

3810 Richardson St.

Loris

$399,900

Property Type: detached

MLS: 2526499

Status: ACTIVE

Just Listed

3880 Richardson St.

Loris

$376,900

Property Type: detached

MLS: 2526503

Status: ACTIVE

Just Listed

435 Rollins Dr.

Longs

$347,800

Property Type: detached

MLS: 2526446

Status: ACTIVE

Just Listed

77 Ballyhoo St.

Georgetown

$2,095,000

Property Type: detached

MLS: 2526458

Status: ACTIVE

Just Listed

1535 Harlow Ct.

Myrtle Beach

$299,900

Property Type: semi-detached

MLS: 2526459

Status: ACTIVE

Just Listed

933 Saluda River Rd.

Myrtle Beach

$535,000

Property Type: detached

MLS: 2526461

Status: ACTIVE

Just Listed

2945 Old Railroad Rd.

Conway

$324,900

Property Type: detached

MLS: 2526465

Status: ACTIVE

Just Listed

196 Valerio St.

Myrtle Beach

$484,690

Property Type: detached

MLS: 2526467

Status: ACTIVE

Just Listed

5633 Tern Hall Dr.

Myrtle Beach

$275,000

Property Type: detached

MLS: 2526468

Status: ACTIVE

Just Listed

1017 Foxfire Dr.

North Myrtle Beach

$109,000

Property Type: manufactured leased land

MLS: 2526472

Status: ACTIVE

Just Listed

154 Cypress Ave.

Murrells Inlet

$675,000

Property Type: detached with hpr

MLS: 2526474

Status: ACTIVE

Just Listed

2021 Walter Rd.

Galivants Ferry

$585,000

Property Type: detached

MLS: 2526476

Status: ACTIVE

Just Listed

5107 Capulet Circle

Myrtle Beach

$317,500

Property Type: detached

MLS: 2526478

Status: ACTIVE

Just Listed

1010 Perrin Dr.

North Myrtle Beach

$1,275,000

Property Type: detached

MLS: 2526487

Status: ACTIVE

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