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

804 Lambeth Ln.

Conway

$389,000

Property Type: detached

MLS: 2527302

Status: ACTIVE

Just Listed

1303 Ashboro Ct.

Myrtle Beach

$625,000

Property Type: detached

MLS: 2527361

Status: ACTIVE

Just Listed

1613 James Island Ave.

North Myrtle Beach

$635,000

Property Type: detached

MLS: 2527309

Status: ACTIVE

Just Listed

485 Kings River Rd.

Pawleys Island

$899,900

Property Type: detached

MLS: 2527297

Status: ACTIVE

Just Listed

200 Brandon Way

Georgetown

$1,795,000

Property Type: detached

MLS: 2527303

Status: ACTIVE

Just Listed

5323 Valley Forge Rd.

Aynor

$629,000

Property Type: detached

MLS: 2527305

Status: ACTIVE

Just Listed

1313 Willow Oaks Way

Conway

$232,000

Property Type: detached

MLS: 2527315

Status: ACTIVE

Just Listed

2705 Ivy Glen Dr.

Conway

$269,900

Property Type: detached

MLS: 2527317

Status: ACTIVE

Just Listed

2902 Silver Leaf Circle

Loris

$250,000

Property Type: detached

MLS: 2527318

Status: ACTIVE

Just Listed

145 Ridge Point Dr.

Conway

$359,900

Property Type: detached

MLS: 2527319

Status: ACTIVE

Just Listed

723 Sun Colony Blvd.

Longs

$299,990

Property Type: detached

MLS: 2527320

Status: ACTIVE

Just Listed

3242 Moss Bridge Ln.

Myrtle Beach

$534,325

Property Type: detached

MLS: 2527323

Status: ACTIVE

Just Listed

1911 Abba Ct.

Conway

$124,900

Property Type: manufactured leased land

MLS: 2527325

Status: ACTIVE

Just Listed

309 Flagstone Dr.

Myrtle Beach

$300,000

Property Type: detached

MLS: 2527327

Status: ACTIVE

Just Listed

514 Strawberry Field Way

Galivants Ferry

$280,000

Property Type: detached

MLS: 2527329

Status: ACTIVE

Just Listed

700 Windy Hill Rd.

North Myrtle Beach

$519,900

Property Type: detached

MLS: 2527331

Status: ACTIVE

Just Listed

1203 N Ocean Blvd.

North Myrtle Beach

$1,975,000

Property Type: detached

MLS: 2527332

Status: ACTIVE

Just Listed

6001- B4 S Kings Hwy.

Myrtle Beach

$1,250,000

Property Type: detached leased land

MLS: 2527337

Status: ACTIVE

Just Listed

1003 Winding Rd.

Conway

$529,900

Property Type: detached

MLS: 2527339

Status: ACTIVE

Just Listed

1004 Maccoa Dr.

Conway

$620,000

Property Type: detached

MLS: 2527340

Status: ACTIVE

Just Listed

6001-1362 S Kings Hwy.

Myrtle Beach

$395,000

Property Type: detached leased land

MLS: 2527343

Status: ACTIVE

Just Listed

1560 Swing Bridge Way

Myrtle Beach

$350,000

Property Type: detached

MLS: 2527344

Status: ACTIVE

Just Listed

380 Hangar Ct.

Myrtle Beach

$89,900

Property Type: manufactured leased land

MLS: 2527347

Status: ACTIVE

Just Listed

306 57th Ave. N

North Myrtle Beach

$825,000

Property Type: detached

MLS: 2527349

Status: ACTIVE

Just Listed

131 Shetland Woods Dr.

Myrtle Beach

$89,900

Property Type: manufactured leased land

MLS: 2527350

Status: ACTIVE

Just Listed

610 Tattlesbury Dr.

Conway

$359,900

Property Type: detached

MLS: 2527351

Status: ACTIVE

Just Listed

1104 Marsh View Dr.

North Myrtle Beach

$800,000

Property Type: detached

MLS: 2527355

Status: ACTIVE

Just Listed

Lot 121 Sea Breeze Way

Longs

$349,000

Property Type: detached

MLS: 2527357

Status: ACTIVE

Just Listed

1426 Powhaton Dr.

Myrtle Beach

$474,900

Property Type: detached with hpr

MLS: 2527365

Status: ACTIVE

Just Listed

131 Balsa Dr.

Longs

$255,000

Property Type: detached

MLS: 2527367

Status: ACTIVE

Just Listed

107 Spanish Oak Ct.

Surfside Beach

$585,900

Property Type: detached

MLS: 2527368

Status: ACTIVE

Just Listed

505 Silver Pidgeon St

Aynor

$274,990

Property Type: detached

MLS: 2527370

Status: ACTIVE

Just Listed

1112 Ocala St.

Myrtle Beach

$355,000

Property Type: detached

MLS: 2527371

Status: ACTIVE

Just Listed

1152 Stoney Falls Blvd.

Myrtle Beach

$295,000

Property Type: detached

MLS: 2527287

Status: ACTIVE

Just Listed

911 Veneda Ct.

Myrtle Beach

$269,000

Property Type: detached

MLS: 2527205

Status: ACTIVE

Just Listed

127 Campania St.

Myrtle Beach

$425,000

Property Type: detached

MLS: 2527206

Status: ACTIVE

Just Listed

140 Carolina Pointe Way

Little River

$262,500

Property Type: detached

MLS: 2527208

Status: ACTIVE

Just Listed

2900 Pegasus Place

Myrtle Beach

$365,000

Property Type: detached

MLS: 2527210

Status: ACTIVE

Just Listed

409 Samara Dr.

Longs

$342,500

Property Type: detached

MLS: 2527211

Status: ACTIVE

Just Listed

5230 Piemonte Ln.

Myrtle Beach

$444,900

Property Type: detached

MLS: 2527213

Status: ACTIVE

Just Listed

815 Mount Gilead Place Dr.

Murrells Inlet

$449,000

Property Type: detached

MLS: 2527216

Status: ACTIVE

Just Listed

160 Stonington Dr.

Murrells Inlet

$950,000

Property Type: detached

MLS: 2527218

Status: ACTIVE

Just Listed

324 Glenridge Dr.

Little River

$360,000

Property Type: detached

MLS: 2527219

Status: ACTIVE

Just Listed

221 Addison Cottage Way

Murrells Inlet

$250,000

Property Type: detached

MLS: 2527222

Status: ACTIVE

Just Listed

1701-K Edge Dr.

North Myrtle Beach

$359,900

Property Type: detached

MLS: 2527226

Status: ACTIVE

Just Listed

102 Spanish Oak Spanish Oak Dr.

Surfside Beach

$375,500

Property Type: detached

MLS: 2527227

Status: ACTIVE

Just Listed

2917 Winding River Rd.

North Myrtle Beach

$539,000

Property Type: detached

MLS: 2527231

Status: ACTIVE

Just Listed

1251 Cypress Shoal Dr.

Conway

$381,921

Property Type: detached

MLS: 2527232

Status: ACTIVE

Just Listed

5518 Woodside Ave.

Myrtle Beach

$895,000

Property Type: detached

MLS: 2527237

Status: ACTIVE

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