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

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

Just Listed

546 Stonemason Dr.

Myrtle Beach

$521,900

Property Type: detached

MLS: 2518491

Status: ACTIVE

Just Listed

409 Meadow Sweet Pl

Conway

$299,900

Property Type: detached

MLS: 2518492

Status: ACTIVE

Just Listed

1712 Brown St.

Conway

$99,000

Property Type: detached

MLS: 2518493

Status: ACTIVE

Just Listed

5104 N Ocean Blvd.

Myrtle Beach

$4,970,000

Property Type: detached

MLS: 2518495

Status: ACTIVE

Just Listed

180 Black Water Dr.

Murrells Inlet

$679,000

Property Type: detached

MLS: 2518355

Status: ACTIVE

Just Listed

2812 Highway 378

Conway

$314,999

Property Type: detached

MLS: 2518352

Status: ACTIVE

Just Listed

183 Blackpepper Loop

Little River

$359,900

Property Type: detached

MLS: 2518428

Status: ACTIVE

Just Listed

2703 N Ocean Blvd.

North Myrtle Beach

$768,000

Property Type: detached

MLS: 2518409

Status: ACTIVE

Just Listed

112-A 7th Ave. N

Surfside Beach

$1,575,000

Property Type: detached

MLS: 2518369

Status: ACTIVE

Just Listed

158 Regency Dr.

Conway

$314,900

Property Type: detached

MLS: 2518348

Status: ACTIVE

Just Listed

801 Celene Ct.

Myrtle Beach

$659,000

Property Type: detached

MLS: 2518349

Status: ACTIVE

Just Listed

1050 Kennington Ct.

Conway

$425,000

Property Type: detached

MLS: 2518350

Status: ACTIVE

Just Listed

722 Coquina Bay Dr.

Conway

$444,900

Property Type: detached

MLS: 2518356

Status: ACTIVE

Just Listed

504 Patapsco St.

Little River

$489,950

Property Type: detached

MLS: 2518357

Status: ACTIVE

Just Listed

3703 Green Sea Rd.

Green Sea

$169,900

Property Type: detached

MLS: 2518359

Status: ACTIVE

Just Listed

1163 East Isle of Palms Ave.

Myrtle Beach

$939,500

Property Type: detached

MLS: 2518379

Status: ACTIVE

Just Listed

788 Wild Wing Blvd.

Conway

$599,900

Property Type: detached

MLS: 2518362

Status: ACTIVE

Just Listed

579 Bucks Trail

Longs

$420,000

Property Type: detached

MLS: 2518370

Status: ACTIVE

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