Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:183 Execution Time: 0.187 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: 3.72 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 |
Intercoastal Waterway 2 bedroom & 2 full bath !!Amazing opportunity to own this luxurious condo in the AAA 4-Diamond awarded resort - Marina Inn at Grande Dunes. This impeccable 2 bed/2 full bath unit overlooking the marina, ICW and the world-renowned Grande Dunes Resort course. Kitchen and baths have beautiful tile floors and solid surface countertops. This maintenance free condo has just about everything included in the HOA, including access to the award-winning Grande Dunes Ocean Club, indoor/outdoor pools, business center, spas, sauna and fitness center, valet parking, and more. The Marina Inn is located in the Grande Dunes development, which is a 2200-acre, amenity-rich development filled with lifestyle opportunities unrivaled in the market. Owners also enjoy the exquisite Ocean Club that has fine dining, oceanfront pools, meeting rooms and is truly a remarkable event venue. Amenities including two prestigious 18-hole golf courses. The Resort course is open to the public and the Nick Price-designed "Members Club" is open to members. Other features include 126-wet slip deep water marina able to accommodate vessels up to 120-feet or more, and state of the art Har-Tru tennis facility. Grande Dunes is a wonderful and private community that sits conveniently in Myrtle Beach, close to the Atlantic Ocean and the best shopping and dining on the Grand Strand!
The Hoffman Group
$289,000
2005
Grande Dunes -Marina Inn
4702
On ICW
Golf Course View,Waterway View
07
1550
1376
0
Wind Treat. Convey,Fire Sprinkler,Smoke Detector,Washer/Dryer,Wshr/Dryer Connection,Furnished,Enter Through Foyer
Single Level
2
2
0
Yes
Carpeting,Tile
Lvr/DR Combo
Dishwasher,Garbage Disposal,Refrigerator,Range,Breakfast Bar,Oven,Microwave,Pantry,Solid Surface Countertops
Lvr/DR Combo
Ceiling Fan,Fireplace
Dishwasher,Garbage Disposal,Refrigerator,Range,Breakfast Bar,Oven,Microwave,Pantry,Solid Surface Countertops
Electricity,Sewer,Telephone,Water Public
Electric
Central Heat,Central Air,Electric
Hi-Rise 7+ Stories
Balcony,Elevator-Exterior
Slab
Parking Lot
Single Level
Yes
Parking Lot
Clubhouse/Rec/Facilities,Pool-Outdoor Community,Restrictions,Security,Seller Disclosure,Owner Allowed Pet,Home Owners Assn Fee,Short Term Rental Allowed,Long Term Rental Allowed,Pool-Indoor Community,Owner Allowed Golf Cart
Rectangular
16C Myrtle Beach Area--79th Ave
Horry
39408040159
$1,892
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.