Striking stone fireplaceSpa-inspired bathroomFire pitExpansive drivewayLarge islandProfessional-grade appliancesQuartz countertops
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.
139 days
|
925
|
38
|
Zillow last checked:
Listing updated:
Listed by:
Matt Shoup970-217-6060,
C3 Real Estate Solutions, LLC,
Gunnar Greenlee303-854-7043,
C3 Real Estate Solutions, LLC
Source: IRES as distributed by MLS GRID,MLS#: 1053524
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 5
Full bathrooms: 3
3/4 bathrooms: 1
1/2 bathrooms: 1
Main level bathrooms: 4
Primary bedroom
Description: Carpet
Features: Luxury Features Primary Bath, 5 Piece Primary Bath, Bidet
Level: Main
Area: 285 Square Feet
Dimensions: 15 x 19
Bedroom 2
Description: Carpet
Level: Main
Area: 156 Square Feet
Dimensions: 12 x 13
Bedroom 3
Description: Carpet
Level: Main
Area: 169 Square Feet
Dimensions: 13 x 13
Bedroom 4
Description: Carpet
Level: Basement
Area: 182 Square Feet
Dimensions: 13 x 14
Bedroom 5
Description: Carpet
Level: Basement
Area: 154 Square Feet
Dimensions: 11 x 14
Dining room
Description: Engineered Hardwood
Level: Main
Area: 216 Square Feet
Dimensions: 12 x 18
Family room
Description: Carpet
Level: Basement
Area: 484 Square Feet
Dimensions: 22 x 22
Great room
Description: Engineered Hardwood
Level: Main
Area: 460 Square Feet
Dimensions: 20 x 23
Kitchen
Description: Engineered Hardwood
Level: Main
Area: 306 Square Feet
Dimensions: 17 x 18
Laundry
Description: Laminate
Level: Main
Area: 240 Square Feet
Dimensions: 15 x 16
Study
Description: Carpet
Level: Main
Area: 156 Square Feet
Dimensions: 12 x 13
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Appliances
Included: Gas Range, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Gas Bar-B-Q, Disposal
Laundry: Washer/Dryer Hookup
Features
Eat-in Kitchen, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, Steam Shower, High Ceilings, Beamed Ceilings
Parking features: Garage Door Opener, Attached, Oversized
Attached garage spaces: 4
Details: Attached
Accessibility
Accessibility features: Level Drive, Low Carpet, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
Levels: One
Stories: 1
Patio & porch: Patio, Deck
Exterior features: Sprinkler System
Has private pool: Yes
Pool features: Private
Fencing: Partial,Fenced,Metal
Has view: Yes
View description: Mountain(s), Hills, Water
Has water view: Yes
Water view: Water
Waterfront features: Abuts Pond/Lake, Lake Privileges, Lake Front, Waterfront
Lot
Size: 2.46 Acres
Features: Cul-De-Sac, Native Plants, Level, Abuts Farm Land, Waterfront, Paved, Fire Hydrant within 500 Feet, Water Rights Excluded, Irrigation Well Excluded
Details
Parcel number: R1645288
Zoning: FA
Special conditions: Private Owner,Licensed Owner
Construction
Type & style
Home type: SingleFamily
Property subtype: Single Family Residence
Materials
Frame, Stone, Painted/Stained
Roof: Composition,Metal
Condition
New construction: No
Year built: 2021
Utilities & green energy
Electric: Poudre Valley REA
Gas: Xcel
Sewer: Septic Tank, Septic Field
Water: District
Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Green energy
Energy efficient items: Windows
Community & HOA
Community
Features: Trail(s)
Security: Fire Sprinkler System, Fire Alarm, Security System
Subdivision: Warberg Farm Conservation Dev #04-2296
HOA
Has HOA: Yes
Services included: Common Amenities
HOA fee: $500 quarterly
HOA name: Warberg Farms HOA
Location
Region: Loveland
Financial & listing details
Price per square foot: $440/sqft
Tax assessed value: $1,720,300
Annual tax amount: $9,027
Date on market: 3/11/2026
Listing terms: Cash,Conventional,FHA,VA Loan
Exclusions: Clothes washer and dryer. Seller's personal property, Living room ceiling fan
Electric utility on property: Yes
Road surface type: Asphalt
Estimated market value
Zestimate®
$2,697,000
Estimated sales range
$2.56M - $2.83M
Rent Zestimate®
$5,463/mo
Price history
Date
Event
Price
6/30/2026
Price change
$2,825,000-2.2%$440/sqft
Source: REcolorado as distributed by MLS GRID #IR1053524Report a problem
6/13/2026
Price change
$2,890,000-2%$450/sqft
Source: IRES as distributed by MLS GRID #1053524Report a problem
5/15/2026
Price change
$2,950,000-1.7%$459/sqft
Source: IRES as distributed by MLS GRID #1053524Report a problem
10/10/2025
Listed for sale
$3,000,000+76.5%$467/sqft
Source: IRES as distributed by MLS GRID #1045289Report a problem
Explore the cost of this home by adjusting the details. Changes won't be saved.
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.