2666 Ny-23, Hillsdale, NY 12529
Local realty services provided by:CENTURY 21 Stoeckeler Real Estate
2666 Ny-23,Hillsdale, NY 12529
$1,100,000
- 3 Beds
- 4 Baths
- 5,000 sq. ft.
- Co-op
- Active
Listed by: margaret bower avenia, john avenia
Office: columbia county re specialist
MLS#:20262810
Source:NY_MLSUC
Price summary
- Price:$1,100,000
- Price per sq. ft.:$220
About this home
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....
Contact an agent
Home facts
- Year built:1880
- Listing ID #:20262810
- Added:63 day(s) ago
- Updated:July 31, 2026 at 03:32 PM
Rooms and interior
- Bedrooms:3
- Total bathrooms:4
- Full bathrooms:4
- Rooms Total:18
- Flooring:Ceramic Tile, Varies, concrete, wood
- Basement:Yes
- Basement Description:Full, Walk-Out Access
- Living area:5,000 sq. ft.
Structure and exterior
- Year built:1880
- Building area:5,000 sq. ft.
- Lot area:0.5 Acres
- Lot Features:Near Golf Course
- Construction Materials:Frame
- Exterior Features:Deck, Patio, Porch
Utilities
- Sewer:Public Sewer
Finances and disclosures
- Price:$1,100,000
- Price per sq. ft.:$220
- Tax amount:$7,314
Features and amenities
- Amenities:High Speed Internet
Parking
- Parking description:Driveway
New listings near 2666 Ny-23
- New
$3,300,000Active4 beds 3 baths5,760 sq. ft.124 Syre Lane, Hillsdale, NY 12529
MLS# 20264310Listed by: COLUMBIA COUNTY RE SPECIALIST - New
$392,500Active2 beds 2 baths1,494 sq. ft.155 Pumpkin Hollow Road N, Hillsdale, NY 12529
MLS# 1030579Listed by: ELYSE HARNEY REAL ESTATE - New
$474,900Active3 beds 2 baths1,912 sq. ft.41 Cold Water Street, Hillsdale, NY 12529
MLS# 20264095Listed by: COPAKE LAKE REALTY CORP.
$1,145,000Pending3 beds 4 baths2,750 sq. ft.42 Shepherd Hill Circle, Hillsdale, NY 12529
MLS# 20264030Listed by: FOUR SEASONS SOTHEBY'S INT'L R
$749,000Active3 beds 2 baths2,040 sq. ft.695 Wolf Hill Road, Hillsdale, NY 12529
MLS# 1005033Listed by: BHHS HUDSON VALLEY PROPERTIES
$890,000Active4 beds 2 baths2,040 sq. ft.49 Knapp Hollow Ln, Hillsdale, NY 12529
MLS# 250191Listed by: COPAKE LAKE REALTY CORP.
$650,000Active3 beds 3 baths1,977 sq. ft.3493 County Road 7, Hillsdale, NY 12529
MLS# 20263719Listed by: CORCORAN COUNTRY LIVING
$325,000Active2 beds 1 baths736 sq. ft.81 SW Colony Road, Hillsdale, NY 12529
MLS# 20263707Listed by: BERKSHIRE HATHAWAY HOMESERVICE
$729,900Active3 beds 3 baths2,210 sq. ft.417 Overlook Drive, Hillsdale, NY 12529
MLS# 20263699Listed by: RED APPLE REALTY
$365,000Active1 beds 1 baths684 sq. ft.251 Overlook Drive, Hillsdale, NY 12529
MLS# 20263656Listed by: COLUMBIA COUNTY RE SPECIALIST