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

2896 Adelphia State Road
Wellston, OH 45692

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,000
Beds: 1
Baths: 1
Status: Active
SqFt: --
Agency: Arrowhead Land Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential
Year Built: --
Notes: NEW BARNDOMINIUM...Now that I have your attention, let's talk about this gem of a property you are looking into. This is an excellent example of what a "turnkey" hunting property is, and it's complete with a new barndominium and 3 stall horse barn with a HUGE loft!! Turning into the driveway to this property I was very impressed by the appearance of the newly constructed buildings. The owner and I toured the horse barn first, 3 stalls and a loft nearly the entire length of the barn give plenty of room for storing probably almost anything you could want to store! Next we toured the barndominium, entering through a man door into the "garage area" you will find a large open area with high open joist ceilings. As you make your way into the "finished" part of the basement you will find an open area unfinished with plumbing for an additional restroom, foam insulated exterior walls, and windows throughout. The openness of the ground floor will allow the new owners to customize this building to suit their needs. On the second floor you will find the living quarters. The living quarters consists of a huge walk in pantry, an open floor plan, and one bedroom. The barndominium currently has no electric and is not wired, the owner finished the inside of the living quarters with metal siding so removing the panels to run electric would not be extremely difficult and the new owners can put outlets wherever they would want. There is electric on a pole in the yard between the barn and barndominium. You can exit the kitchen area through double doors that lead you to a deck that is almost the entire length of the barndominium. The land this property has to offer is what deer hunters dream of. Just off the back of the barn is a 2-3 acre area that could be food plotted, and as a bonus the owners had some left over supplies from building and built a blind overlooking this area. A creek flows through the middle of this property and appears to have water year round. Mature timber litters most of the acreage this farm has to offer. Included in the sale will be numerous treestands, 3 ground level blinds and one elevated blind. The owner informed me that every time he hunted this year he saw several deer and several wild turkey. Deer sign is all over this property, rubs and heavily traveled corridors are not in short supply with this farm. Topography on this tract is diverse but trails make accessing stands very easy. Surrounding properties are generously sized and many practice QDM per the current owner. I can't find a more turnkey hunting property including a beautiful new barndominium on the market.
MlsNumber: 11275354


Listing Provided By: Arrowhead Land Company, original listing
Name: Arrowhead Land Company
Phone: (833) 873-2452
Office Name: Arrowhead Land Company
Office Phone: (833) 873-2452
Agent Name: Brian Whitt
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App