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 = 2990 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 = 2990 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 = 2990 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;

134 Powderhouse Road
Fairmont, WV 26554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $539,000
Beds: 6
Baths: 4
Status: Active
SqFt: 2412
Agency: Heritage Real Estate Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 1865
Notes: *****OPEN HOUSE SATURDAY, MARCH 16th, 11:00 - 5:00***** Step into the life you've dreamed of with this TURNKEY INCOME-PRODUCING FARM & VACATION PROPERTY. You will find infinite peace and unsurpassed beauty on this almost 8-acre u-pick apple farm. Included are two 5-star, fully-equipped, AirBnB’s, both of which have full baths & high-speed Internet. Income from just one was $30K/yr in 2023. Both AirBnB's are booked ahead for good, steady income. Historic, 3/2, brick Farmhouse (1600SF), 200+ apple trees, 2-story barn/workshop w/200amp elec., 28x52' irrigated high tunnel w/elec., stocked pond w/dock, completely fenced w/8' deer fence, pump house for irrigation from pond, 2 chicken coops, stocked woodshed, spring well/creek. All three dwellings have city water and high-speed Internet. Septic tanks pumped/inspected 2024. Newer furnace/HVAC system; roof in great shape. Remodeled bathrooms, living room. Links to AirBnb listings: airbnb.com/h/tinywvfarmhouse / airbnb.com/h/tinyfarmhouse2. 100% turnkey. SUMMARY: 7.8 acres (+/-) 8’ deer fence with electric gate surrounds the property, which is situated near the end of a dead-end street. The property is planted with some 250 apple trees at varying stages, most of them producing. Surrounding homes are also mostly on large parcels, and all the neighbors are wonderful. Stocked, spring-fed pond w/dock Spring water well, and creek. 28x52’ high tunnel w/work bench, electric, water Pump house pumps water from pond to irrigation system which feeds the greenhouse and front orchard. Has Rain timer and can be set for days/amounts/etc. First Airbnb, Tiny farmhouse #1, a studio with full bath. Fully furnished & equipped. All 5-star reviews. Second Airbnb, Tiny farmhouse #2, was completed in September and will double that amount in the coming years. 2BR w/full bath. Fully furnished & equipped. All 5-star reviews. Refinished, insulated 2-story barn/workshop w/200 amp electric Woodshed 2 chicken houses 5 beehives, plus all supplies Main house is 1600 SF, 3BR|2BTH Gas fireplace Newer HVAC Newer water heater New insulation in attic New floor in attic Both bathrooms remodeled recently Workshop in cellar Equipment conveyed w/acceptable offer 2-yr old Cub Cadet, dual-wheel, 0-turn, mower w/72” deck Late model Kawasaki SxS Sprayers Compressor Grafting Tools All Orchard & gardening tools & Supplies Seller is a licensed real estate broker.
MlsNumber: 10152503


Listing Provided By: Heritage Real Estate Company, original listing
Name: Heritage Real Estate Company
Phone: (304) 612-3746
Office Name: HERITAGE REAL ESTATE CO.
Office Phone: (304) 612-3746
Agent Name: BILL PORTER
Disclaimer: Copyright © 2024 North Central West Virginia Real Estate Information Network. 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