SoldJun 12, 2026

Listed by Heather Cohen from Compass, Hillsdale

Listed and Bought with John Barbato from Compass, Hillsdale

Source: Multiple Listing Service of Ulster County #20254088

2657 State Route 23, Columbia County, NY, 12529

$580,000

3
2
2057 sq. ft.
12196.8 sq. ft.

SingleFam

•

30+ days on the market

Sold: Jun 12, 2026

What's around 2657 State Route 23

About this property

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.

Looking for more information on 2657 State Route 23?

Explore comparables, sales history and growth for this property.
Learn more

Contact

Similar properties sold nearby

SoldJun 5, 2026
$580,000
66 Anthony Street
Hillsdale NY 12529
3
3
1
Single-Family
Listing courtesy of Stone House Properties, LLC and Compass Greater NY, LLC d/b/a
SoldMar 27, 2026
$825,000
110 Meadow Lane
Hillsdale NY 12529
3
2
2
Single-Family
Listing courtesy of Columbia County RE Specialist and Rouse + Co Real Estate
SoldDec 22, 2025
$650,000
63 Cherokee Drive
Copake Lake NY 12529
3
3
1
Single-Family
Listing courtesy of Copake Lake Realty Corp. and Beach & Bartolo Realtors

Other properties sold by Compass, Hillsdale

SoldJun 16, 2026
$450,000
11351 State Route 22
Columbia County NY 12017
2
3
1
Single-Family
Listing courtesy of Compass, Hillsdale and Wolf River Real Estate
SoldJun 8, 2026
$3,245,000
411 Texas Hill Road
Hillsdale NY 12529
4
4
2
Single-Family
Listing courtesy of Compass and Compass, Hillsdale
SoldMay 29, 2026
$1,275,000
9195 Miller Road
Canaan NY 12029
7
6
Single-Family
Listing courtesy of Compass, Hillsdale and Compass Greater NY, LLC

Browse properties sold in nearby areas

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.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under MLS GRID IDX Rules Updated September 16, 2024 7 U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: dmca@ratemyagent.com

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 RateMyAgent