$568,000

825 Wagon Bend Rd Berthoud, CO 80513

Estimated payment $3,525/month

Total Views 406
5 Beds
3.5 Baths
2,847 Sq Ft
$200 Price per Sq Ft

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Private Yard
  • Carrie Martin Elementary School Rated 9+
  • Granite Countertops
  • Covered Patio or Porch

About This Home

Welcome to Berthoud living! Lyman Homes presents this beautiful, five-bedroom three-and-a-half-bath 2-story with home a two car garage in the prestigious Prairie Star community. With four bedrooms upstairs and one in the finished basement (with its own updated bath & walk-in shower), this floor plan is ideal for a variety of situations, including multigenerational living! Main level laundry room with washer & dryer included, plus additional washer/dryer hookups in the basement for increased utility & flexibility. From the open entertainer's kitchen to the large master suite with ensuite five-piece bath and huge walk-in closet, this house has all the details. The finished basement includes high ceilings and large egress windows that keep the whole space flooded with natural light. The kitchen includes a large island and plenty of cabinet space, giving the chef room to really spread out! Main level living room plus an extra comfy family room in the basement - not to mention plenty of storage space for the toys! The oversized 2-car garage includes additional space for storage or for a future workbench. The rear of the home includes a fully fenced & landscaped backyard with an awesome covered concrete patio with recessed lighting! Great for Summertime BBQ's or family gatherings. This home is within walking distance of Starbucks, banking & restaurants - a perfect combination of small town vibes with city conveniences! This place has it all - schedule your showing now!

Listing Agent

Noah Lyman

Blue Pebble Homes Brokerage Phone: 970-420-9531 License #100055510 Listed on: 05/20/2026

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,415

Year Built

  • Built in 2015

Lot Details

  • 5,250 Sq Ft Lot
  • Property is Fully Fenced
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Private Yard

Parking

  • 2 Car Attached Garage
  • Oversized Parking
  • Parking Storage or Cabinetry
  • Dry Walled Garage

Home Design

  • Frame Construction
  • Composition Roof
  • Wood Siding
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Recessed Lighting
  • Double Pane Windows
  • Family Room
  • Living Room
  • Dining Room
  • Fire and Smoke Detector

Kitchen

  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • En-Suite Bathroom
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • 1 Bedroom in Basement
  • Basement Window Egress

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Connected
  • Gas Water Heater
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Additional Features

  • Smoke Free Home
  • Covered Patio or Porch

Community Details

  • Property has a Home Owners Association
  • Prairiestar Metropolitan District No. 2 Association, Phone Number (970) 494-0609
  • Prairiestar Subdivision

Listing and Financial Details

  • Exclusions: Seller's Personal Property
  • Assessor Parcel Number R1656989

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,415

Year Built

Built in 2015

Lot Details

5,250 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Two
  • Year Built: 2015
  • Above Grade Finished Sq Ft: 1985
  • Exclusions: Seller's Personal Property
  • Living Area: 2847
  • SubdivisionName: PrairieStar
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Special Features: None

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Oven, Refrigerator, Sump Pump, Washer
  • Interior Amenities: Five Piece Bath, Granite Counters, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Smoke Free, Walk-In Closet(s)
  • Flooring: Carpet, Tile, Vinyl
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Finished, Full, Sump Pump
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 862
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows, Egress Windows

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Roof: Composition
  • Construction Materials: Frame, Wood Siding
  • Exterior Features: Private Yard
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public

Garage/Parking

  • Parking Features: Concrete, Dry Walled, Oversized, Storage
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • Association Name: PrairieStar Metropolitan District No. 2
  • Association Fee Frequency: Annually
  • Phone: (970) 494-0609
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00
  • REC_AssociationManagementType: Self Managed
  • REC_AssociationURL: https://www.prairiestarmd2.org/

Schools

  • Middle Or Junior School: Bill Reed

Lot Info

  • Parcel Number: R1656989
  • Lot Size Acres: 0.12
  • Fencing: Full
  • Building Area Total: 2847
  • Lot Features: Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 5250

Multi Family

  • Number Of Units Total: 1

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 5415

MLS Schools

  • Elementary School: Carrie Martin
  • High School: Thompson Valley

Map

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

Source: Public Records

Average Home Value in this Area





Source: Public Records

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 $5,415 $33,794 $7,650 $26,144
2024 $5,052 $36,756 $8,201 $28,555
2022 $4,084 $27,723 $6,616 $21,107
2021 $4,162 $28,522 $6,807 $21,715
2020 $4,000 $27,406 $7,200 $20,206
2019 $3,926 $27,406 $7,200 $20,206
2018 $3,795 $25,639 $7,128 $18,511
2017 $3,497 $25,639 $7,128 $18,511
2016 $3,082 $22,940 $5,492 $17,448
2015 $1,643 $12,270 $12,270 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/20/2026 05/20/26 For Sale $568,000 +62.3% $200 / Sq Ft
01/28/2019 01/28/19 Off Market $350,000 -- --
10/26/2016 10/26/16 Sold $350,000 +3.0% $131 / Sq Ft View Prior Sale
09/26/2016 09/26/16 Pending -- -- --
05/29/2015 05/29/15 For Sale $339,688 -- $127 / Sq Ft
Source: REcolorado®

Purchase History

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 Type Sale Price Title Company
Special Warranty Deed $548,000 Heritage Title
Special Warranty Deed $350,000 Land Title Guarantee
Source: Public Records

Mortgage History

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 Loan Amount Loan Type
Open $520,600 New Conventional
Source: Public Records

Source: REcolorado®

MLS Number: 4725156

REcolorado®

APN: 94023-11-012

Your Personal Tour Guide

Ask me questions while you tour the home.