Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.33 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_value | display | url | areas | ||
1 | 54A Andrews Are--includes city o | Andrews | andrews | 54A | |
2 | 17A Aynor Area--central includes | Aynor | aynor | 17A,12A,13A | |
3 | 25B Conway Area--between Wacc. R | Conway | conway | 25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B | |
4 | 09A Conway to Longs Area--Betwee | Conway to Longs | conway-to-longs | 09A,09B | |
5 | 10A Conway to Myrtle Beach Area- | Conway to Myrtle Beach | conway-to-myrtle-beach | 10A | |
6 | 27A Garden City Mainland & Penni | Garden City | garden-city | 27A,28C | |
7 | 48A Georgetown Area--Belle Isle | Georgetown | georgetown | 48A,52A,53A,46A,50A,47A,49A,51A | |
8 | 41A Pawleys Island Area-Litchfie | Litchfield Beach | litchfield-beach | 41A,42A | |
9 | 04B Little River Area--North of | Little River | little-river | 04B,04A | |
10 | 03A Longs to Little River Area-- | Longs to Little River | longs-to-little-river | 03A | |
11 | 02A Loris Area--central includes | Loris | loris | 02A,05A,01A | |
12 | 06A Loris to Conway Area--South | Loris to Conway | loris-to-conway | 06A,08A | |
13 | 07A Loris to Longs Area--South o | Loris to Longs | loris-to-longs | 07A,03B | |
14 | 27B Murrells Inlet - Horry Count | Murrells Inlet | murrells-inlet | 27B,40A | |
15 | 25A Myrtle Beach Area--west of S | Myrtle Beach | myrtle-beach | 25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B | |
16 | 31B North Carolina | North Carolina | north-carolina | 31B | |
17 | 11D North Myrtle Beach Area--Atl | North Myrtle Beach | north-myrtle-beach | 11D,10C,11A,11C,11B,11F,11E | |
18 | 31A Other counties in South Caro | Other Counties | other-counties | 31A | |
19 | 31C Not in South Carolina or Nor | Other States | other-states | 31C | |
20 | 45A Pawleys Island Area | Pawleys Island | pawleys-island | 45A,43A,44A,45B | |
21 | 28B Surfside Area-Glensbay to GC | Surfside | surfside | 28B,29A,29B,28A |
Query Template: /themes/irishoward/page_templates/mls.cfm:75 Execution Time: 0.187 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_value | display | url | areas | ||
1 | 54A Andrews Are--includes city o | Andrews | andrews | 54A | |
2 | 17A Aynor Area--central includes | Aynor | aynor | 17A,12A,13A | |
3 | 25B Conway Area--between Wacc. R | Conway | conway | 25B,21A,21B,21D,21C,21E,14A,15A,23A,20A,18A,22A,15B,23B | |
4 | 09A Conway to Longs Area--Betwee | Conway to Longs | conway-to-longs | 09A,09B | |
5 | 10A Conway to Myrtle Beach Area- | Conway to Myrtle Beach | conway-to-myrtle-beach | 10A | |
6 | 27A Garden City Mainland & Penni | Garden City | garden-city | 27A,28C | |
7 | 48A Georgetown Area--Belle Isle | Georgetown | georgetown | 48A,52A,53A,46A,50A,47A,49A,51A | |
8 | 41A Pawleys Island Area-Litchfie | Litchfield Beach | litchfield-beach | 41A,42A | |
9 | 04B Little River Area--North of | Little River | little-river | 04B,04A | |
10 | 03A Longs to Little River Area-- | Longs to Little River | longs-to-little-river | 03A | |
11 | 02A Loris Area--central includes | Loris | loris | 02A,05A,01A | |
12 | 06A Loris to Conway Area--South | Loris to Conway | loris-to-conway | 06A,08A | |
13 | 07A Loris to Longs Area--South o | Loris to Longs | loris-to-longs | 07A,03B | |
14 | 27B Murrells Inlet - Horry Count | Murrells Inlet | murrells-inlet | 27B,40A | |
15 | 25A Myrtle Beach Area--west of S | Myrtle Beach | myrtle-beach | 25A,10B,24A,26A,16F,16E,16D,16C,16B,16A,16G,26B,16J,19A,24B | |
16 | 31B North Carolina | North Carolina | north-carolina | 31B | |
17 | 11D North Myrtle Beach Area--Atl | North Myrtle Beach | north-myrtle-beach | 11D,10C,11A,11C,11B,11F,11E | |
18 | 31A Other counties in South Caro | Other Counties | other-counties | 31A | |
19 | 31C Not in South Carolina or Nor | Other States | other-states | 31C | |
20 | 45A Pawleys Island Area | Pawleys Island | pawleys-island | 45A,43A,44A,45B | |
21 | 28B Surfside Area-Glensbay to GC | Surfside | surfside | 28B,29A,29B,28A |
**Welcome to Your Dream Home in Grande Dunes-Del Webb!** Seller Concessions available!! This home has an entrance on the front of the property (instead of the side), and a detached center island, unlike most of the others. And this is the lowest priced of these floor plans! Discover this stunning 2-bedroom, 2-bathroom residence that perfectly combines modern luxury with comfortable living. Nestled on a desirable corner lot, this home boasts an open concept design, ensuring ample space and natural light throughout. **Upgraded Features Include:** - Premium corner lot for added privacy and space - Top-of-the-line upgraded appliances - Expansive extended kitchen island, perfect for entertaining - Stylish upgraded kitchen cabinets and fixtures - Beautiful upgraded countertops throughout - Relaxing screened-in lanai, ideal for morning coffee or evening relaxation - Fully fenced yard for added security and outdoor enjoyment Located within a vibrant active community, you'll have access to an array of resort-style amenities, including access to GRAND DUNES RESORT AND BEACH CLUB, designed to enhance your lifestyle. Enjoy convenient beach access and proximity to local favorites, including restaurants, shopping, and entertainment along the Grand Strand. **Community Amenities Include:** - 4 Pickleball Courts for active play - 2 Tennis Courts for sports enthusiasts - Bocce Ball Courts for friendly competition - Outdoor Hot Tub for relaxation - Locker Rooms with showers for your convenience - Fully-equipped Fitness Center to stay in shape - Indoor/Outdoor Saltwater Pools for year-round enjoyment Don't miss the opportunity to make this exceptional home yours! Experience the perfect blend of luxury, comfort, and community living in Grande Dunes-Del Webb. Schedule your showing today!
Huskins Realty LLC
$454,900
2023
Semi-Detached
1649
1520
Low Country
Window Treat Convey, Garage Door Opener, Stairs To Attic, Smoke Detector, Wshr/Dryer Connection, Washer/Dryer, Furnished
2
2
0
No
Tile, Wood, Carpeting
Area
Ceiling Fan
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Pantry, Stainless Steel Apps., Solid Surface Countertops
Den/Study/Library, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Screened Porch
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Patio, Rear Porch, Fencing, Lawn Sprinkler
Wood Frame
Slab
Central Heat, Central Air, Electric
Single Level
Attached 2-Car
4
Electric
0.09
Corner
On Lake/Pond, Inside City Limits, Adult Community (55+)
Electricity, Natural Gas, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
7-14-2025
Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Tennis Court, Security, Seller Disclosure, Long Term Rental Allowed, Owner Allowed Motorcycle, Tenant Allowed Motorcycle, Pool - Indoor Community, Owner Allowed Golf Cart, Tenant Allowed Golf Cart, Owner Allowed Pet
Grande Dunes - Del Webb
16D Myrtle Beach Area--48th Ave
Horry
42108010089
$438
Electric Common, Trash Pickup, Pool Service, Landscape/Lawn, Manager, Common Maint/Repair, Recreation Facilities
Myrtle Beach Elementary School
Myrtle Beach Middle School
Myrtle Beach High School
Copyright 2025 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.