Winner of the 2025 Northern Colorado Parade of Homes, Best Primary Suite, Best Craftsmanship, Overall Winner Best Home. Spectacular Custom home in the gated Rookery section of Heron Lakes. This is one of the best floorplans I have seen in 25 years of real estate. From the exquisite Cape Cod exterior, the welcoming front porch, and grand entrance this home makes a statement from the moment you pull up. Vaulted 20-foot beamed ceiling greet you as you enter the front door to the great room and chef's kitchen and huge patio with covered deck. High end AGA stove, Wolf and Sub Zero appliances, and butler's pantry makes this dream kitchen a reality. Primary bedroom is spacious with lake views, beautiful tub, steam shower, and finished closet with washer and dryer. Main floor study and staircase with wainscoting, and second bedroom with on suite. Attached dwelling unit over the garage has over 800 sq ft of living space, kitchen area and full bath. Spacious basement rec room, bar area, golf simulator setup, workout room, 2 more bedrooms with full baths and a storage area with stairs to the garage. 5 car garage with 1442 sq ft, is heated, and has the ability to store a boat. Beautifully landscaped with fire pit and views of the lake and front range mountains. A full deeded membership is included with this home. Golf, restaurants, workout facility, resort style pool, trails and boating on Lonetree are all part of living in Heron Lakes at TPC Colorado.
Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Two or More, Gas, Gas Log
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2025
Builder Name
Stonebrook Homes
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
3150.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Tile
EXTERIOR FEATURES
Sprinkler System, Heated Garage, Oversized Garage
Parking Features
Attached
Fence
Partial, Wood
Lot Features
Golf Course Neighborhood, Abuts Pond/Lake, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet, Water Rights Excluded, Mineral Rights Excluded
Garage spaces
5
View
Mountain(s), Hills, Plains View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Clubhouse, Pool, Fitness Center, Trail(s), Recreation Room, Gated
Lot FeaturesGolf Course Neighborhood, Abuts Pond/Lake, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet, Water Rights Excluded, Mineral Rights Excluded
Garage spaces5
ViewMountain(s), Hills, Plains View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Trail(s), Recreation Room, Gated
TAX AMOUNT19408.0
LATEST UPDATE2026-02-16T09:21:30.590Z
DAYS ON MARKET20
PRICE CHANGE(S)
$3,395,000 Jan 22, 2026
Market Trends
New Properties On Market
40
100%
Increase In New Listings
Average Asking Price
$753,988
$74,196 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$305
$16 Increase In List Price/Sq. Ft.
Average Days On Market
24
34 Day
Decrease In Days On Market
Data as of Feb 21, 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.