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!
Sold for $2,360,685
$2,360,685
3210 Mallard Creek Rd, Berthoud, CO 80513
4beds
5,562sqft
Single Family Residence
Built in 2022
2.51 Acres Lot
$2,301,300 Zestimate®
$424/sqft
$6,502 Estimated rent
Home value
$2,301,300
$2.19M - $2.42M
$6,502/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 20, 2025 at 06:57pm
Listed by:
Catherine Rogers 9709881030,
C3 Real Estate Solutions, LLC
Bought with:
Christopher D Johnston, 100065188
LC Real Estate Group, LLC
Source: IRES,MLS#: 1028305
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 2
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 4
Primary bedroom
- Description: Carpet
- Features: Luxury Features Primary Bath, 5 Piece Primary Bath
- Level: Main
- Area: 320 Square Feet
- Dimensions: 16 x 20
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 196 Square Feet
- Dimensions: 14 x 14
Bedroom 3
- Description: Carpet
- Level: Main
- Area: 195 Square Feet
- Dimensions: 13 x 15
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 252 Square Feet
- Dimensions: 14 x 18
Dining room
- Description: Hardwood
- Level: Main
- Area: 247 Square Feet
- Dimensions: 13 x 19
Family room
- Description: Carpet
- Level: Basement
- Area: 459 Square Feet
- Dimensions: 17 x 27
Kitchen
- Description: Hardwood
- Level: Main
- Area: 209 Square Feet
- Dimensions: 11 x 19
Laundry
- Description: Tile
- Level: Main
- Area: 70 Square Feet
- Dimensions: 7 x 10
Living room
- Description: Hardwood
- Level: Main
- Area: 361 Square Feet
- Dimensions: 19 x 19
Recreation room
- Description: Carpet
- Level: Basement
- Area: 544 Square Feet
- Dimensions: 17 x 32
Study
- Description: Hardwood
- Level: Main
- Area: 180 Square Feet
- Dimensions: 12 x 15
Heating
- Forced Air, Humidity Control
Appliances
- Included: Gas Range, Self Cleaning Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Purifier Owned, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Eat-in Kitchen, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, High Ceilings
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full,Partially Finished,Walk-Out Access,Daylight,Built-In Radon
- Has fireplace: Yes
- Fireplace features: Two or More, Gas, Living Room, Bedroom
Interior area
- Total structure area: 5,562
- Total interior livable area: 5,562 sqft
- Finished area above ground: 3,165
- Finished area below ground: 2,397
Property
Parking
- Total spaces: 3
- Parking features: Garage Door Opener, Heated Garage, Oversized
- Attached garage spaces: 3
- Details: Attached
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Fencing: Fenced,Wood
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 2.51 Acres
- Features: Corner Lot, Evergreen Trees, Deciduous Trees, Abuts Private Open Space, City Limits, Paved
Details
- Parcel number: R1626080
- Zoning: RR2
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Stucco
- Roof: Composition
Condition
- New construction: No
- Year built: 2022
Details
- Builder model: Custom
- Builder name: Adams Design
Utilities & green energy
- Electric: PVREA
- Gas: Xcel
- Sewer: Septic Tank
- Water: District
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Green energy
- Energy efficient items: Southern Exposure, Windows, High Efficiency Furnace
Community & neighborhood
Security
- Security features: Security System, Fire Alarm
Community
- Community features: Trail(s)
Location
- Region: Berthoud
- Subdivision: Preserve at Lonetree
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $724 quarterly
- Services included: Management
- Association name: Preserve at Lonetree
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 4/15/2025 | Sold | $2,360,685+1.1%$424/sqft |
Source:  IRES #1028305 Report a problem | ||
| 3/18/2025 | Pending sale | $2,335,000$420/sqft |
Source:  REcolorado #8532579 Report a problem | ||
| 3/13/2025 | Listed for sale | $2,335,000+22.9%$420/sqft |
Source: REcolorado #8532579 Report a problem | ||
| 1/12/2023 | Sold | $1,900,000-5%$342/sqft |
Source: Public Record Report a problem | ||
| 12/10/2022 | Pending sale | $2,000,000$360/sqft |
Source: IRES #973945 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $11,959 +254.6% | $146,603 -1% |
| 2023 | $3,372 -53% | $148,025 +278.6% |
| 2022 | $7,180 +135.6% | $39,093 -53.1% |
Find assessor info on the county website
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 7/10Berthoud Elementary SchoolGrades: PK-5Distance: 2.8 mi
- 5/10Turner Middle SchoolGrades: 6-8Distance: 2.8 mi
- 7/10Berthoud High SchoolGrades: 9-12Distance: 3 mi
Schools provided by the listing agent
- Elementary: Berthoud
- Middle: Turner
- High: Berthoud
Source: IRES. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,301,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,301,300