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

3648 Eagle Trace Dr.

Myrtle Beach

$274,900

Property Type: detached

MLS: 2530096

Status: ACTIVE

Just Listed

701 67th Ave. N

Myrtle Beach

$449,000

Property Type: detached

MLS: 2530097

Status: ACTIVE

Just Listed

8024 Old Reaves Ferry Rd.

Conway

$758,000

Property Type: detached

MLS: 2530098

Status: ACTIVE

Just Listed

5025 Yellowstone Dr.

Conway

$331,890

Property Type: detached

MLS: 2530100

Status: ACTIVE

Just Listed

96 Bonnie Bridge Circle

Myrtle Beach

$280,000

Property Type: detached

MLS: 2530101

Status: ACTIVE

Just Listed

8027 Bear Claw Way

Conway

$401,570

Property Type: detached

MLS: 2530102

Status: ACTIVE

Just Listed

405 Beulah Circle

Conway

$269,900

Property Type: detached

MLS: 2530103

Status: ACTIVE

Just Listed

2222 Steep Landing Rd.

Conway

$789,000

Property Type: detached

MLS: 2530104

Status: ACTIVE

Just Listed

358 Trestle Way

Conway

$449,000

Property Type: detached

MLS: 2530105

Status: ACTIVE

Just Listed

183 Pampa Dr.

Loris

$337,610

Property Type: detached

MLS: 2530107

Status: ACTIVE

Just Listed

600 Table Rock Court

Myrtle Beach

$399,000

Property Type: detached

MLS: 2530108

Status: ACTIVE

Just Listed

312 RookRoost Circle

Conway

$317,115

Property Type: detached

MLS: 2530110

Status: ACTIVE

Just Listed

320 RookRoost Circle

Conway

$300,740

Property Type: detached

MLS: 2530111

Status: ACTIVE

Just Listed

316 RookRoost Circle

Conway

$309,115

Property Type: detached

MLS: 2530113

Status: ACTIVE

Just Listed

8210 Energize Dr.

Longs

$339,990

Property Type: detached

MLS: 2530118

Status: ACTIVE

Just Listed

8210 Energize Dr.

Longs

$339,990

Property Type: detached

MLS: 2530118

Status: ACTIVE

Just Listed

8232 Sparkle Ct.

Longs

$349,990

Property Type: detached

MLS: 2530119

Status: ACTIVE

Just Listed

205 Bantry Ln.

Conway

$387,725

Property Type: detached

MLS: 2530120

Status: ACTIVE

Just Listed

748 Nelson Dr.

Murrells Inlet

$199,900

Property Type: manufactured with land

MLS: 2530121

Status: ACTIVE

Just Listed

2236 Steep Landing Rd.

Conway

$789,000

Property Type: detached

MLS: 2530124

Status: ACTIVE

Just Listed

2239 Jackson Circle

Little River

$489,500

Property Type: detached

MLS: 2530137

Status: ACTIVE

Just Listed

224 Birchwood Dr.

Longs

$235,950

Property Type: detached

MLS: 2530145

Status: ACTIVE

Just Listed

219 Pin Oak Dr.

Murrells Inlet

$378,000

Property Type: detached

MLS: 2530149

Status: ACTIVE

Just Listed

1082 Rocky Ln.

Conway

$349,900

Property Type: detached

MLS: 2530153

Status: ACTIVE

Just Listed

1086 Rocky Ln.

Conway

$349,900

Property Type: detached

MLS: 2530154

Status: ACTIVE

Just Listed

2302 Seaseeker Ln.

Myrtle Beach

$799,900

Property Type: detached with hpr

MLS: 2530155

Status: ACTIVE

Just Listed

1336 Nokota Dr.

Conway

$312,030

Property Type: detached

MLS: 2530156

Status: ACTIVE

Just Listed

4722 Harvest Dr.

Myrtle Beach

$440,000

Property Type: detached

MLS: 2530159

Status: ACTIVE

Just Listed

250 Konik St.

Conway

$448,745

Property Type: detached

MLS: 2530161

Status: ACTIVE

Just Listed

516 Cambria Dr

Longs

$319,120

Property Type: detached

MLS: 2530162

Status: ACTIVE

Just Listed

162 Indigo Grove Dr

Longs

$271,700

Property Type: detached

MLS: 2530163

Status: ACTIVE

Just Listed

150 Indigo Grove Dr

Longs

$241,700

Property Type: detached

MLS: 2530164

Status: ACTIVE

Just Listed

206 Dagger Ct.

Myrtle Beach

$348,840

Property Type: detached

MLS: 2530076

Status: ACTIVE

Just Listed

141 Homestead Way

Myrtle Beach

$372,840

Property Type: detached

MLS: 2530079

Status: ACTIVE

Just Listed

74 Double Pond Dr

Georgetown

$393,581

Property Type: detached

MLS: 2530089

Status: ACTIVE

Just Listed

492 Acosta Circle

Conway

$306,295

Property Type: detached

MLS: 2530057

Status: ACTIVE

Just Listed

374 Wingspan Ct.

Myrtle Beach

$438,210

Property Type: detached

MLS: 2530063

Status: ACTIVE

Just Listed

2931 Duke Trail

Garden City Beach

$125,000

Property Type: manufactured leased land

MLS: 2530055

Status: ACTIVE

Just Listed

543 Acosta Circle

Conway

$275,490

Property Type: detached

MLS: 2530060

Status: ACTIVE

Just Listed

166 Cayman Loop

Pawleys Island

$1,141,000

Property Type: detached

MLS: 2530062

Status: ACTIVE

Just Listed

747 Plumage Ct.

Myrtle Beach

$453,860

Property Type: detached

MLS: 2530065

Status: ACTIVE

Just Listed

1030 Ridgeford Dr.

Conway

$347,990

Property Type: detached

MLS: 2530068

Status: ACTIVE

Just Listed

1033 Ridgeford Dr.

Conway

$358,990

Property Type: detached

MLS: 2530071

Status: ACTIVE

Just Listed

184 Dagger Ct.

Myrtle Beach

$350,840

Property Type: detached

MLS: 2530073

Status: ACTIVE

Just Listed

1008 1st Ave. S

North Myrtle Beach

$170,000

Property Type: detached

MLS: 2530074

Status: ACTIVE

Just Listed

113 7Th Ave #A 7th Ave. S

Surfside Beach

$875,000

Property Type: detached

MLS: 2530075

Status: ACTIVE

Just Listed

4485 Farm Lake Dr.

Myrtle Beach

$335,000

Property Type: detached

MLS: 2530077

Status: ACTIVE

Just Listed

312 Skyward St.

Myrtle Beach

$333,840

Property Type: detached

MLS: 2530078

Status: ACTIVE

Just Listed

149 Homestead Way

Myrtle Beach

$353,840

Property Type: detached

MLS: 2530080

Status: ACTIVE

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