Welcome to this exceptional Modern Farmhouse, a 4-bedroom, 5-bath residence spanning 5,124 square feet of thoughtfully designed living space, perfectly positioned backing to the 11th tee box. Now offered below construction cost, this is a rare opportunity to acquire a premier golf-course home with immediate equity.The main level showcases a striking chef's kitchen with soaring 10-foot ceilings, stainless steel appliances, a farmhouse sink, and refined finishes-designed to anchor both everyday living and elevated entertaining. The adjoining living room is warm yet sophisticated, featuring a gas fireplace, coffered ceilings, and curated Arhaus lighting.The owner's suite is a private retreat, highlighted by coffered ceilings, heated bathroom floors, and French doors that open to a secluded patio-an ideal space to unwind with views and privacy.The lower level is purpose-built for entertaining, offering a second gas fireplace, wine and wet bar, two generous bedrooms, and a flexible bonus space ideal for a media room, gym, or guest retreat.Outdoor living is equally impressive. The covered, heated back patio includes dual heaters and a built-in BBQ, overlooking a professionally landscaped, expansive yard designed for year-round enjoyment. An oversized, heated three-car garage completes the home with both function and style.
Lot FeaturesLevel, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet, Mineral Rights Excluded
Garage spaces3
ViewMountain(s), Hills, Water
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESClubhouse, Pool, Fitness Center
TAX AMOUNT11682.0
LATEST UPDATE2026-02-09T09:23:29.404Z
DAYS ON MARKET2
PRICE CHANGE(S)
$1,750,000 Feb 4, 2026
Market Trends
New Properties On Market
42
133%
Increase In New Listings
Average Asking Price
$736,412
$104,959 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$303
$6 Increase In List Price/Sq. Ft.
Average Days On Market
29
33 Day
Decrease In Days On Market
Data as of Feb 25, 2026.
Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 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.