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;

133 Tower Drive
Gate City, VA 24251
Lori Fletcher with Conservus Real Estate Group, original listing - (423) 343-4307

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $375,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1632 Square Feet
Agency: Conservus Real Estate Group
Agency Phone: (423) 343-4307

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1956
Notes: Here it is! A home that is NEW inside and out situated on a private 2.75 acre tract that feels remote yet minutes to it all. <br /> <br /> Owners have taken this 1956 farmhouse and brought a storybook vision to life. As soon as you enter the driveway, you notice the picturesque double porches- perfect for taking in the serene views. <br /> <br /> This home is NEW, NEW, NEW! Even the studs are new. New duct work, roof, windows, siding, flooring, drywall, appliances, and HVAC. All the work has been done for you. You just need to call the movers.<br /> <br /> Luxury plank flooring, nice kitchen with appliances conveying, large living room area, TWO covered porches, and so much charm and character inside and out. <br /> <br /> Great floor plan! The main level offers flex space, kitchen, bathroom, and oversized living area. A beautiful fireplace is the focal point of the room . The second story offers bedrooms, additional bath, and access to the second story porch that has dreamy views. You won't want to leave your rocking chair. <br /> <br /> Dreamy acreage that offers privacy. You may even spot a deer or two in your own backyard. This is a rare jewel of a find in Scott County. Private location- yet minutes from everything SW VA and NE TN. If you have ever dreamed of building a new home in the countryside with acreage, look no more. This farmhouse has been lovingly transformed all throughout and is ready for new owners. Make your appointment to see this beauty today!<br /> <br /> All information is deemed reliable but to be verified by Buyer and/or Buyer Agent.
MlsNumber: --
ListingId: 9971675


Listing Provided By: Conservus Real Estate Group, original listing
Phone: (423) 343-4307
Office Phone: (423) 343-4307
Agent Name: Lori Fletcher
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