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

648 Grateful Dr.

Little River

$315,390

Property Type: detached

MLS: 2600584

Status: ACTIVE

Just Listed

2104 Clematis Ct.

Myrtle Beach

$1,049,000

Property Type: detached

MLS: 2600599

Status: ACTIVE

Just Listed

153 Watson Way

Pawleys Island

$650,000

Property Type: detached

MLS: 2600578

Status: ACTIVE

Just Listed

318 31st Ave. N

North Myrtle Beach

$624,900

Property Type: detached

MLS: 2600565

Status: ACTIVE

Just Listed

2724 A C Ln

Conway

$459,000

Property Type: detached

MLS: 2600568

Status: ACTIVE

Just Listed

1961 Indigo Cove Way

Calabash

$549,999

Property Type: detached

MLS: 2600569

Status: ACTIVE

Just Listed

2028 Misty Morning Dr.

Conway

$219,900

Property Type: manufactured with land

MLS: 2600572

Status: ACTIVE

Just Listed

800 Wild Leaf Loop

Conway

$425,000

Property Type: detached

MLS: 2600573

Status: ACTIVE

Just Listed

166 Ecum Secum Pl.

Conway

$275,000

Property Type: detached

MLS: 2600581

Status: ACTIVE

Just Listed

304 Lakota Loop

Longs

$325,000

Property Type: detached

MLS: 2600583

Status: ACTIVE

Just Listed

206 Bantry Ln.

Conway

$402,840

Property Type: detached

MLS: 2600587

Status: ACTIVE

Just Listed

210 Bantry Ln.

Conway

$391,465

Property Type: detached

MLS: 2600588

Status: ACTIVE

Just Listed

6001 - 1162 S Kings Hwy.

Myrtle Beach

$219,000

Property Type: manufactured leased land

MLS: 2600589

Status: ACTIVE

Just Listed

703 62nd Ave. N

Myrtle Beach

$475,000

Property Type: detached

MLS: 2600590

Status: ACTIVE

Just Listed

1509 Two Notch Circle

Ash

$393,315

Property Type: detached

MLS: 2600592

Status: ACTIVE

Just Listed

600 Ermine Rd

West Columbia

$77,000

Property Type: detached

MLS: 2600593

Status: ACTIVE

Just Listed

1587 Landing Rd.

Myrtle Beach

$299,900

Property Type: detached

MLS: 2600594

Status: ACTIVE

Just Listed

292 Flamingo Dr.

Surfside Beach

$247,500

Property Type: manufactured leased land

MLS: 2600598

Status: ACTIVE

Just Listed

304 Beaufain Dr.

Myrtle Beach

$639,900

Property Type: detached

MLS: 2600600

Status: ACTIVE

Just Listed

891 Mourning Dove Dr.

Myrtle Beach

$609,999

Property Type: detached

MLS: 2600603

Status: ACTIVE

Just Listed

3023 Tasso Dr.

Sunset Beach

$298,810

Property Type: detached

MLS: 2600605

Status: ACTIVE

Just Listed

34 Lazy Hammock Trail

Pawleys Island

$649,000

Property Type: detached

MLS: 2600606

Status: ACTIVE

Just Listed

6001 1829A South Kings Hwy.

Myrtle Beach

$250,000

Property Type: detached leased land

MLS: 2600607

Status: ACTIVE

Just Listed

1727 Kings Oak Lp

Conway

$244,000

Property Type: detached

MLS: 2600609

Status: ACTIVE

Just Listed

258 Lifestyle Court

Surfside Beach

$406,000

Property Type: detached

MLS: 2600611

Status: ACTIVE

Just Listed

301 B N North Ocean Blvd.

Myrtle Beach

$1,450,000

Property Type: detached

MLS: 2600613

Status: ACTIVE

Just Listed

502 Lakeshore Dr.

Surfside Beach

$449,000

Property Type: detached

MLS: 2600614

Status: ACTIVE

Just Listed

379 Mikita Dr.

Surfside Beach

$539,900

Property Type: detached

MLS: 2600617

Status: ACTIVE

Just Listed

712 Raleigh Trail

Murrells Inlet

$129,000

Property Type: manufactured leased land

MLS: 2600618

Status: ACTIVE

Just Listed

235 Palmetto Harbour Dr.

North Myrtle Beach

$1,349,900

Property Type: detached

MLS: 2600620

Status: ACTIVE

Just Listed

3721 Long Avenue Ext.

Conway

$599,900

Property Type: detached

MLS: 2600625

Status: ACTIVE

Just Listed

3206 N Ocean Blvd.

North Myrtle Beach

$2,599,000

Property Type: detached

MLS: 2600628

Status: ACTIVE

Just Listed

613 5th Ave. S

Myrtle Beach

$95,000

Property Type: manufactured leased land

MLS: 2600530

Status: ACTIVE

Just Listed

3021 Moss Bridge Ln.

Myrtle Beach

$597,000

Property Type: detached

MLS: 2600444

Status: ACTIVE

Just Listed

876 Birch Garden Dr.

Longs

$369,990

Property Type: detached

MLS: 2600517

Status: ACTIVE

Just Listed

127 Campania St.

Myrtle Beach

$399,900

Property Type: detached

MLS: 2600432

Status: ACTIVE

Just Listed

653 Pamlico Ct.

Myrtle Beach

$349,000

Property Type: detached

MLS: 2600437

Status: ACTIVE

Just Listed

253 Splendor Circle

Murrells Inlet

$569,000

Property Type: detached

MLS: 2600438

Status: ACTIVE

Just Listed

5434 Merrywind Ct.

Myrtle Beach

$435,000

Property Type: detached

MLS: 2600440

Status: ACTIVE

Just Listed

236 Gloucester Way

Little River

$480,000

Property Type: detached with hpr

MLS: 2600442

Status: ACTIVE

Just Listed

49 Schooner Ct.

Pawleys Island

$1,484,000

Property Type: detached

MLS: 2600445

Status: ACTIVE

Just Listed

521 Oak Lawn Rd.

Georgetown

$674,900

Property Type: detached

MLS: 2600446

Status: ACTIVE

Just Listed

3901 Birchwood St.

North Myrtle Beach

$485,000

Property Type: detached

MLS: 2600449

Status: ACTIVE

Just Listed

1309 Camlet Ln.

Little River

$352,000

Property Type: detached

MLS: 2600452

Status: ACTIVE

Just Listed

1309 Camlet Ln.

Little River

$352,000

Property Type: detached

MLS: 2600452

Status: ACTIVE

Just Listed

2105 Cultra Rd.

Conway

$350,000

Property Type: detached

MLS: 2600453

Status: ACTIVE

Just Listed

5361 Bottle Branch Rd.

Conway

$225,000

Property Type: detached

MLS: 2600460

Status: ACTIVE

Just Listed

586 Indigo Bay Circle

Myrtle Beach

$614,999

Property Type: detached

MLS: 2600462

Status: ACTIVE

Just Listed

6001 - 1669 S Kings Hwy.

Myrtle Beach

$239,900

Property Type: manufactured leased land

MLS: 2600464

Status: ACTIVE

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