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

2347 Devine St.

Georgetown

$499,000

Property Type: detached

MLS: 2601906

Status: ACTIVE

Just Listed

572 Talisman Trail

Longs

$299,000

Property Type: detached

MLS: 2601844

Status: ACTIVE

Just Listed

3725 Park Pointe Ave.

Little River

$429,900

Property Type: detached

MLS: 2601819

Status: ACTIVE

Just Listed

1132 Harbison Circle

Myrtle Beach

$405,000

Property Type: detached

MLS: 2601822

Status: ACTIVE

Just Listed

308 Picnic Basket Pl.

Longs

$324,900

Property Type: detached

MLS: 2601823

Status: ACTIVE

Just Listed

3011 Waterfall Way

Georgetown

$326,840

Property Type: detached

MLS: 2601862

Status: ACTIVE

Just Listed

600 Table Rock Court

Myrtle Beach

$409,000

Property Type: detached

MLS: 2601824

Status: ACTIVE

Just Listed

6391 Longwood Dr.

Murrells Inlet

$659,000

Property Type: detached

MLS: 2601825

Status: ACTIVE

Just Listed

3019 Warf Dr

Conway

$75,000

Property Type: manufactured leased land

MLS: 2601826

Status: ACTIVE

Just Listed

214 Clearwater Dr.

Pawleys Island

$429,000

Property Type: detached

MLS: 2601827

Status: ACTIVE

Just Listed

420 Old McCutcheon Rd

Coward

$190,000

Property Type: detached

MLS: 2601828

Status: ACTIVE

Just Listed

1705 Duke Rd.

Longs

$235,000

Property Type: detached with hpr

MLS: 2601829

Status: ACTIVE

Just Listed

3637 Church St.

Loris

$265,000

Property Type: detached

MLS: 2601830

Status: ACTIVE

Just Listed

885 Farmers Passage Loop

Loris

$291,790

Property Type: detached

MLS: 2601831

Status: ACTIVE

Just Listed

1211 Cherry St.

Conway

$245,000

Property Type: detached

MLS: 2601833

Status: ACTIVE

Just Listed

1190 Log Cabin Rd.

Loris

$275,000

Property Type: detached

MLS: 2601834

Status: ACTIVE

Just Listed

911 Farmers Passage Loop

Loris

$278,490

Property Type: detached

MLS: 2601835

Status: ACTIVE

Just Listed

1204 Log Cabin Rd.

Loris

$295,000

Property Type: detached

MLS: 2601836

Status: ACTIVE

Just Listed

1035 Flag Patch Rd.

Loris

$305,000

Property Type: detached

MLS: 2601837

Status: ACTIVE

Just Listed

1025 Flag Patch Rd.

Loris

$280,000

Property Type: detached

MLS: 2601838

Status: ACTIVE

Just Listed

60 Madison Dr.

Georgetown

$660,000

Property Type: detached

MLS: 2601839

Status: ACTIVE

Just Listed

902 Shipmaster Ave.

Myrtle Beach

$729,900

Property Type: detached

MLS: 2601841

Status: ACTIVE

Just Listed

209 Angel Wing Dr.

Myrtle Beach

$525,000

Property Type: detached

MLS: 2601843

Status: ACTIVE

Just Listed

1028 Lauryn Oak Loop

Longs

$264,990

Property Type: detached

MLS: 2601846

Status: ACTIVE

Just Listed

1018 Ridgeford Dr.

Conway

$428,490

Property Type: detached

MLS: 2601848

Status: ACTIVE

Just Listed

648 Culmen Ct.

Myrtle Beach

$272,990

Property Type: detached

MLS: 2601849

Status: ACTIVE

Just Listed

420 Flank St.

Myrtle Beach

$305,405

Property Type: detached

MLS: 2601851

Status: ACTIVE

Just Listed

201 Craigflower Ct.

Longs

$420,000

Property Type: detached

MLS: 2601855

Status: ACTIVE

Just Listed

3005 Waterfall Way

Georgetown

$301,840

Property Type: detached

MLS: 2601858

Status: ACTIVE

Just Listed

3619 Allentown Dr.

Conway

$489,900

Property Type: detached

MLS: 2601859

Status: ACTIVE

Just Listed

1338 Tidway Circle

Conway

$240,000

Property Type: manufactured with land

MLS: 2601861

Status: ACTIVE

Just Listed

520 Caribbean Way

Myrtle Beach

$739,900

Property Type: detached with hpr

MLS: 2601864

Status: ACTIVE

Just Listed

780 Harrison Mill St.

Myrtle Beach

$455,000

Property Type: detached

MLS: 2601865

Status: ACTIVE

Just Listed

208 Bethea St

Latta

$199,000

Property Type: detached

MLS: 2601869

Status: ACTIVE

Just Listed

203 S Withlacoochee Ave.

Marion

$160,000

Property Type: detached

MLS: 2601872

Status: ACTIVE

Just Listed

101 Dubbs Ave

West Columbia

$50,000

Property Type: detached

MLS: 2601877

Status: ACTIVE

Just Listed

4310 Enoch Rd.

Aynor

$739,900

Property Type: detached

MLS: 2601878

Status: ACTIVE

Just Listed

140 Leadwood St.

Andrews

$345,000

Property Type: detached

MLS: 2601880

Status: ACTIVE

Just Listed

200 Button Willow St

Taylors

$249,900

Property Type: semi-detached

MLS: 2601883

Status: ACTIVE

Just Listed

964 Maya Layne Dr.

Little River

$385,000

Property Type: detached

MLS: 2601890

Status: ACTIVE

Just Listed

270 Jeff Waters Circle

Longs

$235,000

Property Type: detached

MLS: 2601892

Status: ACTIVE

Just Listed

1301 Regent Terrace N

Surfside Beach

$700,000

Property Type: detached

MLS: 2601896

Status: ACTIVE

Just Listed

10142 Hamilton Branch Loop

Myrtle Beach

$499,900

Property Type: detached

MLS: 2601898

Status: ACTIVE

Just Listed

427 Meadowlark Dr.

Surfside Beach

$339,000

Property Type: manufactured leased land

MLS: 2601899

Status: ACTIVE

Just Listed

2521 Revolutionary Way

Conway

$301,500

Property Type: detached

MLS: 2601907

Status: ACTIVE

Just Listed

492 Cypress Preserve Circle

Longs

$386,990

Property Type: detached

MLS: 2601908

Status: ACTIVE

Just Listed

8220 Sparkle Ct.

Longs

$307,990

Property Type: detached

MLS: 2601911

Status: ACTIVE

Just Listed

157 Homestead Way

Myrtle Beach

$416,190

Property Type: detached

MLS: 2601913

Status: ACTIVE

Just Listed

8224 Sparkle Ct.

Longs

$317,990

Property Type: detached

MLS: 2601914

Status: ACTIVE

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