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

65 Armstrong Road
Hardenburgh, NY 12406
Dara Barr with Keller Williams Upstate NY Pro, original listing - (607) 431-2540

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,799,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Upstate NY Pro
Agency Phone: (607) 431-2540

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 335 acre(s)
Property Type: Land-Agriculture
Year Built: --
Notes: Own Paradise: this historic farm estate has passed thru generations since the 1800s and is now on market for the first time. At the end of a town-maintained dead-end road in the Catskills is The Odell Farm, 335 splendid acres of forest, meadows, pond, and stream adjoining thousands of acres of protected state land. This private and delightfully secluded retreat consists of the original 4BR 1.5 bath 1826 farmhouse and 1991 3BR 2BA oversized lodge along with a detached 5 bay garage and a professionally restored barn. Maintained forest roads throughout the property make for usable land to explore + the potential for new builds with spectacular western views. The farmhouse is replete with country charm. The Lodge, a mountain chalet impressive in size, is built like a fort. Experience unparalleled privacy and serenity within close proximity to Margaretville, Belleayre for Skiing, all 2.5 Hours to NYC. A unique opportunity to become the next steward of an exceptional property. includes 11 parcels: 11.1-1-1; 11.-1-3; 11.-1-4; 3.3-3-27; 3.3-3-37; 3.3-3-38.100; 3.3-3-38.200; 3.3-3-39; 3.3-3-40; 3.3-3-41; 3.3-3-42
MlsNumber: --
ListingId: 20251079


Listing Provided By: Keller Williams Upstate NY Pro, original listing
Phone: (607) 431-2540
Office Phone: (607) 431-2540
Agent Name: Dara Barr
Disclaimer: Copyright © 2025 Multiple Listing Service of Ulster County. 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