The best value per square foot in Heron Lakes - $451,000 below the 2026 certified appraisal. 6,837 sq ft of custom construction, a deeded TPC Colorado membership, and the privacy of an interior lot that keeps the course as your backdrop without the cart traffic at your door. This custom-designed 6-bedroom, 5-bath estate in the gated Rookery at Heron Lakes embodies refined Colorado living, framed by sweeping mountain, water, and open-space views. Encompassing a ~.32 acre lot, 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 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 - 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-06-02T10:31:11.404Z
DAYS ON MARKET105
PRICE CHANGE(S)
$2,075,000 Feb 18, 2026
$2,000,000 Mar 12, 2026
$1,995,000 May 13, 2026
$1,849,000 May 20, 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.