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

8245 Sandlapper Way

Myrtle Beach

$890,000

Property Type: detached

MLS: 2517824

Status: ACTIVE

Just Listed

168 Myrtle Grande Dr.

Conway

$385,000

Property Type: detached

MLS: 2517823

Status: ACTIVE

Just Listed

299 River Edge Dr.

Myrtle Beach

$408,290

Property Type: detached

MLS: 2517821

Status: ACTIVE

Just Listed

156 Osprey Cove Loop

Myrtle Beach

$265,000

Property Type: detached

MLS: 2517820

Status: ACTIVE

Just Listed

109 Forman Way

Aynor

$239,999

Property Type: manufactured with land

MLS: 2517813

Status: ACTIVE

Just Listed

109 Forman Way

Aynor

$239,999

Property Type: manufactured with land

MLS: 2517813

Status: ACTIVE

Just Listed

309 36th Ave. N

North Myrtle Beach

$639,900

Property Type: detached

MLS: 2517812

Status: ACTIVE

Just Listed

112 Forman Way

Aynor

$264,999

Property Type: manufactured with land

MLS: 2517810

Status: ACTIVE

Just Listed

117 B 9th Ave. S

Surfside Beach

$738,500

Property Type: detached with hpr

MLS: 2517799

Status: ACTIVE

Just Listed

6001 - V7 S Kings Hwy.

Myrtle Beach

$425,500

Property Type: detached leased land

MLS: 2517798

Status: ACTIVE

Just Listed

472 Craigflower Ct.

Longs

$324,900

Property Type: detached

MLS: 2517789

Status: ACTIVE

Just Listed

9212 Goodwill Ct.

Myrtle Beach

$475,000

Property Type: detached

MLS: 2517791

Status: ACTIVE

Just Listed

1773 Berkley Village Loop

Myrtle Beach

$347,900

Property Type: semi-detached

MLS: 2517788

Status: ACTIVE

Just Listed

854 Longwood Bluffs Circle

Murrells Inlet

$739,900

Property Type: detached

MLS: 2517785

Status: ACTIVE

Just Listed

108 Whaler Harbour

Myrtle Beach

$265,000

Property Type: detached

MLS: 2517773

Status: ACTIVE

Just Listed

2336 Highway 1115

Galivants Ferry

$979,000

Property Type: detached

MLS: 2517769

Status: ACTIVE

Just Listed

180 Highwood Circle

Murrells Inlet

$999,999

Property Type: detached

MLS: 2517762

Status: ACTIVE

Just Listed

1568 Pachino Dr.

Myrtle Beach

$3,400,000

Property Type: detached

MLS: 2517761

Status: ACTIVE

Just Listed

1922 N Twisted Oaks Dr.

Little River

$185,500

Property Type: manufactured with land

MLS: 2517760

Status: ACTIVE

Just Listed

20338 Choppee Rd.

Hemingway

$275,000

Property Type: detached

MLS: 2517759

Status: ACTIVE

Just Listed

3005 Sawyer St.

Conway

$235,000

Property Type: detached

MLS: 2517772

Status: ACTIVE

Just Listed

801 Bluffview Dr.

Myrtle Beach

$720,000

Property Type: detached

MLS: 2517764

Status: ACTIVE

Just Listed

345 Mikita Dr.

Surfside Beach

$660,000

Property Type: detached

MLS: 2517805

Status: ACTIVE

Just Listed

4725 Harmony Ln.

North Myrtle Beach

$829,000

Property Type: detached

MLS: 2517766

Status: ACTIVE

Just Listed

44 Hamby Dr.

Pawleys Island

$750,000

Property Type: detached

MLS: 2517758

Status: ACTIVE

Just Listed

3332 Candytuft Dr.

Conway

$359,990

Property Type: detached

MLS: 2517752

Status: ACTIVE

Just Listed

429 Falling Leaf Loop

Myrtle Beach

$275,000

Property Type: detached

MLS: 2517749

Status: ACTIVE

Just Listed

9546 Indigo Club Dr.

Murrells Inlet

$350,000

Property Type: detached

MLS: 2517748

Status: ACTIVE

Just Listed

138 Westfield Circle

Conway

$384,340

Property Type: detached

MLS: 2517746

Status: ACTIVE

Just Listed

4880 Hopespring St.

Myrtle Beach

$374,990

Property Type: detached

MLS: 2517744

Status: ACTIVE

Just Listed

4874 Hopespring St.

Myrtle Beach

$357,990

Property Type: detached

MLS: 2517742

Status: ACTIVE

Just Listed

315 Mistletoe Way

Longs

$258,900

Property Type: detached

MLS: 2517740

Status: ACTIVE

Just Listed

305 Little Caboose Rd

Loris

$272,500

Property Type: detached

MLS: 2517736

Status: ACTIVE

Just Listed

316 Mistletoe Way

Longs

$263,700

Property Type: detached

MLS: 2517738

Status: ACTIVE

Just Listed

607 Trap Shooter Circle

Longs

$311,900

Property Type: detached

MLS: 2517728

Status: ACTIVE

Just Listed

741 Londonberry Ct.

Conway

$310,000

Property Type: detached

MLS: 2517756

Status: ACTIVE

Just Listed

1301 Rabbit Ln.

Conway

$244,999

Property Type: manufactured with land

MLS: 2517729

Status: ACTIVE

Just Listed

2571 Wild Game Trail

Myrtle Beach

$284,900

Property Type: detached

MLS: 2517753

Status: ACTIVE

Just Listed

5400 Little River Neck Rd.

North Myrtle Beach

$159,000

Property Type: manufactured with land

MLS: 2517730

Status: ACTIVE

Just Listed

239 Yellow Rail St.

Murrells Inlet

$489,900

Property Type: detached

MLS: 2517723

Status: ACTIVE

Just Listed

TBB Black Creek Rd.

Nichols

$244,900

Property Type: detached

MLS: 2517715

Status: ACTIVE

Just Listed

2772 Ophelia Way

Myrtle Beach

$349,900

Property Type: detached

MLS: 2517713

Status: ACTIVE

Just Listed

8555 Black Creek Rd.

Nichols

$224,900

Property Type: detached

MLS: 2517712

Status: ACTIVE

Just Listed

8233 Vibrant Loop

Longs

$352,990

Property Type: detached

MLS: 2517711

Status: ACTIVE

Just Listed

256 Melody Gardens Dr.

Surfside Beach

$540,000

Property Type: detached leased land

MLS: 2517708

Status: ACTIVE

Just Listed

3704 Tranquility Loop

Longs

$369,990

Property Type: detached

MLS: 2517707

Status: ACTIVE

Just Listed

413 Cotton Grass Dr.

Loris

$400,000

Property Type: detached

MLS: 2517706

Status: ACTIVE

Just Listed

1494 Caines Landing Rd.

Conway

$625,000

Property Type: detached

MLS: 2517696

Status: ACTIVE

Just Listed

5005 Gallop Ct.

Myrtle Beach

$381,391

Property Type: detached

MLS: 2517689

Status: ACTIVE

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