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

990 Highway 66

Conway

$395,000

Property Type: manufactured with land

MLS: 2503878

Status: ACTIVE

Just Listed

1408 Seagull Blvd.

North Myrtle Beach

$125,000

Property Type: manufactured leased land

MLS: 2518506

Status: ACTIVE

Just Listed

1118 Decatur St.

Orangeburg

$60,000

Property Type: manufactured with land

MLS: 2518508

Status: ACTIVE

Just Listed

236 Chamberlin Rd.

Myrtle Beach

$625,000

Property Type: detached

MLS: 2518511

Status: ACTIVE

Just Listed

801 Abalone Ct.

Myrtle Beach

$499,500

Property Type: detached

MLS: 2518515

Status: ACTIVE

Just Listed

493 Winding Ridge Rd.

Sanford

$134,900

Property Type: manufactured with land

MLS: 2518516

Status: ACTIVE

Just Listed

6001 - 1434 S Kings Hwy.

Myrtle Beach

$329,000

Property Type: detached leased land

MLS: 2518517

Status: ACTIVE

Just Listed

797 Wapama St.

Little River

$277,355

Property Type: detached

MLS: 2518521

Status: ACTIVE

Just Listed

986 Briarwood Dr.

Myrtle Beach

$439,900

Property Type: detached

MLS: 2518522

Status: ACTIVE

Just Listed

338 Spruce Pine Way

Conway

$273,900

Property Type: detached

MLS: 2518523

Status: ACTIVE

Just Listed

712 Dogwood Ave.

Myrtle Beach

$539,900

Property Type: detached

MLS: 2518529

Status: ACTIVE

Just Listed

815 Tillson Rd.

North Myrtle Beach

$795,900

Property Type: detached

MLS: 2518533

Status: ACTIVE

Just Listed

3286 Magnolia Hwy.

Aynor

$325,000

Property Type: detached

MLS: 2518539

Status: ACTIVE

Just Listed

TBB1 Coats Rd.

Loris

$483,000

Property Type: detached

MLS: 2518540

Status: ACTIVE

Just Listed

1600 Regal Fern Way

Longs

$359,990

Property Type: detached

MLS: 2518541

Status: ACTIVE

Just Listed

TBB2 Coats Rd.

Loris

$478,000

Property Type: detached

MLS: 2518543

Status: ACTIVE

Just Listed

TBB3 Coats Rd.

Loris

$478,000

Property Type: detached

MLS: 2518546

Status: ACTIVE

Just Listed

TBB4 Coats Rd.

Loris

$478,000

Property Type: detached

MLS: 2518549

Status: ACTIVE

Just Listed

205 Camrose Way

Myrtle Beach

$349,900

Property Type: detached

MLS: 2518550

Status: ACTIVE

Just Listed

4801 National Dr.

Myrtle Beach

$399,000

Property Type: detached

MLS: 2518418

Status: ACTIVE

Just Listed

1710 Oak St.

Georgetown

$271,500

Property Type: detached

MLS: 2518419

Status: ACTIVE

Just Listed

4890 Highway 319

Aynor

$249,900

Property Type: detached

MLS: 2518420

Status: ACTIVE

Just Listed

775 Oyster Bluff Dr.

Myrtle Beach

$312,000

Property Type: detached

MLS: 2518425

Status: ACTIVE

Just Listed

611 23rd Ave. N

North Myrtle Beach

$595,000

Property Type: detached

MLS: 2518426

Status: ACTIVE

Just Listed

1005 Cherrystone Loop

Conway

$352,990

Property Type: detached

MLS: 2518429

Status: ACTIVE

Just Listed

1001 Cherrystone Loop

Conway

$339,990

Property Type: detached

MLS: 2518430

Status: ACTIVE

Just Listed

248 Vista Dr.

Murrells Inlet

$1,499,900

Property Type: detached

MLS: 2518433

Status: ACTIVE

Just Listed

1701 Spinnaker Dr.

North Myrtle Beach

$854,000

Property Type: detached

MLS: 2518436

Status: ACTIVE

Just Listed

1215 Ocean Mist Dr.

Little River

$449,900

Property Type: detached

MLS: 2518441

Status: ACTIVE

Just Listed

1523 Breakwater Dr.

Little River

$673,547

Property Type: detached

MLS: 2518443

Status: ACTIVE

Just Listed

1527 Breakwater Dr.

Little River

$645,343

Property Type: detached

MLS: 2518446

Status: ACTIVE

Just Listed

1061 Sennema Circle

Myrtle Beach

$324,900

Property Type: detached

MLS: 2518447

Status: ACTIVE

Just Listed

449 Levanto Rd.

Myrtle Beach

$335,000

Property Type: detached

MLS: 2518448

Status: ACTIVE

Just Listed

2221 Rosebud Dr.

Conway

$400,000

Property Type: detached

MLS: 2518449

Status: ACTIVE

Just Listed

301 Walden Lake Rd.

Conway

$204,900

Property Type: manufactured leased land

MLS: 2518455

Status: ACTIVE

Just Listed

1817 Wood Stork Dr.

Conway

$947,880

Property Type: detached

MLS: 2518459

Status: ACTIVE

Just Listed

113 Countryside Dr.

Myrtle Beach

$229,900

Property Type: detached

MLS: 2518460

Status: ACTIVE

Just Listed

1017 Clamour Ct.

Conway

$1,038,730

Property Type: detached

MLS: 2518461

Status: ACTIVE

Just Listed

2196 Liberty Circle

Little River

$342,000

Property Type: detached

MLS: 2518465

Status: ACTIVE

Just Listed

8487 Pee Dee Hwy.

Conway

$459,990

Property Type: detached

MLS: 2518473

Status: ACTIVE

Just Listed

520 Flowering Branch Ave.

Little River

$399,900

Property Type: detached

MLS: 2518477

Status: ACTIVE

Just Listed

8161 Bear Claw Way

Conway

$472,895

Property Type: detached

MLS: 2518479

Status: ACTIVE

Just Listed

1230 Trisail Ln

North Myrtle Beach

$400,000

Property Type: detached

MLS: 2518480

Status: ACTIVE

Just Listed

4165 Stevens St.

Loris

$279,999

Property Type: detached

MLS: 2518483

Status: ACTIVE

Just Listed

8169 Bear Claw Way

Conway

$439,040

Property Type: detached

MLS: 2518484

Status: ACTIVE

Just Listed

6040 Campanella St.

Myrtle Beach

$444,900

Property Type: semi-detached

MLS: 2518486

Status: ACTIVE

Just Listed

34 Talon Circle

Murrells Inlet

$234,500

Property Type: manufactured leased land

MLS: 2518487

Status: ACTIVE

Just Listed

1537 Regal Fern Way

Longs

$274,990

Property Type: detached

MLS: 2518494

Status: ACTIVE

Just Listed

920 Silvercrest Dr.

Myrtle Beach

$244,900

Property Type: detached

MLS: 2518489

Status: ACTIVE

Just Listed

440 Meadow Sweet Pl

Conway

$309,900

Property Type: detached

MLS: 2518490

Status: ACTIVE

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