Offer Deadline Mon. the 17th by 5PM with an acceptance of Mon. 17th by 7PM. In a league all its own, experience the ultimate Colorado lifestyle in this Modern Prairie Masterpiece built 2022, nestled up against acres HOA open space & trails, at the Preserve at Lonetree! Featuring both breathtaking snow capped mountain views and water views! With extensive recent additions/improvements, elaborate award winning Lindgren Landscaping + new west side summer kitchen, fully fenced/landscape area within the lot! 5,562sft, 4 Bdrms, 4.5 Baths, huge main level office, 5 car garage (3 attached + 2 detached heated garage bays) + full walk-out basement! No Metro, HOA covers non-potable irrigation water! Floor to ceiling windows showcasing full panoramic front range vistas, Meeker and Longs! Modern eat-in Gourmet Kitchen features all that an aspiring chef would desire, loaded with workspace & cabinetry, prep sink and an incredible Butler's Pantry with its own new ice maker! Bathed in natural daylight - with exquisite finishes and custom millwork all with an amazing mountain backdrop! The main floor primary suite features a spa-inspired 5 piece bath, gas fireplace with a large covered deck showcasing mountain and water views, and a large walk-in closet with built-ins (don't miss the roughed in W/D connections.) Oversized secondary bedrooms on the main level are each "ensuite" and have their own walk-in closets. Looking for a wonderful in home office? Here it is! at 15 X 12 with it's own storage and french doors right off the foyer. Stunning horizontal wrought-iron rail staircase, solid-core doors, casement windows, dual zone HVAC. Finished Walk-out lower level features many built-ins and a gorgeous wet bar with wine/beverage fridge. Ideal outdoor Colorado living - gas stubs ready for added firepits or heaters off the back. Easy access to 287, Carter Lake, Boulder, Loveland, TPC, and Longmont for commuting! Extensive list of inclusions!
Offered By
Catherine Rogers 9709881030, C3 Real Estate Solutions, LLC
Parking FeaturesGarage Door Opener, Heated Garage, Oversized
FenceFenced, Wood
Lot FeaturesLawn Sprinkler System, Corner Lot, Abuts Private Open Space, Within City Limits
Garage spaces3
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONPreserve at Lonetree
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESHiking/Biking Trails
HOA1
TAX AMOUNT12365.0
HOA FEE723.55
HOA FREQUENCYQuarterly
LATEST UPDATE2025-04-15T21:17:46.434Z
DAYS ON MARKET33
PRICE CHANGE(S)
$2,335,000 Mar 12, 2025
CUMULATIVE DAYS ON MARKET33
Market Trends
New Properties On Market
69
64%
Increase In New Listings
Average Asking Price
$856,896
$174,699 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$268
$15 Decrease In List Price/Sq. Ft.
Average Days On Market
21
21 Day
Decrease In Days On Market
Data as of Apr 18, 2025.
Remaining statistics above are calculated on activity within the period from Feb 01, 2025 to Mar 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.