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

111 Westfield Circle

Conway

$348,189

Property Type: detached

MLS: 2526296

Status: ACTIVE

Just Listed

203 Marauder Dr.

Longs

$427,000

Property Type: detached

MLS: 2526262

Status: ACTIVE

Just Listed

TBD Oakdale Rd.

Loris

$320,000

Property Type: detached

MLS: 2526263

Status: ACTIVE

Just Listed

5008 Blue Spruce Ln.

Murrells Inlet

$304,900

Property Type: detached

MLS: 2526264

Status: ACTIVE

Just Listed

4349 Bayberry Dr.

Little River

$220,000

Property Type: manufactured with land

MLS: 2526266

Status: ACTIVE

Just Listed

1479 Tiger Grand Dr.

Conway

$395,000

Property Type: detached

MLS: 2526267

Status: ACTIVE

Just Listed

25 Berwick Dr.

Pawleys Island

$485,000

Property Type: detached

MLS: 2526269

Status: ACTIVE

Just Listed

2709 Orion Dr.

Myrtle Beach

$129,900

Property Type: manufactured leased land

MLS: 2526270

Status: ACTIVE

Just Listed

1144 Harbison Circle

Myrtle Beach

$419,900

Property Type: detached

MLS: 2526274

Status: ACTIVE

Just Listed

544 Fanciful Way

Myrtle Beach

$479,900

Property Type: detached

MLS: 2526275

Status: ACTIVE

Just Listed

3293 Center Rd.

Georgetown

$995,000

Property Type: detached

MLS: 2526276

Status: ACTIVE

Just Listed

1605 Embers Dr.

North Myrtle Beach

$129,900

Property Type: manufactured leased land

MLS: 2526278

Status: ACTIVE

Just Listed

2595 Orion Loop

Myrtle Beach

$425,000

Property Type: detached

MLS: 2526281

Status: ACTIVE

Just Listed

4183 Golf Ave.

Little River

$589,999

Property Type: detached

MLS: 2526282

Status: ACTIVE

Just Listed

486 Copenhagen Dr.

Little River

$349,900

Property Type: detached

MLS: 2526285

Status: ACTIVE

Just Listed

1544 Jardine Loop

Little River

$339,000

Property Type: semi-detached

MLS: 2526289

Status: ACTIVE

Just Listed

6927 Pauley Swamp Rd.

Conway

$439,000

Property Type: detached

MLS: 2526292

Status: ACTIVE

Just Listed

336 Vintage Circle

Myrtle Beach

$430,000

Property Type: detached

MLS: 2526295

Status: ACTIVE

Just Listed

1543 Jardine Loop

Little River

$342,000

Property Type: semi-detached

MLS: 2526297

Status: ACTIVE

Just Listed

599 Pier Ct.

Longs

$575,000

Property Type: detached

MLS: 2526298

Status: ACTIVE

Just Listed

3038 Visionary Dr.

Myrtle Beach

$399,994

Property Type: detached

MLS: 2526308

Status: ACTIVE

Just Listed

3070 Visionary Dr.

Myrtle Beach

$396,792

Property Type: detached

MLS: 2526310

Status: ACTIVE

Just Listed

1359 Beechnut Dr.

Latta

$129,000

Property Type: detached

MLS: 2526312

Status: ACTIVE

Just Listed

4511 Saint Johns Pl.

Murrells Inlet

$849,900

Property Type: detached

MLS: 2526313

Status: ACTIVE

Just Listed

9235 Marina Pkwy.

Myrtle Beach

$3,950,000

Property Type: detached

MLS: 2526317

Status: ACTIVE

Just Listed

4835 Cantor Ct.

North Myrtle Beach

$785,000

Property Type: detached with hpr

MLS: 2526321

Status: ACTIVE

Just Listed

2807 Temperance Dr.

Myrtle Beach

$324,999

Property Type: detached

MLS: 2526325

Status: ACTIVE

Just Listed

131 Cypress Ave.

Garden City Beach

$479,000

Property Type: detached with hpr

MLS: 2526329

Status: ACTIVE

Just Listed

6526 Bay Gully Rd.

Aynor

$949,900

Property Type: detached

MLS: 2526331

Status: ACTIVE

Just Listed

412 Chesterfield Ct.

Myrtle Beach

$223,000

Property Type: detached with hpr

MLS: 2526332

Status: ACTIVE

Just Listed

83 Hammock Ave.

Pawleys Island

$1,275,000

Property Type: detached

MLS: 2526336

Status: ACTIVE

Just Listed

457 E East Bank Dr.

Garden City Beach

$269,900

Property Type: manufactured leased land

MLS: 2526337

Status: ACTIVE

Just Listed

4351 Dew N. Ct.

Myrtle Beach

$289,000

Property Type: detached

MLS: 2526339

Status: ACTIVE

Just Listed

305 Woodrow St.

Tabor City

$219,900

Property Type: detached

MLS: 2526340

Status: ACTIVE

Just Listed

331 Sparrow Dr.

Surfside Beach

$569,000

Property Type: detached

MLS: 2526346

Status: ACTIVE

Just Listed

326 Tunnoch Rd.

Garden City Beach

$129,900

Property Type: manufactured leased land

MLS: 2526347

Status: ACTIVE

Just Listed

6001 - 1132 S Kings Hwy.

Myrtle Beach

$519,900

Property Type: detached leased land

MLS: 2526351

Status: ACTIVE

Just Listed

4800 Camellia Dr.

Myrtle Beach

$995,000

Property Type: detached

MLS: 2526352

Status: ACTIVE

Just Listed

1115 Bluffton Ct.

Myrtle Beach

$775,000

Property Type: detached

MLS: 2526353

Status: ACTIVE

Just Listed

605 Coquina Bay Dr.

Conway

$370,545

Property Type: detached

MLS: 2526218

Status: ACTIVE

Just Listed

1609 Littleleaf Loop

North Myrtle Beach

$579,900

Property Type: detached

MLS: 2526181

Status: ACTIVE

Just Listed

3464 Cedar Creek Run

Little River

$379,000

Property Type: detached

MLS: 2526183

Status: ACTIVE

Just Listed

132 Columbus St.

Conway

$335,000

Property Type: detached

MLS: 2526184

Status: ACTIVE

Just Listed

903 23rd Ave. N

North Myrtle Beach

$599,900

Property Type: detached

MLS: 2526186

Status: ACTIVE

Just Listed

253 Wellspring Dr.

Conway

$229,900

Property Type: manufactured leased land

MLS: 2526194

Status: ACTIVE

Just Listed

10 Martinique Dr.

Myrtle Beach

$729,000

Property Type: detached

MLS: 2526195

Status: ACTIVE

Just Listed

903 Durant St.

Conway

$250,000

Property Type: detached

MLS: 2526196

Status: ACTIVE

Just Listed

2601 S Allen Dr.

North Charleston

$264,500

Property Type: detached

MLS: 2526203

Status: ACTIVE

Just Listed

106 Harriet Tubman Ln

Moncks Corner

$289,900

Property Type: detached

MLS: 2526209

Status: ACTIVE

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