- 5 beds
- 6 baths
- 6,791 sqft
- 12,725 sqft lot
- $467 per sqft
- 2022 build
- – on site
Welcome to an extraordinary estate nestled in The Rookery-the most coveted enclave within the TPC at Heron Lakes Subdivision. This remarkable home offers not only elegance and privacy but also a grandfathered-in TPC Golf Membership. This incredible luxury estate is spanning over 7,000 square feet of meticulously crafted living space, this architectural masterpiece showcases panoramic, unobstructed views of the Rocky Mountains and sits just steps from the famous Heron Lakes. As you step through the grand entrance, you're greeted by soaring vaulted ceilings, a striking fireplace centerpiece, and an ambiance of timeless sophistication. Designed with both beauty and function in mind, the home features five spacious en-suite bedrooms, including a luxurious main-floor primary suite. The gourmet kitchen is a chef's dream-equipped with JennAir appliances, a built-in Miele espresso machine, granite counter tops, large chefs island and so much more. Whole home is bathed in natural light. Every inch of this home exudes luxury, with high-end finishes and thoughtful details throughout. Hydraulic elevator provides seamless access to all levels, where you'll find a resort-style spa complete with a custom wet and dry sauna, relaxing water feature, and a fully equipped private gym-offering a true wellness retreat without ever leaving home. Residents of Heron Lakes enjoy access to unmatched neighborhood amenities, including a clubhouse, fine dining restaurants, resort-style pool, private fitness center, and miles of scenic walking and biking trails.This is more than a home-it's a lifestyle of elevated living and a true golfers dream.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jul 16, 2025
•
MLS# 1038828 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2022
-
New Construction:false
-
Construction Materials:Wood/Frame
-
Total SqFt:7,070 Sqft
-
Building Area Total:4685
-
Roof:Tile
-
Levels:Two
-
Basement:Full
-
Stories:2
-
Window Features:Window Coverings
-
Patio And Porch Features:Patio
-
Accessibility Features:Main Floor Bath
-
Green Energy Efficient:HVAC
-
Above Grade Finished Area:4685
-
Below Grade Finished Area:2385
Interior
-
Interior Features:Study Area
-
Fireplace:true
-
Fireplace Features:Gas
-
Living Room Level:Main
-
Living Room Features:Tile Floor
-
Kitchen Level:Main
-
Kitchen Features:Tile Floor
-
Dining Room Level:Main
-
Dining Room Features:Tile Floor
-
Family Room Level:Upper
-
Family Room Features:Carpet
-
Laundry Features:Sink
Room Dimensions
-
Living Area:6791
-
Study Length:27
-
Living Area Units:Square Feet
-
Living Area Source:Other
-
Main Floor SqFt:2424
-
Living Room Area:266
-
Living Room Length:19
-
Living Room Width:14
-
Kitchen Length:17
-
Kitchen Area:204
-
Kitchen Width:12
-
Dining Room Area:240
-
Dining Room Length:20
-
Dining Room Width:12
-
Family Room Area:378
-
Family Room Length:27
-
Family Room Width:14
-
Rec Room Length:21
-
Master Bedroom Area:299
-
Master Bedroom Width:13
-
Master Bedroom Length:23
-
Bedroom 2 Area:132
-
Bedroom 2 Length:12
-
Bedroom 3 Length:16
-
Bedroom 2 Width:11
-
Bedroom 4 Length:12
-
Bedroom 3 Area:192
-
Bedroom 3 Width:12
-
Bedroom 5 Length:13
-
Bedroom 4 Area:144
-
Bedroom 4 Width:12
-
Bedroom 5 Area:156
-
Bedroom 5 Width:12
-
Laundry Room Length:11
-
Laundry Room Width:8
Financial & Terms
-
Listing Terms:Cash
Location
-
Coordinates:-105.11763, 40.3379
-
Latitude:40.3379
-
Longitude:-105.11763
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Parcel Number:R1661779
-
Lot Features:Curbs
-
Lot Size Acres:0.29
-
Lot Size SqFt:12,725 Sqft
-
Lot Size Area:12725
-
Lot Size Units:Square Feet
-
Zoning:Res
-
View:Mountain(s)
-
Possible Use:Single Family
-
Exclusions:Seller's Personal Property
-
Horse:false
-
Fencing:Fenced
-
Exterior Features:Lighting
-
Waterfront:false
-
Road Frontage Type:City Street
-
Road Surface Type:Paved
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$15,757
Beds
-
Bedrooms Total:5
-
Bedroom 2 Level:Upper
-
Bedroom 2 Features:Carpet
-
Bedroom 3 Level:Main
-
Bedroom 3 Features:Carpet
-
Bedroom 4 Level:Main
-
Bedroom 4 Features:Carpet
-
Bedroom 5 Level:Basement
-
Bedroom 5 Features:Carpet
-
Master Bedroom Level:Upper
-
Master Bedroom Features:Carpet
Baths
-
Total Baths:6
-
Three Quarter Baths:3
-
Full Baths:1
-
Half Baths:2
-
Master Bath Features:3/4 Primary Bath, Luxury Features Primary Bath
The Listing
-
Special Listing Conditions:Private Owner
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Utilities:Natural Gas Available
-
Gas:Natural Gas, Xcel
-
Electric:Electric, PVREA
-
Sewer:City Sewer
-
Water Source:City Water, Town of Berthoud
Appliances
-
Appliances:Gas Range/Oven
Schools
-
Elementary School:Carrie Martin
-
Middle School:Bill Reed
-
High School:Thompson Valley
-
High School District:Thompson R2-J
The Community
-
Community Features:Clubhouse
-
Association:false
-
Subdivision Name:Heron Lakes 3rd Filing
-
Association Fee Includes:Common Amenities
-
Spa:false
-
Senior Community:false
Parking
-
Parking Features:Garage Door Opener
-
Garage Spaces:4
-
Garage:true
-
Garage SqFt:1,060 Sqft
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:4
Monthly cost estimate

Asking price
$3,175,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$17,001
|
Taxes | $1,313 |
Insurance | $1,481 |
Utilities | $196 See report |
Total | $19,991/mo.* |
*This is an estimate |
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
7/15/25
Jul 15, 2025
|
Listed / Active | IRES | $3,175,000 |