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

3202 Inland St.

North Myrtle Beach

$559,000

Property Type: detached

MLS: 2524767

Status: ACTIVE

236 Legends Village Loop

Myrtle Beach

$289,900

Property Type: detached

MLS: 2524696

Status: ACTIVE

8951 Alexander Ct.

Myrtle Beach

$265,000

Property Type: manufactured with land

MLS: 2524700

Status: ACTIVE

1178 Sennema Circle

Myrtle Beach

$344,900

Property Type: detached

MLS: 2524701

Status: ACTIVE

3806 North Ocean Blvd.

Myrtle Beach

$2,790,000

Property Type: detached

MLS: 2524702

Status: ACTIVE

403 Lifestyle Court

Surfside Beach

$420,000

Property Type: detached

MLS: 2524703

Status: ACTIVE

298 Flamingo Ct.

Surfside Beach

$350,000

Property Type: manufactured leased land

MLS: 2524709

Status: ACTIVE

2214 Eastwoods Dr.

Conway

$549,900

Property Type: detached

MLS: 2524711

Status: ACTIVE

8346 Cape Dutch Loop

Myrtle Beach

$919,000

Property Type: detached

MLS: 2524712

Status: ACTIVE

253 Maple Oak Dr.

Conway

$292,500

Property Type: detached

MLS: 2524714

Status: ACTIVE

411 Lake Shore Dr.

Sunset Beach

$1,369,000

Property Type: detached

MLS: 2524715

Status: ACTIVE

1904 Blue Bird Rd.

Loris

$319,900

Property Type: detached

MLS: 2524723

Status: ACTIVE

1490 Lawson Dr.

Galivants Ferry

$259,900

Property Type: detached

MLS: 2524724

Status: ACTIVE

2701 South Key Largo Circle

Myrtle Beach

$425,000

Property Type: detached

MLS: 2524725

Status: ACTIVE

9282 Checkerberry Square

Calabash

$925,000

Property Type: detached

MLS: 2524729

Status: ACTIVE

131 Marauder Dr.

Longs

$299,900

Property Type: detached

MLS: 2524730

Status: ACTIVE

8243 Energize Dr.

Longs

$392,990

Property Type: detached

MLS: 2524732

Status: ACTIVE

8251 Energize Dr.

Longs

$375,990

Property Type: detached

MLS: 2524734

Status: ACTIVE

8223 Energize Dr.

Longs

$399,990

Property Type: detached

MLS: 2524735

Status: ACTIVE

2532 Stones Edge Blvd.

Little River

$293,000

Property Type: detached

MLS: 2524739

Status: ACTIVE

1529 Bucksport Rd.

Conway

$244,000

Property Type: detached

MLS: 2524742

Status: ACTIVE

8213 Energize Dr.

Longs

$328,990

Property Type: detached

MLS: 2524747

Status: ACTIVE

3400 Tranquility Ln.

Longs

$389,990

Property Type: detached

MLS: 2524748

Status: ACTIVE

1097 Lauryn Oak Loop

Longs

$294,990

Property Type: detached

MLS: 2524750

Status: ACTIVE

3721 Park Pointe Ave.

Little River

$489,000

Property Type: detached

MLS: 2524752

Status: ACTIVE

1060 Lauryn Oak Loop

Longs

$264,990

Property Type: detached

MLS: 2524753

Status: ACTIVE

1064 Lauryn Oak Loop

Longs

$279,990

Property Type: detached

MLS: 2524756

Status: ACTIVE

3404 Tranquility Ln.

Longs

$418,990

Property Type: detached

MLS: 2524757

Status: ACTIVE

3412 Tranquility Ln.

Longs

$463,990

Property Type: detached

MLS: 2524758

Status: ACTIVE

3385 Pampas Dr.

Myrtle Beach

$850,000

Property Type: detached

MLS: 2524759

Status: ACTIVE

2737 Capricorn Dr.

Myrtle Beach

$149,000

Property Type: manufactured leased land

MLS: 2524761

Status: ACTIVE

3500 Tranquility Ln.

Longs

$412,990

Property Type: detached

MLS: 2524765

Status: ACTIVE

1068 Lauryn Oak Loop

Longs

$307,990

Property Type: detached

MLS: 2524766

Status: ACTIVE

747 Coquina Bay Dr.

Conway

$320,000

Property Type: detached

MLS: 2524769

Status: ACTIVE

472 Cypress Preserve Circle

Longs

$339,990

Property Type: detached

MLS: 2524770

Status: ACTIVE

8230 Energize Dr.

Longs

$413,990

Property Type: detached

MLS: 2524772

Status: ACTIVE

1657 Hope Pointe Dr

North Myrtle Beach

$559,990

Property Type: detached

MLS: 2524774

Status: ACTIVE

5811 Woodside Dr.

Myrtle Beach

$1,215,035

Property Type: detached

MLS: 2524776

Status: ACTIVE

2073 Timmerman Rd.

Myrtle Beach

$815,000

Property Type: detached

MLS: 2524778

Status: ACTIVE

312 Garden Grove St

Conway

$331,900

Property Type: detached

MLS: 2524779

Status: ACTIVE

1609 Eastover Ln.

North Myrtle Beach

$799,000

Property Type: detached

MLS: 2524780

Status: ACTIVE

8234 Energize Dr.

Longs

$383,990

Property Type: detached

MLS: 2524781

Status: ACTIVE

728 Four Mile Rd.

Conway

$319,000

Property Type: detached

MLS: 2524782

Status: ACTIVE

8488 Cape Dutch Loop

Myrtle Beach

$814,000

Property Type: detached

MLS: 2524785

Status: ACTIVE

545 Saluda River Rd.

Myrtle Beach

$349,999

Property Type: detached

MLS: 2524786

Status: ACTIVE

397 Indigo Bay Circle

Myrtle Beach

$549,990

Property Type: detached

MLS: 2524789

Status: ACTIVE

340 Waties Dr.

Murrells Inlet

$399,900

Property Type: detached

MLS: 2524791

Status: ACTIVE

216 Rose Water Loop

Myrtle Beach

$315,000

Property Type: semi-detached

MLS: 2524793

Status: ACTIVE

828 Channel Cat Cove

Murrells Inlet

$1,125,000

Property Type: detached

MLS: 2524797

Status: ACTIVE

442 Deer Watch Circle

Longs

$299,000

Property Type: detached

MLS: 2524802

Status: ACTIVE

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