2657 State Route 23

Columbia County NY 12529

2057 sq. ft.

12196.8 sq. ft.

Single-Family

Last sold for $580,000

John Barbato, last sold this property on 12 June 2026 after 83 days on market.

Overview

Proudly offering one of Hillsdale's most iconic and enduring homes—an exquisite piece of the Hudson Valley's heritage, perfectly positioned at the crossroads between Hudson, NY and Great Barrington, MA. Set in the vibrant and historic hamlet center, this timeless 3-bedroom, 2-bathroom residence is simply beautiful colonial charm. Thoughtfully renovated from top to bottom, the home retains its original 1790's soul with restored wide-plank wood floors, antique glass windows, and two original fireplaces anchoring the front and rear parlors. The front parlor is formal and elegant, while the rear parlor offers flexible living space that is ideal as a first floor fourth bedroom, office, or cozy and quiet media room. The large eat-in kitchen is a standout, featuring Bosch appliances and an inviting breakfast bar. A traditional pantry nods to the home's roots, while Carrara marble bathrooms and central air conditioning provide the ease of modern living. The formal dining room is perfect for entertaining, and the cathedral-ceiled primary bedroom creates a peaceful retreat upstairs. Step outside to discover a surprisingly spacious and private backyard—an oasis in the center of town. Zoned for both residential and commercial use, the property offers rare flexibility: perfect as a full-time residence, a charming boutique, café, or even a destination restaurant in a town brimming with character and foot traffic. Live where everything is at your doorstep—walk to the local grocery, post office, hardware store, wine shop, retail shops, hair salon, diner, brewery, and even a historic tavern. Outdoor enthusiasts will appreciate quick access to the Harlem Valley Rail Trail for biking, walking, and running.

Features

3 bedrooms

2 bathrooms

2057 sq. ft. floor area

12196.8 sq. ft. lot size

Single-Family

Estimated Value

Based on this property and similar 3 bedroom single-family properties sold in Columbia County over the last 12 months, the estimated median property value of 2657 State Route 23 is $786k.

Median value

$786k

Estimated value range

$335k - $1.29m

Median days on market

Estimated value trend

43%

increase over the last 12 months

Average days on market is based on recent, comparable sales in Columbia County. It is only an indication of the time a property is actively listed and should not be relied upon as an accurate representation of how soon a property will be sold.

Property history for 2657 State Route 23

2026

Sold

$580,000

12 Jun 2026 by John Barbato, of Compass, Hillsdale

2018

Sold

$201,000

09 Nov 2018 by Lindsay LeBrecht, of Copake Lake Realty Corp.

Happy sellers in Columbia County

We have insufficient information to provide an overview of customer satisfaction for Columbia County. Viewing the agent profiles, reviews and sales for Columbia County can provide insights for this location.