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

990 Highway 66

Conway

$309,000

Property Type: acreage

MLS: 2517682

Status: ACTIVE

Just Listed

4478 Barcelona Ln.

Little River

$69,900

Property Type: residential lot

MLS: 2526363

Status: ACTIVE

Just Listed

4616 Marion Circle

North Myrtle Beach

$434,900

Property Type: residential lot

MLS: 2526368

Status: ACTIVE

Just Listed

TBD Old Reaves Ferry Rd.

Conway

$1,200,000

Property Type: acreage

MLS: 2526376

Status: ACTIVE

Just Listed

TBD Tract A Old Reaves Ferry Rd.

Conway

$625,000

Property Type: acreage

MLS: 2526380

Status: ACTIVE

Just Listed

TBD Water Tower Rd.

Longs

$7,500,000

Property Type: acreage

MLS: 2526383

Status: ACTIVE

Just Listed

985 Beaumont Dr.

Pawleys Island

$335,000

Property Type: residential lot

MLS: 2526280

Status: ACTIVE

Just Listed

4390 S Fraser St.

Georgetown

$2,000,000

Property Type: industrial lot

MLS: 2526294

Status: ACTIVE

Just Listed

2144 Harvey Rd.

Loris

$257,505

Property Type: residential lot

MLS: 2526311

Status: ACTIVE

Just Listed

275 Waccamaw River Dr.

Conway

$149,900

Property Type: residential lot

MLS: 2526323

Status: ACTIVE

Just Listed

McDowell Shortcut Rd.

Murrells Inlet

$75,000

Property Type: acreage

MLS: 2526341

Status: ACTIVE

Just Listed

TBD J H Martin Rd.

Galivants Ferry

$395,000

Property Type: acreage

MLS: 2526229

Status: ACTIVE

Just Listed

TBD Sand Plant Rd.

Nichols

$449,900

Property Type: acreage

MLS: 2526193

Status: ACTIVE

Just Listed

TBD Old Ebenezer Rd.

Marion

$155,000

Property Type: acreage

MLS: 2526207

Status: ACTIVE

Just Listed

6011 Renata Ln.

Myrtle Beach

$799,999

Property Type: acreage

MLS: 2526234

Status: ACTIVE

Just Listed

1228 Church St.

Georgetown

$600

Property Type: commercial lot - lease

MLS: 2526246

Status: ACTIVE

Just Listed

745 McDuffie Dr.

Myrtle Beach

$100,000

Property Type: residential lot

MLS: 2526253

Status: ACTIVE

Just Listed

TBD Left Meadow St.

Loris

$95,000

Property Type: residential lot

MLS: 2526132

Status: ACTIVE

Just Listed

TBD Right Meadow St.

Loris

$95,000

Property Type: residential lot

MLS: 2526135

Status: ACTIVE

Just Listed

Lot 4 Seacrest Dr.

Murrells Inlet

$350,000

Property Type: residential lot

MLS: 2526160

Status: ACTIVE

Just Listed

255 Ole Maple St.

Loris

$239,000

Property Type: acreage

MLS: 2526166

Status: ACTIVE

Just Listed

255 Ole Maple St.

Loris

$239,000

Property Type: acreage

MLS: 2526166

Status: ACTIVE

Just Listed

TBD Ole Maple St.

Loris

$139,000

Property Type: acreage

MLS: 2526177

Status: ACTIVE

Just Listed

885 Martin Luther King Rd.

Pawleys Island

$1,600,000

Property Type: multi-family lot

MLS: 2526188

Status: ACTIVE

Just Listed

5241 Cates Bay Hwy.

Conway

$955,000

Property Type: acreage

MLS: 2526045

Status: ACTIVE

Just Listed

3691 Highway 905

Conway

$120,000

Property Type: residential lot

MLS: 2526062

Status: ACTIVE

Just Listed

6788 Hanbury Place

Ocean Isle Beach

$59,000

Property Type: residential lot

MLS: 2526097

Status: ACTIVE

Just Listed

TBD Mahalia Dr.

Conway

$60,000

Property Type: residential lot

MLS: 2526100

Status: ACTIVE

Just Listed

1962 Highway 646

Green Sea

$225,000

Property Type: acreage

MLS: 2526116

Status: ACTIVE

TBD E Highway 9 Bypass

Loris

$525,000

Property Type: acreage

MLS: 2525932

Status: ACTIVE

7320 Maple Wild Rd

Nichols

$1,500,000

Property Type: acreage

MLS: 2525948

Status: ACTIVE

565 SW Gladstone Circle

Ocean Isle Beach

$128,000

Property Type: residential lot

MLS: 2525962

Status: ACTIVE

1013 31st Ave. S

North Myrtle Beach

$175,000

Property Type: residential lot

MLS: 2525963

Status: ACTIVE

829 9th Ave. S

North Myrtle Beach

$142,500

Property Type: residential lot

MLS: 2525973

Status: ACTIVE

6101 Teal St

Wilmington

$179,500

Property Type: residential lot

MLS: 2525974

Status: ACTIVE

6105 Teal St

Wilmington

$168,900

Property Type: residential lot

MLS: 2525975

Status: ACTIVE

Tract B Highway 66

Loris

$349,350

Property Type: acreage

MLS: 2525979

Status: ACTIVE

TBD Long Avenue Ext.

Conway

$100,000

Property Type: residential lot

MLS: 2525983

Status: ACTIVE

345 Player St.

Georgetown

$99,000

Property Type: residential lot

MLS: 2526007

Status: ACTIVE

TBD Cleveland St.

Mullins

$34,900

Property Type: acreage

MLS: 2526010

Status: ACTIVE

TBD Simpson Creek Dr.

Loris

$182,000

Property Type: acreage

MLS: 2525955

Status: ACTIVE

TBD Barnes Rd.

Andrews

$15,000

Property Type: residential lot

MLS: 2525783

Status: ACTIVE

TBD Carolina Forest Blvd.

Myrtle Beach

$3,750,000

Property Type: acreage

MLS: 2525790

Status: ACTIVE

1005 Whooping Crane Dr.

Conway

$209,000

Property Type: residential lot

MLS: 2525796

Status: ACTIVE

3025, 3029 Fowler Rd.

Loris

$234,900

Property Type: acreage

MLS: 2525819

Status: ACTIVE

3025 Fowler Rd.

Loris

$59,900

Property Type: acreage

MLS: 2525828

Status: ACTIVE

Lot 161 Seaport Circle

Georgetown

$115,000

Property Type: residential lot

MLS: 2525829

Status: ACTIVE

5760 Hugh Ryan Rd

Dalzell

$149,500

Property Type: acreage

MLS: 2525833

Status: ACTIVE

3029 Fowler Rd.

Loris

$59,900

Property Type: acreage

MLS: 2525853

Status: ACTIVE

Lot 227 Summerwood Dr.

Georgetown

$450,000

Property Type: residential lot

MLS: 2525856

Status: ACTIVE

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