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

218 Wade Lookabill Drive
Boone, NC 28607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1920 Square Feet
Agency: Keller Williams High Country
Agency Phone: (828) 386-1086

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: A piece of Green Valley history, this farm has been in the same family for over 100 years, purchased by the current owners great grandfather in 1900! With Views a creek, barn, pasture, 36 x 48 post steel garage and multiple outbuildings this is truly a rare find. The first thing that you see as you enter the property is a beautiful knoll currently used to cut hay that would also make an outstanding building site with gorgeous views. Passing the hay field you will come to a 6 stall barn with a tack room, feed room and wash room that also has a 225 x 24 extension and a 936 sf apartment that has been framed in with plumbing and electrical. Next to the barn there is a 4 year old 36 x 48 Post Steel Garage with an insulated ceiling and 2 10 x 12 garage doors also wired for an RV. While the house is a mobile home, it sits on a block foundation with a large addition and 30 year roof installed in 2014 with smart siding that has just been painted. The kitchen has been upgraded with hickory cabinets, leathered black granite countertop and stainless appliances. A new Rheem heat pump, water heater, pressure tank and well pump are just a few of the upgrades in this home. A lovely creek runs along the back side of the property and several sheds including a root cellar are scattered throughout. Green Valley is a beautiful area, just 10 minutes from everything Boone and located near several parks including Elk Knob State park and historical Todd featuring the New River and multiple activities including rafting, hiking and biking. If you are looking for a mini farm that is close to town with potential income and a building site this property is a must see. Call us for a showing today!!
MlsNumber: --
ListingId: 249753


Listing Provided By: Keller Williams High Country, original listing
Phone: (828) 268-5337
Office Phone: (828) 386-1086
Agent Name: Donna Dunham
Disclaimer: Copyright © 2024 High Country Association of Realtors. 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