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;

7456 A P Carter Highway
Hiltons, VA 24258
Kristina Kilgore with The Addington Agency Bristol, original listing - (423) 845-5800

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 415 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Situated in the heart of the Appalachian Mountains, this exquisite property offers the rare opportunity to own one of the most beautiful and versatile farms in the region. Just 30 minutes from Bristol TN/VA and 25 minutes from Kingsport, TN you can take advantage of attractions like Bristol Motor Speedway, Hard Rock Resort and Casino, Birthplace of Country Music Museum, historic downtown Bristol and much more. The region is an outdoorsman's paradise with it's world class fishing, hiking, hunting and boating. The potential utilization for this 415 acre, partly wooded, partly pasture estate with stunning 360 views is endless: livestock, hunting and fishing retreat, family compound, event venue, ''Airbnb''. The extraordinary 7,592 feet of frontage on the Holston River is priceless. There is an historic log cabin that the current owners utilize as a short term rental. The plan was to build a 7000+/- sf lodge for family retreats. The plans for the aforementioned lodge do convey. There is a gorgeous 90x50 metal building, a 48x80 wood barn with cattle working facility, another hay barn, 2 ponds (one with an aerated fountain and stocked with fish), and ATV trails throughout the wooded areas. The current owner has meticulously maintained the property, as well as, taken care of all of the infrastructure necessary to make this the estate of your dreams: drainage, steel bridge spanning the river, fencing, multiple pastures, power run throughout most of property. The property consists of 4 parcels: 112 A 9A, 112 A 9, 112 A 9,7-11, 111 A 19C. Some farm equipment does convey. This is truly a special estate. Be sure to watch the video to get a better glimpse. All information herein is deemed reliable but subject to buyer verification.
MlsNumber: --
ListingId: 9958796


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