Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184
Execution Time: 0.168 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: 0.579 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
OSPREY COVE

206 Kestrel Ct.

Myrtle Beach

$249,900

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2301670

Status: ACTIVE

Just Listed
WINDY HILL BEACH

3601 Poinsett St.

North Myrtle Beach

$549,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2305426

Status: ACTIVE

Just Listed
CAROPINES

7 Pierce Pl.

Surfside Beach

$285,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2305444

Status: ACTIVE

Just Listed
CAPE COD COTTAGES AT MARKER 350

108 Marblehead Dr.

Little River

$699,900

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached with hpr

MLS: 2305386

Status: ACTIVE

Just Listed
WILD WING PLANTATION

1001 Limpkin Dr.

Conway

$647,500

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2305385

Status: ACTIVE

Just Listed
SPRINGFIELD

1127 Lampwick Ln.

Murrells Inlet

$370,000

Beds / Baths: 4 Bed, 2 Bath

Property Type: detached

MLS: 2305387

Status: ACTIVE

Just Listed
LITCHFIELD COUNTRY CLUB

536 Hawthorn Dr.

Pawleys Island

$449,900

Beds / Baths: 4 Bed, 2 Bath

Property Type: detached

MLS: 2305394

Status: ACTIVE

Just Listed
PLANTATION POINT

3706 Kinloch Dr.

Myrtle Beach

$689,900

Beds / Baths: 4 Bed, 4 Bath

Property Type: detached

MLS: 2305395

Status: ACTIVE

Just Listed
WINDJAMMER VILLAGE - GC

20 Ocean Reef Ln.

Murrells Inlet

$120,000

Beds / Baths: 2 Bed, 2 Bath

Property Type: manufactured leased land

MLS: 2305400

Status: ACTIVE

Just Listed
WESLIN CREEK

8804 Gallant Ct.

Myrtle Beach

$265,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: manufactured with land

MLS: 2305403

Status: ACTIVE

Just Listed
SUNNYSIDE VILLAGE

10 Hallandale Lane

Murrells Inlet

$449,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: semi-detached

MLS: 2305399

Status: ACTIVE

Just Listed
RED HILL COMMONS

352 Borrowdale Dr.

Conway

$344,800

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2305405

Status: ACTIVE

Just Listed
RED HILL COMMONS

356 Borrowdale Dr.

Conway

$325,000

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2305407

Status: ACTIVE

Just Listed
RED HILL COMMONS

364 Borrowdale Dr.

Conway

$319,000

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2305410

Status: ACTIVE

Just Listed
EMMENS PRESERVE - MARKET COMMONS

1549 Beaumont Way

Myrtle Beach

$580,000

Beds / Baths: 4 Bed, 4 Bath

Property Type: detached

MLS: 2305417

Status: ACTIVE

Just Listed
NORTH LITCHFIELD BEACH

65 Starboard Ct.

Pawleys Island

$1,350,000

Beds / Baths: 6 Bed, 5 Bath

Property Type: detached

MLS: 2305415

Status: ACTIVE

Just Listed
SPARROW

1015-A Lakeside Dr.

Surfside Beach

$999,900

Beds / Baths: 5 Bed, 5 Bath

Property Type: detached

MLS: 2305425

Status: ACTIVE

Just Listed
WILD HORSE

3030 Wild Horse Circle

Conway

$649,900

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2305422

Status: ACTIVE

Just Listed
SPARROW

1015-B Lakeside Dr.

Surfside Beach

$1,249,900

Beds / Baths: 7 Bed, 7 Bath

Property Type: detached

MLS: 2305431

Status: ACTIVE

Just Listed
CLEAR POND AT MYRTLE BEACH NATIO

4208 Vista Wood Dr.

Myrtle Beach

$389,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2305437

Status: ACTIVE

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