2666 New York 23, Hillsdale

$1,100,000

3 Beds
4 Baths
2,448 Sqft
½ Acre
0 Garage

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.

Essential Information
MLS® #20262449
Price$1,100,000
Bedrooms3
Bathrooms4.00
Square Footage2,448
Acres0.50
Year Built1880
TypeResidential Income
Sub-TypeQuadruplex
StatusActive
Style

Cottage, Farmhouse, Gothic Revival

Community Information
Address2666 New York 23
AreaHillsdale
CityHillsdale
CountyColumbia
StateNY
Zip Code12529
Amenities
ParkingDriveway
Interior
Interior FeaturesHigh Speed Internet
HeatingVaries by Unit
StoriesBi-Level
Appliances

Washer/Dryer, Refrigerator, Range, Microwave

Exterior
ExteriorFrame
ConstructionFrame
FoundationBlock, Brick/Mortar
Lot Description

Few Trees, Front Yard, Near Golf Course, Paved, Rectangular Lot, Views

School Information
DistrictTaconic Hills Central Schools
Additional Information
ZoningResidential/Com
Listing Details
AgentMargaret Bower Avenia
Listing Courtesy of Columbia County RE Specialist
LISTING MAP

Get directions to this property:

Ulster County Board of Realtors Logo The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.

Copyright © 2026 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.

All information provided is deemed reliable but is not guaranteed and should be independently verified.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.