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

994 Albany Turnpike Turnpike
Chatham, NY 12037

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 5
Baths: 2
Status: Active
SqFt: 3040
Agency: William Pitt Sotheby's Int'l

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential
Year Built: 1750
Notes: Historic Elijah Hudson Homestead & Farm<br /> <br /> Welcome to the Elijah Hudson homestead and farm, nestled in the hamlet of Malden Bridge, NY. Steeped in rich history dating back to the mid1700s, this property boasts a captivating past as a colonial-era inn, meeting place for traveling preachers, and farm of a co-founder of the Federal Stores mercantile (Old Chatham). The homestead, lovingly restored over decades, offers a glimpse into the region's storied past, with original features meticulously preserved alongside modern updates for comfortable living. The property encompasses 43 acres of picturesque land, including sprawling fields, pristine gardens, and tranquil woods teeming with wildlife. Two meticulously restored barns, including a stunning German horse barn and a Dutch dairy barn, stand as testaments to the property's enduring legacy. The Dutch barn, fully rebuilt in recent years, presents a blank canvas for the next owner's vision, while the German barn offers versatile finished spaces for entertainment, hobbies, and more. Experience the best of country living in this idyllic retreat, where generations have gathered to celebrate life's milestones and forge lasting memories. With its proximity to local amenities, recreational opportunities, and vibrant community life, the Elijah Hudson homestead offers an opportunity to own a piece of living history in the heart of upstate New York. Don't miss your chance to write the next chapter in this timeless legacy.<br /> <br /> Property Improvement Highlights<br /> This meticulously maintained property has seen numerous upgrades and renovations over the years, ensuring modern comfort without compromising its historic charm. Recent improvements include an upgraded bath and laundry rooms, a complete restoration of the Dutch barn, and exterior painting of both barns, among others. With a commitment to preserving its heritage while embracing modern living, the Elijah Hudson homestead is ready to welcome its next steward into a future filled with possibility.
MlsNumber: 20242347


Listing Provided By: William Pitt Sotheby's Int'l, original listing
Name: William Pitt Sotheby's Int'l
Phone: (518) 392-0244
Office Name: William Pitt Sotheby's Int'l
Office Phone: (518) 392-0244
Agent Name: Joseph Briggs
Disclaimer: Copyright © 2024 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