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

Longs

$323,500

Property Type: detached

MLS: 2508785

Status: ACTIVE

329 46th Ave. N

North Myrtle Beach

$1,049,500

Property Type: detached

MLS: 2508826

Status: ACTIVE

4898 Sawgrass Ln.

Longs

$219,900

Property Type: manufactured with land

MLS: 2508831

Status: ACTIVE

164 Mohican Dr.

Georgetown

$985,000

Property Type: detached

MLS: 2508849

Status: ACTIVE

234 Avenue of the Palms

Myrtle Beach

$799,000

Property Type: detached

MLS: 2508867

Status: ACTIVE

234 Avenue of the Palms

Myrtle Beach

$799,000

Property Type: detached

MLS: 2508867

Status: ACTIVE

349 Robin Hood Circle

Little River

$320,000

Property Type: detached

MLS: 2508868

Status: ACTIVE

1302 Conifer Ct.

Murrells Inlet

$289,900

Property Type: detached

MLS: 2508975

Status: ACTIVE

422 Harbour View Dr.

Myrtle Beach

$674,900

Property Type: detached

MLS: 2509012

Status: ACTIVE

780 Finley Circle

Murrells Inlet

$299,777

Property Type: manufactured with land

MLS: 2508669

Status: ACTIVE

6001- 1105a S Kings Highway

Myrtle Beach

$205,000

Property Type: manufactured leased land

MLS: 2508673

Status: ACTIVE

1307 Wading Heron Rd.

North Myrtle Beach

$669,900

Property Type: detached

MLS: 2508702

Status: ACTIVE

511 Rice Bluff Rd.

Pawleys Island

$3,990,000

Property Type: detached

MLS: 2508670

Status: ACTIVE

115 Kingston Bluff Dr.

Longs

$310,000

Property Type: detached

MLS: 2508708

Status: ACTIVE

1521 Edge Dr.

North Myrtle Beach

$440,000

Property Type: detached

MLS: 2508714

Status: ACTIVE

8711 Baton Rouge Ave NW

Calabash

$417,275

Property Type: detached

MLS: 2508720

Status: ACTIVE

1250 Halter Pl.

Calabash

$534,900

Property Type: detached

MLS: 2508731

Status: ACTIVE

1242 Halter Pl.

Calabash

$524,900

Property Type: detached

MLS: 2508739

Status: ACTIVE

1242 Halter Pl.

Calabash

$524,900

Property Type: detached

MLS: 2508739

Status: ACTIVE

1 Topsail Ln.

Murrells Inlet

$175,900

Property Type: manufactured leased land

MLS: 2508767

Status: ACTIVE

826 Sand Binder Dr.

Myrtle Beach

$415,000

Property Type: detached

MLS: 2508771

Status: ACTIVE

141 Wickham Ct.

Pawleys Island

$624,900

Property Type: detached

MLS: 2509018

Status: ACTIVE

152 Creek Harbour Circle

Murrells Inlet

$1,075,000

Property Type: detached

MLS: 2508641

Status: ACTIVE

2543 Brescia St.

Myrtle Beach

$436,400

Property Type: detached

MLS: 2508648

Status: ACTIVE

301 58th Ave. N

North Myrtle Beach

$720,000

Property Type: detached

MLS: 2508590

Status: ACTIVE

247 Welcome Dr.

Myrtle Beach

$949,999

Property Type: detached

MLS: 2508601

Status: ACTIVE

333 Yucca Circle

Garden City Beach

$289,900

Property Type: manufactured leased land

MLS: 2508613

Status: ACTIVE

317 Saint James St.

Georgetown

$750,000

Property Type: detached

MLS: 2508614

Status: ACTIVE

252 Red Maple Loop

Longs

$287,990

Property Type: detached

MLS: 2508626

Status: ACTIVE

1359 Beechnut Dr.

Latta

$127,400

Property Type: manufactured with land

MLS: 2508639

Status: ACTIVE

4890 Highway 319

Aynor

$249,900

Property Type: detached

MLS: 2508442

Status: ACTIVE

9243 Marina Pkwy.

Myrtle Beach

$2,850,000

Property Type: detached

MLS: 2508448

Status: ACTIVE

308 36th Ave. N

North Myrtle Beach

$630,000

Property Type: detached

MLS: 2508449

Status: ACTIVE

669 Sun Colony Blvd.

Longs

$324,900

Property Type: detached

MLS: 2508470

Status: ACTIVE

586 Indigo Bay Circle

Myrtle Beach

$619,999

Property Type: detached

MLS: 2508471

Status: ACTIVE

913 Padgett Lane

Conway

$232,400

Property Type: detached

MLS: 2508486

Status: ACTIVE

41 Bear Creek Loop

Murrells Inlet

$450,000

Property Type: detached

MLS: 2508494

Status: ACTIVE

2309 Seaseeker Ln.

Myrtle Beach

$725,000

Property Type: detached with hpr

MLS: 2508519

Status: ACTIVE

2309 Seaseeker Ln.

Myrtle Beach

$725,000

Property Type: detached with hpr

MLS: 2508519

Status: ACTIVE

313 73rd Ave. N

Myrtle Beach

$710,000

Property Type: detached

MLS: 2508520

Status: ACTIVE

9278 NW Checkerberry Square

Calabash

$679,000

Property Type: detached

MLS: 2508529

Status: ACTIVE

2935 Moss Bridge Ln.

Myrtle Beach

$849,999

Property Type: detached

MLS: 2508536

Status: ACTIVE

1130 Buck Swamp Rd.

Fork

$295,000

Property Type: manufactured with land

MLS: 2508644

Status: ACTIVE

69 Sea Level Loop

Pawleys Island

$599,000

Property Type: detached

MLS: 2509380

Status: ACTIVE

609 Beaver Pond Rd.

Conway

$559,000

Property Type: detached

MLS: 2508407

Status: ACTIVE

481 Pennington Loop

Myrtle Beach

$387,900

Property Type: detached

MLS: 2508301

Status: ACTIVE

2707B Prince St.

Georgetown

$185,000

Property Type: manufactured with land

MLS: 2508316

Status: ACTIVE

2707A Prince St.

Georgetown

$185,000

Property Type: manufactured with land

MLS: 2508319

Status: ACTIVE

2070 Santa Maria St.

Myrtle Beach

$410,500

Property Type: detached

MLS: 2508325

Status: ACTIVE

136 Splendor Circle

Murrells Inlet

$479,000

Property Type: detached

MLS: 2508344

Status: ACTIVE

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