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

1370 Hidden Valley Road
Kingsport, TN 37663
Lauren Castle with Castle & Associates Real Estate, original listing - (423) 307-5128

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 4310 Square Feet
Agency: Castle & Associates Real Estate
Agency Phone: (423) 307-5128

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 46 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1957
Notes: Over 47 picturesque acres within 5 minutes to I-26 and about 8 minutes to I-81. This is a 2 home-2 lot package with the Main Home situated on 46.75 acres, complete with a One Acre Pond w/ fountain, Separate 3-Bay Garage, a Custom climate-controlled Workshop-Showroom w/ hydraulic motorbike lift, full bathroom and security cameras. A short walk across the field is a 120'x140' Open Span Barn which could be used as a riding arena or possibly a wedding/event venue. The main home is a comfortable farmhouse ranch with eat-in kitchen w/ granite countertops, a generous family room with fireplace and sliding glass doors overlooking the pond, the brick patio and views of rolling pasture land. There is an 18'x36' inground swimming pool finished with concrete decking and a metal gazebo for entertaining (pool will need a little work, however, a new $4000 cover is on the way soon). The metal roof on this home is less than 10 years old. This acreage is currently designated Greenbelt for possible tax advantage. The second property is an 882 sq ft, 2/1 Bungalow, (233 Hidden Valley, Washington County Tax ID 004 028.00) on a Residential one-acre adjacent lot, and includes newer metal roof, updated kitchen, bath and paint. CLOSE to Bristol Motor Speedway, Great Smoky Mountains National Park. A 1.5 hours' drive to Dollywood, Sevierville, Pigeon Forge, Gatlinburg. Some photos may be digitally enhanced. All information deemed to be reliable but not guaranteed. Square footage and acreage taken from tax records. Buyer should verify all information to their satisfaction.
MlsNumber: --
ListingId: 9970169


Listing Provided By: Castle & Associates Real Estate, original listing
Phone: (423) 312-1910
Office Phone: (423) 307-5128
Agent Name: Lauren Castle
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.


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 = 2508 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Ronnie (Doc) Manis
Ronnie (Doc) Manis
ASCIIWeichert Realty Saxon Clark
Call Today!: (210) 380-1892

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App