Query Template: /themes/irishoward/modules/myrtle-beach-mls/realcfc/mlsnew.cfc:184 Execution Time: 0.248 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.224 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 |
Leave behind the ordinary as you are welcomed home to this custom-built masterpiece where no expense was spared to construct a luxurious lifestyle. Step inside the grand entrance of this well-appointed home and awe at the 16’ soaring ceilings and the gorgeous views from the oversized windows that provide an abundance of natural light. Designed for entertaining, the great room also includes a fireplace and large entertaining bar with sink. The open floor plan flows effortlessly to an expansive gourmet kitchen complete with a center island boasting ample prep space and sink, a top-of-the-line Wolf gas range with dual ovens, a Sub-Zero oversized refrigerator and built-in wine fridge. This endless display of custom craftsmanship and artistry continues into the expansive first-floor master suite featuring a cozy sitting area with gas fireplace, two oversized walk-in closets and all the upgrades you’d expect in a home of this magnitude. The en-suite bath, designed with Grecian spas in mind, features an oversized jacuzzi tub surrounded by a tile shower with multiple shower heads to suit any showering preference. A stately office wrapped entirely in mahogany with custom built-ins, coffer ceilings and an air filtration system (for enjoying the finest cigars at your leisure) completes the main level along with a home gym, laundry, and guest room. Two large bedrooms with full size en-suites and a bonus room with wet bar comprise the second level, creating a perfectly private space for entertaining guests and daily life. Outside a paver drive is flanked by garages on either side with room for 3 cars and plenty of storage. A resort style outdoor living area including a pool, spa, and outdoor kitchen create a true oasis in the backyard. Located in the prestigious, gated community of Grande Dunes Calais, you’ll enjoy access to amenities that mirror the luxurious lifestyle of this grand estate including the Ocean Club with pool, private beach access and dining, two 18-hole golf courses, including the area's only truly private course designed by Nick Price, a deep-water marina, Har-tru tennis courts and so much more! Built with only the finest materials, including highly durable steel studs, this home is a rare find for those seeking a truly exquisite lifestyle.
CRG Real Estate
$1,599,000
2007
Detached
7201
5212
Mediterranean
Wind Treat Convey, Garage Door Opener, Security System, Sauna Room, Wshr/Dryer Connection, Washer/Dryer, Split Bedroom Plan, Fireplace
4
4
2
Yes
Bar, Wet Bar, Vaulted/Cathedral Ceiling, Fireplace
Vaulted/Cath. Ceiling, Ceiling Fan, 1st Flr Level, Walk-in Closet, Sitting Area, Linen Closet, Fireplace
Tile, Wood, Carpeting
Formal, Vaulted/Cathedral Ceiling
Bar, Fireplace, Vaulted/Cathedral Ceiling, Ceiling Fan
Range, Work Island, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Breakfast Bar, Pantry, Double Oven, Freezer, Solid Surface Countertops
Den/Study/Library, Recreation Room, 1st Floor Bedrooms, 1st Floor Baths, Foyer, Laundry/Utility, Bonus Room, Media Room
Double Sink, Shower, Tub, Vanity, Vaulted/Cathedral Ceiling, Whirlpool Tub
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
Patio, Balcony, Fencing, Lawn Sprinkler, Pool-Outdoor Private, Spa/Hot Tub, Insulated Doors/Windows, Side Load Garage
Stucco
Slab
Central Heat, Electric
Two-Story
Attached 3-Car
8
Electric
0.47
Rectangular
Inside City Limits, East of Bus 17
124x180x99x180 ft
Electricity, Water Public, Sewer, Cable TV, Underground Utilities, Telephone
10-16-2021
Home Owners Assoc. Fees, Restrictions, Clubhouse/Rec/Facilities, Pool - Outdoor Community, Security, Gated Community, Long Term Rental Allowed, Owner Allowed Motorcyle, Tenant Allowed Motorcycle, Owner Allowed Golf Cart, Tenant Allowed Golf Cart, Owner Allowed Pet, Private Beach Comm Access
Grande Dunes - Calais
16C Myrtle Beach Area--79th Ave
Horry
39415010002
$380
Electric Common, Trash Pickup, Common Maint/Repair, Recreation Facilities
Myrtle Beach Elementary School
Myrtle Beach Middle School
Myrtle Beach High School
Copyright 2024 Coastal Carolinas Association of REALTORS®, Inc.
Information Deemed Reliable, but Not Guaranteed.