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

2086 Turkey Ridge Road
Gate City, VA 24251
Kristina Kilgore with The Addington Agency Bristol, original listing - (423) 845-5800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4132 Square Feet
Agency: The Addington Agency Bristol
Agency Phone: (423) 845-5800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Wow, wow, wow! This stunning, custom home with gorgeous mountain views has so many architectural details that you simply will not find in any other home. And the property is like a little piece of secluded heaven with a resort setting. With the laundry and primary suite on the main, this home offers one level living. Please note a few of the custom details: high end El Mira Appliances, wormy chestnut beams, custom designed wood and tin ceilings, wrought iron ''Gobblers Knob'' gate at pool entrance, commercial tower and slide at pool, logs from a 100 year old home, fire pit with seating, wired for whole house generator and so much more. The property is 3 parcels (69 A 17, 69 A 16, and 53 A 32) including 2.5 acres where home sits, 10 acres of pasture with pond and barn, and 24 wooded acres with lots of wildlife. There is a wood burning fireplace in the front living room and gas logs in the great room, primary suite and sunroom. Lots of large closets and storage. The kitchen boasts a granite eating bar, lots of cabinetry, and double ovens. Wrap around covered porch with swing for enjoying the views. The 2 story garage/pool house offers a completely open and unfinished 2nd floor and is plumbed for a 1/2 bath. The heated pool has gas heater and ion system for sanitation, as well as, pool vac, solar cover and winter cover. Don't miss the secret storage/storm/pool utility room behind the garage. All information herein is deemed reliable but subject to buyer verification.
MlsNumber: --
ListingId: 9967725


Listing Provided By: The Addington Agency Bristol, original listing
Phone: (423) 360-0092
Office Phone: (423) 845-5800
Agent Name: Kristina Kilgore
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. 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