Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2353 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2353 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2353 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

304 Club Cove Way
Sunset, SC 29685
Justin Winter with Justin Winter & Associates, original listing - (864) 506-6387

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,489,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: --
Agency: Justin Winter & Associates
Agency Phone: (864) 506-6387

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Elegance and exquisite taste are personified in this beautifully proportioned French Country lake home in an exclusive enclave of The Cliffs at Keowee Vineyards. Gentle topography and a plethora of high-canopied native trees frame the 9 bedroom home, served by 6 full bathrooms and one powder room. Views are multi-dimensional, including mountains, lake cove and channel, pristine state parkland, and the 4th green of the Tom Fazio golf course. The tranquil cove is just off the main channel, protecting boats and swimmers alike, whilst providing privacy. Set into the gracious stone façade, a handsome mahogany door opens into a contiguous living area, with beamed great room lit by Charleston lanterns, dining room, keeping room, and kitchen. Vaulted ceilings, clerestory windows, vast sliding doors to the screened outdoor living area, and a multitude of inner balconies and windows enhance the spacious atmosphere, while numerous European antique architectural elements add an essence of timelessness. The kitchen is flanked by the comfortable keeping room, and outfitted with a Dacor 6-burner gas range, double Dacor wall ovens, two apron farmhouse sinks, a walnut-topped island, and walk-in pantry. The generous screened porch readily accommodates dining and sitting areas on blue crab orchard stone, warmed by a gas-log limestone fireplace. In addition to four principally-sized suites are two darling double bedrooms, a charming bunk room at the lower level, and separate suite above the 3-car garage. The lake level media room opens to a blue flagstone patio delineated by zinc planters, with inset hot tub, grilling kitchen, and second outdoor fireplace. Also at this level are the bunk room, 9th bedroom, two full bathrooms, media room with billiards, a wet bar with ice machine, plenty of storage (including lake toy “garage”), and second laundry room with 3rd fridge and 2nd dishwasher. The home is professionally decorated, with sumptuous window treatments and thoughtful detailing throughout. Numerous impressive features include custom lighting fixtures (many of which are either antique or artisan-crafted from antiques), a home office with lake views, custom hand-wrought iron balusters, Grade 1 white oak flooring (a recent addition to the lower level), a two-slip boathouse, exterior gas lanterns, solid stone exterior, some 7,000 square feet of custom designed and engineered living space, and superlative artistic sensitivity, in both plan and execution. This beautifully designed and masterfully constructed home is a Cliffs at Keowee Vineyards icon with recent updates that bely the home’s early 2000’s construction.
MlsNumber: --
ListingId: 20286264


Listing Provided By: Justin Winter & Associates, original listing
Phone: (864) 506-6387
Office Phone: (864) 506-6387
Agent Name: Justin Winter
Disclaimer: Copyright © 2025 Western Upstate Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2353 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Rick Stroud
ASCIIEpique Realty - Great Homes of South Carolina
Call Today!: (864) 735-0705

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App