Seller's Agent in 2025
Holly Vejrostek
LPT Realty
(720) 556-0080
4 in this area
136 Total Sales
404 Wagon Bend Rd Berthoud, CO 80513
4
Beds
3.5
Baths
3,031
Sq Ft
7,831
Sq Ft Lot
Highlights
- Primary Bedroom Suite
- High Ceiling
- No HOA
- Carrie Martin Elementary School Rated 9+
- Mud Room
- Covered Patio or Porch
About This Home
As of April 2025Welcome 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
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,451
Year Built
- Built in 2019
Lot Details
- 7,831 Sq Ft Lot
- Cul-De-Sac
- South Facing Home
- Property is Fully Fenced
- Level Lot
Parking
- 3 Car Attached Garage
Home Design
- Frame Construction
- Composition Roof
Interior Spaces
- 1-Story Property
- Wet Bar
- High Ceiling
- Ceiling Fan
- Double Pane Windows
- Mud Room
- Entrance Foyer
- Family Room
- Living Room with Fireplace
- Dining Room
- Home Security System
- Laundry Room
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Oven
- Range
- Microwave
- Dishwasher
- Kitchen Island
Flooring
- Carpet
- Laminate
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms | 2 Main Level Bedrooms
- Primary Bedroom Suite
- Walk-In Closet
Finished Basement
- Basement Fills Entire Space Under The House
- 2 Bedrooms in Basement
Schools
- Carrie Martin Elementary School
- Bill Reed Middle School
- Thompson Valley High School
Additional Features
- Smoke Free Home
- Covered Patio or Porch
- Ground Level
- Forced Air Heating and Cooling System
Community Details
- No Home Owners Association
- Prairie Star Subdivision
Listing and Financial Details
- Exclusions: Sellers Personal Property
- Assessor Parcel Number R1663363
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 4, 2025
Closed on
Apr 25, 2025
Sold by
Stahl Mary Kaye
Bought by
Adams Alicia Joy and Adams Kenneth Martin
Seller's Agent
Holly Vejrostek
LPT Realty
Buyer's Agent
Amy Tallent
Tallent Co. Real Estate
List Price
$665,000
Sold Price
$670,000
Premium/Discount to List
$5,000
0.75%
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
$26
Avg. Annual Appreciation
0.01%
Original Mortgage
$469,000
Outstanding Balance
$467,346
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$202,680
Purchase Details
Closed on
Sep 27, 2019
Sold by
Richfield Homes Llc
Bought by
Stahl Mary Kaye
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
3.6%
Mortgage Type
New Conventional
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 | $670,000 | None Listed On Document | |
| Special Warranty Deed | $556,559 | Land Title Guarantee |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $469,000 | New Conventional | |
| Previous Owner | $250,000 | New Conventional |
Source: Public Records
Property History
| 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 |
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 | $6,451 | $44,997 | $8,201 | $36,796 |
| 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 |
Source: Public Records
Agents Affiliated with this Home
-
Holly Vejrostek
-
Amy Tallent
A
Buyer's Agent in 2025
Amy Tallent
Tallent Co. Real Estate
(303) 434-5321
3 in this area
107 Total Sales
Map
Source: REcolorado®
MLS Number: 6162140
APN: 94023-28-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
- 575 Ranchhand Dr
- 513 Grand Market Ave
- 533 Grand Market Ave
- 593 Country Rd
- 2771 Red Wheat Trail
- 719 Wagon Bend Rd
- 714 Grand Market Ave
- 2748 Cooperland Blvd
- 853 Cooperland Trail
- 106 Sunset Ct
- 1120 Little Branch Ln
- 228 42nd St SW
- 4601 N Sunshine Ct
- 2238 Breckenridge Dr
- 4706 Lucille Ct
- 1324 Means Ln
- 2032 Cuda Ct
- 4721 Maggie Ct
- 2289 Elmwood St
- 1467 Harebell St