Iris & Howard Real Estate
Query
Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184
Execution Time: 0.229 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.456 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
FORESTBROOK ESTATES

747 Little Fawn Way

Myrtle Beach

$424,900

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2413274

Status: ACTIVE

WHITE HALL

736 Hobonny Loop

Longs

$259,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2410240

Status: ACTIVE

Just Listed
PINE FOREST

336 Spruce Pine Way

Conway

$275,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417595

Status: ACTIVE

Just Listed
APACHE CAMPGROUND

9700 Kings Rd.

Myrtle Beach

$79,000

Beds / Baths: 1 Bed, 1 Bath

Property Type: manufactured leased land

MLS: 2417598

Status: ACTIVE

Just Listed
ANDALUSIA

158 Linares St.

Loris

$290,490

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417556

Status: ACTIVE

Just Listed
NOT WITHIN A SUBDIVISION

1309 Belle Dr.

North Myrtle Beach

$550,000

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2417503

Status: ACTIVE

Just Listed
NOT WITHIN A SUBDIVISION

2403 Park St.

North Myrtle Beach

$435,000

Beds / Baths: 3 Bed, 3 Bath

Property Type: detached

MLS: 2417506

Status: ACTIVE

Just Listed
NOT WITHIN A SUBDIVISION

1913 Hillside Dr. S

North Myrtle Beach

$450,000

Beds / Baths: 2 Bed, 2 Bath

Property Type: detached

MLS: 2417505

Status: ACTIVE

Just Listed
THE FARM @ TIMBERLAKE

4931 Oat Fields Dr.

Myrtle Beach

$499,900

Beds / Baths: 4 Bed, 2 Bath

Property Type: detached

MLS: 2417504

Status: ACTIVE

Just Listed
57TH PLACE

878 Snowberry Dr.

Longs

$375,000

Beds / Baths: 4 Bed, 2 Bath

Property Type: detached

MLS: 2417507

Status: ACTIVE

Just Listed
TIFFANY RIDGE

1212 Lexi Ln.

Myrtle Beach

$265,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417508

Status: ACTIVE

Just Listed
NORTH BEACH PLANTATION - WHITEPO

4985 Salt Creek Ct.

North Myrtle Beach

$910,000

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached with hpr

MLS: 2417509

Status: ACTIVE

Just Listed
RAVENWOOD

4224 Ravenwood Dr.

Little River

$438,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417510

Status: ACTIVE

Just Listed
NOT WITHIN A SUBDIVISION

4032 Nesmith Rd.

Nesmith

$249,000

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2417511

Status: ACTIVE

Just Listed
HILLSBOROUGH

1225 White Fox Ct.

Conway

$435,000

Beds / Baths: 5 Bed, 2 Bath

Property Type: detached

MLS: 2417512

Status: ACTIVE

Just Listed
NOT WITHIN A SUBDIVISION

478 Hammock Ave.

Murrells Inlet

$774,900

Beds / Baths: 4 Bed, 3 Bath

Property Type: detached

MLS: 2417513

Status: ACTIVE

Just Listed
CONWAY PLANTATION

1023 Conway Plantation Dr.

Conway

$109,000

Beds / Baths: 3 Bed, 2 Bath

Property Type: manufactured leased land

MLS: 2417519

Status: ACTIVE

Just Listed
AMBERFIELD

7010 Walden Ct.

Myrtle Beach

$225,000

Beds / Baths: 4 Bed, 2 Bath

Property Type: manufactured with land

MLS: 2417516

Status: ACTIVE

Just Listed
BUNGALOWS ON 9TH

841 9th Ave. S

North Myrtle Beach

$614,900

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417517

Status: ACTIVE

Just Listed
RED HILL COMMONS

373 Borrowdale Dr.

Conway

$324,900

Beds / Baths: 3 Bed, 2 Bath

Property Type: detached

MLS: 2417515

Status: ACTIVE

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