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.
Offered By
David Johnson 3038933200, LIV Sotheby's Intl Realty D
FIREPLACE FEATURES2+ Fireplaces, Gas, Gas Logs Included
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2025
Builder NameStonebrook Homes
BasementFull, Partially Finished
FINISHED BASEMENT SIZE3150.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofTile
EXTERIOR FEATURESLighting
Parking FeaturesHeated Garage, Oversized
FencePartial, Wood
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Water Rights Excluded, Mineral Rights Excluded, Near Golf Course
Garage spaces5
ViewMountain(s), Foothills View, Plains View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Pool, Fitness Center, Hiking/Biking Trails, Recreation Room, Gated
TAX AMOUNT19408.0
LATEST UPDATE2025-07-09T20:07:52.034Z
DAYS ON MARKET1
PRICE CHANGE(S)
$3,425,000 Jul 9, 2025
CUMULATIVE DAYS ON MARKET1
Market Trends
New Properties On Market
70
27%
Increase In New Listings
Average Asking Price
$960,822
$139,385 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$278
$51 Decrease In List Price/Sq. Ft.
Average Days On Market
11
20 Day
Decrease In Days On Market
Data as of Jul 10, 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.