Active

2666 Ny-23

Hillsdale, NY 12529
Mark as Favorite
Bed 3

Bed

Bath 4

Bath

SqFt5,000

Sqft

Acres0.50

Acre(Lot)

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.

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $1,100,000

AD Id : 77678446

MLS Id : 20262810

Beds : 3

Lot Size : 0.50 Acre

Living Area Size : 5,000

Year Built : 1880

County : Columbia

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 3

    Bathroom Information

    Total Baths: 4 Full Baths: 4

    Room Information

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

    Concrete, Ceramic Tile, Varies, Wood
  • Interior Features

    High Speed Internet Appliances: Microwave, Range, Refrigerator, Washer/Dryer Laundry Features: In Basement
  • Heating & Cooling

    Has Heating: Yes Heating: Varies by Unit

  • Building Information

    Year Built: 1880 Building Area Total: 5000 Construction Materials: Frame Stories: 2 Patio And Porch Features: Deck, Patio, Porch Private Pool: No

  • 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: 4 Units / 2 buildings / Mixed Use

  • Parking Information

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

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
292 White Hill Rd, Hillsdale, NY, 12529 $2,195,000 3 3 2,755 2,755 SqFt
523 Breezy Hill Rd, Hillsdale, NY, 12529 $1,195,000 3 3 1,931 1,931 SqFt
523 Breezy Hill Road, Hillsdale, NY, 12529 $1,195,000 3 3 1,931 1,931 SqFt
523 Breezy Hill Road, Hillsdale, NY, 12529 $1,195,000 3 3 1,931 1,931 SqFt
309 Pine Ridge Lane, Hillsdale, NY, 12529 $1,100,000 3 3 2,495 2,495 SqFt
25 Nobletown Rd, Hillsdale, NY, 12529 $999,000 4 3 1,344 1,344 SqFt
25 Nobletown Road, Hillsdale, NY, 12529 $999,000 4 3 1,344 1,344 SqFt
25 Nobletown Road, Hillsdale, NY, 12529 $999,000 4 3 1,344 1,344 SqFt
2955 State Route 23, Hillsdale, NY, 12529 $999,900 2 2 1,600 1,600 SqFt
401 Collins Street, Hillsdale, NY, 12529 $1,175,000 1 2 1,700 1,700 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 06/16/2026 @ 17:53

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

Selling? Save $65,501 when you sell a home like this

Tour with a ByOwner Agent