Experience the ultimate in modern luxury with this masterfully designed contemporary custom home in the prestigious Rookery at Heron Lakes, a premier enclave within the TPC Colorado golf community. Architectural masterpiece offers a seamless blend of bold design and everyday functionality across three expansive levels. Main floor serves as the home's heart, featuring a grand living area that flows into a gourmet kitchen equipped with walk-in pantry and dedicated dining space. Primary suite is a true main-level sanctuary, offering a private retreat complete with a spa-like bath and an oversized walk-in closet. For the professional, a quiet home office is perfectly situated, while the 4-car garage provides substantial space for vehicles and gear. Upstairs, the luxury continues with a junior master suite, additional ensuite bedroom, and the ultimate convenience of a secondary laundry room. The crowning jewel of the second level is the expansive rooftop patio, perfect for soaking the unbelievable in panoramic views. The entertainment potential extends to the finished basement, where you will find a massive recreation room equipped with wet bar, plus fourth bedroom with full bath, and additional powder room for guests. Optional gym-wellness retreat available for basement. Designed for the quintessential Colorado lifestyle, this residence includes multiple outdoor retreats, from the inviting front patio to the grill-ready rear patio. Your ultimate Colorado lifestyle awaits. This home comes with a deeded membership to Heron Lakes at TPC Colorado, putting elite amenities in your backyard. Whether you're hitting the links, launching a boat on Lonetree Reservoir, or exploring the winding trail system, the adventure never ends. After a workout in the premier fitness facility, unwind at the resort-style pool or grab dinner at one of the club's signature restaurants. Combining innovative design with world-class amenities this home represents the pinnacle of contemporary living.
Natural Gas Available, Electricity Available, Cable Available
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2027
Basement
Partially Finished
FINISHED BASEMENT SIZE
2391.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
Roof
Composition
Parking Features
Attached
Lot Features
Cul-De-Sac, Corner Lot, Paved
Garage spaces
4
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
TAX AMOUNT
12263.0
LATEST UPDATE
2026-06-03T08:42:36.004Z
DAYS ON MARKET
1
PRICE CHANGE(S)
$2,645,000 Jun 3, 2026
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)2
Property Sub TypeSingle Family Residence
Square Feet6,308
MLS #2294786
Bathrooms (¾)2
Bathrooms (Half)2
AppliancesDishwasher, Microwave, Disposal, Fire Alarm
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERPublic Sewer
WATER SOURCECity
Year Built2027
BasementPartially Finished
FINISHED BASEMENT SIZE2391.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
RoofComposition
Parking FeaturesAttached
Lot FeaturesCul-De-Sac, Corner Lot, Paved
Garage spaces4
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
TAX AMOUNT12263.0
LATEST UPDATE2026-06-03T08:42:36.004Z
DAYS ON MARKET1
PRICE CHANGE(S)
$2,645,000 Jun 3, 2026
Market Trends
New Properties On Market
71
15%
Increase In New Listings
Average Asking Price
$1,202,365
$330,664 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$339
$69 Increase In List Price/Sq. Ft.
Average Days On Market
8
24 Day
Decrease In Days On Market
Data as of Jun 03, 2026.
Remaining statistics above are calculated on activity within the period from Apr 01, 2026 to May 31, 2026.
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.