Custom-built masterpiece offering the perfect blend of modern luxury, resort-style amenities, and serene privacy. Nestled on 2.46 acres along Chapman Reservoir, this exceptional home delivers unparalleled Colorado lifestyle with breathtaking water and mountain views. Step inside to soaring ceilings, expansive windows, and a bright open floor plan designed for both relaxation and entertaining. The gourmet kitchen features professional-grade appliances, quartz countertops, and a large island; while the living room centers around a striking stone fireplace and panoramic lake and mountain views. The primary suite is a true retreat, complete with a spa-inspired bathroom that includes a steam shower and luxurious soaking tub. 2 spacious, main floor secondary bedrooms with full bathrooms, a dedicated office, 2 basement bedrooms and a finished walkout basement with wet bar provide ample room for gathering with family and guests. Outdoor living takes center stage with covered upper and lower decks, built-in grill, fire pit, and 4 raised garden beds. The crown jewel: a private, heated in-ground pool with slide, surrounded by a large patio and iron fencing for both fun and safety. From sunrise coffee overlooking the lake and mountains to sunset swims and fireside gatherings, this home is built for year-round enjoyment. Additional highlights include a 4-car garage, expansive driveway, and beautifully landscaped grounds. All within minutes of town, yet offering the peace and privacy of country living. If you've been searching for the rare combination of lakefront property, mountain views, and luxury living - this is it.
Cul-De-Sac, Native Grass, Level, Abuts Pond/Lake, Abuts Farm Land, House/Lot Faces NE, Lake Access, Lake Front, Waterfront, Paved, Fire Hydrant within 500 Feet, Water Rights Excluded, Mineral Rights Excluded
Garage spaces
4
View
Mountain(s), Hills, Water
CITY
Loveland
SUBDIVISION
Warberg Farms
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Trail(s)
HOA
1
TAX AMOUNT
8537.0
HOA FEE
500.0
HOA FREQUENCY
Quarterly
LATEST UPDATE
2026-01-23T14:18:29.144Z
PRICE CHANGE(S)
$3,000,000 Nov 11, 2025
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)3
Property Sub TypeSingle Family Residence
Square Feet6,421
MLS #1045289
Bathrooms (¾)1
Bathrooms (Half)1
FlooringWood
AppliancesGas Range, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Gas Bar-B-Q, Disposal, Fire Alarm
FIREPLACE FEATURESGas Log, Living Room
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Lot FeaturesCul-De-Sac, Native Grass, Level, Abuts Pond/Lake, Abuts Farm Land, House/Lot Faces NE, Lake Access, Lake Front, Waterfront, Paved, Fire Hydrant within 500 Feet, Water Rights Excluded, Mineral Rights Excluded
Garage spaces4
ViewMountain(s), Hills, Water
CITYLoveland
SUBDIVISIONWarberg Farms
COUNTYLarimer
AREALoveland/Berthoud
STATECO
COMMUNITY FEATURESTrail(s)
HOA1
TAX AMOUNT8537.0
HOA FEE500.0
HOA FREQUENCYQuarterly
LATEST UPDATE2026-01-23T14:18:29.144Z
PRICE CHANGE(S)
$3,000,000 Nov 11, 2025
Market Trends
New Properties On Market
71
184%
Increase In New Listings
Average Asking Price
$603,213
$265,505 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$276
$140 Decrease In List Price/Sq. Ft.
Average Days On Market
24
31 Day
Decrease In Days On Market
Data as of Feb 22, 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.