3210 Mallard Creek Rd Berthoud, CO 80513
4
Beds
4.5
Baths
5,042
Sq Ft
2.51
Acres
Highlights
- Home Theater
- Primary Bedroom Suite
- Fireplace in Primary Bedroom
- Berthoud Elementary School Rated A-
- Lake View
- Deck
About This Home
As of April 2025Offer 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!
Last Agent to Sell the Property
C3 Real Estate Solutions LLC Brokerage Phone: 970-988-1030 License #40033220 Listed on: 03/13/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $12,365
Year Built
- Built in 2022 | Remodeled
Lot Details
- 2.51 Acre Lot
- South Facing Home
- Landscaped
- Corner Lot
- Front and Back Yard Sprinklers
- Private Yard
- Property is zoned RR2
HOA Fees
- $241 Monthly HOA Fees
Parking
- 5 Car Attached Garage
- Heated Garage
Property Views
- Lake
- Mountain
Home Design
- Slab Foundation
- Frame Construction
- Composition Roof
- Stone Siding
- Radon Mitigation System
- Stucco
Interior Spaces
- 1-Story Property
- Wet Bar
- Built-In Features
- Bar Fridge
- Vaulted Ceiling
- Gas Fireplace
- Double Pane Windows
- Smart Window Coverings
- Smart Doorbell
- Family Room
- Living Room with Fireplace
- 2 Fireplaces
- Dining Room
- Home Theater
- Home Office
Kitchen
- Eat-In Kitchen
- Self-Cleaning Convection Oven
- Range
- Microwave
- Dishwasher
- Kitchen Island
- Quartz Countertops
- Utility Sink
- Disposal
Flooring
- Wood
- Carpet
- Radiant Floor
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms | 3 Main Level Bedrooms
- Fireplace in Primary Bedroom
- Primary Bedroom Suite
- Walk-In Closet
Laundry
- Laundry Room
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Bedroom in Basement
- 1 Bedroom in Basement
- Crawl Space
Home Security
- Home Security System
- Radon Detector
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Eco-Friendly Details
- Energy-Efficient HVAC
- Smoke Free Home
Outdoor Features
- Balcony
- Deck
- Covered patio or porch
- Fire Pit
- Exterior Lighting
- Outdoor Gas Grill
Schools
- Berthoud Elementary School
- Turner Middle School
- Berthoud High School
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- 220 Volts
- 110 Volts
- Natural Gas Connected
- Tankless Water Heater
- Gas Water Heater
- Septic Tank
- High Speed Internet
- Cable TV Available
Community Details
- Association fees include irrigation, snow removal
- Preserve At Lonetree Association, Phone Number (970) 988-1030
- Preserve At Lonetree Subdivision
Listing and Financial Details
- Exclusions: Seller’s Personal Property, Staging, standing basketball hoop on driveway. Gun safe in Study. Sonos speakers, and whole home sound system. In the attached 3 car garage: metal shelving, all metal storage cabinets, Samsung Fridge and Insignia freezer. In the detached 2 car garage: all metal shelving. On west side patio Green Egg smoker. 2 Attached exterior sky chairs.
- Assessor Parcel Number R1626080
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 13, 2025
Closed on
Apr 15, 2025
Sold by
Candes Michael R and Candes Leslie C
Bought by
Holsapple Eric J and Holsapple Tracy S
Seller's Agent
Catherine Rogers
C3 Real Estate Solutions LLC
Buyer's Agent
Chris Johnston
LC Real Estate Group, LLC
List Price
$2,335,000
Sold Price
$2,360,685
Premium/Discount to List
$25,685
1.1%
Views
14
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$20,497
Avg. Annual Appreciation
0.07%
Purchase Details
Listed on
Aug 23, 2022
Closed on
Jan 11, 2023
Sold by
Adams Design Inc
Bought by
Candes Michael R and Candes Leslie C
Seller's Agent
Tara Littell
Compass - Boulder
Buyer's Agent
Andrea Stull
C3 Real Estate Solutions, LLC
List Price
$2,000,000
Sold Price
$1,900,000
Premium/Discount to List
-$100,000
-5%
Views
264
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.08%
Original Mortgage
$1,425,000
Interest Rate
5.75%
Mortgage Type
New Conventional
Purchase Details
Listed on
Sep 24, 2020
Closed on
Nov 10, 2020
Sold by
Prairie Rose Revocable Trust
Bought by
Adams Design Inc
Seller's Agent
Amy Tallent
Tallent Co. Real Estate
Buyer's Agent
Tara Littell
Compass - Boulder
List Price
$315,000
Sold Price
$315,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
128.90%
Original Mortgage
$240,000
Interest Rate
2.71%
Mortgage Type
Future Advance Clause Open End Mortgage
Purchase Details
Closed on
Feb 13, 2020
Sold by
Germany Nancy S
Bought by
Prairie Rose Revocable Trust
Purchase Details
Listed on
Sep 11, 2018
Closed on
Jan 31, 2019
Sold by
Cummings Kerr Family Trust
Bought by
Germany Nancy S
Seller's Agent
Chad Brent
Group Loveland
Buyer's Agent
Chad Brent
Group Loveland
List Price
$285,000
Sold Price
$275,000
Premium/Discount to List
-$10,000
-3.51%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
39.07%
Purchase Details
Closed on
Aug 31, 2017
Sold by
Cummings David A and Kerr Shelley
Bought by
Cummings Kerr Family Trust
Purchase Details
Listed on
Jul 26, 2013
Closed on
Jan 15, 2014
Sold by
Blue Mountain Holdings Llc
Bought by
Cummings David A and Kerr Shelley
Seller's Agent
Chad Brent
Group Loveland
Buyer's Agent
Susan Orth
C3 Real Estate Solutions, LLC
List Price
$145,000
Sold Price
$122,300
Premium/Discount to List
-$22,700
-15.66%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
29.16%
Purchase Details
Closed on
Nov 18, 2010
Sold by
Blue Mountain Holdings Llc
Bought by
Hermesch Dennis
Similar Homes in Berthoud, CO
-
$1,997,700
- 4 Beds
- 5 Baths
- 2,455 Sq Ft
- 2696 Bluewater Rd
- Berthoud, CO
Spectacular Vacant Lot with Mountain, Lake views and TPC Colorado Membership! Build your dream home in this prestigious gated community, offering unparalleled amenities and breathtaking views. This vacant lot boasts stunning, unobstructed mountain views and is conveniently located directly across from a motorized lake, perfect for boating, fishing, and year-round recreation. As a resident, you'll
Melissa Maersk-Moller Luxury Homes LLC
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Special Warranty Deed | $2,360,685 | None Listed On Document | |
| Warranty Deed | $1,900,000 | Land Title | |
| Special Warranty Deed | $315,000 | Guardian Title | |
| Special Warranty Deed | -- | None Available | |
| Warranty Deed | $275,000 | The Group Guarantee Title | |
| Interfamily Deed Transfer | -- | None Available | |
| Warranty Deed | $122,300 | Chicago Title Co | |
| Public Action Common In Florida Clerks Tax Deed Or Tax Deeds Or Property Sold For Taxes | -- | None Available |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $800,000 | New Conventional | |
| Previous Owner | $1,425,000 | New Conventional | |
| Previous Owner | $1,125,000 | Construction | |
| Previous Owner | $240,000 | Construction | |
| Previous Owner | $240,000 | Future Advance Clause Open End Mortgage |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/15/2025 04/15/25 | Sold | $2,360,685 | +1.1% | $468 / Sq Ft |
| 03/13/2025 03/13/25 | For Sale | $2,335,000 | +22.9% | $463 / Sq Ft |
| 01/11/2023 01/11/23 | Sold | $1,900,000 | -5.0% | $348 / Sq Ft |
| 12/08/2022 12/08/22 | Pending | -- | -- | -- |
| 12/06/2022 12/06/22 | For Sale | $2,000,000 | +5.3% | $367 / Sq Ft |
| 12/05/2022 12/05/22 | Off Market | $1,900,000 | -- | -- |
| 11/05/2022 11/05/22 | For Sale | $2,000,000 | 0.0% | $367 / Sq Ft |
| 10/17/2022 10/17/22 | Pending | -- | -- | -- |
| 10/06/2022 10/06/22 | Price Changed | $2,000,000 | -9.1% | $367 / Sq Ft |
| 08/23/2022 08/23/22 | For Sale | $2,200,000 | +598.4% | $403 / Sq Ft |
| 02/08/2022 02/08/22 | Off Market | $315,000 | -- | -- |
| 11/10/2020 11/10/20 | Sold | $315,000 | 0.0% | -- |
| 10/03/2020 10/03/20 | For Sale | $315,000 | 0.0% | -- |
| 10/03/2020 10/03/20 | Pending | -- | -- | -- |
| 09/24/2020 09/24/20 | For Sale | $315,000 | +14.5% | -- |
| 05/02/2019 05/02/19 | Off Market | $275,000 | -- | -- |
| 01/31/2019 01/31/19 | Sold | $275,000 | +124.9% | -- |
| 01/28/2019 01/28/19 | Off Market | $122,300 | -- | -- |
| 09/11/2018 09/11/18 | For Sale | $285,000 | +133.0% | -- |
| 01/15/2014 01/15/14 | Sold | $122,300 | -15.7% | -- |
| 12/16/2013 12/16/13 | Pending | -- | -- | -- |
| 07/26/2013 07/26/13 | For Sale | $145,000 | -- | -- |
Source: REcolorado®
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $12,365 | $146,603 | $23,450 | $123,153 |
| 2024 | $11,959 | $146,603 | $23,450 | $123,153 |
| 2022 | $3,372 | $39,093 | $19,967 | $19,126 |
| 2021 | $7,180 | $83,317 | $83,317 | $0 |
| 2020 | $3,047 | $35,351 | $35,351 | $0 |
| 2019 | $3,003 | $35,351 | $35,351 | $0 |
| 2018 | $3,144 | $35,351 | $35,351 | $0 |
| 2017 | $2,741 | $35,351 | $35,351 | $0 |
| 2016 | $2,242 | $28,043 | $28,043 | $0 |
| 2015 | $2,227 | $28,040 | $28,040 | $0 |
| 2014 | $1,312 | $15,750 | $15,750 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Seller's Agent in 2025
Catherine Rogers
C3 Real Estate Solutions LLC
(970) 988-1030
231 Total Sales
-
Buyer's Agent in 2025
Chris Johnston
LC Real Estate Group, LLC
(970) 420-5652
36 Total Sales
-
Seller's Agent in 2023
Tara Littell
Compass - Boulder
(303) 819-2761
72 Total Sales
-
Buyer's Agent in 2023
Andrea Stull
C3 Real Estate Solutions, LLC
(970) 692-9081
52 Total Sales
-
A
Seller's Agent in 2020
Amy Tallent
Tallent Co. Real Estate
(303) 434-5321
96 Total Sales
-
Seller Co-Listing Agent in 2020
Brie Fowler
The Agency - Boulder
(303) 882-8672
162 Total Sales
Map
Source: REcolorado®
MLS Number: 8532579
APN: 94084-05-010
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (“IDX”) program of METROLIST, INC., DBA RECOLORADO®. Real estate listings held by brokers other than Ten-X are marked with the IDX Logo. This information is being provided for the consumers’ personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
PUBLISHER’S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved. 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Nearby Homes
- 2102 Shoreside Dr
- 1932 N County Road 23
- 2366 Shoreside Dr
- 3825 Nations Way
- 2654 Big Creek Ct
- 2609 Big Creek Ct
- 2622 Big Creek Ct
- 2672 Bluewater Rd
- 2552 Bluewater Rd
- 2598 Bluewater Rd
- 2696 Bluewater Rd
- 2622 Bluewater Rd
- 3520 W County Road 8
- 2669 Southwind Rd
- 2568 Southwind Rd
- 2554 Southwind Rd
- 2732 Bluewater Rd
- 2638 Southwind Rd
- 2682 Southwind Rd
- 2664 Southwind Rd