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

721 Old Castle Loop

Myrtle Beach

$360,000

Property Type: detached

MLS: 2520191

Status: ACTIVE

1036 Great Lakes Circle

Myrtle Beach

$325,000

Property Type: detached

MLS: 2520195

Status: ACTIVE

340 Emery Oak Dr.

Murrells Inlet

$459,000

Property Type: detached

MLS: 2520201

Status: ACTIVE

438 Archer Ct.

Conway

$347,900

Property Type: detached

MLS: 2520248

Status: ACTIVE

394 Sun Colony Blvd.

Longs

$369,000

Property Type: detached

MLS: 2520290

Status: ACTIVE

288 Farris Rd.

Clover

$449,900

Property Type: detached

MLS: 2520315

Status: ACTIVE

868 Agostino Dr.

Myrtle Beach

$470,000

Property Type: detached

MLS: 2520014

Status: ACTIVE

42 Enclave Pl.

Pawleys Island

$1,395,000

Property Type: detached

MLS: 2520033

Status: ACTIVE

787 Ebb Tide Rd.

Little River

$439,990

Property Type: detached

MLS: 2520092

Status: ACTIVE

787 Ebb Tide Rd.

Little River

$439,990

Property Type: detached

MLS: 2520092

Status: ACTIVE

131 Marauder Dr.

Longs

$299,000

Property Type: detached

MLS: 2520016

Status: ACTIVE

208 Green Lake Dr.

Myrtle Beach

$1,599,000

Property Type: detached

MLS: 2520019

Status: ACTIVE

5230 Piemonte Ln.

Myrtle Beach

$455,000

Property Type: detached

MLS: 2520020

Status: ACTIVE

6001-5524 S Kings Hwy.

Myrtle Beach

$432,000

Property Type: detached leased land

MLS: 2520024

Status: ACTIVE

531 Key Largo Ave.

Murrells Inlet

$129,900

Property Type: manufactured leased land

MLS: 2520026

Status: ACTIVE

1335 Tarisa Ave.

Myrtle Beach

$594,000

Property Type: detached

MLS: 2520030

Status: ACTIVE

4186 Still Pond Rd.

Conway

$279,900

Property Type: manufactured with land

MLS: 2520031

Status: ACTIVE

1010 Swan Lake Dr.

North Myrtle Beach

$569,900

Property Type: detached

MLS: 2520036

Status: ACTIVE

701 Shell Point Ct.

Longs

$779,900

Property Type: detached

MLS: 2520044

Status: ACTIVE

5070 South First St.

Murrells Inlet

$749,000

Property Type: detached

MLS: 2520069

Status: ACTIVE

414 Carriage Lake Dr.

Little River

$464,999

Property Type: detached

MLS: 2520076

Status: ACTIVE

767 Ebb Tide Rd.

Little River

$419,990

Property Type: detached

MLS: 2520087

Status: ACTIVE

767 Ebb Tide Rd.

Little River

$419,990

Property Type: detached

MLS: 2520087

Status: ACTIVE

775 Ebb Tide Rd.

Little River

$509,990

Property Type: detached

MLS: 2520089

Status: ACTIVE

775 Ebb Tide Rd.

Little River

$509,990

Property Type: detached

MLS: 2520089

Status: ACTIVE

775 Ebb Tide Rd.

Little River

$509,990

Property Type: detached

MLS: 2520089

Status: ACTIVE

774 Ebb Tide Rd.

Little River

$479,990

Property Type: detached

MLS: 2520094

Status: ACTIVE

774 Ebb Tide Rd.

Little River

$479,990

Property Type: detached

MLS: 2520094

Status: ACTIVE

4189 Schoolhouse Circle

Little River

$389,900

Property Type: detached

MLS: 2520101

Status: ACTIVE

83 Pond St.

Georgetown

$379,900

Property Type: detached

MLS: 2519995

Status: ACTIVE

1118 Hainer Place Dr

Conway

$299,900

Property Type: detached

MLS: 2520000

Status: ACTIVE

1118 Hainer Place Dr

Conway

$299,900

Property Type: detached

MLS: 2520000

Status: ACTIVE

6001 South Kings Hwy.

Surfside Beach

$389,000

Property Type: manufactured leased land

MLS: 2520001

Status: ACTIVE

3431 Logan St.

Conway

$334,900

Property Type: detached

MLS: 2520004

Status: ACTIVE

3431 Logan St.

Conway

$334,900

Property Type: detached

MLS: 2520004

Status: ACTIVE

2807 Temperance Dr.

Myrtle Beach

$339,000

Property Type: detached

MLS: 2520006

Status: ACTIVE

741 Enchantment Loop

Myrtle Beach

$480,000

Property Type: detached

MLS: 2519961

Status: ACTIVE

322 Yucca Circle

Garden City Beach

$159,900

Property Type: manufactured leased land

MLS: 2519962

Status: ACTIVE

2544 Lake Vista Dr.

Little River

$540,000

Property Type: detached

MLS: 2519965

Status: ACTIVE

105 Double Pond Dr

Georgetown

$362,179

Property Type: detached

MLS: 2519968

Status: ACTIVE

105 Double Pond Dr

Georgetown

$362,179

Property Type: detached

MLS: 2519968

Status: ACTIVE

134 Double Pond Dr

Georgetown

$357,944

Property Type: detached

MLS: 2519972

Status: ACTIVE

3137 Visionary Dr.

Myrtle Beach

$479,900

Property Type: detached

MLS: 2519973

Status: ACTIVE

409 14th Ave. S

North Myrtle Beach

$529,900

Property Type: detached

MLS: 2519977

Status: ACTIVE

TBD Anna Marie Way

Murrells Inlet

$557,990

Property Type: detached

MLS: 2519981

Status: ACTIVE

676 N Port Bass Dr

Fair Play

$549,000

Property Type: detached

MLS: 2520043

Status: ACTIVE

4101 Ridgewood Dr.

Conway

$425,800

Property Type: detached

MLS: 2519919

Status: ACTIVE

201 Delano Way

Myrtle Beach

$649,900

Property Type: detached

MLS: 2519985

Status: ACTIVE

2660 Pegasus Place

Myrtle Beach

$375,000

Property Type: detached

MLS: 2519840

Status: ACTIVE

2145 Lark Dr.

Surfside Beach

$540,000

Property Type: manufactured leased land

MLS: 2519843

Status: ACTIVE

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