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','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

824 Top Ridge Drive
Sunset, SC 29685
James Fuqua with Coldwell Banker Caine/Williams, original listing - (864) 250-2850

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,499,000
Beds: 4
Baths: Full: 6, ½: 4
Status: Active
SqFt: --
Agency: Coldwell Banker Caine/Williams
Agency Phone: (864) 250-2850

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Instantly relax in the tucked away splendor of Stone Vista Manor with open, panoramic water views in The Reserve at Lake Keowee! Driving up the cobblestone courtyard, Stone Vista Manor’s massive stone arches welcome you through the foyer into the main living room that showcases some of the best views of Lake Keowee and the Blue Ridge Mountains. Designed by Brad Wright and built by Morgan-Keefe Builders, this home is designed to provide special pockets of grandeur to its residents with features like a screened in porch with fireplace, outdoor kitchen, and dining all in one place (the best room in the home!), sleeping porch off the master bedroom, curved wine cellar under the spiral staircase, English pub style den and billiards room, and covered heated swimming pool installed in 2019 with a full bathroom to rinse off just steps away. The interior was thoughtfully curated by ID Studios Interiors in Greenville, with the landscape shaped by Barry Cosgrove Landscaping. Live at ease in the home’s 4 bedrooms, 6 full baths, 4 half baths, and bunk room that sleeps four. The master includes his and her baths on the main floor with a laundry room just around the corner. Also on the main floor, the high ceilings in the living room feature reclaimed beams from an Ohio Mennonite Farm. The kitchen cabinetry conceals the refrigerator, separate freezer, and first-rate Miele appliances, giving the space a clean and refined look. Off to the side, a mudroom provides room for umbrellas, coats, and extra storage. The third level holds a separate craft room and separate office, all with built-in storage for supplies, files, and more, and the home’s elevator allows seamless access to all three floors. On the lower level, you’ll find an inlaid compass at the base of the stairs next to the wine cellar before entering the English pub and billiards room. Lofty ceilings feature reclaimed Cypress from the Everglades and more expansive views of the lake. Built for entertainment, the lower level also hosts a separate sitting room, full kitchen, and full bath where downstairs guests can make themselves right at home with access to the covered, heated swimming pool that overlooks the lake. The detached 3 bay garage offers plenty of space for your vehicles or working space and includes a half bath. A carriage house apartment is above the garage, perfectly suited for a caregiver, housekeeper, or guests. Stone Vista Manor makes for an ideal retreat for those who appreciate quality, custom craftsmanship and attention to detail. With stone arches inside and out, a slate roof, exterior mahogany doors, Morgan Creek Cabinets, and accents from Charles Calhoun Design & Metal Works, this home is built to last and serve your luxury lifestyle. Positioned on 1.34 acres with tons of outdoor space, you’ll love living in the incomparable Reserve at Lake Keowee which offers over $100 million in world-class amenities: Jack Nicklaus Signature Golf Course, Orchard Clubhouse with fine dining, Fitness Center, Several Hiking Trails, Har-Tru Clay Tennis Courts at the Tennis Center plus Lawn Tennis on the Great Lawn, Pool and Cabana, Settlement Village Pool Pavilion, Pickleball Courts, Marina, and Village Market for casual dining. A Reserve membership, offering access to these world class amenities, is available for purchase with the home. Get to the lake in under two minutes with your own full Kroeger Marine covered Dock and Tram access, enjoy the beautiful waters of Lake Keowee all year round.
MlsNumber: --
ListingId: 1524613


Listing Provided By: Coldwell Banker Caine/Williams, original listing
Phone: (864) 250-2850
Office Phone: (864) 250-2850
Agent Name: James Fuqua
Disclaimer: Copyright © 2024 Greater Greenville 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','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;
Real Estate Expert Photo for Kim Humphries
Kim Humphries
ASCIIBluefield Realty Group
Call Today!: (864) 345-3635

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App