Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.184 ms
Record Count: 21
Cached: Yes
Cache Type: timespan
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.177 ms
Record Count: 21
Cached: No
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

990 Highway 66

Conway

$395,000

Property Type: manufactured with land

MLS: 2503878

Status: ACTIVE

1213 Pineridge St.

Conway

$349,900

Property Type: detached

MLS: 2501576

Status: ACTIVE

Just Listed

6506 Royal Pine Dr.

Myrtle Beach

$285,000

Property Type: detached

MLS: 2517230

Status: ACTIVE

Just Listed

1049 Augustus Dr.

Conway

$290,000

Property Type: detached

MLS: 2517231

Status: ACTIVE

Just Listed

259 Hull St.

Surfside Beach

$725,000

Property Type: detached

MLS: 2517229

Status: ACTIVE

Just Listed

815 Rogers Dr.

Myrtle Beach

$229,900

Property Type: detached

MLS: 2517227

Status: ACTIVE

Just Listed

244 Gloucester Way

Little River

$492,500

Property Type: detached

MLS: 2517228

Status: ACTIVE

Just Listed

5039 Gladstone Dr

Conway

$358,900

Property Type: detached

MLS: 2517226

Status: ACTIVE

Just Listed

260 Maiden's Choice Dr.

Conway

$275,000

Property Type: detached

MLS: 2517225

Status: ACTIVE

Just Listed

1001 Bonita Loop

Myrtle Beach

$320,000

Property Type: detached

MLS: 2517224

Status: ACTIVE

Just Listed

192 Hamby Dr.

Pawleys Island

$739,900

Property Type: detached

MLS: 2517218

Status: ACTIVE

Just Listed

2025 Sawyer St.

Conway

$350,000

Property Type: detached

MLS: 2517220

Status: ACTIVE

Just Listed

388 Carmello Circle

Conway

$299,000

Property Type: detached

MLS: 2517216

Status: ACTIVE

Just Listed

856 W Highway 9

Longs

$4,150,000

Property Type: detached

MLS: 2517207

Status: ACTIVE

Just Listed

1004 Edge Dr.

North Myrtle Beach

$436,000

Property Type: detached

MLS: 2517206

Status: ACTIVE

Just Listed

1300 Floyd Page Rd.

Galivants Ferry

$235,000

Property Type: detached

MLS: 2517201

Status: ACTIVE

Just Listed

5876 Cremona Dr.

Myrtle Beach

$454,900

Property Type: semi-detached

MLS: 2517194

Status: ACTIVE

Just Listed

7913 E Highway 19

Loris

$264,500

Property Type: detached

MLS: 2517192

Status: ACTIVE

Just Listed

603 Bucks Trail

Longs

$278,500

Property Type: detached

MLS: 2517193

Status: ACTIVE

Just Listed

329 Waterfall Circle

Little River

$619,000

Property Type: detached

MLS: 2517191

Status: ACTIVE

Just Listed

293 Waterfall Circle

Little River

$551,680

Property Type: detached

MLS: 2517190

Status: ACTIVE

Just Listed

289 Waterfall Circle

Little River

$548,500

Property Type: detached

MLS: 2517189

Status: ACTIVE

Just Listed

277 Waterfall Circle

Little River

$549,825

Property Type: detached

MLS: 2517188

Status: ACTIVE

Just Listed

269 Waterfall Circle

Little River

$548,500

Property Type: detached

MLS: 2517187

Status: ACTIVE

Just Listed

297 Waterfall Circle

Little River

$548,500

Property Type: detached

MLS: 2517186

Status: ACTIVE

Just Listed

309 Waterfall Circle

Little River

$596,000

Property Type: detached

MLS: 2517185

Status: ACTIVE

Just Listed

205 Waterfall Circle

Little River

$550,000

Property Type: detached

MLS: 2517184

Status: ACTIVE

Just Listed

116 Infinity Ln.

Loris

$339,000

Property Type: detached

MLS: 2517183

Status: ACTIVE

Just Listed

112 Infinity Ln.

Loris

$359,900

Property Type: detached

MLS: 2517182

Status: ACTIVE

Just Listed

425 Falling Leaf Loop

Myrtle Beach

$276,000

Property Type: detached

MLS: 2517181

Status: ACTIVE

Just Listed

4298 Pecan St.

Little River

$429,900

Property Type: detached

MLS: 2517175

Status: ACTIVE

Just Listed

309 H. Coleman Lane

Tabor City

$299,000

Property Type: manufactured with land

MLS: 2517163

Status: ACTIVE

Just Listed

6001 - 1471 S Kings Hwy.

Myrtle Beach

$269,500

Property Type: detached leased land

MLS: 2517160

Status: ACTIVE

Just Listed

724 Woodstone Ct.

Murrells Inlet

$540,000

Property Type: detached

MLS: 2517158

Status: ACTIVE

Just Listed

40 Capt Anthony White Ln.

Georgetown

$549,999

Property Type: detached

MLS: 2517152

Status: ACTIVE

Just Listed

214 Rum Bluff Blvd.

Longs

$324,900

Property Type: detached

MLS: 2517215

Status: ACTIVE

Just Listed

2336 Highway 1115

Galivants Ferry

$1,100,000

Property Type: detached

MLS: 2517174

Status: ACTIVE

Just Listed

219A N Yaupon Dr.

Surfside Beach

$1,450,000

Property Type: detached

MLS: 2517153

Status: ACTIVE

Just Listed

108 Infinity Ln.

Loris

$349,000

Property Type: detached

MLS: 2517180

Status: ACTIVE

Just Listed

3002 Sawyer St.

Conway

$359,000

Property Type: detached

MLS: 2517157

Status: ACTIVE

Just Listed

704 Upton Way

Myrtle Beach

$499,900

Property Type: detached

MLS: 2517147

Status: ACTIVE

Just Listed

910 Perrin Dr.

North Myrtle Beach

$624,900

Property Type: detached

MLS: 2517146

Status: ACTIVE

Just Listed

824 Sweeney Dr.

Little River

$359,900

Property Type: detached

MLS: 2517144

Status: ACTIVE

Just Listed

237 Broughton Dr.

Myrtle Beach

$374,900

Property Type: detached

MLS: 2517142

Status: ACTIVE

Just Listed

1323 Wykham Park Dr.

Myrtle Beach

$369,900

Property Type: detached

MLS: 2517141

Status: ACTIVE

Just Listed

48 Seagrass Ct.

Pawleys Island

$970,940

Property Type: detached

MLS: 2517139

Status: ACTIVE

Just Listed

1001 Muskeg Ct.

Conway

$697,000

Property Type: detached

MLS: 2517138

Status: ACTIVE

Just Listed

1504 27th Ave. N

North Myrtle Beach

$719,900

Property Type: detached

MLS: 2517137

Status: ACTIVE

Just Listed

1734 Crooked Pine Dr.

Myrtle Beach

$390,000

Property Type: detached

MLS: 2517145

Status: ACTIVE

Just Listed

6001 - 1795 S Kings Hwy.

Myrtle Beach

$207,500

Property Type: manufactured leased land

MLS: 2517136

Status: ACTIVE

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