Designed by HGTV Fix my Flips stars Page Turner and Mitch Glew, as featured on season 4 of Rock the Block, this Alpine Chic design is nestled on a peaceful cul-de-sac. Escape to your private, unobstructed, 180 degree views of the Rookery, McNeil and Lone tree lakes w/ mountain views. Step into an entertainer's delight w/ stunning, luxury interior design in the gorgeous kitchen including double Calacatta marble, waterfall islands, built-in wine rack entrance to dining room with stone wall accent, and luxury primary bathroom complete with fireplace and oversized shower. Cleverly designed fitness studio off the connected back deck w/a glass garage door to open on perfect Colorado days. Continue the entertainment in the open-concept walk-out basement with a full kitchen, golf simulator, built in the bunk area, built-in outdoor grill & Traeger smoker. Step outdoors and sit by the fire pit in custom-made ski Adirondack chairs, or set up your outdoor chess set on the built-in cement board in the backyard. Experience a resort lifestyle in a one-of-a -kind, HGTV star designed home. Includes $40k TPC championship golf membership, access to luxury pool w/ swim up bar, oversized hot tub & concession cabana, fitness studio, golf lockers, & golf simulator. Lake club available with registration and fee. Sold fully furnished.
Cul-De-Sac, Golf Course Neighborhood, Abuts Pond/Lake, Abuts Public Open Space, Paved, Curbs, Gutters, Sidewalks, Street Light, Mineral Rights Excluded
Garage spaces
3
View
Mountain(s), Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Clubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s)
LATEST UPDATE
2026-01-23T12:44:55.306Z
PRICE CHANGE(S)
$3,250,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms4
Bathrooms (Full)4
Property Sub TypeSingle Family Residence
Square Feet5,669
MLS #987354
Bathrooms (¾)1
Bathrooms (Half)2
FlooringWood
AppliancesGas Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Some Furniture, Disposal, Fire Alarm
FIREPLACE FEATURESTwo or More, Gas, Living Room
HeatingForced Air, 2 or more Heat Sources, Humidity Control, 2 or more H20 Heaters
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Lot FeaturesCul-De-Sac, Golf Course Neighborhood, Abuts Pond/Lake, Abuts Public Open Space, Paved, Curbs, Gutters, Sidewalks, Street Light, Mineral Rights Excluded
Garage spaces3
ViewMountain(s), Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Trail(s)
LATEST UPDATE2026-01-23T12:44:55.306Z
PRICE CHANGE(S)
$3,250,000 Oct 21, 2025
Market Trends
New Properties On Market
72
31%
Increase In New Listings
Average Asking Price
$1,011,028
$186,640 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$329
$30 Increase In List Price/Sq. Ft.
Average Days On Market
11
21 Day
Decrease In Days On Market
Data as of Apr 07, 2026.
Remaining statistics above are calculated on activity within the period from Feb 01, 2026 to Mar 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.