Experience resort-style living every day in this show-stopping custom residence on a nearly 17,000 sq ft lot with panoramic views of the mountains. Bordering open space to the north and backing to the community trail, this property delivers privacy and convenience plus seasonal water views. Outside delivers the ultimate Colorado lifestyle w/ professionally designed landscaping, two tranquil fountains, a custom-built fire pit, and multiple seating areas to take in Colorado's stunning sunsets. Entertain with ease on two expansive upper decks-one featuring an 8-foot gas fireplace for uninterrupted mountain gazing, the other equipped with a built-in grilling station. A fully enclosed dog run w/ its own turf lawn & bonus -Hot tub included! Inside, luxury lives in the details. The chef's kitchen wows, dramatic granite backsplashes, an oversized island, a designer hood & lighted glass cabinetry. The great room features soaring beamed ceilings, a floor-to-ceiling fireplace w/ wood & tile accents and a dramatic custom antler chandelier in the entry. Retreat to the main floor primary suite w/ private deck access and a spa-like bathroom featuring a soaking tub, custom wood vanity w/ trough sink and handsome leaded glass windows. Even the powder room is a work of art, w/ a floating vanity, backlit shelving, and a sculptural vessel sink. Downstairs, the walk-out basement continues to showcase designer talent w/ stained concrete epoxy floors, two more ensuite bedrooms, a home theater, a massive granite bar w/ seating for six, a glass-enclosed wine room, and even a hidden safe. And yes-there are still mountain views from every window. Set in Northern Colorado's premier TPC Heron Lakes community-home to an award-winning golf course, miles of trails, lake recreation, and a world-class clubhouse and fitness center-you'll enjoy convenient access to DIA, Boulder, and Denver. Every corner has been curated, every finish considered. This is more than a home-it's a lifestyle.
EXTERIOR FEATURESGas Grill, Balcony, Hot Tub Included
Parking FeaturesGarage Door Opener
FenceFenced, Wood, Wire
Lot FeaturesLawn Sprinkler System
Garage spaces3
Other StructuresKennel/Dog Run
ViewMountain(s), Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails, Gated
TAX AMOUNT13929.0
LATEST UPDATE2025-06-18T19:12:24.043Z
DAYS ON MARKET8
PRICE CHANGE(S)
$2,700,000 Jun 11, 2025
CUMULATIVE DAYS ON MARKET8
Market Trends
New Properties On Market
56
2%
Increase In New Listings
Average Asking Price
$1,106,403
$42,175 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$338
$11 Increase In List Price/Sq. Ft.
Average Days On Market
22
18 Day
Decrease In Days On Market
Data as of Jun 23, 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.