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

2397 River Rd.

Myrtle Beach

$1,159,000

Property Type: detached

MLS: 2525248

Status: ACTIVE

Just Listed

4049 Golf Ave.

Little River

$459,900

Property Type: detached

MLS: 2525249

Status: ACTIVE

Just Listed

405 N 30th Ave. N

North Myrtle Beach

$579,000

Property Type: detached

MLS: 2525253

Status: ACTIVE

Just Listed

611 Bay St.

Aynor

$349,990

Property Type: detached

MLS: 2525254

Status: ACTIVE

Just Listed

1981 Morning Glory Ct.

Surfside Beach

$319,000

Property Type: manufactured leased land

MLS: 2525255

Status: ACTIVE

Just Listed

3054 Visionary Dr.

Myrtle Beach

$414,965

Property Type: detached

MLS: 2525258

Status: ACTIVE

Just Listed

285 Hawks Run Dr.

Carolina Shores

$338,000

Property Type: detached

MLS: 2525260

Status: ACTIVE

Just Listed

609 Bay St.

Aynor

$374,990

Property Type: detached

MLS: 2525261

Status: ACTIVE

Just Listed

3086 Visionary Dr.

Myrtle Beach

$369,997

Property Type: detached

MLS: 2525262

Status: ACTIVE

Just Listed

406 S Rosemary Ave.

Andrews

$325,000

Property Type: detached

MLS: 2525265

Status: ACTIVE

Just Listed

405 38th Ave. N

Myrtle Beach

$765,000

Property Type: detached

MLS: 2525266

Status: ACTIVE

Just Listed

605 Bay St.

Aynor

$327,713

Property Type: detached

MLS: 2525272

Status: ACTIVE

Just Listed

1354 Tarisa Ave.

Myrtle Beach

$849,900

Property Type: detached

MLS: 2525300

Status: ACTIVE

Just Listed

164 Seasons Trace Loop

Longs

$355,000

Property Type: detached

MLS: 2525305

Status: ACTIVE

Just Listed

52 Trimmings Ct.

Pawleys Island

$1,099,000

Property Type: detached

MLS: 2525398

Status: ACTIVE

Just Listed

3007 Visionary Dr.

Myrtle Beach

$394,000

Property Type: detached

MLS: 2525123

Status: ACTIVE

Just Listed

335 Oak Crest Circle

Little River

$394,900

Property Type: detached

MLS: 2525124

Status: ACTIVE

Just Listed

205 Ocean Commons Dr.

Surfside Beach

$569,900

Property Type: detached

MLS: 2525125

Status: ACTIVE

Just Listed

8169 Woodland Dr.

Myrtle Beach

$250,000

Property Type: manufactured with land

MLS: 2525127

Status: ACTIVE

Just Listed

809 Covelo Ln.

Myrtle Beach

$459,900

Property Type: detached

MLS: 2525134

Status: ACTIVE

Just Listed

3351 Little Bay Dr.

Conway

$327,500

Property Type: detached

MLS: 2525135

Status: ACTIVE

Just Listed

1535 Breakwater Dr.

Little River

$651,100

Property Type: detached

MLS: 2525136

Status: ACTIVE

Just Listed

1040 Palm Dr.

Conway

$123,000

Property Type: manufactured leased land

MLS: 2525142

Status: ACTIVE

Just Listed

442 Castillo Dr.

Loris

$266,990

Property Type: detached

MLS: 2525143

Status: ACTIVE

Just Listed

8239 Energize Dr.

Longs

$299,990

Property Type: detached

MLS: 2525145

Status: ACTIVE

Just Listed

1126 Prescott Circle

Myrtle Beach

$500,000

Property Type: detached

MLS: 2525150

Status: ACTIVE

Just Listed

1853 Willowcress Ln.

Myrtle Beach

$569,900

Property Type: detached

MLS: 2525157

Status: ACTIVE

Just Listed

939 Grace Dr.

Conway

$445,000

Property Type: detached

MLS: 2525160

Status: ACTIVE

Just Listed

1616 Perrin Dr.

North Myrtle Beach

$579,000

Property Type: detached

MLS: 2525163

Status: ACTIVE

Just Listed

308 36th Ave. N

North Myrtle Beach

$649,000

Property Type: detached

MLS: 2525165

Status: ACTIVE

Just Listed

8217 Energize Dr.

Longs

$312,990

Property Type: detached

MLS: 2525166

Status: ACTIVE

Just Listed

3616 White Wing Circle

Myrtle Beach

$400,000

Property Type: detached

MLS: 2525168

Status: ACTIVE

Just Listed

500 Cloverfield Ln.

Conway

$515,000

Property Type: detached

MLS: 2525169

Status: ACTIVE

Just Listed

4728 Rose Hill Rd.

Georgetown

$174,900

Property Type: detached

MLS: 2525171

Status: ACTIVE

Just Listed

575 Affinity Dr.

Myrtle Beach

$375,000

Property Type: detached

MLS: 2525175

Status: ACTIVE

Just Listed

829 Palmwood Circle

North Myrtle Beach

$360,000

Property Type: detached

MLS: 2525176

Status: ACTIVE

Just Listed

3729 Golf Ave.

Little River

$515,000

Property Type: detached

MLS: 2525177

Status: ACTIVE

Just Listed

609 Beaver Pond Rd.

Conway

$559,000

Property Type: detached

MLS: 2525179

Status: ACTIVE

Just Listed

122 Lida Lane

Loris

$92,900

Property Type: manufactured leased land

MLS: 2525183

Status: ACTIVE

Just Listed

1353 Hucks Rd.

Aynor

$450,000

Property Type: detached

MLS: 2525184

Status: ACTIVE

Just Listed

851 Raleigh Trail

Murrells Inlet

$244,900

Property Type: manufactured leased land

MLS: 2525185

Status: ACTIVE

Just Listed

543 Belton Dr.

Conway

$420,000

Property Type: detached

MLS: 2525187

Status: ACTIVE

Just Listed

1293 Gailard Dr.

Conway

$299,900

Property Type: detached

MLS: 2525191

Status: ACTIVE

Just Listed

1879 Ackerrose Dr.

Conway

$259,000

Property Type: detached

MLS: 2525192

Status: ACTIVE

Just Listed

531 Charlton Blvd.

Georgetown

$379,000

Property Type: detached

MLS: 2525194

Status: ACTIVE

Just Listed

9310 Long Meadow Way

Longs

$534,440

Property Type: detached

MLS: 2525196

Status: ACTIVE

Just Listed

4689 Southgate Pkwy.

Myrtle Beach

$314,900

Property Type: detached

MLS: 2525197

Status: ACTIVE

Just Listed

125 Covey Rise Dr

Aynor

$269,990

Property Type: detached

MLS: 2525201

Status: ACTIVE

Just Listed

424 Cotton Grass Dr.

Loris

$334,900

Property Type: detached

MLS: 2525204

Status: ACTIVE

Just Listed

320 Sporting Dr

Aynor

$272,990

Property Type: detached

MLS: 2525205

Status: ACTIVE

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