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 = 1940 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 = 1940 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 = 1940 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;

812 Ravenel Ridge Road
Highlands, NC 28741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,995,000
Beds: 5
Baths: Full: 6, ½: 2
Status: Active
SqFt: --
Agency: Highlands Sotheby's International Realty - DT
Agency Phone: (828) 526-8300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Stunning estate home in Highlands' most prestigious gated community, nestled in a natural mountain setting, yet just a few blocks from the Highlands' boutique shopping, upscale dining and entertainment. You escape to paradise in this sophisticated sanctuary, where luxury and nature offer the pinnacle of refined and relaxed living. The main residence has a flowing floorplan, with a massive chef's kitchen, pantry, and top-end appliances that is perfect for entertaining. Adjoining the kitchen is the perfect dining area with a stone fireplace to add warmth to the setting. Leading from the kitchen too is a vaulted great room bathed in light and panoramic views, with walls of floor-to-ceiling windows that's ideal for hosting friends. The home also boasts a second more intimate living room with a towering stone fireplace that sets the stage for relaxation, awe-inspiring views across the stone patio, and unforgettable memories. This oasis has a primary ensuite on the main level that features an large high-ceiling bedroom, private living room, his and her bathrooms and walk-in-closets with generous cabinetry, and luxury tiled showers. Additionally, the standard of excellence is evident in each of the additional (4) bedrooms and bathrooms. The home also boasts personal offices, a fitness center, large laundry, and an additional bonus room ready for your imagination. A beautiful and spacious detached guest cottage adjoins the home with a kitchenette, laundry, bedroom, bathroom and separate living room. A meandering stream and waterfall flows through the estate and amongst the picturesque gardens and manicured grounds. Large outdoor deck spaces offer captivating spaces with one of the best views of the Blue Ridge Mountain peaks and downtown Highlands. This residence has a unique elegance that immerses you in the grandeur of the Highlands Plateau and offers an unrivaled living experience for those with discerning tastes
MlsNumber: --
ListingId: 104722


Listing Provided By: Highlands Sotheby's International Realty - DT, original listing
Phone: (828) 734-0565
Office Phone: (828) 526-8300
Agent Name: David Parker
Disclaimer: Copyright © 2024 Highlands Cashiers Board 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App