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;

7427 Manville Road
Gate City, VA 24251
Angela Rundle with Blue Ridge Properties, original listing - (423) 247-4181

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1568 Square Feet
Agency: Blue Ridge Properties
Agency Phone: (423) 247-4181

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 46 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Whether you're looking for a peaceful escape, a property to hunt, or wanting to retire in the mountains, this property checks all the boxes! This immaculate 2021 doublewide home sits on 46.20 acres. The property offers panoramic views of the beautiful mountains, a beautiful open floor plan home with 3 bedrooms, 2 full baths and beautiful kitchen with island and a propane fireplace. Outside you will find 3-30-amp camper plugs (1 connected to the home and 2 on a pole at top of the property. The pole at the top of the property with 2 camper hookups and Wi-Fi connections available. Chicken coop in barn stalls, 100-year-old rustic barn, 14x28 shed (new $12K), 720 foot well with pump house, 2021, home with septic 2021, with WI-FI available. You will also enjoy sitting on a new 10x58 foot deck overlooking the mountains and on the back of the home you will find a new 6x6 deck. There is a large, fenced area for a garden or animals. You will also find trails throughout the property, 2 hunting ladder stands, 1 tripod stand, unfinished with all the pieces and instructions, 2-275-gallon IBC tanks and so much more!! You are going to fall in love with this property, it's as if you could touch the sky!! Don't wait to make this your new home or vacation getaway!! Buyer/ buyer's agent to verify all information.
MlsNumber: --
ListingId: 9971096


Listing Provided By: Blue Ridge Properties, original listing
Phone: (423) 247-4181
Office Phone: (423) 247-4181
Agent Name: Angela Rundle
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