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

1802 Winchester Road
Shady Valley, TN 37688
Sonya Shepard with Bridge Pointe Real Estate Jonesborough, original listing - (423) 482-9616

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,999
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1186 Square Feet
Agency: Bridge Pointe Real Estate Jonesborough
Agency Phone: (423) 482-9616

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Charming 1900 farmhouse situated on 3.01 acres located in the beautiful mountains of Northeast Tennessee. Covered front porch invites you to a scenic lawn area with fruit trees and other evergreens. Creek running to the front gives the property that homestead feel. A lot of updates have been done to the property from Major electrical upgrades for house/property from Mr.electric installed outdoor 5 panel for outdoor hookups. The property now has a main shutoff from meter to panel. Water has been upgraded from well to house with PVC. Sewer pipe has been repaired. Installed 0utdoor water spigots with cutoff valves. Installed 3 RV pads with -250 ft of electric, water and sewer. Main RV pads for up to a 45ft camper is 30/50 amp service. 2-30ft RV pads with 30 amp service- 1 has plug installed w/outdoor cover- 1 pad is not finished. Ran water & electric 450ft away from home for future workshop. Cut out driveway 300ft to future workshop. Installed 100 amp outdoor electric 40 slot panel with 110 & 220 service for future workshop. also included with property is 30*30 upgraded steel master workshop for area snow w/blueprints. Ground cut out & leveled 30*45ft for future shop. The property also has a stone cellar with smoke shop, attached to barn. House is 100yrs old has hemlock beams. Many apple trees add to charm of property/about 8/10 have been fertilized.Buyer/ buyer's agent to verify all information.
MlsNumber: --
ListingId: 9970693


Listing Provided By: Bridge Pointe Real Estate Jonesborough, original listing
Phone: (423) 491-0389
Office Phone: (423) 482-9616
Agent Name: Sonya Shepard
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