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;

533 North Mountain Rd
Copake Falls, NY 12517
Mitchell Serlin with WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1314 Square Feet
Agency: WHITETAIL PROPERTIES REAL ESTATE LLC (NY)
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 120 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1940
Notes: A Premier Hudson Valley farm is for sale. This family owned farm at its max production was milking 1500 head of cows 3 times a day. The farm is nestled between the Taconic and Catskill mountain ranges with spectacular views of both. The land contains good fertile soils capable of producing quality forage. The farm has the infrastructure and equipment to start up a large dairy or can be converted to any other farm operation. Back in 2019 the farm was enrolled in a Conservation Easement with Columbia County Land Conservancy Inc. The conservancy had the vision of keeping this farm forever in agricultural practices which can never be developed. Within the designated " Agricultural complex" their is two designated locations to build. These locations were hand picked because of their great building locations and outstanding views. The farm also comes with a 3 Bedroom 1 Bathroom home. The farm is equipped with: * 46000 Sq ft of cattle housing, * 3 Wells capable producing enough water to for 1500 cows which consume an average of 40 gals/day , * Bunk Silos with enough capacity for the necessary feed for 1500 cows, * 7 Bulk grain bins, * 32 Stall functioning Milking Parlor equipped with Metatron 12 Westfalia Surge milking equipment, * Milk handling equipment such as Mueller OE model Cooling and sanitizing equipment, *2 bulk tanks totaling 11,000 gallon capacity, *calf hutches, * 5 farm employee house trailers, * large manure handling pond, * Several buildings ( for bulk materials, shop,and storage) And much more.
MlsNumber: --
ListingId: 11164391


Listing Provided By: WHITETAIL PROPERTIES REAL ESTATE LLC (NY), original listing
Phone: (845) 216-1300
Office Phone: (217) 285-9000
Agent Name: Mitchell Serlin
Disclaimer: Copyright © 2025 My State 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