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

1450 Powhaton Dr.

Myrtle Beach

$399,500

Property Type: detached with hpr

MLS: 2522497

Status: ACTIVE

Just Listed

3241 Moss Bridge Ln.

Myrtle Beach

$516,590

Property Type: detached

MLS: 2528669

Status: ACTIVE

Just Listed

170 River Birch Dr.

Loris

$341,990

Property Type: detached

MLS: 2528719

Status: ACTIVE

Just Listed

780 Finley Circle

Murrells Inlet

$285,888

Property Type: manufactured with land

MLS: 2528653

Status: ACTIVE

Just Listed

5145 Water Breeze Ct.

Myrtle Beach

$414,754

Property Type: detached

MLS: 2528658

Status: ACTIVE

Just Listed

5137 Water Breeze Ct.

Myrtle Beach

$420,703

Property Type: detached

MLS: 2528659

Status: ACTIVE

Just Listed

105 Hickory Dr.

Conway

$260,000

Property Type: detached

MLS: 2528662

Status: ACTIVE

Just Listed

3238 Moss Bridge Ln.

Myrtle Beach

$461,550

Property Type: detached

MLS: 2528666

Status: ACTIVE

Just Listed

160 Weston Dr.

Pawleys Island

$365,000

Property Type: detached

MLS: 2528667

Status: ACTIVE

Just Listed

124 Albatross Way

Myrtle Beach

$379,900

Property Type: detached

MLS: 2528671

Status: ACTIVE

Just Listed

3257 Moss Bridge Ln.

Myrtle Beach

$506,425

Property Type: detached

MLS: 2528672

Status: ACTIVE

Just Listed

1414 Bohicket Ct.

Myrtle Beach

$525,000

Property Type: detached

MLS: 2528673

Status: ACTIVE

Just Listed

177 Northside Dr.

Little River

$354,900

Property Type: detached

MLS: 2528674

Status: ACTIVE

Just Listed

4044 Elmridge Ct.

Conway

$369,840

Property Type: detached

MLS: 2528676

Status: ACTIVE

Just Listed

4045 Elmridge Ct.

Conway

$379,765

Property Type: detached

MLS: 2528680

Status: ACTIVE

Just Listed

833 Silver Crest Dr.

Myrtle Beach

$269,900

Property Type: detached

MLS: 2528681

Status: ACTIVE

Just Listed

893 Summer Starling Pl.

Myrtle Beach

$510,000

Property Type: detached

MLS: 2528682

Status: ACTIVE

Just Listed

5671 Canary Island Ct.

Myrtle Beach

$724,900

Property Type: detached

MLS: 2528683

Status: ACTIVE

Just Listed

5073 Spanish Oaks Ct.

Murrells Inlet

$625,000

Property Type: detached

MLS: 2528685

Status: ACTIVE

Just Listed

4153 Charleston Oaks Dr

Loris

$334,900

Property Type: detached

MLS: 2528687

Status: ACTIVE

Just Listed

4048 Elmridge Ct.

Conway

$348,840

Property Type: detached

MLS: 2528689

Status: ACTIVE

Just Listed

2617 Hudson Trail

Conway

$385,990

Property Type: detached

MLS: 2528697

Status: ACTIVE

Just Listed

8001 Lotus Dr

Myrtle Beach

$567,990

Property Type: detached

MLS: 2528698

Status: ACTIVE

Just Listed

4024 Viola Loop

Myrtle Beach

$514,990

Property Type: detached

MLS: 2528700

Status: ACTIVE

Just Listed

471 Meadowlark Dr.

Surfside Beach

$309,000

Property Type: manufactured leased land

MLS: 2528710

Status: ACTIVE

Just Listed

110 Ashworth Dr.

Little River

$339,900

Property Type: detached

MLS: 2528713

Status: ACTIVE

Just Listed

2626 Hudson Trail

Conway

$409,795

Property Type: detached

MLS: 2528714

Status: ACTIVE

Just Listed

1198 Shire Way

Myrtle Beach

$624,900

Property Type: detached

MLS: 2528715

Status: ACTIVE

Just Listed

37 Wildberry Way

Pawleys Island

$1,475,000

Property Type: detached

MLS: 2528716

Status: ACTIVE

Just Listed

112 Village Ct.

Murrells Inlet

$124,900

Property Type: manufactured leased land

MLS: 2528720

Status: ACTIVE

Just Listed

1768 Vereen Rd.

Aynor

$317,900

Property Type: detached

MLS: 2528724

Status: ACTIVE

Just Listed

105 Mace Ct

Latta

$124,900

Property Type: detached

MLS: 2528536

Status: ACTIVE

Just Listed

84 Greentown Rd.

Georgetown

$234,900

Property Type: detached

MLS: 2528578

Status: ACTIVE

Just Listed

324 Edgewood Circle

Conway

$209,900

Property Type: detached

MLS: 2528549

Status: ACTIVE

Just Listed

403 32nd Ave. N

Myrtle Beach

$695,000

Property Type: detached

MLS: 2528596

Status: ACTIVE

Just Listed

144 Yeomans Dr.

Conway

$310,000

Property Type: detached

MLS: 2528534

Status: ACTIVE

Just Listed

321 Hidden Cove Dr.

Little River

$427,000

Property Type: detached

MLS: 2528537

Status: ACTIVE

Just Listed

2276 Python Circle

Conway

$109,900

Property Type: manufactured leased land

MLS: 2528538

Status: ACTIVE

Just Listed

356 Rossdhu Ave.

Pawleys Island

$2,199,000

Property Type: detached

MLS: 2528539

Status: ACTIVE

Just Listed

355 Dunbarton Ln.

Conway

$344,900

Property Type: detached

MLS: 2528540

Status: ACTIVE

Just Listed

331 Emery Oak Dr.

Murrells Inlet

$449,900

Property Type: detached

MLS: 2528542

Status: ACTIVE

Just Listed

1107 Blue Ridge Trail

North Myrtle Beach

$240,000

Property Type: manufactured with land

MLS: 2528543

Status: ACTIVE

Just Listed

5407 N Ocean Blvd.

Myrtle Beach

$1,100,000

Property Type: detached

MLS: 2528546

Status: ACTIVE

Just Listed

255 Madison Dr.

Georgetown

$675,000

Property Type: detached

MLS: 2528547

Status: ACTIVE

Just Listed

237 Madison Dr.

Georgetown

$650,000

Property Type: detached

MLS: 2528548

Status: ACTIVE

Just Listed

5095 Yellowstone Dr.

Conway

$379,940

Property Type: detached

MLS: 2528551

Status: ACTIVE

Just Listed

4119 Westchester Ct.

Myrtle Beach

$589,900

Property Type: detached

MLS: 2528561

Status: ACTIVE

Just Listed

148 Bjorn Way

Longs

$366,565

Property Type: detached

MLS: 2528563

Status: ACTIVE

Just Listed

3012 Gadwall Dr.

Aynor

$305,990

Property Type: detached

MLS: 2528564

Status: ACTIVE

Just Listed

2644 Highway 701 North

Loris

$459,999

Property Type: detached

MLS: 2528565

Status: ACTIVE

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