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

135 Sugar Loaf Ln.

Murrells Inlet

$599,999

Property Type: detached

MLS: 2529553

Status: ACTIVE

Just Listed

1445 Tiger Grand Dr.

Conway

$272,500

Property Type: detached

MLS: 2529571

Status: ACTIVE

Just Listed

305 Cheerful Way

Little River

$325,840

Property Type: detached

MLS: 2529523

Status: ACTIVE

Just Listed

874 Farmers Passage Loop

Loris

$293,690

Property Type: detached

MLS: 2529524

Status: ACTIVE

Just Listed

881 Farmers Passage Loop

Loris

$322,673

Property Type: detached

MLS: 2529525

Status: ACTIVE

Just Listed

732 Choctaw Dr.

Conway

$404,595

Property Type: detached

MLS: 2529526

Status: ACTIVE

Just Listed

119 Coralberry Dr.

Conway

$287,490

Property Type: detached

MLS: 2529528

Status: ACTIVE

Just Listed

127 Coralberry Dr.

Conway

$296,490

Property Type: detached

MLS: 2529529

Status: ACTIVE

Just Listed

115 Stride Ct.

Myrtle Beach

$488,105

Property Type: detached

MLS: 2529530

Status: ACTIVE

Just Listed

148 Dagger Ct.

Myrtle Beach

$287,990

Property Type: detached

MLS: 2529531

Status: ACTIVE

Just Listed

356 Skyward St.

Myrtle Beach

$278,990

Property Type: detached

MLS: 2529532

Status: ACTIVE

Just Listed

315 Skyward St.

Myrtle Beach

$332,390

Property Type: detached

MLS: 2529533

Status: ACTIVE

Just Listed

523 Sagebrush St.

Myrtle Beach

$337,840

Property Type: detached

MLS: 2529534

Status: ACTIVE

Just Listed

117 Homestead Way

Myrtle Beach

$415,190

Property Type: detached

MLS: 2529535

Status: ACTIVE

Just Listed

125 Homestead Way

Myrtle Beach

$369,840

Property Type: detached

MLS: 2529536

Status: ACTIVE

Just Listed

425 Grain Field Dr.

Georgetown

$375,000

Property Type: detached

MLS: 2529537

Status: ACTIVE

Just Listed

3 Burr Circle

Murrells Inlet

$59,959

Property Type: manufactured leased land

MLS: 2529541

Status: ACTIVE

Just Listed

2824 Gobblers Run

Conway

$139,900

Property Type: manufactured leased land

MLS: 2529545

Status: ACTIVE

Just Listed

6001-1098 S Kings Hwy.

Myrtle Beach

$749,900

Property Type: detached

MLS: 2529549

Status: ACTIVE

Just Listed

381 Sanddollar Dr.

Surfside Beach

$339,000

Property Type: manufactured leased land

MLS: 2529551

Status: ACTIVE

Just Listed

231 Lifestyle Court

Myrtle Beach

$439,000

Property Type: detached

MLS: 2529560

Status: ACTIVE

Just Listed

7144 Highway 366

Conway

$279,900

Property Type: manufactured with land

MLS: 2529563

Status: ACTIVE

Just Listed

TBD Old Buck Creek Rd.

Longs

$499,800

Property Type: detached

MLS: 2529573

Status: ACTIVE

Just Listed

1657 Ursa Major Dr.

Myrtle Beach

$149,959

Property Type: manufactured leased land

MLS: 2529580

Status: ACTIVE

Just Listed

137 Riptide Circle

North Myrtle Beach

$130,000

Property Type: manufactured leased land

MLS: 2529583

Status: ACTIVE

Just Listed

1701 Crystal Lake Dr.

Myrtle Beach

$162,500

Property Type: manufactured leased land

MLS: 2529447

Status: ACTIVE

Just Listed

4544 Plum Tree Ln.

Conway

$465,000

Property Type: detached

MLS: 2529513

Status: ACTIVE

Just Listed

2475 Copper Creek Loop

Longs

$429,000

Property Type: detached

MLS: 2529459

Status: ACTIVE

Just Listed

2160 Spring Tree Dr.

Little River

$459,000

Property Type: detached

MLS: 2529506

Status: ACTIVE

Just Listed

2730 Cultra Rd.

Conway

$399,900

Property Type: detached

MLS: 2529442

Status: ACTIVE

Just Listed

60 Summerlight Dr.

Murrells Inlet

$725,000

Property Type: detached

MLS: 2529448

Status: ACTIVE

Just Listed

286 Copperwood Loop

Conway

$294,500

Property Type: detached

MLS: 2529449

Status: ACTIVE

Just Listed

2701 Monaca Dr.

Longs

$390,000

Property Type: detached

MLS: 2529451

Status: ACTIVE

Just Listed

349 St. Julian Ln.

Myrtle Beach

$1,299,999

Property Type: detached

MLS: 2529463

Status: ACTIVE

Just Listed

78 Wicklow Way

Pawleys Island

$725,000

Property Type: detached

MLS: 2529469

Status: ACTIVE

Just Listed

510 Folly Estates Dr.

Myrtle Beach

$115,000

Property Type: manufactured leased land

MLS: 2529477

Status: ACTIVE

Just Listed

216 Blue Wing Court

Conway

$345,990

Property Type: detached

MLS: 2529478

Status: ACTIVE

Just Listed

1210 SeaChase Way

North Myrtle Beach

$454,100

Property Type: detached

MLS: 2529483

Status: ACTIVE

Just Listed

122 Cascade Dr.

Conway

$339,989

Property Type: detached

MLS: 2529484

Status: ACTIVE

Just Listed

3393 N Pointe Blvd.

Little River

$225,000

Property Type: manufactured with land

MLS: 2529486

Status: ACTIVE

Just Listed

3211 Sutherland Dr.

Little River

$419,900

Property Type: detached

MLS: 2529492

Status: ACTIVE

Just Listed

563 Chandler Ave.

Murrells Inlet

$2,400,000

Property Type: detached

MLS: 2529496

Status: ACTIVE

Just Listed

1017 Franks Ln.

Conway

$170,000

Property Type: manufactured with land

MLS: 2529499

Status: ACTIVE

Just Listed

1015 Franks Ln.

Conway

$220,000

Property Type: manufactured with land

MLS: 2529500

Status: ACTIVE

Just Listed

296 Lakota Loop

Longs

$309,900

Property Type: detached

MLS: 2529503

Status: ACTIVE

Just Listed

724 1st St.

Murrells Inlet

$279,900

Property Type: manufactured with land

MLS: 2529504

Status: ACTIVE

Just Listed

414 S Dogwood Dr.

Murrells Inlet

$1,690,000

Property Type: detached

MLS: 2529510

Status: ACTIVE

Just Listed

3458 Eversheen Dr.

Little River

$425,000

Property Type: detached

MLS: 2529515

Status: ACTIVE

Just Listed

3458 Eversheen Dr.

Little River

$425,000

Property Type: detached

MLS: 2529515

Status: ACTIVE

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