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.
Offered By
Celina Rodriguez 9702141106, The Station Real Estate
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2022
BasementFull, Partially Finished, Rough-in for Radon
FINISHED BASEMENT SIZE2385.0
RoofTile
EXTERIOR FEATURESLighting, Balcony, Hot Tub Included
Parking FeaturesGarage Door Opener, Oversized
FenceFenced, Wood
Lot FeaturesCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Near Golf Course
Garage spaces4
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Hiking/Biking Trails, Recreation Room, Gated
TAX AMOUNT15757.0
LATEST UPDATE2025-07-11T20:58:11.873Z
PRICE CHANGE(S)
$3,175,000 Jul 10, 2025
Market Trends
New Properties On Market
69
25%
Increase In New Listings
Average Asking Price
$966,776
$133,156 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$278
$50 Decrease In List Price/Sq. Ft.
Average Days On Market
11
21 Day
Decrease In Days On Market
Data as of Jul 12, 2025.
Remaining statistics above are calculated on activity within the period from May 01, 2025 to Jun 30, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.