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;

130 Carmack Drive
Hiltons, VA 24258
Lou Britt with Blue Ridge Properties, original listing - (423) 247-4181

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $174,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1124 Square Feet
Agency: Blue Ridge Properties
Agency Phone: (423) 247-4181

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Discover the perfect blend of charm, character, and modern convenience in this completely remodeled home in the idyllic community of Hiltons, VA. Boasting income-generating potential as a successful AirBnB, this move-in-ready residence offers the ideal opportunity for both comfortable living and savvy investment. Step into a world of elegance and comfort as you explore the spacious living areas of this meticulously renovated home. The living room, bathed in natural light, seamlessly flows into the dining area, providing ample space for gatherings and relaxation. The heart of the home, is the eat-in kitchen, with its abundance of natural light, new appliances, and adjacent laundry room. It offers the perfect space for culinary endeavors and everyday living. With three bedrooms and a fourth room that can be used as a den, office, or additional bedroom, this home provides flexibility to suit your lifestyle needs. Whether you're working from home, hosting guests, or simply enjoying quiet moments of solitude, there's a space for every occasion. A spacious 20 x 20 detached garage provides ample storage for all your outdoor gear, vehicles, and more. Situated on a large, perfectly level lot, this home offers easy access to a wealth of recreational opportunities. From the nearby Holston River and Carter Fold to hiking and biking along the Mendota Trail. The home is also close to all that the Tri-Cities region has to offer. From the excitement of the Hard Rock Casino and Bristol Motor Speedway. All furnishings can stay with the home, making it easy to move in and start enjoying the comforts of your new surroundings right away. With the exception, of a few personal items, everything you need to begin your new chapter awaits. Whether you're seeking a peaceful retreat or a lucrative investment opportunity this property offers the perfect blend of comfort, convenience, and income potential.
MlsNumber: --
ListingId: 9964686


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