Brandon Rearick
Coldwell Banker Realty-Boulder
(970) 900-5952
66 Total Sales
4 in Berthoud
$480K - $615K Price Range
Estimated Value: $637,112
Welcome to 404 Wagon Bend Rd., Berthoud, CO 80513—a stunning residence nestled at the end of a quiet cul-de-sac, offering exceptional upgrades, luxury finishes, and an inviting layout perfect for modern living. This home is the epitome of comfort and style, enhanced by thoughtful design elements throughout. Step inside and be greeted by 10-foot ceilings and grand 8-foot doors, creating a sense of space and sophistication in every room. The heart of the home features an upgraded gourmet kitchen, beautifully designed for both function and flair with premium appliances, sleek countertops, and ample cabinetry—ideal for home chefs and entertainers alike. Enjoy the warmth of brand-new flooring throughout, including plush carpet and elegant LVP, offering a fresh, move-in-ready ambiance. The finished basement adds additional flexible living space, perfect for a home office, gym, guest suite, or recreational area. The covered back patio provides a tranquil outdoor escape, perfect for morning coffee or summer BBQs, and the outdoor storage shed offers practical space for tools, bikes, and seasonal items. Located in a peaceful neighborhood in Berthoud, this property offers a quiet cul-de-sac setting while still providing easy access to parks, schools, shopping, and community events. Don't miss your opportunity to own this beautifully upgraded home that blends luxury and practicality in one exceptional package. Schedule your private showing today and experience the charm of 404 Wagon Bend Rd for yourself!
Last Agent to Sell the Property
LPT Realty Brokerage Email: hollysellsco@gmail.com,720-556-0080 License #100071644 Listed on: 04/04/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Brandon Rearick
Coldwell Banker Realty-Boulder
(970) 900-5952
66 Total Sales
4 in Berthoud
$480K - $615K Price Range
John Feeney
C3 Real Estate Solutions, LLC
(970) 999-1592
81 Total Sales
8 in Berthoud
$575K - $2M Price Range
Heather McChesney
Keller Williams-Preferred Rlty
(833) 610-0979
84 Total Sales
8 in Berthoud
$79K - $830K Price Range
Elise Kaynor
Ortiz & Associate Inc.
(720) 738-6546
47 Total Sales
1 in Berthoud
$590,000 Price
Danna Hinz
RE/MAX Alliance
(720) 734-9375
98 Total Sales
6 in Berthoud
$780K - $945K Price Range
Erika Staggs
Brick and Ivy LLC
(720) 706-4643
217 Total Sales
1 in Berthoud
$660,000 Price
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $670,000 | None Listed On Document | ||
| Stahl Mary Kaye | $556,559 | Land Title Guarantee |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $469,000 | ||
| Previous Owner | Stahl Mary Kaye | $237,000 | |
| Previous Owner | Stahl Mary Kaye | $250,000 |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 04/25/2025 04/25/25 | Sold | $670,000 | +0.8% | $221 / Sq Ft |
| 04/04/2025 04/04/25 | For Sale | $665,000 | -- | $219 / Sq Ft |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $6,451 | $39,263 | $7,650 | $31,613 |
| 2024 | $6,311 | $44,997 | $8,201 | $36,796 |
| 2022 | $5,184 | $35,187 | $6,616 | $28,571 |
| 2021 | $5,283 | $36,201 | $6,807 | $29,394 |
| 2020 | $4,932 | $33,791 | $7,200 | $26,591 |
| 2019 | $3,111 | $21,721 | $21,721 | $0 |
| 2018 | $2,447 | $16,530 | $16,530 | $0 |
| 2017 | $6 | $10 | $10 | $0 |
Seller's Agent in 2025
Holly Vejrostek
LPT Realty
(720) 556-0080
159 Total Sales
AT
Buyer's Agent in 2025
Amy Tallent
Tallent Co. Real Estate
(303) 434-5321
110 Total Sales
Source: REcolorado®
MLS Number: 6162140
APN: 94023-28-010
Ask me questions while you tour the home.