Welcome to an extraordinary contemporary home in The Rookery, a highly sought-after, double-gated enclave within the Heron Lakes community. Property includes a deeded membership to TPC Colorado - an exclusive advantage with full access to golf and amenities. Designed for luxurious multi-generational living - or simply those who want ample space with breathtaking water and mountain views - this stunning residence offers the perfect blend of style and exclusivity. Grand main level showcases a striking fireplace with floor-to-ceiling tile, custom-beamed ceilings from 18 to 24 feet, and rich oak flooring. The open-concept layout includes dual primary suites - one featuring a spa-like 5-piece bath, and the other offering a custom two-person Swedish sauna and steam shower. The modern eat-in kitchen is a chef's dream, equipped with top-of-the-line appliances, custom soft-close cabinetry, large leathered granite island, spacious dining area, and a walk-in butler's pantry. Main-level primary suite also includes an expanded walk-in closet and direct access to covered deck overlooking the fenced-in backyard with views of open space. Upstairs, an expansive loft offers a full bath, closet, and private AC unit-ideal as an additional bedroom or flex space. Finished lower level features full second chef's kitchen, tiled gas fireplace, and three additional bedrooms-two of which include en-suite baths. Lower-level primary offers a 5-piece bath and walk-in closet that flows directly into laundry area. This level also includes a garden-level covered patio, dual-zoned HVAC, and professionally installed soundproofing between floors for enhanced privacy. Exterior features a full landscaping package and sprinkler system. Oversized four-car garage is finished with epoxy floors, a utility sink, and separate entries to both levels. This home delivers a rare opportunity for unmatched views, amenity access, versatility and luxury in one of Northern Colorado's most prestigious communities.
Offered By
Brady Marinangeli 9702263990, RE/MAX Alliance-FTC South
Parking FeaturesGarage Door Opener, Heated Garage, Oversized
FenceFenced, Wood, Wire
Lot FeaturesCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Near Golf Course, Within City Limits, Lake Access
Garage spaces4
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Hiking/Biking Trails, Business Center, Recreation Room, Gated
TAX AMOUNT3434.0
LATEST UPDATE2025-06-05T06:09:24.886Z
DAYS ON MARKET1
PRICE CHANGE(S)
$2,495,000 May 29, 2025
CUMULATIVE DAYS ON MARKET1
Market Trends
New Properties On Market
53
10%
Decrease In New Listings
Average Asking Price
$1,120,709
$78,522 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$339
$15 Increase In List Price/Sq. Ft.
Average Days On Market
9
24 Day
Decrease In Days On Market
Data as of Jun 09, 2025.
Remaining statistics above are calculated on activity within the period from Apr 01, 2025 to May 31, 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.