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

860 Freed Rd
Brohard, WV 26138
Bryan Groves with Central WV Real Estate, LLC, original listing - (304) 462-5997

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 5
Baths: Full: 2
Status: Active
SqFt: 3000 Square Feet
Agency: Central WV Real Estate, LLC
Agency Phone: (304) 462-5997

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: This 100 acre farm is located in a private and picturesque location on a quiet, country road and has over a mile of road frontage. The home has been totally renovated and remodeled, both interior and exterior, in the last year and a half. The spacious, two-story home offers over 3,000 sq ft of living space. The first floor of the home has a large open area, which contains the newly remodeled kitchen, living and dining area, a full bath, two bedrooms, an office, and a utility room. The beautiful staircase leads to the second floor where the master bedroom suite, with a full bath, is located along with two other bedrooms. The exterior of the home has vinyl siding and a shingle roof. One can relax and overlook the scenic valley and hills from a newly constructed, back deck (496 sq ft), a small deck off of the second story master bedroom suite, along with a small front stoop. The indoor climate is controlled by the efficient radiant water heat and two mini split systems. There is a private water well and septic, and the Seller will convey the FREE GAS rights. Additional structures include a four stall outbuilding / storage shed, a one stall outbuilding / storage shed, a small barn, a cellar with a cellar house above, and a chicken coop. The land offers ample room for livestock and small scale farming. The wooded area is teeming with deer, turkey, squirrels, rabbits and a few bears. All in all, this property offers the opportunity for the prepper / survivalist lifestyle. There are no restrictions or zoning on this property. The location is less than an hour to Parkersburg, WV, and within 20 minutes of conveniences such as groceries, gas, hardware, household items and a restaurant. This property will be shown by appointment only and the Seller requests no drive-bys. A preapproval letter or proof of funds letter will be required when submitting a written offer. This large tract of country acreage, with a spacious home in move-in condition, is being offered for $450,000.00.
MlsNumber: --
ListingId: 11350973


Listing Provided By: Central WV Real Estate, LLC, original listing
Phone: (304) 462-5997
Office Phone: (304) 462-5997
Agent Name: Bryan Groves
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 = 3019 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