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;

0 Dam Road
Ancram, NY 12502
Charles Peck with Charles Peck Real Estate, original listing - 851-9854

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Charles Peck Real Estate
Agency Phone: 851-9854

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 113 acre(s)
Property Type: Land-Other
Year Built: --
Notes: 113.38 acres on both sides of Dam Road with over 6,000 ft of road frontage and approximately 1,800 feet of underground electric, with 3 electric stations, one of which is 400 phase electric and an electric outlet for power equipment located at the top of a knoll on the North side of Dam Road. Accompanying the electric conduit line is also a telephone line in conduit as well that goes to the building site. There are two perc tests located on the North side of dam Road that are located on the survey with a letter of approval from the Columbia County Health department. A letter from the NYSD of Environmental Conservation Division of Fish, Wildlife and Marine Resources, Region 4 explains the disposition of the wetlands on the South side of Dam Road.There is also a soil Survey of the types of soil for growing crops and an acreage total for each type of soil. There are open fields that are organic in nature and have not been fertilized in 22 years. This property is in an agricultural and residential zone. There is a pond surrounded by Black Ash trees which are used by the Shakers to make baskets and I have one that was made by a person from the Shaker Village in Cannan, NY. from my wetlands. There are 4 home-sites that have Southerly views of Columbia and Dutchess Counties. The farmer is entitled to harvest his crops.There are many portals through the fields and hedgerows and woods that allow vehicles to go to any part of the property. Very well kept. Broker owned
MlsNumber: --
ListingId: 143528


Listing Provided By: Charles Peck Real Estate, original listing
Phone: (518) 821-2311
Office Phone: 851-9854
Agent Name: Charles Peck
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