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','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 = 1833 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 = 1833 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;

2205 County Route 5
Canaan, NY 12029

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3204 Square Feet
Agency: William Pitt Sothebys International Realty
Agency Phone: 392-0244

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Set atop a serene hill along a quiet, winding county road, this charming New England saltbox home perfectly blends classic elegance and modern comfort. Built in 1995 by a contractor as a spec project, the residence was customized to feature two spacious bedrooms, a cozy den that doubles as a ground-floor bedroom, three baths, a dining room that opens into the living room, an expansive great room that is ideal for both entertaining and everyday living, and tons of storage space throughout.A thoughtfully designed addition constructed in 2005 has enhanced the home's comfort-factor by introducing a bright and airy family room, a bonus space that could easily be converted to an exercise room, and above all of that an inspiring artist's/craft studio. Step outside and be greeted by a hot tub and the mahogany wood deck that overlooks a delightful .75-acre pond, perfect for unwinding, hosting outdoor gatherings, or taking in the abundant wildlife that frequents the area.With large double-hung windows throughout, the home is flooded with natural light, making every space feel warm and inviting. The property is surrounded by a blend of open landscapes and lush wooded areas, creating a private oasis where nature is just outside your door. Experience the best of country living while being minutes from local amenities in nearby New Lebanon, West Stockbridge, Chatham, Williamstown, Pittsfield and Lenox, as well as 40 minutes to Albany, 2.5 hours to NYC and 3.0 hours to Boston.
MlsNumber: --
ListingId: 154655


Listing Provided By: William Pitt Sothebys International Realty, original listing
Phone: (917) 748-5100
Office Phone: 392-0244
Agent Name: DeWayne A. Powell
Disclaimer: Copyright © 2024 Columbia Greene and Northern Dutchess 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