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','wihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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','wihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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','wihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wihud', 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;

7951 Route 22
Copake Falls, NY 12517
Margaret Bower Avenia with COLUMBIA COUNTY REAL ESTATE SPECIALISTS LLC, original listing - (518) 697-9865

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,850,000
Beds: 20
Baths: Full: 20
Status: Active
SqFt: --
Agency: COLUMBIA COUNTY REAL ESTATE SPECIALISTS LLC
Agency Phone: (518) 697-9865

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Bring All Offers ~ Motivated Seller This might be one of the most exciting opportunities available in Columbia County right now! Zoned both Commercial and Residential, most recently run as Newman Residence Adult Camp &previously known as 'The Rockledge Motel' on just under 16 acres. Mature landscaping and unique stone walls with 1,130 feet of road frontage on Route 22. Original building Cira 1900, added on (20x20 sq. ft additional living space) in 1950-1970 when 3 cottages & dining hall were built. Additional Features: 2 Generators, Top of the Line Security System (whole property wired & connected to Fire alarms), 20x20 Redwood deck, Paved Driveway, Unique Stone Walls,3000 gallon paddock in-ground pool. 5 buildings in total with an inground 24x42 pool. Unit 1: 960 Sq Ft: 3 bedrooms, Living room, 2 bathrooms Unit 2: 960 Sq Ft: 2 bedrooms w/ensuite bathrooms Unit 3: Self Contained Caretakers House ~ Kitchen, Dining room, Living room, 2 bedrooms, 1 bathroom Main House/5,268 Sq. Ft: 9 bedrooms (5 upstairs/4 downstairs), eat-in Kitchen, Lrg Dining room/Living room with DOUBLE SIDED FIREPLACE, 12 bathrooms, beautiful & unique living space, Open deck, Back & Side patios Unit 5: 1,360 Sq Ft: Dining Hall with Rec Room, Pool House The advantages this property offers as an event/reception facility, or multiple housing units can't be matched by any other property. With zoning and existing structures in place a new owner can begin their project immediately. If you have a vision for multiple housing units on a single parcel of land you won't find a better opportunity than this one. So many opportunities & possibilities for commercial and residential use are endless. Maintain as a camp or convert to a boutique hotel (much needed in the area) or build single or multiple unit residential units (subject to planning board review and approval). Perfectly located in the heart of the Hudson Valley, 20 minutes from Hudson, NY and Great Barrington, MA. 30 minutes from Rhinebeck NY, 2 Hours from NYC, 2.5 hours from Boston.
MlsNumber: --
ListingId: 11416287


Listing Provided By: COLUMBIA COUNTY REAL ESTATE SPECIALISTS LLC, original listing
Phone: (518) 325-9784
Office Phone: (518) 697-9865
Agent Name: Margaret Bower Avenia
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