2666 Ny-23, Hillsdale, NY 12529 (MLS# 20262810)
$1,100,000
Hillsdale, NY 12529
MLS# 20262810
3 beds | 4 baths | 5000 sqft

1 / 56
Property Description
Unique investment opportunity in the hamlet of Hillsdale. This new-to-the-market commercial/residential property has been meticulously renovated by the current owner, a commercial builder, who over-engineered the project with high-end features throughout. The property consists of four distinct rental units: 2666 Route 23, Main (Blue) Building - First-Floor Commercial Unit Right Side: 360 sq. ft. (currently Antique Shop) - Second-Floor Residential Apartment: Two bedrooms, 737 sq. ft. (currently VERY LUCRATIVE AirBnB) - Two-Story Commercial Unit Left Side: 766 sq. ft. (currently leased 12+/- mo. to State) Red Barn Building - Two-Story Barn Renovation: Two bedrooms, one bath, 791 sq. ft. (currently VERY LUCRATIVE AirBnB) Main Building: Circa 1880 3 Units ~ 2 Commercial Retails and a Fully Furnished turn key AirBnB/Apartment In the Berkshire/Taconic Mtn area, main building was fully renovated creating retail shops and a sophisticated but casually comfortable 2 BR apt. saving many of the original building features. Efficiency kitchen (convention microwave, cooktop, Mr. Coffee, all utensils, cookware, DW) with a W/D, marble bath, sleeps 4 , cable TV and internet. Bright and airy, full AC. Children friendly with tamper proof outlets, central station fire alarm system, CO detector. Offered Fully Furnished. The Carriage House ~ Private Residence AirBnB This structure was built around 1845 as a carriage house for the main building. The building's structure was completely reconstructed with great sensitivity to the unique features of the original use. The hay loft floor remains as a ceiling for the 1st floor although it is now 11 ft high. The 1st floor consists of an open plan living space with a washer/dryer combo tucked tastefully in the utility space. The 2nd floor has 2 bedrooms and a bathroom highlighted by the exposed timber roof framing. The space; the effort to maintain the 1845 appeal of the space is very successful with finishes utilizing reclaimed materials from the main house renovation as well as much from the original carriage house. The original siding has been incorporated into the interior walls abutting the timber framed structure. The bathroom is finished with Carrera marble tile shower walls and floor. Five panel mahogany doors complete the charming ambiance of the space. The Barn is highly energy efficient with spray foam insulation, new Pella windows and heat pump supplying environmental comfort. Immediately outside the entrance is a blue-stone paver patio with dining table chairs, Adirondack seating and gas grill. This overlooks a calming view of gardens and neighboring backyards. Offered Fully Furnished. Five Start AirBnB stats upon request. Purchased in 2012, transformed into sophisticated retail/residential, vacation getaway spaces, while preserving many original architectural features - see list of improvements. Basement of main building could easily be converted into additional living space. Features include high ceilings, water already hooked up etc. The location is ideal for a four-season destination, situated near Catamount Ski and Adventure Park, the Copake-Hillsdale Farmers Market, the Harlem Valley Rail Trail (goes all the way to NYC now!), and Taghkanic State Park. It also offers easy access to the dining and entertainment options in Hudson and the Berkshires. This is an exceptional multi-use property for anyone seeking a high-quality investment in Columbia County.
Details
Contract Information
Current Price: $1,100,000
Original List Price: 1100000
List Price: $1,100,000
Status: Active
Listing Contract Date: 2026-05-28
Property Sub Type: Co-Ownership
Property Attached YN: Yes
Listing Agreement: Exclusive Right To Sell
Owner Name: Sullivan
Occupant Type: Vacant
Lease Considered YN: No
General Property Information
Bedrooms Total: 3
Bathrooms Total: 4
Bathrooms Full: 4
Above Grade Finished Area: 2448
Below Grade Finished Area: 2448
Living Area: 5000
New Construction YN: No
Year Built: 1880
Garage YN: No
Lot Size Acres: 0.5
Flood Plain YN: No
Association YN: No
Basement YN: Yes
Stories: 2
Fireplace YN: No
Spa YN: No
Sign On Property YN: Yes
List Price/SqFt: 220
Remarks and Miscellaneous
Public Remarks: Unique investment opportunity in the hamlet of Hillsdale. This new-to-the-market commercial/residential property has been meticulously renovated by the current owner, a commercial builder, who over-engineered the project with high-end features throughout.
The property consists of four distinct rental units:
2666 Route 23, Main (Blue) Building
- First-Floor Commercial Unit Right Side: 360 sq. ft. (currently Antique Shop)
- Second-Floor Residential Apartment: Two bedrooms, 737 sq. ft. (currently VERY LUCRATIVE AirBnB)
- Two-Story Commercial Unit Left Side: 766 sq. ft. (currently leased 12+/- mo. to State)
Red Barn Building
- Two-Story Barn Renovation: Two bedrooms, one bath, 791 sq. ft. (currently VERY LUCRATIVE AirBnB)
Main Building: Circa 1880 3 Units ~ 2 Commercial Retails and a Fully Furnished turn key AirBnB/Apartment
In the Berkshire/Taconic Mtn area, main building was fully renovated creating retail shops and a sophisticated but casually comfortable 2 BR apt. saving many of the original building features. Efficiency kitchen (convention microwave, cooktop, Mr. Coffee, all utensils, cookware, DW) with a W/D, marble bath, sleeps 4 , cable TV and internet. Bright and airy, full AC. Children friendly with tamper proof outlets, central station fire alarm system, CO detector. Offered Fully Furnished.
The Carriage House ~ Private Residence AirBnB
This structure was built around 1845 as a carriage house for the main building. The building's structure was completely reconstructed with great sensitivity to the unique features of the original use. The hay loft floor remains as a ceiling for the 1st floor although it is now 11 ft high. The 1st floor consists of an open plan living space with a washer/dryer combo tucked tastefully in the utility space. The 2nd floor has 2 bedrooms and a bathroom highlighted by the exposed timber roof framing.
The space; the effort to maintain the 1845 appeal of the space is very successful with finishes utilizing reclaimed materials from the main house renovation as well as much from the original carriage house. The original siding has been incorporated into the interior walls abutting the timber framed structure. The bathroom is finished with Carrera marble tile shower walls and floor. Five panel mahogany doors complete the charming ambiance of the space. The Barn is highly energy efficient with spray foam insulation, new Pella windows and heat pump supplying environmental comfort. Immediately outside the entrance is a blue-stone paver patio with dining table chairs, Adirondack seating and gas grill. This overlooks a calming view of gardens and neighboring backyards. Offered Fully Furnished.
Five Start AirBnB stats upon request. Purchased in 2012, transformed into sophisticated retail/residential, vacation getaway spaces, while preserving many original architectural features - see list of improvements.
Basement of main building could easily be converted into additional living space. Features include high ceilings, water already hooked up etc.
The location is ideal for a four-season destination, situated near Catamount Ski and Adventure Park, the Copake-Hillsdale Farmers Market, the Harlem Valley Rail Trail (goes all the way to NYC now!), and Taghkanic State Park. It also offers easy access to the dining and entertainment options in Hudson and the Berkshires.
This is an exceptional multi-use property for anyone seeking a high-quality investment in Columbia County.
Status Change Information
Major Change Timestamp: 2026-05-29T01:09:07Z
Major Change Type: New Listing
Status Change Timestamp: 2026-05-28
Book Information
Liber/Book: Deed
Page: 360
Section: 145
Room Types
Bathroom Level: Second
Great Room Level: Lower
Kitchen Level: Second
Laundry Level: First
Living Room Level: Second
Other Room Level: First
Location Tax and Legal
Street Number: 2666
Street Name: Ny-23
County: Columbia
State: NY
Zip Code: 12529
Town (Taxable): Hillsdale
Property Features
Appliances: Microwave; Range; Refrigerator; Washer/Dryer
Architectural Style: Other
Attic Features: Unfinished
Basement: Full; Walk-Out Access
Community Features: Clubhouse; Fishing; Golf; Lake; Park; Playground; Racquetball; Restaurant; Sidewalks; Storm Drains; Street Lights
Construction Materials: Frame
Electric: 220 Volts in Kitchen
Fencing: Back Yard
Flooring: Ceramic Tile; Concrete; Varies; Wood
Foundation Details: Block; Brick/Mortar
Green Energy Efficient: Insulation
Heating: Varies by Unit
Interior Features: High Speed Internet
Laundry Features: In Basement
Levels: Bi-Level
Listing Terms: Contract
Lot Features: Few Trees; Front Yard; Near Golf Course; Paved; Rectangular Lot; Views
Other Equipment: Varies by Unit
Parking Features: Driveway
Patio And Porch Features: Deck; Patio; Porch
Possession: Close Of Escrow
Property Condition: Updated/Remodeled
Road Frontage Type: Town
Road Surface Type: Paved
Sewer: Public Sewer
Room Types: Bathroom; Bedroom; Great Room; Kitchen; Laundry; Living Room; Other Room
Room Information
| Room Name | Level | Remarks |
| Great Room | Lower | Unit 1/Left Side of building |
| Great Room | Second | Unit 1/Left Side of building |
| Bedroom | Second | Unit 1/Left Side of building |
| Other Room | First | Unit 1/Left Side of building |
| Other Room | Second | Unit 1/Left Side of building |
| Kitchen | Second | Unit 2/Fully Furnished Apt. |
| Living Room | Second | Unit 2/Fully Furnished Apt. |
| Bedroom | Second | Unit 2/Fully Furnished Apt. |
| Bedroom | Second | Unit 2/Fully Furnished Apt. |
| Bathroom | Second | Unit 2/Fully Furnished Apt. |
| Great Room | First | Unit 2/Right side of building |
| Bathroom | First | Unit 2/Right side of building |
| Kitchen | First | Sep building/BARN RESIDENCE |
| Great Room | First | Sep building/BARN RESIDENCE |
| Laundry | First | Sep building/BARN RESIDENCE |
| Bedroom | Second | Sep building/BARN RESIDENCE |
| Bedroom | Second | Sep building/BARN RESIDENCE |
| Bathroom | Second | Sep building/BARN RESIDENCE |
Listing Courtesy of Columbia County RE Specialist
Listing Agent: Margaret Bower Avenia
