Opportunity awaits with a 2026 appraisal in hand at $2.3M! This custom-designed 6-bedroom, 5-bath estate in the gated Rookery at Heron Lakes at TPC Colorado embodies refined Colorado living, framed by sweeping mountain, water, and open-space views. Encompassing 6,837 square feet on ~.32 acres, the residence makes a striking first impression with manicured grounds, a timeless water feature, and architectural detail that carries throughout the home. Designed for effortless entertaining and elevated daily living, the open layout centers on a dramatic great room with soaring ceilings and a floor-to-ceiling stone fireplace. The chef's kitchen is both sophisticated and functional, featuring quartz surfaces, custom knotty alder cabinetry, premium built-in appliances, and a substantial island. A sunlit morning room and formal dining area with butler's bar and wine refrigeration extend seamlessly to dual covered terraces, creating exceptional indoor-outdoor flow. The main level offers a private guest suite, well-appointed laundry, and access to a heated oversized three-car garage. Upstairs, the primary suite serves as a serene retreat with coffee bar, see-through fireplace, spa-inspired bath with steam shower and soaking tub, custom walk-in closet, and covered balcony for enjoying Colorado sunsets. The walkout lower level enhances the lifestyle with an expansive recreation room, wet bar, additional bedrooms, covered patio, and gas fire feature. A recreation-ready garage with epoxy floors, dog wash, and dedicated dog run completes the offering. Residents enjoy resort-caliber amenities including a pool, clubhouse, fitness center, miles of trails and shoreline, over 130 acres of preserved open space, and deeded TPC Colorado golf privileges - an exceptional opportunity within one of Northern Colorado's most distinguished gated communities.
Lot FeaturesLevel, Golf Course Neighborhood, House Faces West, City Limits, Paved, Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet
Garage spaces3
ViewMountain(s)
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s)
TAX AMOUNT15968.0
LATEST UPDATE2026-02-21T01:21:23.430Z
DAYS ON MARKET3
PRICE CHANGE(S)
$2,075,000 Feb 18, 2026
Market Trends
New Properties On Market
42
133%
Increase In New Listings
Average Asking Price
$736,412
$104,959 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$303
$6 Increase In List Price/Sq. Ft.
Average Days On Market
29
33 Day
Decrease In Days On Market
Data as of Feb 24, 2026.
Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 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.