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

340 Walden Lake Rd.

Conway

$182,000

Property Type: manufactured leased land

MLS: 2423391

Status: ACTIVE

719 American Beech St.

Loris

$265,000

Property Type: detached

MLS: 2423393

Status: ACTIVE

404 Jessamine Rd

Marion

$125,000

Property Type: manufactured with land

MLS: 2423252

Status: ACTIVE

494 Folly Estates Dr.

Myrtle Beach

$135,000

Property Type: manufactured leased land

MLS: 2423127

Status: ACTIVE

703 62nd Ave. N

Myrtle Beach

$475,000

Property Type: detached

MLS: 2423140

Status: ACTIVE

2729 Gemini Dr.

Myrtle Beach

$105,995

Property Type: manufactured leased land

MLS: 2423096

Status: ACTIVE

3722 White Wing Circle

Myrtle Beach

$419,900

Property Type: detached

MLS: 2423099

Status: ACTIVE

217 Southern Breezes Circle

Murrells Inlet

$539,000

Property Type: detached

MLS: 2424840

Status: ACTIVE

333 Carolina Springs Ct.

Conway

$257,300

Property Type: detached

MLS: 2422963

Status: ACTIVE

891 Waterton Ave.

Myrtle Beach

$1,230,000

Property Type: detached

MLS: 2422970

Status: ACTIVE

4605 Hickory Holt Rd.

Galivants Ferry

$570,000

Property Type: detached

MLS: 2422810

Status: ACTIVE

3030 Deerberry Place

Longs

$294,900

Property Type: detached

MLS: 2422842

Status: ACTIVE

908 Old Magnolia Dr.

Conway

$168,000

Property Type: manufactured leased land

MLS: 2422705

Status: ACTIVE

875 Mountain Mint Circle NW

Calabash

$389,900

Property Type: detached

MLS: 2422730

Status: ACTIVE

7990 Short Needle Ct.

Murrells Inlet

$245,000

Property Type: detached

MLS: 2422745

Status: ACTIVE

1000 Strand Ave.

North Myrtle Beach

$925,000

Property Type: detached

MLS: 2422793

Status: ACTIVE

223 Air Stream Dr.

Myrtle Beach

$150,000

Property Type: manufactured leased land

MLS: 2422806

Status: ACTIVE

328 S Waccamaw Dr.

Garden City Beach

$1,624,990

Property Type: detached

MLS: 2422620

Status: ACTIVE

6001-MH107 S Kings Hwy.

Myrtle Beach

$335,000

Property Type: manufactured leased land

MLS: 2422946

Status: ACTIVE

110 Hallandale Lane

Murrells Inlet

$454,575

Property Type: semi-detached

MLS: 2422531

Status: ACTIVE

7129 Spoleto Dr.

Myrtle Beach

$946,900

Property Type: detached

MLS: 2422468

Status: ACTIVE

4808 Cantor Ct.

North Myrtle Beach

$675,000

Property Type: detached with hpr

MLS: 2422482

Status: ACTIVE

1234 St. John Rd.

Galivants Ferry

$249,900

Property Type: detached

MLS: 2422492

Status: ACTIVE

1174 St. John Rd.

Galivants Ferry

$249,900

Property Type: detached

MLS: 2422493

Status: ACTIVE

1210 John St.

Mullins

$213,000

Property Type: detached

MLS: 2422873

Status: ACTIVE

6001-1424 S Kings Hwy.

Myrtle Beach

$192,000

Property Type: manufactured leased land

MLS: 2422344

Status: ACTIVE

6001 - 5238 S Kings Hwy.

Myrtle Beach

$219,000

Property Type: manufactured leased land

MLS: 2422375

Status: ACTIVE

7122 Cox Lake Dr.

Mullins

$275,000

Property Type: detached

MLS: 2422379

Status: ACTIVE

7018 Cox Lake Ct.

Mullins

$689,900

Property Type: detached

MLS: 2422387

Status: ACTIVE

1104 Maccoa Dr.

Conway

$839,900

Property Type: detached

MLS: 2422286

Status: ACTIVE

6001 S Kings Hwy.

Myrtle Beach

$690,000

Property Type: detached leased land

MLS: 2422304

Status: ACTIVE

629 Slash Pine Ct.

Myrtle Beach

$409,900

Property Type: detached

MLS: 2422068

Status: ACTIVE

9325 Cove Dr.

Myrtle Beach

$1,340,000

Property Type: detached

MLS: 2422116

Status: ACTIVE

6350 Morris Pl.

Myrtle Beach

$299,000

Property Type: manufactured with land

MLS: 2421966

Status: ACTIVE

3517 Golf Ave.

Little River

$599,000

Property Type: detached

MLS: 2421970

Status: ACTIVE

1356 Tranquility Ln.

Myrtle Beach

$324,000

Property Type: detached

MLS: 2421771

Status: ACTIVE

6001 - N21 S Kings Hwy.

Myrtle Beach

$169,000

Property Type: manufactured leased land

MLS: 2421809

Status: ACTIVE

6001-1092 S Kings Hwy.

Myrtle Beach

$219,900

Property Type: manufactured leased land

MLS: 2422194

Status: ACTIVE

1417 Tiger Grand Dr.

Conway

$279,999

Property Type: detached

MLS: 2421762

Status: ACTIVE

1015 Garden Sprout Dr

Galivants Ferry

$270,990

Property Type: detached

MLS: 2421601

Status: ACTIVE

1120 Hickory Knob Ct.

Myrtle Beach

$299,999

Property Type: semi-detached

MLS: 2421547

Status: ACTIVE

3955 Highway 501 Business

Marion

$129,000

Property Type: manufactured with land

MLS: 2421543

Status: ACTIVE

6001 - N14 S Kings Hwy.

Myrtle Beach

$535,000

Property Type: detached leased land

MLS: 2421463

Status: ACTIVE

334 Norris Dr.

Pawleys Island

$1,250,000

Property Type: detached

MLS: 2421527

Status: ACTIVE

393 Sanddollar Dr.

Surfside Beach

$425,000

Property Type: manufactured leased land

MLS: 2421380

Status: ACTIVE

805 Woodland Farms Circle

Aynor

$260,000

Property Type: detached

MLS: 2421234

Status: ACTIVE

710 Lakeside Dr.

Surfside Beach

$770,000

Property Type: detached

MLS: 2421322

Status: ACTIVE

60 Shady Ln.

Kingstree

$159,900

Property Type: detached

MLS: 2423169

Status: ACTIVE

2000 Easy St.

Conway

$447,000

Property Type: detached

MLS: 2420957

Status: ACTIVE

3747 Bakers Chapel Rd.

Aynor

$629,900

Property Type: detached

MLS: 2420665

Status: ACTIVE

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