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;

2920 Ann Goode Cooper Road
Hiltons, VA 24258
Billy Vermillion with Greater Impact Realty Kingsport, original listing - (423) 530-7185

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 6
Baths: Full: 3
Status: Active
SqFt: 4880 Square Feet
Agency: Greater Impact Realty Kingsport
Agency Phone: (423) 530-7185

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Take a look at this 4800 sf custom built log cabin on a quiet country road with a wrap around porch sitting on 8+ acres on the North Fork of the Holston River with 275+ feet of riverbank. The house is constructed of hand hued hemlock logs, yellow knotty pine hardwood floors, oak and poplar cabinetry and cedar lined closets. This home has large spacious rooms with vaulted ceilings and an inlaw suite that has a 2nd kitchen in the finished basement. The attic space bonus room floor and walls are lined with yellow pine T&G boards. Watch the sunrise on the wrap around porch that surrounds the entire exterior of the home and enjoy a sunset on the riverbank catching small mouth bass, sunfish and catfish then at night make smores on the riverbank campfire. 279 feet of riverbank property is included. There is a 30'x24' picnic shelter with electric, water and an RV septic connection to host parties and family BBQ cookouts that will accommodate large groups with plenty of parking area in the front yard. American Home Shield home warranty is transferable to the new buyers. New inside hvac thats 3 mos old. <br /> The road has been recently paved. Most of the furniture will convey with the property. Some personal property furnishings may convey if buyer is interest. Call today and schedule your showing as this dream log cabin will not last very long. All information contained herein comes from tax records and is subject to buyers verification.
MlsNumber: --
ListingId: 9971404


Listing Provided By: Greater Impact Realty Kingsport, original listing
Phone: (423) 218-5900
Office Phone: (423) 530-7185
Agent Name: Billy Vermillion
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