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;

1199 Odes Wilson Road
Zionville, NC 28698

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 1703 Square Feet
Agency: Blue Ridge Realty & Inv. Blowing Rock
Agency Phone: (828) 263-8711

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1917
Notes: Stunning Solare ar Home with Extensive Upgrades 3 bedrooms, 2 full baths, 2 half baths, lovely views, 8 stall barn, chicken coop, workout room, and two car detached garage. Welcome to this beautifully upgraded home, meticulously maintained and thoughtfully enhanced over the past four years. This property features: Brand new roofs on both the house and detached garage. All new, high-quality windows installed by Champion, with professional installation. New garage doors, front door, & kitchen door leading to the patio. New gutters installed professionally. Investment of several thousand dollars in landscaping, including outdoor raised vegetable beds. Upgraded outdoor lighting with motion and dusk-to-dawn sensors, new exterior and interior light fixtures, and solar lights on the pergola. New ceiling fans throughout the home. A newly built workout room in the outbuilding is designed to withstand extreme weather. Two full and two half bathrooms were fully remodeled by professionals. Fresh paint throughout the interior by a professional painter. A heavily stained patio pergola in excellent condition. A new propane fireplace was installed Two custom pantry cabinets were added. New flooring and utility sink in the laundry room. All-new smoke & carbon monoxide detectors.Crawlspace was cleaned, sealed, & ventilated by professionals, with a new dehumidifier. Fresh paint and stain on the front porch and pillars, with grading completed by the driveway. This home combines modern conveniences with extensive updates, offering both luxury and functionality in a beautifully maintained setting. Lot 1 has no restrictions lot 2 has restrictions please see the attached documents. Lots were combined. The buried tank was empty and filled with sand, & well water was tested at the time of purchase and found to be safe for drinking, Propane tanks are leased, one buried & one above ground. Please note; 837 heated square feet NOT counted due to ceiling height. ROW on lot 2 for property access.
MlsNumber: --
ListingId: 251263


Listing Provided By: Blue Ridge Realty & Inv. Blowing Rock, original listing
Phone: (828) 263-8711
Office Phone: (828) 263-8711
Agent Name: Holly Meyers
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.


Local Real Estate Expert

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;
Real Estate Expert Photo for Lori Eastridge
Lori Eastridge
ASCIINC High Country Real Estate - Powered by Realty One Group Select
Call Today!: (828) 773-2080

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App