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

1004 Ray Costin Way

Murrells Inlet

$364,900

Property Type: condo

MLS: 2503245

Status: ACTIVE

Just Listed

108 Parmelee Dr.

Murrells Inlet

$399,500

Property Type: townhouse

MLS: 2520318

Status: ACTIVE

Just Listed

4657 Fringetree Dr.

Murrells Inlet

$285,000

Property Type: condo

MLS: 2520332

Status: ACTIVE

Just Listed

928 Villa Dr.

North Myrtle Beach

$215,000

Property Type: townhouse

MLS: 2520319

Status: ACTIVE

Just Listed

4811 48th Ave. S

Myrtle Beach

$325,000

Property Type: condo

MLS: 2520321

Status: ACTIVE

Just Listed

301 River Rock Ln.

Murrells Inlet

$318,000

Property Type: condo

MLS: 2520323

Status: ACTIVE

Just Listed

5750 Oyster Catcher Dr.

North Myrtle Beach

$234,900

Property Type: condo

MLS: 2520324

Status: ACTIVE

Just Listed

651 Woodmoor Dr.

Murrells Inlet

$260,000

Property Type: condo

MLS: 2520327

Status: ACTIVE

Just Listed

4793 Wild Iris Dr.

Myrtle Beach

$220,000

Property Type: condo

MLS: 2520336

Status: ACTIVE

Just Listed

215 77th Ave. N

Myrtle Beach

$599,900

Property Type: condo

MLS: 2520341

Status: ACTIVE

Just Listed

244 Layla Way

Murrells Inlet

$397,900

Property Type: condo

MLS: 2520306

Status: ACTIVE

Just Listed

822 Sail Ln.

Murrells Inlet

$245,000

Property Type: condo

MLS: 2520259

Status: ACTIVE

Just Listed

109 South Shore Blvd.

Longs

$200,000

Property Type: condo

MLS: 2520209

Status: ACTIVE

Just Listed

4061-B Taranto Loop

Myrtle Beach

$320,000

Property Type: condo

MLS: 2520204

Status: ACTIVE

Just Listed

1 Norris Dr.

Pawleys Island

$199,900

Property Type: condo

MLS: 2520212

Status: ACTIVE

Just Listed

4823 Magnolia Lake Dr.

Myrtle Beach

$299,900

Property Type: condo

MLS: 2520213

Status: ACTIVE

Just Listed

6203 Catalina Dr.

North Myrtle Beach

$329,999

Property Type: condo

MLS: 2520214

Status: ACTIVE

Just Listed

406 74th Ave. N

Myrtle Beach

$269,900

Property Type: townhouse

MLS: 2520221

Status: ACTIVE

Just Listed

2504 N Ocean Blvd.

Myrtle Beach

$399,900

Property Type: condo

MLS: 2520222

Status: ACTIVE

Just Listed

801 Maxine Ct.

Myrtle Beach

$319,900

Property Type: condo

MLS: 2520224

Status: ACTIVE

Just Listed

724 Pinehurst Ln.

Pawleys Island

$435,777

Property Type: townhouse

MLS: 2520234

Status: ACTIVE

Just Listed

1041 Fairway Ln.

Conway

$230,000

Property Type: townhouse

MLS: 2520235

Status: ACTIVE

Just Listed

250 NW South Crow Creek Dr.

Calabash

$259,900

Property Type: condo

MLS: 2520238

Status: ACTIVE

Just Listed

4679 Wild Iris Dr.

Myrtle Beach

$189,900

Property Type: condo

MLS: 2520239

Status: ACTIVE

Just Listed

8845 Chandler Dr.

Surfside Beach

$210,000

Property Type: condo

MLS: 2520251

Status: ACTIVE

Just Listed

205 74th Ave. N

Myrtle Beach

$389,900

Property Type: condo

MLS: 2520265

Status: ACTIVE

Just Listed

173 Olde Towne Way

Myrtle Beach

$237,500

Property Type: condo

MLS: 2520269

Status: ACTIVE

Just Listed

698 Riverwalk Dr.

Myrtle Beach

$254,900

Property Type: condo

MLS: 2520271

Status: ACTIVE

Just Listed

9994 Beach Club Dr.

Myrtle Beach

$495,000

Property Type: condo

MLS: 2520272

Status: ACTIVE

Just Listed

6203 Catalina Dr.

North Myrtle Beach

$304,900

Property Type: condo

MLS: 2520278

Status: ACTIVE

Just Listed

1018 Red Sky Ln.

Murrells Inlet

$369,999

Property Type: condo

MLS: 2520281

Status: ACTIVE

Just Listed

6900 N Ocean Blvd.

Myrtle Beach

$175,000

Property Type: condo

MLS: 2520286

Status: ACTIVE

Just Listed

750 Charter Dr.

Longs

$209,000

Property Type: condo

MLS: 2520294

Status: ACTIVE

Just Listed

2241 Waterview Dr.

North Myrtle Beach

$350,000

Property Type: condo

MLS: 2520301

Status: ACTIVE

Just Listed

5825 Catalina Dr.

North Myrtle Beach

$220,000

Property Type: condo

MLS: 2520305

Status: ACTIVE

Just Listed

236 Layla Way

Murrells Inlet

$401,900

Property Type: condo

MLS: 2520307

Status: ACTIVE

Just Listed

9661 Shore Dr.

Myrtle Beach

$257,000

Property Type: condo

MLS: 2520326

Status: ACTIVE

Just Listed

102 N Ocean Blvd.

North Myrtle Beach

$635,000

Property Type: condo

MLS: 2520189

Status: ACTIVE

Just Listed

123 Dogwood Dr. N

Murrells Inlet

$243,000

Property Type: condo

MLS: 2520108

Status: ACTIVE

Just Listed

5310 N Ocean Blvd.

Myrtle Beach

$925,000

Property Type: condo

MLS: 2520130

Status: ACTIVE

Just Listed

1768 Hunting Harris Ct

Ocean Isle Beach

$259,900

Property Type: townhouse

MLS: 2520166

Status: ACTIVE

Just Listed

601 Hillside Dr. N

North Myrtle Beach

$574,999

Property Type: condo

MLS: 2520167

Status: ACTIVE

Just Listed

1769 Hunting Harris Ct

Ocean Isle Beach

$254,900

Property Type: townhouse

MLS: 2520168

Status: ACTIVE

Just Listed

1765 Hunting Harris Ct

Ocean Isle Beach

$254,900

Property Type: townhouse

MLS: 2520169

Status: ACTIVE

Just Listed

1772 Hunting Harris Ct

Ocean Isle Beach

$279,900

Property Type: townhouse

MLS: 2520172

Status: ACTIVE

Just Listed

1776 Hunting Harris Ct

Ocean Isle Beach

$278,300

Property Type: townhouse

MLS: 2520173

Status: ACTIVE

Just Listed

1761 Hunting Harris Ct

Ocean Isle Beach

$284,600

Property Type: townhouse

MLS: 2520175

Status: ACTIVE

Just Listed

1757 Hunting Harris Ct

Ocean Isle Beach

$284,800

Property Type: townhouse

MLS: 2520176

Status: ACTIVE

Just Listed

1809 S Ocean Blvd.

North Myrtle Beach

$355,000

Property Type: condo

MLS: 2520179

Status: ACTIVE

Just Listed

1819 N Ocean Dr.

North Myrtle Beach

$599,000

Property Type: condo

MLS: 2520193

Status: ACTIVE

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