For Sale For Rent
Advertise
bedrooms
bedrooms
20
bathrooms
bathrooms
20
square feet
square feet
0
acreage
Acreage
15.78
open houses
Open Houses
-
year built
year built
-
full baths
Full Baths
20
half baths
Half Baths
0
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.
Location
Subdivision -
County New York
Elementary School -
Middle School -
High School -
open houses Open houses
None scheduled.
Find out more
Tell us who you are, and we will have someone reach out to you.

By proceeding, you consent to receive calls, texts and voicemails at the number you provided (may be recorded and may be autodialed and use pre-recorded and artificial voices), and email, from Kotohomes, Margaret Bower Avenia, and their network of service providers about your inquiry and other home-related matters.

Msg/data rates may apply. This consent applies even if you are on a do not call list and is not a condition of any purchase.

MLS number: 11416287
Listing agent: Margaret Bower Avenia
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.   [source]
Last update: Friday, February 7 2025 at 7:28 p.m. EST
Kotohomes National