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

8145 Highway 131
Washburn, TN 37888
Tannor Giles with Your Home Sold Guaranteed Realty TN, original listing - (865) 365-1670

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $600,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3520 Square Feet
Agency: Your Home Sold Guaranteed Realty TN
Agency Phone: (865) 365-1670

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1986
Notes: Your Home Sold Guaranteed or I'll Buy It! This property comes with $22,000+ in savings, guaranteed! That's no money down ($0) and up to 2 months of no payments for a stress-free move that can happen immediately. Better yet, if you are not satisfied with your investment at 24 months, we'll buy it back or sell it absolutely free-no questions asked. That's a $16,000+ value to our VIP buyers! We can even buy your current home so you can move in right away, so you don't get stuck owning two homes. Contact us today for a complimentary consultation and to get started. ________________________________________________________WOW! WOW! WOW!! What an amazingly huge and beautiful home. Can be for a growing family, or with a little work make part of the home into an In Law living space. Extremely Large Farmhouse kitchen and dining room combo for get togethers and entertaining. Move right into the super size living room with a cozy gas fireplace for those chilly nights. All 4 bedrooms live very large and the home also offers a fifth room for an office space, craft room or whatever you need it to be. When you go upstairs there is another living space that can be made into a kitchen and living room for older kids or the in laws. Walk into the next room and you have an 850 square foot open space for living quarters, storage, kids recreation area. Or reinstall a large garage door and make it into your mechanic shop, a store whatever you want it to be used for. Possibilities are endless... Also, there is a barn and a chicken coop. Take a little break and enjoy the Clinch mountain views from the front porch. This is a definite must see home that you do not want to pass up. Washer/dryer and ECO friendly thermostat 2 years old. Roof 6 years old, septic pumped in 2023, HVAC 5 years old. __________________________________________________________ Contact us today to get more information about this exclusive offer! Our properties include a 12-month limited home warranty ($500) value, $500 lender credit, $300 attorney credit, and $100 home inspection credit for VIP buyers. Note: This home qualifies for an additional 1% buy down rate for our VIP buyers, so much sure to sign up today! Your Home Sold Guaranteed Realty is the #1 Real Estate team for people looking to make a move fast while getting the most return. Let us show you why our team is the best in Tennessee and beyond.
MlsNumber: --
ListingId: 11401625


Listing Provided By: Your Home Sold Guaranteed Realty TN, original listing
Phone: (865) 505-8215
Office Phone: (865) 365-1670
Agent Name: Tannor Giles
Disclaimer: Copyright © 2025 My State MLS. 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