SoldAug 26, 2026

Listed by Crystal Coleman

Bought with Linnea VanTassel from Country Life Real Estate, LLC

Source: Multiple Listing Service of Ulster County #20262263

25 Rockledge Rd, Columbia County, NY, 12029

$1,125,000

3
4
20
3768 sq. ft.
461736 sq. ft.

SingleFam

30+ days on the market

Sold: Aug 26, 2026

What's around 25 Rockledge Rd

About this property

Open House 5/30 12:00-2:30 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 versatilty 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. 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.

Looking for more information on 25 Rockledge Rd?

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

Contact

Similar properties sold nearby

SoldAug 20, 2026
$325,000
127 Queechy Shores Beach Club
Canaan NY 12029
3
1
2
Single-Family
Listing courtesy of Houlihan Lawrence
SoldDec 30, 2025
$669,000
1907 County Route 5
Canaan NY 12029
3
2
2
Single-Family
Listing courtesy of Beach & Bartolo Realtors
SoldSep 16, 2025
$1,400,000
75 Shaker Ridge Dr
Columbia County NY 12029
3
3
4
Single-Family
Listing courtesy of Houlihan Lawrence Inc. and Brown Harris Stevens Hudson

Other properties sold by Crystal Coleman Realty, LLC

SoldJun 1, 2026
$340,000
80 Southard Road
Rensselaer County NY 12168
2
2
Single-Family
Listing courtesy of Stone House Properties, LLC and Crystal Coleman Realty, LLC
SoldApr 17, 2026
$816,200
96 Thompson Hill Road
East Greenbush NY 12144
4
6
Single-Family
Listing courtesy of Crystal Coleman Realty, LLC
SoldMar 27, 2026
$422,500
40 Balmoral Court
Kinderhook NY 12184
3
2
2
Single-Family
Listing courtesy of Keller Williams Capital Dist and Crystal Coleman Realty, 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