Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183
Execution Time: 0.184 ms
Record Count: 21
Cached: Yes
Cache Type: timespan
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.96 ms
Record Count: 21
Cached: No
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

990 Highway 66

Conway

$395,000

Property Type: manufactured with land

MLS: 2503878

Status: ACTIVE

Just Listed

868 Agostino Dr.

Myrtle Beach

$480,000

Property Type: detached

MLS: 2520014

Status: ACTIVE

Just Listed

42 Enclave Pl.

Pawleys Island

$1,475,000

Property Type: detached

MLS: 2520033

Status: ACTIVE

Just Listed

568 Rosedale Dr.

Aynor

$276,300

Property Type: detached

MLS: 2520072

Status: ACTIVE

Just Listed

1531 Milano Ct.

Myrtle Beach

$1,425,000

Property Type: detached

MLS: 2520046

Status: ACTIVE

Just Listed

1416 Lighthouse Dr.

North Myrtle Beach

$689,900

Property Type: detached

MLS: 2520011

Status: ACTIVE

Just Listed

171 Cassina Dr.

Longs

$360,000

Property Type: detached

MLS: 2520015

Status: ACTIVE

Just Listed

131 Marauder Dr.

Longs

$299,900

Property Type: detached

MLS: 2520016

Status: ACTIVE

Just Listed

6001 South Kings Hwy.

Myrtle Beach

$208,500

Property Type: manufactured leased land

MLS: 2520017

Status: ACTIVE

Just Listed

533 Key Largo Ave.

Murrells Inlet

$129,900

Property Type: manufactured leased land

MLS: 2520018

Status: ACTIVE

Just Listed

208 Green Lake Dr.

Myrtle Beach

$1,625,000

Property Type: detached

MLS: 2520019

Status: ACTIVE

Just Listed

5230 Piemonte Ln.

Myrtle Beach

$455,000

Property Type: detached

MLS: 2520020

Status: ACTIVE

Just Listed

6001-5524 S Kings Hwy.

Myrtle Beach

$432,000

Property Type: detached leased land

MLS: 2520024

Status: ACTIVE

Just Listed

531 Key Largo Ave.

Murrells Inlet

$129,900

Property Type: manufactured leased land

MLS: 2520026

Status: ACTIVE

Just Listed

2013 Spring Valley Ct.

Loris

$274,900

Property Type: detached

MLS: 2520027

Status: ACTIVE

Just Listed

1335 Tarisa Ave.

Myrtle Beach

$599,000

Property Type: detached

MLS: 2520030

Status: ACTIVE

Just Listed

4186 Still Pond Rd.

Conway

$279,900

Property Type: manufactured with land

MLS: 2520031

Status: ACTIVE

Just Listed

1010 Swan Lake Dr.

North Myrtle Beach

$610,000

Property Type: detached

MLS: 2520036

Status: ACTIVE

Just Listed

317 Wheeler Rd.

Andrews

$334,000

Property Type: detached

MLS: 2520037

Status: ACTIVE

Just Listed

701 Shell Point Ct.

Longs

$834,999

Property Type: detached

MLS: 2520044

Status: ACTIVE

Just Listed

6591 Breezewood Blvd.

Myrtle Beach

$280,000

Property Type: detached

MLS: 2520045

Status: ACTIVE

Just Listed

399 Lumbee Circle

Pawleys Island

$649,000

Property Type: detached

MLS: 2520053

Status: ACTIVE

Just Listed

574 Whiddy Loop

Conway

$312,000

Property Type: detached

MLS: 2520061

Status: ACTIVE

Just Listed

757 Bucklin Loop

Myrtle Beach

$299,900

Property Type: detached

MLS: 2520063

Status: ACTIVE

Just Listed

4090 Matanzas Dr.

Myrtle Beach

$1,300,000

Property Type: detached

MLS: 2520064

Status: ACTIVE

Just Listed

626 Woodholme Dr.

Conway

$220,000

Property Type: manufactured leased land

MLS: 2520067

Status: ACTIVE

Just Listed

1104 Worchester Ct.

Murrells Inlet

$555,000

Property Type: detached

MLS: 2520068

Status: ACTIVE

Just Listed

5070 South First St.

Murrells Inlet

$765,000

Property Type: detached

MLS: 2520069

Status: ACTIVE

Just Listed

5730 Highway 707

Myrtle Beach

$76,500

Property Type: manufactured leased land

MLS: 2520070

Status: ACTIVE

Just Listed

414 Carriage Lake Dr.

Little River

$499,999

Property Type: detached

MLS: 2520076

Status: ACTIVE

Just Listed

6001-N76 S Kings Hwy.

Myrtle Beach

$189,000

Property Type: manufactured leased land

MLS: 2519986

Status: ACTIVE

Just Listed

83 Pond St.

Georgetown

$385,000

Property Type: detached

MLS: 2519995

Status: ACTIVE

Just Listed

3114 Visionary Dr.

Myrtle Beach

$582,900

Property Type: detached

MLS: 2519996

Status: ACTIVE

Just Listed

3130 Visionary Dr.

Myrtle Beach

$507,900

Property Type: detached

MLS: 2519998

Status: ACTIVE

Just Listed

1118 Hainer Place Dr

Conway

$319,900

Property Type: detached

MLS: 2520000

Status: ACTIVE

Just Listed

6001 South Kings Hwy.

Surfside Beach

$410,000

Property Type: manufactured leased land

MLS: 2520001

Status: ACTIVE

Just Listed

3431 Logan St.

Conway

$342,900

Property Type: detached

MLS: 2520004

Status: ACTIVE

Just Listed

2807 Temperance Dr.

Myrtle Beach

$349,000

Property Type: detached

MLS: 2520006

Status: ACTIVE

Just Listed

3001 Palma Way

Myrtle Beach

$384,990

Property Type: detached

MLS: 2519967

Status: ACTIVE

Just Listed

617 Truman Rd.

Conway

$300,000

Property Type: detached

MLS: 2519952

Status: ACTIVE

Just Listed

741 Enchantment Loop

Myrtle Beach

$480,000

Property Type: detached

MLS: 2519961

Status: ACTIVE

Just Listed

322 Yucca Circle

Garden City Beach

$189,900

Property Type: manufactured leased land

MLS: 2519962

Status: ACTIVE

Just Listed

2005 Duckweed Dr.

Longs

$268,000

Property Type: detached

MLS: 2519963

Status: ACTIVE

Just Listed

258 NW Mayflower Dr.

Calabash

$351,900

Property Type: detached

MLS: 2519964

Status: ACTIVE

Just Listed

2544 Lake Vista Dr.

Little River

$545,000

Property Type: detached

MLS: 2519965

Status: ACTIVE

Just Listed

105 Double Pond Dr

Georgetown

$368,639

Property Type: detached

MLS: 2519968

Status: ACTIVE

Just Listed

1458 Vardon Ct.

Murrells Inlet

$372,000

Property Type: detached

MLS: 2519969

Status: ACTIVE

Just Listed

1142 N Blackmoor Dr.

Murrells Inlet

$549,000

Property Type: detached

MLS: 2519970

Status: ACTIVE

Just Listed

188 Valerio St.

Myrtle Beach

$490,990

Property Type: detached

MLS: 2519971

Status: ACTIVE

Just Listed

134 Double Pond Dr

Georgetown

$364,539

Property Type: detached

MLS: 2519972

Status: ACTIVE

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