Back 25 Rockledge Rd
Active

25 Rockledge Rd

Columbia County NY 12029

3
4
15
3768 sq. ft.
461736 sq. ft.
Single-Family
Currently for sale - view listing

Overview

Welcome to this one-of-a-kind mountain oasis with breathtaking views of the Taconic Range. Set on 10 private acres, this extraordinary upstate retreat features a stunning 3,768 SF custom lodge-style home, a 3-car garage with a private guest suite, an in-ground pool with pool house, and an additional 2-car garage. The main residence blends rustic elegance with modern comfort, offering 3 bedrooms, including both a first-floor primary suite and a second-floor primary suite, 3.5 baths, a gourmet kitchen, multiple wood-burning fireplaces, and a spacious family/media room designed for both relaxing and entertaining. Step outside to your own resort-style setting complete with sweeping mountain views, a fire pit, koi pond, and in-ground pool -- the perfect backdrop for relaxing or hosting guests year-round. What truly sets this property apart is its incredible versatility and income potential. In addition to the main home, the property includes a fully equipped 2-bedroom guest/pool house and a private 1-bedroom guest suite above the 3-car garage, each featuring its own living space, fireplace and kitchen. Whether you're searching for a multi-generational compound, luxury retreat, or investment opportunity, the possibilities are endless. Perfectly suited for short-term rental opportunities such as Airbnb or VRBO, this unique property offers the ability to offset expenses while enjoying luxury living in one of the region's most scenic settings. To think this property couldn't get any better, it does with Deeded Lake rights to Queechy Lake (8min drive away). Conveniently located just 14 minutes to the Taconic Parkway, 20 minutes to Jiminy Peak Mountain Resort, 24 minutes to Tanglewood, and 18 minutes to Chatham, this exceptional property offers the perfect balance of privacy, convenience, lifestyle, and investment potential. A rare opportunity to own an extraordinary mountain retreat in one of the area's most scenic and sought-after locations.

Features

3 bedrooms
4 bathrooms
15 carspaces
5 garage spaces
3768 sq. ft. floor area
461736 sq. ft. lot size
Single-Family

Property history for 25 Rockledge Rd

2017
Sold
$890,000
28 Dec 2017 by Nancy Cuddihy, of Stone House Properties, LLC

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.

Local market activity for 3 bedroom single-family properties in Columbia County

In the last 12 months, 6 three-bedroom single-family properties similar to 25 Rockledge Rd, have been sold.

This represents a 50% increase in three-bedroom single-family properties sales when compared to the previous 12 months.

© 2026 RateMyAgent