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' with 18++ bedrooms, 20 bathrooms, 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.