Active

2666 New York 23

Hillsdale, NY 12529

$1,100,000 $4,637/Mo

Get Pre-Approved Check your credit

Overview

Bed

Bath

2,880

Sqft

0.50

Acre(Lot)

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

Property Details

Property Type : Residential Income

Price : $1,100,000

AD Id : 78787827

MLS Id : 20262449

Beds : 3

Lot Size : 0.50 Acre

Living Area Size : 2,880

Year Built : 1880

County : Columbia

Map

What's Nearby

Nearby Areas

Features

Bedroom Information

Total beds: 3

Bathroom Information

Total Baths: 4

Room Information

Has Basement: Yes Basement: Apartment, Full, Walk-Out Access, Walk-Up Access
Flooring Information

Concrete, Combination, Ceramic Tile, Hardwood, Varies, Wood
Roofing Information

Shingle
Interior Features

Cathedral Ceiling(s), Ceiling Fan(s), Eat-in Kitchen, High Speed Internet, Kitchen Island, Pantry, Walk-In Closet(s) Roof: Shingle Appliances: Dishwasher, Microwave, Range, Refrigerator, Washer/Dryer Laundry Features: In Basement
Heating & Cooling

Has Heating: Yes Heating: Baseboard, Electric, Varies by Unit Has Cooling: Yes Cooling: Ceiling Fan(s)

Building Information

Year Built: 1880 Building Area Total: 2880 Construction Materials: Frame Stories: 2 Patio And Porch Features: Deck, Patio, Porch Private Pool: No View: Mountain(s), Neighborhood
Exterior Features

Exterior Features: Balcony, Courtyard, Private Entrance, Private Yard, Rain Gutters

Lot Information

Main Square Feet: 0.5 Acres Lot Size Acres: 0.5 Lot Size Square Feet: 21780 Lot Description: On Golf Course, Few Trees, Front Yard, Near Golf Course, Paved, Rectangular Lot, Views

Listing Price Information

Listing Price: $1100000 Contract

Tax Information

Parcel Number: 145.4-1-32 Tax Lot: 145 Tax Block: 4-1 Tax Year: 2026 Annual Tax: $7314 Tax Legal Desc: Commercial / Residential / Income Property

Parking Information

Driveway, Private

Utility Information

Electricity Available, Sewer Available, Water Connected
Location Information

WaterSource: Private, Well Security Features: Carbon Monoxide Detector(s), Smoke Detector(s)

Sell a home like this and save $65,501 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Loading, please wait...

Nearby Home Value

Address	Estimate	Bed	Bath	Sq. Ft	Lot Size
9249 Route 22, Hillsdale, NY, 12529	$257,000	3	--	2,304	2,304 SqFt

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the Ulster County Board of REALTORS®. 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. Information deemed reliable but not guaranteed. Copyright ©2026 Ulster County Board of REALTORS®, Inc.

ByOwner last updated this listing 07/25/2026 @ 23:07

MLS: 20262449 LISTED BY: Margaret Bower Avenia, Columbia County RE Specialist SOURCE: Hudson Valley Catskills Region Multiple List Service (Ulster County Board of REALTORS)

2666 New York 23

Property Details

Map

What's Nearby

Nearby Areas

Features

Interior Features

Exterior Features

Property / Lot Details

Listing Information

Taxes / Assessments

Virtual Tour, Parking, Multi-Unit Information & Homeowners Association

School, Utilities & Location Details

How much is this property worth?

Nearby Home Value

More Cities with for Sale by Owner Homes

Homes around $1,100,000

Tour with a ByOwner Agent

Verify Your Email