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

80 County Route 408
Westerlo, NY 12193
Elizabeth Alfeld with Keller Williams Realty HV Nort, original listing - (845) 481-2700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $582,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3128 Square Feet
Agency: Keller Williams Realty HV Nort
Agency Phone: (845) 481-2700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1849
Notes: 1800s Farmhouse on 17.49 Acres of Scenic Beauty in Westerlo<br /> <br /> Set far back from the road and nestled among the rolling hills of Westerlo, this 1800s farmhouse is steeped in charm and surrounded by 17.49 acres of meadows, woodlands, and long-range mountain views. The setting is private, peaceful, and picturesque—ideal for anyone seeking a quiet country escape with room to create, retreat, or reinvent.<br /> <br /> Inside, you'll find the kind of timeless character that only comes with age: wide plank refinished wood floors throughout, original woodwork, a mix of sheetrock, plaster, and paneling, and double-hung windows that let in golden-hour light. Thoughtful updates over time have maintained the home's integrity while allowing space for your own vision.<br /> <br /> One of the property's standout features is the oversized, heated 4-car garage with an accessory dwelling unit (ADU). Whether you're envisioning a home office, guest quarters, creative studio, or a private retreat for a loved one, this flexible space offers endless potential.<br /> <br /> Significant updates offer peace of mind: two new propane boilers and hot water heaters, a whole-house generator, a freshly painted exterior in 2024, a new roof on the garage/studio, and a metal roof on the main house recently coated with anti-rust paint—all done to preserve the property and protect your investment.<br /> <br /> The land itself is a showstopper. Open fields perfect for gardening or stargazing. Wooded areas to explore. Distant views that seem to go on forever. And thanks to a neighboring farmer, the property qualifies for an agricultural exemption, providing the potential for reduced property taxes.<br /> <br /> Whether you're dreaming of a quiet country lifestyle, a beautiful place to grow, or a scenic backdrop for your next chapter, this historic farmhouse offers space, soul, and untapped potential in one of Upstate New York's most enchanting settings.
MlsNumber: --
ListingId: 20251286


Listing Provided By: Keller Williams Realty HV Nort, original listing
Phone: (845) 481-2700
Office Phone: (845) 481-2700
Agent Name: Elizabeth Alfeld
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.


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 = 1823 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;
Anthony Redway
ASCIIRedway Realty
Call Today!: (917) 915-0250

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App