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

$399,500

Property Type: detached with hpr

MLS: 2522497

Status: ACTIVE

Just Listed

236 Spencerswood Dr.

Conway

$319,900

Property Type: detached

MLS: 2528126

Status: ACTIVE

Just Listed

723 St. Vincent Loop

Little River

$568,351

Property Type: detached

MLS: 2528164

Status: ACTIVE

Just Listed

2161 N Berwick Dr.

Surfside Beach

$645,000

Property Type: detached

MLS: 2528128

Status: ACTIVE

Just Listed

386 Glacier Way

Conway

$410,000

Property Type: detached

MLS: 2528131

Status: ACTIVE

Just Listed

5521 Daffodil Dr.

Conway

$225,000

Property Type: manufactured with land

MLS: 2528132

Status: ACTIVE

Just Listed

924 Blacksmith Dr.

Loris

$254,940

Property Type: detached

MLS: 2528137

Status: ACTIVE

Just Listed

4101 Rockwood Dr.

Conway

$349,900

Property Type: detached

MLS: 2528138

Status: ACTIVE

Just Listed

450 Castillo Dr.

Loris

$219,990

Property Type: detached

MLS: 2528139

Status: ACTIVE

Just Listed

458 Castillo Dr.

Loris

$247,990

Property Type: detached

MLS: 2528144

Status: ACTIVE

Just Listed

418 Chesterfield Ct.

Myrtle Beach

$239,000

Property Type: detached with hpr

MLS: 2528151

Status: ACTIVE

Just Listed

405 Sea Breeze Way

Longs

$340,000

Property Type: detached

MLS: 2528152

Status: ACTIVE

Just Listed

1109 Boswell Ct.

Conway

$434,900

Property Type: detached

MLS: 2528153

Status: ACTIVE

Just Listed

3444 Highway 50

Little River

$249,900

Property Type: manufactured with land

MLS: 2528155

Status: ACTIVE

Just Listed

106 Skyler Dayle Dr.

Myrtle Beach

$590,000

Property Type: detached

MLS: 2528162

Status: ACTIVE

Just Listed

1558 Breakwater Dr.

Little River

$532,490

Property Type: detached

MLS: 2528163

Status: ACTIVE

Just Listed

744 Sun Colony Blvd.

Longs

$375,990

Property Type: detached

MLS: 2528166

Status: ACTIVE

Just Listed

5077 Capulet Circle

Myrtle Beach

$395,000

Property Type: detached

MLS: 2528088

Status: ACTIVE

Just Listed

121 Feather Dr

Georgetown

$179,900

Property Type: manufactured with land

MLS: 2528086

Status: ACTIVE

Just Listed

617 Forbes Dr.

Myrtle Beach

$384,900

Property Type: detached

MLS: 2528089

Status: ACTIVE

Just Listed

1184 Halter Pl.

Calabash

$399,955

Property Type: detached

MLS: 2528101

Status: ACTIVE

Just Listed

1216 Halter Pl.

Calabash

$528,187

Property Type: detached

MLS: 2528102

Status: ACTIVE

Just Listed

225 Upper Saddle Circle

Conway

$279,000

Property Type: detached

MLS: 2528106

Status: ACTIVE

Just Listed

22 Crooked Island Circle

Murrells Inlet

$125,000

Property Type: manufactured leased land

MLS: 2528110

Status: ACTIVE

Just Listed

414 36th Ave. N

Myrtle Beach

$749,900

Property Type: detached

MLS: 2528111

Status: ACTIVE

Just Listed

2996 Emory Trail

Murrells Inlet

$199,999

Property Type: manufactured leased land

MLS: 2528113

Status: ACTIVE

Just Listed

2520 Suzanne Dr.

Conway

$425,000

Property Type: detached

MLS: 2528115

Status: ACTIVE

Just Listed

1320 Horse Shoe Rd.

Mullins

$299,000

Property Type: detached

MLS: 2528150

Status: ACTIVE

Just Listed

10463 County Line Rd.

Hemingway

$675,000

Property Type: detached

MLS: 2528075

Status: ACTIVE

Just Listed

670 Kings River Rd.

Pawleys Island

$440,000

Property Type: detached

MLS: 2528042

Status: ACTIVE

Just Listed

6001 - 5614 S Kings Hwy.

Myrtle Beach

$275,000

Property Type: manufactured leased land

MLS: 2528049

Status: ACTIVE

Just Listed

4406 Indigo Ln.

Murrells Inlet

$579,900

Property Type: detached

MLS: 2528051

Status: ACTIVE

Just Listed

1012 S Hollywood Dr.

Surfside Beach

$1,382,693

Property Type: detached

MLS: 2528056

Status: ACTIVE

Just Listed

206 Weyburn St.

Myrtle Beach

$235,000

Property Type: manufactured with land

MLS: 2528058

Status: ACTIVE

Just Listed

704 St. Vincent Loop

Little River

$666,207

Property Type: detached

MLS: 2528060

Status: ACTIVE

Just Listed

1505 Crooked Hook Rd.

North Myrtle Beach

$669,600

Property Type: detached

MLS: 2528062

Status: ACTIVE

Just Listed

2231 Seagrape Dr.

Little River

$633,023

Property Type: detached

MLS: 2528063

Status: ACTIVE

Just Listed

2021 S Ocean Blvd.

North Myrtle Beach

$2,500,000

Property Type: detached

MLS: 2528064

Status: ACTIVE

Just Listed

379 Garden Grove St

Conway

$354,900

Property Type: detached

MLS: 2528066

Status: ACTIVE

Just Listed

126 Jericho Ct.

Georgetown

$411,000

Property Type: detached

MLS: 2528068

Status: ACTIVE

Just Listed

103 Condor Ct

Pawleys Island

$513,000

Property Type: detached

MLS: 2528072

Status: ACTIVE

Just Listed

2519 Hillbourne Loop

North Myrtle Beach

$437,986

Property Type: detached with hpr

MLS: 2528073

Status: ACTIVE

Just Listed

610 Bayview Dr.

Georgetown

$435,000

Property Type: detached

MLS: 2528076

Status: ACTIVE

Just Listed

200 Seasons Trace Loop

Longs

$325,000

Property Type: detached

MLS: 2528077

Status: ACTIVE

Just Listed

4221 Blake Rd.

Myrtle Beach

$285,000

Property Type: manufactured with land

MLS: 2528079

Status: ACTIVE

Just Listed

272 Old Ashley Loop

Pawleys Island

$1,125,000

Property Type: detached

MLS: 2528080

Status: ACTIVE

Just Listed

5805 Cottonfield Ct.

Myrtle Beach

$349,800

Property Type: detached

MLS: 2528081

Status: ACTIVE

Just Listed

2030 Manor Parc Dr

Calabash

$1,166,160

Property Type: detached

MLS: 2528109

Status: ACTIVE

Just Listed

227 Walden Lake Rd.

Conway

$250,000

Property Type: manufactured leased land

MLS: 2528038

Status: ACTIVE

Just Listed

804 Gammon Dr.

Myrtle Beach

$464,900

Property Type: detached

MLS: 2527967

Status: ACTIVE

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