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

$415,000

Property Type: detached with hpr

MLS: 2522497

Status: ACTIVE

Just Listed

9306 Long Meadow Way

Longs

$569,440

Property Type: detached

MLS: 2527132

Status: ACTIVE

Just Listed

500 Acosta Circle

Conway

$297,490

Property Type: detached

MLS: 2527128

Status: ACTIVE

Just Listed

101 Feather Dr

Georgetown

$219,000

Property Type: manufactured with land

MLS: 2527098

Status: ACTIVE

Just Listed

408 Feathergrass Way

Little River

$634,900

Property Type: detached

MLS: 2527101

Status: ACTIVE

Just Listed

1509 Lakeland Dr.

Conway

$275,000

Property Type: detached

MLS: 2527102

Status: ACTIVE

Just Listed

139 Pioneer Loop

Georgetown

$8,500,000

Property Type: detached

MLS: 2527103

Status: ACTIVE

Just Listed

899 Callant Dr.

Little River

$350,000

Property Type: detached

MLS: 2527106

Status: ACTIVE

Just Listed

177 Pampa Dr.

Loris

$302,965

Property Type: detached

MLS: 2527107

Status: ACTIVE

Just Listed

192 Pampa Dr.

Loris

$307,965

Property Type: detached

MLS: 2527109

Status: ACTIVE

Just Listed

3593 Valley Forge Rd.

Aynor

$319,900

Property Type: detached

MLS: 2527110

Status: ACTIVE

Just Listed

3589 Valley Forge Rd.

Aynor

$319,900

Property Type: detached

MLS: 2527111

Status: ACTIVE

Just Listed

5115 Marigold Rd.

Conway

$229,900

Property Type: detached

MLS: 2527112

Status: ACTIVE

Just Listed

5119 Marigold Rd.

Conway

$229,900

Property Type: detached

MLS: 2527114

Status: ACTIVE

Just Listed

384 Glade Ct.

Loris

$325,298

Property Type: detached

MLS: 2527115

Status: ACTIVE

Just Listed

237 Perrin Rd.

Loris

$275,000

Property Type: detached

MLS: 2527119

Status: ACTIVE

Just Listed

6001 - 1705 S Kings Hwy.

Myrtle Beach

$499,000

Property Type: detached leased land

MLS: 2527123

Status: ACTIVE

Just Listed

912 Blacksmith Dr.

Loris

$306,040

Property Type: detached

MLS: 2527124

Status: ACTIVE

Just Listed

495 Acosta Circle

Conway

$297,490

Property Type: detached

MLS: 2527126

Status: ACTIVE

Just Listed

709 Triple Oak Ln.

Garden City Beach

$824,999

Property Type: detached

MLS: 2527130

Status: ACTIVE

Just Listed

6052 Renata Ln.

Myrtle Beach

$2,750,000

Property Type: detached

MLS: 2527133

Status: ACTIVE

Just Listed

801 Talbot Circle

Myrtle Beach

$370,000

Property Type: detached

MLS: 2527135

Status: ACTIVE

Just Listed

348 Mistletoe Way

Longs

$264,600

Property Type: detached

MLS: 2527136

Status: ACTIVE

Just Listed

407 Turtlehead Dr.

Longs

$259,900

Property Type: detached

MLS: 2527137

Status: ACTIVE

Just Listed

TBB 3 Duford Rd.

Nichols

$433,900

Property Type: detached

MLS: 2527143

Status: ACTIVE

Just Listed

TBD23 Duford Rd.

Nichols

$631,900

Property Type: detached

MLS: 2527145

Status: ACTIVE

Just Listed

3264 Ten Acre Rd.

Andrews

$370,000

Property Type: manufactured with land

MLS: 2527146

Status: ACTIVE

Just Listed

58 Swan Point Trail

Georgetown

$3,950,000

Property Type: detached

MLS: 2527033

Status: ACTIVE

Just Listed

164 Boatmen Dr.

Pawleys Island

$530,000

Property Type: detached

MLS: 2527039

Status: ACTIVE

Just Listed

1605 Sessions St.

Conway

$259,900

Property Type: detached

MLS: 2527040

Status: ACTIVE

Just Listed

1549 Brookgreen Dr.

Myrtle Beach

$1,185,000

Property Type: detached

MLS: 2527028

Status: ACTIVE

Just Listed

1439 Winding Creek Way

Myrtle Beach

$479,640

Property Type: detached

MLS: 2527108

Status: ACTIVE

Just Listed

15 Pinckney Rd.

Georgetown

$2,190,000

Property Type: detached

MLS: 2526996

Status: ACTIVE

Just Listed

820 9th Ave. S

North Myrtle Beach

$439,000

Property Type: detached

MLS: 2527031

Status: ACTIVE

Just Listed

1495 Wilderness Ln.

Loris

$279,000

Property Type: detached

MLS: 2526994

Status: ACTIVE

Just Listed

5706 Porcher Dr.

Myrtle Beach

$2,190,000

Property Type: detached

MLS: 2527001

Status: ACTIVE

Just Listed

5811 Sumter Dr.

Myrtle Beach

$799,900

Property Type: detached

MLS: 2527008

Status: ACTIVE

Just Listed

5580 Green Bay Circle

Myrtle Beach

$295,900

Property Type: detached

MLS: 2527013

Status: ACTIVE

Just Listed

141 Feather Dr

Georgetown

$199,000

Property Type: manufactured with land

MLS: 2527020

Status: ACTIVE

Just Listed

4384 Superior Circle

Little River

$194,000

Property Type: manufactured leased land

MLS: 2527022

Status: ACTIVE

Just Listed

63 Saxon Ct.

Murrells Inlet

$107,900

Property Type: manufactured leased land

MLS: 2527023

Status: ACTIVE

Just Listed

4237 Rivergate Ln.

Little River

$275,000

Property Type: semi-detached

MLS: 2527030

Status: ACTIVE

Just Listed

4715 Harvest Dr.

Myrtle Beach

$415,000

Property Type: detached

MLS: 2527036

Status: ACTIVE

Just Listed

1225 Forestbrook Rd.

Myrtle Beach

$329,000

Property Type: detached

MLS: 2527045

Status: ACTIVE

Just Listed

103 E 2nd Ave.

Lake View

$189,900

Property Type: detached

MLS: 2527061

Status: ACTIVE

Just Listed

313 Azimuth Dr

Conway

$309,990

Property Type: detached

MLS: 2527063

Status: ACTIVE

Just Listed

1349 Midtown Village Dr.

Conway

$250,000

Property Type: detached

MLS: 2527067

Status: ACTIVE

Just Listed

1416 Winding Creek Way

Myrtle Beach

$444,490

Property Type: detached

MLS: 2527068

Status: ACTIVE

Just Listed

438 Castillo Dr.

Loris

$284,990

Property Type: detached

MLS: 2527070

Status: ACTIVE

Just Listed

463 Castillo Dr.

Loris

$267,990

Property Type: detached

MLS: 2527071

Status: ACTIVE

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