Title Page Background
DEBUG FN args: Array ( [0] => 2907 [1] => [2] => [3] => agent ) BEFORE: Site: 2907 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2907 Igate: njhud LocID: 2907 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2907 [1] => [2] => [3] => lender ) BEFORE: Site: 2907 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2907 Igate: njhud LocID: 2907 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2907 [1] => [2] => [3] => other ) BEFORE: Site: 2907 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2907 Igate: njhud LocID: 2907 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

133 Cloud High Road
Duffield, VA 24244

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $196,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1290 Square Feet
Agency: Appalachian Realty Executives, LLC
Agency Phone: (276) 523-2635

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1973
Notes: Well Loved Brick Home on 1.57 acres beckons you to come and enjoy the peace and quiet......and the views. There is a covered patio off the kitchen and dining perfect for that early morning or evening 'break' to enjoy all Mother Nature has to offer. Only 3 miles from Natural Tunnel State Park, a 35 minute drive to Kingsport. There are 2 covered carports and a one car detached garage. Large hall bath with 2 sink vanity, tub/shower combo, new toilet and there is a large linen closet. 3 good sized bedrooms with a coat closet between 2 of the bedrooms at the end of the hall. Living room fireplace could easily be converted to gas. There are 2 rooms off the bedroom area that could be used as an office, TV room, library, or a huge mud/laundry room; one room has a man door to the covered carport. There is a FP in the 2nd room that could be converted to gas. The home has public water and there is a well on the property you could use for gardening, etc. Metal roof was checked this year. Generous, site built gazebo in the side yard shaded by pear trees. There is a hot tub in the gazebo; sellers do not know if it still works. There are 2 lovely Mimosa trees in the back yard and another along the paved driveway. This home is very close to local schools, shopping in the Duffield area and convenient to the Tri-Cities amenities. There is more than enough space for a large garden, chickens, kids, pets, pool........you decide.....no restrictions!<br /> Call and schedule your appointment today! Seller does require POF and/or letter of pre-qual. Estate sale and being sold AS IS.
MlsNumber: --
ListingId: 9966234


Listing Provided By: Appalachian Realty Executives, LLC, original listing
Phone: (276) 219-4822
Office Phone: (276) 523-2635
Agent Name: Elaine Lawson
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