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;

284 Hall Hill Rd-stop # 18
Ancram, NY 12502
Lindsay LeBrecht with Copake Lake Realty Corp., original listing - 325-9741

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1768 Square Feet
Agency: Copake Lake Realty Corp.
Agency Phone: 325-9741

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Cabin
Year Built: 1970
Notes: Spring has sprung and it is such a beautiful time of the year, here in Ancram, New York. The birds are starting to nest and are singing away!This 3 BR, 2 BA, 1768 sf log cabin is sited on 5 acres, and is surrounded by woods and meadows. A full basement below with its own fireplace (never used by these owners with no representation of its condition).There is a separate 3-acre parcel across the private road that is buildable. This will be offered first to the purchaser of the log cabin. The asking price for the separate 3 acre parcel is $50,000.The heart of this REAL log cabin is the open living room/dining area and kitchen. The fireplace and wood stove further contribute to the ambiance. The fiber-optic broadband brings your connection to the world up to today's standards.On a private road and close to a road less traveled, this centrally located property offers privacy AND convenience to Pine Plains, Millerton and Hudson, New York and Great Barrington, Massachusetts and Salisbury, Connecticut. New York is about two hours via the Taconic State Parkway, while the Metro-North train station is a 30-minute trip.If you haven't discovered Columbia County yet, you are in for a treat! Enjoy the close proximity to organic farms, theatre venues, Tanglewood, antiquing, Catamount Adventure Park, historic Hudson and farm-to-table restaurants, while having a private setting.The songbirds are already practicing their serenades to inspire you to see what Ancram and Columbia County, New York are all about.See additional notes attached to this listing. Also message from Ancram Highway Superintendent about road closure beginning May 5 for bridge work.
MlsNumber: --
ListingId: 156879


Listing Provided By: Copake Lake Realty Corp., original listing
Phone: (518) 325-9741
Office Phone: 325-9741
Agent Name: Lindsay LeBrecht
Disclaimer: Copyright © 2025 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