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

601 E Madison St.

Dillon

$219,900

Property Type: detached

MLS: 2601189

Status: ACTIVE

1712 26th Ave. N

North Myrtle Beach

$750,000

Property Type: detached

MLS: 2500979

Status: ACTIVE

3359 Tavernee Ct.

Little River

$249,000

Property Type: manufactured with land

MLS: 2501017

Status: ACTIVE

301 North Main St.

Hemingway

$399,000

Property Type: detached

MLS: 2500937

Status: ACTIVE

1422 Bohicket Ct.

Myrtle Beach

$799,999

Property Type: detached

MLS: 2500939

Status: ACTIVE

25 Frigate Ct.

Pawleys Island

$799,900

Property Type: detached with hpr

MLS: 2500942

Status: ACTIVE

1716 26th Ave. N

North Myrtle Beach

$750,000

Property Type: detached

MLS: 2500997

Status: ACTIVE

40 Capt Anthony White Ln.

Georgetown

$549,999

Property Type: detached

MLS: 2501009

Status: ACTIVE

34 Lazy Hammock Trail

Pawleys Island

$639,900

Property Type: detached

MLS: 2500911

Status: ACTIVE

34 Lazy Hammock Trail

Pawleys Island

$639,900

Property Type: detached

MLS: 2500911

Status: ACTIVE

410 Ponderosa Rd.

Murrells Inlet

$99,000

Property Type: manufactured leased land

MLS: 2500885

Status: ACTIVE

760 Patrick Rd.

Garden City Beach

$314,900

Property Type: manufactured with land

MLS: 2500879

Status: ACTIVE

327 55th Ave. N

North Myrtle Beach

$779,900

Property Type: detached

MLS: 2500846

Status: ACTIVE

1013 Conway Plantation Dr.

Conway

$114,950

Property Type: manufactured leased land

MLS: 2500827

Status: ACTIVE

429 Ocean Pointe Ct.

North Myrtle Beach

$1,439,000

Property Type: detached

MLS: 2500764

Status: ACTIVE

6001-1810 S Kings Hwy.

Myrtle Beach

$387,000

Property Type: detached leased land

MLS: 2500747

Status: ACTIVE

496 Starlit Way

Myrtle Beach

$750,000

Property Type: detached

MLS: 2500782

Status: ACTIVE

645 Lafayette Park Dr.

Little River

$412,800

Property Type: detached

MLS: 2500818

Status: ACTIVE

10 Buckthorn St.

Andrews

$225,500

Property Type: detached

MLS: 2501433

Status: ACTIVE

100 Lulu Ln.

Bennettsville

$339,900

Property Type: semi-detached

MLS: 2500736

Status: ACTIVE

9719 E Highway 76

Nichols

$119,900

Property Type: detached

MLS: 2500618

Status: ACTIVE

4382 Saint Annes Ct.

Myrtle Beach

$469,000

Property Type: detached

MLS: 2500619

Status: ACTIVE

2659 Blue Crane Circle

Myrtle Beach

$542,000

Property Type: detached

MLS: 2500623

Status: ACTIVE

1420 Circle Dr.

North Myrtle Beach

$112,000

Property Type: manufactured leased land

MLS: 2500616

Status: ACTIVE

9502 Knights Ct.

Myrtle Beach

$299,900

Property Type: detached with hpr

MLS: 2500504

Status: ACTIVE

255 Madison Dr.

Georgetown

$675,000

Property Type: detached

MLS: 2500534

Status: ACTIVE

6001-Z16 S Kings Hwy.

Myrtle Beach

$269,900

Property Type: detached leased land

MLS: 2500565

Status: ACTIVE

2220 Pettus Way

Surfside Beach

$673,000

Property Type: detached

MLS: 2500597

Status: ACTIVE

2172 Pettus Way

Surfside Beach

$659,900

Property Type: detached

MLS: 2500598

Status: ACTIVE

2176 Pettus Way

Surfside Beach

$664,900

Property Type: detached

MLS: 2500600

Status: ACTIVE

2176 Pettus Way

Surfside Beach

$664,900

Property Type: detached

MLS: 2500600

Status: ACTIVE

2180 Pettus Way

Surfside Beach

$589,900

Property Type: detached

MLS: 2500602

Status: ACTIVE

2402 Hillside Dr. S

North Myrtle Beach

$414,900

Property Type: detached

MLS: 2500609

Status: ACTIVE

6001 South Kings Hwy.

Myrtle Beach

$220,000

Property Type: manufactured leased land

MLS: 2500498

Status: ACTIVE

6001 South Kings Hwy.

Myrtle Beach

$700,000

Property Type: detached leased land

MLS: 2500503

Status: ACTIVE

9620 Windchime Dr.

Myrtle Beach

$548,500

Property Type: detached with hpr

MLS: 2500403

Status: ACTIVE

1262 Witch Hazel Way

Longs

$395,000

Property Type: detached

MLS: 2500445

Status: ACTIVE

7350 Meadow Walk Loop

Loris

$269,110

Property Type: detached

MLS: 2501505

Status: ACTIVE

6001-1909 S Kings Hwy.

Myrtle Beach

$425,000

Property Type: detached leased land

MLS: 2500466

Status: ACTIVE

6001-1041 S Kings Hwy.

Myrtle Beach

$579,900

Property Type: detached leased land

MLS: 2500427

Status: ACTIVE

6001 - 1563 S Kings Hwy.

Myrtle Beach

$399,000

Property Type: detached leased land

MLS: 2500482

Status: ACTIVE

747 Coquina Bay Dr.

Conway

$329,900

Property Type: detached

MLS: 2500442

Status: ACTIVE

931 Edge Dr.

North Myrtle Beach

$749,850

Property Type: detached

MLS: 2500441

Status: ACTIVE

507 Slaty Dr.

Myrtle Beach

$462,770

Property Type: detached

MLS: 2501033

Status: ACTIVE

2409 Causey Dr.

North Myrtle Beach

$489,000

Property Type: detached

MLS: 2500330

Status: ACTIVE

162 Wellspring Dr.

Conway

$224,900

Property Type: manufactured leased land

MLS: 2500898

Status: ACTIVE

5300 Ocean Blvd. N

North Myrtle Beach

$1,900,000

Property Type: semi-detached

MLS: 2500395

Status: ACTIVE

816 17th Ave. N

Surfside Beach

$980,000

Property Type: detached

MLS: 2500762

Status: ACTIVE

1049 Augustus Dr.

Conway

$289,000

Property Type: detached

MLS: 2500377

Status: ACTIVE

1020 Clamour Ct.

Conway

$949,753

Property Type: detached

MLS: 2500299

Status: ACTIVE

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