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

496 Happy Hollow Rd
Orlando, WV 26412
Wyndi Yanero with Central WV Real Estate, LLC, original listing - (304) 462-5997

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $398,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2000 Square Feet
Agency: Central WV Real Estate, LLC
Agency Phone: (304) 462-5997

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 120 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1965
Notes: Want PRIVACY? This 120 acres sits at the very end of Happy Hollow and what's best is it offers unlimited FREE GAS! This hobby farm has just what you need to live off the land. There's garden space with its own well and garden shed, a four stall livestock/ hay barn, a flowing creek in the valley, two hunting cabins, and it borders thousands of acres of government public hunting that leads to the Burnsville Lake and Campground. There's a 20x24 utility barn to store your tractor or ATVs, two weathering sheds for livestock, and a chicken coop with a fenced-in run. Fencing is around part of the pasture, garden area, and a small orchard of peach and apple trees as well as blueberry bushes. The home was originally a single-wide mobile home on a permanent foundation with an attached two-car garage, a basement and additions on every side. Spacious and cozy, this home includes a walkout basement level where you will find the utility room/half bath, a sun-room with a view, and even a greenhouse room with it's own dug well. The two stall garage offers a ton of attic space for extra storage. The free gas on the property provides heat for the home and also gas for the cook-stove, water heater, dryer and generator. There's also two mounted gas lights on the wall in the wrap around addition. Vinyl siding/ metal roof, and the appliances convey. Private septic and an excellent water well. Approximately 8 acres are open, and it was selectively timbered 6 years ago.Large and unique bucks roam the land and does and fawns are seen daily in the pastures around the home. The seller notes that "Each season brings a beauty to enjoy from the snow that decorates the large evergreens seen from the windows, to the springtime when the dogwoods glow with their blooms on the hill, as well as flowering perennials that were planted years ago.This is a place to be enjoyed by those who love God's beautiful creation." Take a look at this hobby farm soon! Make it yours for $398,000.
MlsNumber: --
ListingId: 11354326


Listing Provided By: Central WV Real Estate, LLC, original listing
Phone: (304) 765-2255
Office Phone: (304) 462-5997
Agent Name: Wyndi Yanero
Disclaimer: Copyright © 2024 My State MLS. 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 = 2987 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App