Find your dream home in the beautiful Hudson Valley

2666 Ny-23, Hillsdale, NY 12529

New Listing
$1,100,000
Property Type: Residential Bedrooms: 3 Baths: 4 Square Footage: 5,000 Lot Size (sq. ft.): 21,780 Status: Active
Current Price: $1,100,000 List Date: 5/29/2026 Last Modified: 5/30/2026

Overview

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 ...

Listing Details MLS# 20262810

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
Bathrooms Half
0

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

Contract Information

Original List Price
1100000
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

Location Tax and Legal

Street Number
2666
Street Name
Ny-23
County
Columbia
State
NY
Zip Code
12529
Town (Taxable)
Hillsdale

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

More Information

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
Bathroom
Yes
Bedroom
Yes
Great Room
Yes
Kitchen
Yes
Laundry
Yes
Living Room
Yes
Other Room
Yes

Location, Tax, and Legal

911 Address
2666 State Route 23, Hillsdale NY 12529
Township
Hillsdale
School District
Taconic Hills Central Schools
General Tax
4709.66
School Tax
2604.43
Tax Annual Amount
7314
Tax Year
2026
Assessors Full Market Value
403226
Tax Assessed Value
403226
Tax Legal Description
4 Units / 2 buildings / Mixed Use
Parcel Number
145.4-1-32
Tax Lot
145
Tax Block
4-1
Tax Exemptions YN
No
Zoning
Residential/Com
Zoning Description
Multi Use
Directions
From Route 22/23 Intersection

Appliances

Microwave
Yes
Range
Yes
Refrigerator
Yes
Washer/Dryer
Yes

Architectural Style

Other
Yes

Attic Features

Unfinished
Yes

Basement

Full
Yes
Walk-Out Access
Yes

Community Features

Clubhouse
Yes
Fishing
Yes
Golf
Yes
Lake
Yes
Park
Yes
Playground
Yes
Racquetball
Yes
Restaurant
Yes
Sidewalks
Yes
Storm Drains
Yes
Street Lights
Yes

Construction Materials

Frame
Yes

Electric

220 Volts in Kitchen
Yes

Fencing

Back Yard
Yes

Flooring

Ceramic Tile
Yes
Concrete
Yes
Varies
Yes
Wood
Yes

Foundation Details

Block
Yes
Brick/Mortar
Yes

Green Energy Efficient

Insulation
Yes

Heating

Varies by Unit
Yes

Interior Features

High Speed Internet
Yes

Laundry Features

In Basement
Yes

Levels

Bi-Level
Yes

Listing Terms

Contract
Yes

Lot Features

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

Other Equipment

Varies by Unit
Yes

Parking Features

Driveway
Yes

Patio And Porch Features

Deck
Yes
Patio
Yes
Porch
Yes

Possession

Close Of Escrow
Yes

Property Condition

Updated/Remodeled
Yes

Road Frontage Type

Town
Yes

Road Surface Type

Paved
Yes

Sewer

Public Sewer
Yes

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
Information deemed reliable but not guaranteed.