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

15 Lookout Ridge Drive
Travelers Rest, SC 29690
Teresa Jones with Coldwell Banker Caine/Williams, original listing - (864) 250-2850

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: --
Agency: Coldwell Banker Caine/Williams
Agency Phone: (864) 250-2850

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: A perfect diamond in a sea of gems… A rare and precious find, 15 Lookout Ridge Drive was created with precision and detail by expert artisans crafting natural stone, rich warm woods and unique metal accents to infuse the European cottage aesthetic which inspired the timeless design of this distinguished mountain home. This 5BR, 5.5 BA personal mountain retreat has it all with gathering spaces for small or large groups, and activities and interests for all ages. -- Complementing the surrounding natural beauty, it is tucked on 2.42 private wooded acres, (2 lots) in the exclusive, gated golf & fitness community of Cliff’s Valley, where club member golf, cycle, swim and play pickleball and tennis year-round. -- Enter the home from the bluestone courtyard through the covered arched entrance into the foyer with soaring plaster groin vaulted ceilings. The Foyer opens into the comfortably understated elegance of the Living Room with hickory floors, coffered ceilings, stone fireplace, built-ins and vast windows capturing dynamic views. Flowing into the open floor plan of the main living areas and Dining Room through natural stone arches, the gourmet Kitchen is equipped for serious cooking with a center island, premium appliances, a huge pantry, a butler’s pantry, a bar and a casual dining area which opens into the screened outdoor living spaces. This wrap-around screened living space has a vaulted tongue and grove ceiling, a stone fireplace, an al fresco dining area, and an outdoor kitchen with hooded DCS grill w/rotisserie. -- The main-level Primary Suite with dressing room is designed for lavish luxury with a bespoke En-Suite with heated Travertine floors, air jetted soaking tub, and an irresistible Travertine shower spa with multiple shower heads, 2 entrances, 2 benches and a shaving sink. Also found on the main level are a second Primary/Guest Suite with full En-Suite with heated Travertine floors, a Powder Room w/ custom sink made to replicate a lion fountain, a Laundry Room, an Office w/ built-ins, the “Friends Entrance” off of the courtyard, and access to the oversized 3 Bay Garage. -- Upstairs are 2 stunning Guest Suites w/full En-Suits and a Bunk Room w/a play fort.-- The lower level has a central Rec Room with Travertine floors, a stone fireplace, a Bar/Kitchenette, a climate-controlled Wine Cellar with tasting area, a Game Room, a Music Room, a Gym with cork floors, a full Bathroom, a screened outdoor Grotto w/stone fireplace and inground hot tub pool, a screened porch and a bluestone patio, as well as a gardeners potting room and 2 storage rooms. – Thoughtfully designed for efficiency, this home has several smart technology features, an energy efficient Geothermal heating & cooling system, and a whole house generator. -- 15 Lookout Ridge is an easy commute to GSP, downtown Greenville and Travelers Rest, SC, as well as Hendersonville, Asheville & Tryon NC. -- A Club membership with access to all 7 Clubs is available as a separate purchase.
MlsNumber: --
ListingId: 1531949


Listing Provided By: Coldwell Banker Caine/Williams, original listing
Phone: (864) 569-3329
Office Phone: (864) 250-2850
Agent Name: Teresa Jones
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 = 2337 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;
Hayley Searcy
ASCIIPonce Realty Group
Call Today!: (864) 580-1013

Local Mortgage Pro

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 = 2337 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;
Real Estate Expert Photo for Chad Baur NMLS# 1050384
Chad Baur NMLS# 1050384
ASCIICarolina Mortgage Firm
Call Today!: (239) 821-8814

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App