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

108 Nunn Ct.

Longs

$372,000

Property Type: detached

MLS: 2521493

Status: ACTIVE

489 Cordgrass Ln.

Little River

$248,000

Property Type: detached

MLS: 2521494

Status: ACTIVE

173 Norris Dr.

Pawleys Island

$3,995,000

Property Type: detached

MLS: 2521502

Status: ACTIVE

112 Furnies Place

Loris

$373,990

Property Type: detached

MLS: 2521504

Status: ACTIVE

135 Colonial Circle

Murrells Inlet

$425,000

Property Type: detached

MLS: 2521507

Status: ACTIVE

2732 Libra Dr.

Myrtle Beach

$179,000

Property Type: manufactured leased land

MLS: 2521511

Status: ACTIVE

1421 Crested Iris Way

North Myrtle Beach

$665,000

Property Type: detached

MLS: 2521514

Status: ACTIVE

430 Stevia Ct.

Conway

$370,000

Property Type: detached

MLS: 2521519

Status: ACTIVE

3090 Bay View Dr.

Green Sea

$1,200,000

Property Type: detached

MLS: 2521520

Status: ACTIVE

6019 Mandrake Ct.

Myrtle Beach

$419,990

Property Type: detached

MLS: 2521524

Status: ACTIVE

2631 Ophelia Way

Myrtle Beach

$469,900

Property Type: detached

MLS: 2521535

Status: ACTIVE

1058 Doral Dr.

Pawleys Island

$850,000

Property Type: detached

MLS: 2521537

Status: ACTIVE

1309 Timber Row

Murrells Inlet

$275,000

Property Type: detached

MLS: 2521563

Status: ACTIVE

6001-1573 S Kings Hwy.

Myrtle Beach

$289,000

Property Type: detached leased land

MLS: 2521600

Status: ACTIVE

406 9th Ave. S

Myrtle Beach

$90,000

Property Type: manufactured leased land

MLS: 2521389

Status: ACTIVE

255 Iroquis Trail

Longs

$184,900

Property Type: manufactured with land

MLS: 2521334

Status: ACTIVE

381 Saint Ives Rd.

Longs

$629,900

Property Type: detached

MLS: 2521341

Status: ACTIVE

118 Sly Fox Trail

Myrtle Beach

$339,000

Property Type: detached

MLS: 2521352

Status: ACTIVE

1331 Winding Creek Way

Myrtle Beach

$415,000

Property Type: detached

MLS: 2521355

Status: ACTIVE

1036 Augustus Dr.

Conway

$284,900

Property Type: detached

MLS: 2521358

Status: ACTIVE

1161 Loop Circle

Longs

$479,369

Property Type: detached

MLS: 2521359

Status: ACTIVE

1013 Wigeon Dr.

Conway

$614,900

Property Type: detached

MLS: 2521366

Status: ACTIVE

1519 Wood Stork Dr.

Conway

$389,900

Property Type: detached

MLS: 2521369

Status: ACTIVE

115 Green Lake Dr.

Myrtle Beach

$950,000

Property Type: detached

MLS: 2521370

Status: ACTIVE

232 Ole Maple St.

Loris

$489,400

Property Type: detached

MLS: 2521372

Status: ACTIVE

4087 Steeple Chase Dr.

Myrtle Beach

$335,000

Property Type: detached

MLS: 2521379

Status: ACTIVE

330 Adoniram Dr.

Conway

$515,000

Property Type: detached

MLS: 2521386

Status: ACTIVE

736 Sturdy Root Rd

Myrtle Beach

$271,500

Property Type: detached

MLS: 2521387

Status: ACTIVE

6001-MH137A S Kings Hwy.

Myrtle Beach

$599,900

Property Type: detached leased land

MLS: 2521390

Status: ACTIVE

116 Belclare Way

Longs

$398,000

Property Type: detached

MLS: 2521392

Status: ACTIVE

124 Ocean Sands Ct.

Myrtle Beach

$640,000

Property Type: detached

MLS: 2521394

Status: ACTIVE

3005 Cedar Creek Run

Little River

$750,000

Property Type: detached

MLS: 2521399

Status: ACTIVE

299 Long Beard Way

Longs

$294,465

Property Type: detached

MLS: 2521404

Status: ACTIVE

1518 Two Notch Circle

Ash

$412,335

Property Type: detached

MLS: 2521405

Status: ACTIVE

214 Yucca Ave.

Murrells Inlet

$849,000

Property Type: detached

MLS: 2521410

Status: ACTIVE

654 Blue Bird Ln.

Murrells Inlet

$325,000

Property Type: detached

MLS: 2521413

Status: ACTIVE

533 Honeyhill Loop

Conway

$339,990

Property Type: detached

MLS: 2521422

Status: ACTIVE

2 Keel Lane

Murrells Inlet

$235,000

Property Type: manufactured leased land

MLS: 2521426

Status: ACTIVE

2301 S Holly Dr.

North Myrtle Beach

$935,000

Property Type: detached

MLS: 2521431

Status: ACTIVE

3428 Asbury Rd.

Aynor

$314,900

Property Type: detached

MLS: 2521439

Status: ACTIVE

613-618 5th Ave. S

Myrtle Beach

$124,900

Property Type: manufactured leased land

MLS: 2521472

Status: ACTIVE

613-618 5th Ave. S

Myrtle Beach

$124,900

Property Type: manufactured leased land

MLS: 2521472

Status: ACTIVE

3200 S Ocean Blvd.

Myrtle Beach

$67,000

Property Type: manufactured leased land

MLS: 2521492

Status: ACTIVE

455 Deerfield Links Dr.

Myrtle Beach

$343,900

Property Type: semi-detached

MLS: 2521950

Status: ACTIVE

772 Planters Moon Dr.

Galivants Ferry

$315,000

Property Type: detached

MLS: 2521332

Status: ACTIVE

830 Whispering Tide Ct.

Myrtle Beach

$384,900

Property Type: detached with hpr

MLS: 2521323

Status: ACTIVE

3078 Visionary Dr.

Myrtle Beach

$333,997

Property Type: detached

MLS: 2521310

Status: ACTIVE

6001-N73 South Kings Hwy.

Myrtle Beach

$319,900

Property Type: detached leased land

MLS: 2521287

Status: ACTIVE

129 Stamper Trail

Pawleys Island

$2,795,000

Property Type: detached

MLS: 2521315

Status: ACTIVE

181 Dunbarton Ln.

Conway

$348,500

Property Type: detached

MLS: 2521325

Status: ACTIVE

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