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
List your home for rent
$6,502/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$6,502/mo
Rent Zestimate®
Refinance and save
$13,939/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$13,939/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat'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
- Colorado
- Larimer County
- Berthoud
- 80513
- 3210 Mallard Creek Rd