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','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

15047 South Us Hwy 23
Duffield, VA 24244
David Childress with Century 21 Heritage, original listing - (423) 900-0270

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 2716 Square Feet
Agency: Century 21 Heritage
Agency Phone: (423) 900-0270

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1953
Notes: Come see this awesome 23.9 acre property. One of those acres is across the road with 1000 ft. of river frontage, a hunting cabin and outhouse. This property does not have any restrictions you can have livestock, farm, fish and camp/tube or just spend time on/in the clinch river. The home has 3 bedrooms and one bath. You shouldn't run out of closet space with a closet in each bedroom, pantry in kitchen, coat closet at entry, 2 linen closets in hall and a utility closet. Two of the bedroom closets are lined with cedar wood. All new double pane windows, hard wood floors throughout, new tile work in bathroom and wood like floor and floating vanity. Kitchen has new flooring, plenty of cabinet space, movable island, double farm porcelain sink. new backsplash and stainless steal hood over stove. Nice sunroom on back of house with a concreate patio also, great for just hanging out or having guest over to enjoy the outdoors. There is a metal building behind the house for multiple uses like storing a side by side or a tractor etc.. Also there is a one car garage. The HVAC is only about 4 years old and the attic has had insulation blown in throughout. All water pipes have been replaced with new PEX and a water softener system. Moving back inside is a wood burning fire place for those cold winter nights, and will easily heat the almost 1400 sq.ft. home with almost 1400 sq. ft. in the unfinished basement making a total of about 2800 sq. ft. You can use this property for a wide variety of things such as hunting, building another home, or even use for a farm which it is already set up for with about 5 acres fenced near the house and about 1 acre across the road fenced.<br /> This home conveys with a generator for power loss that hooks up to the electric meter, Stove, Refrigerator, Washer and Dryer. Schedule your showing while it last. You don't want to miss this one. Just imagine enjoying the clinch river fishing or just relaxing while taking in all the beauty this property offers.
MlsNumber: --
ListingId: 9966339


Listing Provided By: Century 21 Heritage, original listing
Phone: (423) 895-2085
Office Phone: (423) 900-0270
Agent Name: David Childress
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