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

10804 Hoxie Rd
West Edmeston, NY 13485
Noah Posson with Posson Realty LLC, original listing - (607) 316-6597

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $890,000
Beds: 7
Baths: --
Status: Active
SqFt: --
Agency: Posson Realty LLC
Agency Phone: (607) 316-6597

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 211 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1865
Notes: Welcome to this amazing 211-acre certified organic Amish farm. Located on a quiet road, this farm features a total of nearly 2,000 yards of road frontage stretch along two roads, providing great year-round access to farmland. The land lays in a balance of approximately 125 acres of tillable, nearly 80 of which is fenced in and is currently used as a mix between pasture and cropland(corn and wheat). The remaining acreage is a combination of wooded land(60+ acres) and three ponds totaling roughly 8 acres, which have been generously stocked with blue gill and large-mouth bass and are perfect for other outdoor activities. Moving inside the home, you'll find a large seven-bed Amish-modified home. With new additions on all four sides of the original structure, this home has seen many new updates, including new vinyl windows and siding, fresh paint on the interior and exterior of the home, and newer wood flooring. The house is primarily heated using a wood furnace, and water is provided by a spring-fed well-supplying water throughout the barns and the home. If the upstairs wasn't spacious enough, the walk-in basement provides extra space for storage as needed. Outside, there are several buildings, including a cabinet workshop(48x115) with an attached garage/shop, large enough for parking cars or larger machinery. Additionally, the horse barn(35x100) is equipped with partial concrete floors, ten wooden stalls for livestock and tackle, a larger bay for machinery, and plenty of room for hay storage. Moving to the centerpiece of the property, the two-story conventional barn spanning 35x160 is rigged with 37 caw-size stalls, with water line hook-ups ready to roll. Farming isn't your thing, or need a new side hobby? Step into the maple house, featuring a six y/0 CDL high-efficiency evaporator ready to process syrup from the more than 1000 taps located throughout the property. Centrally located, this property is a short 12-minute drive to Edmeston, NY, where you'll find all your small-town necessities like gas stations, banks, restaurants, and more. For larger commercial offerings the cities of Utica(34 min), Syracuse(1hr 1o) where there is an international airport, Binghamton (1hr 20), and Albany(1hr 45) are within drivable distance. Don't miss out on this beautiful farm, book your showing today!
MlsNumber: --
ListingId: 11384849


Listing Provided By: Posson Realty LLC, original listing
Phone: (607) 334-9727
Office Phone: (607) 316-6597
Agent Name: Noah Posson
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 = 1849 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Heather M. Morgan
Heather M. Morgan
ASCIIPeterson Properties
Call Today!: (585) 500-2927

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App