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

TBD Oneal Road Oneal Rd

Loris

$80,000

Property Type: acreage

MLS: 2517768

Status: ACTIVE

TBD Old Railroad Rd.

Conway

$495,000

Property Type: acreage

MLS: 2517776

Status: ACTIVE

5705 Highway 712

Galivants Ferry

$135,000

Property Type: acreage

MLS: 2517777

Status: ACTIVE

2405 & 2407 Highmarket St.

Georgetown

$500,000

Property Type: commercial lot - sale

MLS: 2517782

Status: ACTIVE

TBD Carver Hall Rd

Hamer

$65,000

Property Type: acreage

MLS: 2517783

Status: ACTIVE

713 17th Ave. N

Surfside Beach

$300,000

Property Type: residential lot

MLS: 2517784

Status: ACTIVE

TBD Dukes Rd.

Conway

$699,900

Property Type: acreage

MLS: 2517831

Status: ACTIVE

0 Magill Dr.

Georgetown

$300,000

Property Type: residential lot

MLS: 2517751

Status: ACTIVE

TBD Tomahawk Rd.

Hemingway

$48,000

Property Type: acreage

MLS: 2517699

Status: ACTIVE

186 Fern Creek Ct.

Myrtle Beach

$84,900

Property Type: residential lot

MLS: 2517809

Status: ACTIVE

LOT Alma Ct

Marion

$22,500

Property Type: acreage

MLS: 2517754

Status: ACTIVE

5695 Hwy 712

Galivants Ferry

$376,000

Property Type: residential lot

MLS: 2517669

Status: ACTIVE

0 Nichols Hwy.

Aynor

$1,000,000

Property Type: acreage

MLS: 2517677

Status: ACTIVE

TBD Lot 6B Red Bluff Rd.

Loris

$120,000

Property Type: acreage

MLS: 2517683

Status: ACTIVE

1321 Professional Dr.

Myrtle Beach

$850,000

Property Type: commercial lot - sale

MLS: 2517659

Status: ACTIVE

1242 Ray Rd.

Hemingway

$140,000

Property Type: acreage

MLS: 2517698

Status: ACTIVE

TBD Beaver Rd.

Hemingway

$85,000

Property Type: acreage

MLS: 2517613

Status: ACTIVE

TBD Hwy 9

Nichols

$35,000

Property Type: residential lot

MLS: 2517586

Status: ACTIVE

175 Crepe Myrtle Dr.

Loris

$39,900

Property Type: residential lot

MLS: 2517547

Status: ACTIVE

TBD Vance Ln.

Nichols

$89,000

Property Type: residential lot

MLS: 2517588

Status: ACTIVE

2862 Vanderbilt Blvd.

Pawleys Island

$1,090,000

Property Type: residential lot

MLS: 2517499

Status: ACTIVE

4172 Heather Lake Dr.

Little River

$109,900

Property Type: residential lot

MLS: 2517513

Status: ACTIVE

592 Chamberlin Rd.

Myrtle Beach

$225,000

Property Type: residential lot

MLS: 2517369

Status: ACTIVE

186 Preservation Dr.

Myrtle Beach

$169,900

Property Type: residential lot

MLS: 2517421

Status: ACTIVE

450 Harbour View Dr.

Myrtle Beach

$175,000

Property Type: residential lot

MLS: 2517435

Status: ACTIVE

8 Clair St.

Andrews

$15,000

Property Type: residential lot

MLS: 2517445

Status: ACTIVE

7023 New Bridge Rd.

Nichols

$40,000

Property Type: manufactured lot

MLS: 2517449

Status: ACTIVE

TBD Marlboro Way

Bennettsville

$22,000

Property Type: residential lot

MLS: 2517453

Status: ACTIVE

990 Robert M Grissom Pkwy.

Myrtle Beach

$3,000,000

Property Type: commercial lot - sale

MLS: 2517456

Status: ACTIVE

664 N Seascape Blvd. SW

Supply

$41,900

Property Type: residential lot

MLS: 2517422

Status: ACTIVE

tbd Sarvis Dr.

Loris

$159,000

Property Type: residential lot

MLS: 2517308

Status: ACTIVE

11051 Lee Circle

Murrells Inlet

$550,000

Property Type: residential lot

MLS: 2517282

Status: ACTIVE

Slip 97 Friendfield Marina

Georgetown

$325

Property Type: boat slip - lease

MLS: 2517304

Status: ACTIVE

107 Triple Crown Ct.

Myrtle Beach

$244,000

Property Type: residential lot

MLS: 2517326

Status: ACTIVE

Oak Bay Dr.

Georgetown

$95,000

Property Type: residential lot

MLS: 2517487

Status: ACTIVE

TBD Hwy 9

Loris

$50,000

Property Type: residential lot

MLS: 2517154

Status: ACTIVE

TBD Plainfield Rd.

Galivants Ferry

$75,000

Property Type: acreage

MLS: 2517155

Status: ACTIVE

Jacks Circle Rd.

North Myrtle Beach

$139,000

Property Type: acreage

MLS: 2517169

Status: ACTIVE

Jacks Circle Rd.

North Myrtle Beach

$139,000

Property Type: acreage

MLS: 2517169

Status: ACTIVE

TBD 24th Ave. S

Myrtle Beach

$399,900

Property Type: residential lot

MLS: 2517090

Status: ACTIVE

TBD 24th Ave. S

Myrtle Beach

$399,900

Property Type: residential lot

MLS: 2517091

Status: ACTIVE

TBD 24th Ave. S

Myrtle Beach

$399,900

Property Type: residential lot

MLS: 2517093

Status: ACTIVE

TBD Sand Dunes Dr.

Myrtle Beach

$325,000

Property Type: residential lot

MLS: 2517094

Status: ACTIVE

TBD Sand Dunes Dr.

Myrtle Beach

$325,000

Property Type: residential lot

MLS: 2517097

Status: ACTIVE

TBD Sand Dunes Dr.

Myrtle Beach

$325,000

Property Type: residential lot

MLS: 2517098

Status: ACTIVE

TBD Sand Dunes Dr.

Myrtle Beach

$325,000

Property Type: residential lot

MLS: 2517099

Status: ACTIVE

4526 Railroad Ave.

Loris

$79,000

Property Type: multi-family lot

MLS: 2517101

Status: ACTIVE

TBD Bellamy Dr.

Little River

$70,000

Property Type: manufactured lot

MLS: 2517007

Status: ACTIVE

2366 Lockhart Rd

Camden

$1,750,000

Property Type: acreage

MLS: 2517022

Status: ACTIVE

TBD Kelly St

Kingstree

$35,000

Property Type: acreage

MLS: 2517038

Status: ACTIVE

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