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!
For sale
Price cut: $10 (6/16)
$547,990
825 Wagon Bend Road, Berthoud, CO 80513
5beds
2,847sqft
Single Family Residence
Built in 2015
5,250 Square Feet Lot
$-- Zestimate®
$192/sqft
$-- HOA
What's special
- 30 days |
- 531 |
- 25 |
Zillow last checked:
Listing updated:
Listed by:
Noah Lyman 970-420-9531,
Blue Pebble Homes
Source: REcolorado as distributed by MLS GRID,MLS#: 4725156
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom
- Features: Primary Suite
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Basement
Bathroom
- Features: En Suite Bathroom, Primary Suite
- Level: Upper
Bathroom
- Level: Upper
Bathroom
- Level: Basement
Bathroom
- Level: Main
Dining room
- Level: Main
Family room
- Level: Basement
Kitchen
- Level: Main
Laundry
- Level: Main
Living room
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Oven, Refrigerator, Washer
Features
- Five Piece Bath, Granite Counters, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Smoke Free, Walk-In Closet(s)
- Flooring: Carpet, Tile, Vinyl
- Windows: Double Pane Windows
- Basement: Finished,Full,Sump Pump
Interior area
- Total structure area: 2,847
- Total interior livable area: 2,847 sqft
- Finished area above ground: 1,985
- Finished area below ground: 862
Property
Parking
- Total spaces: 2
- Parking features: Concrete, Dry Walled, Oversized, Storage
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Front Porch, Patio
- Exterior features: Private Yard
- Fencing: Full
Lot
- Size: 5,250 Square Feet
- Features: Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R1656989
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Wood Siding
- Foundation: Concrete Perimeter
- Roof: Composition
Condition
- Year built: 2015
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Prairiestar
HOA
- Has HOA: Yes
- HOA name: PrairieStar Metropolitan District No. 2
- HOA phone: 970-494-0609
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $192/sqft
- Tax assessed value: $548,600
- Annual tax amount: $5,415
- Date on market: 5/20/2026
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Exclusions: Seller's Personal Property
- Ownership: Individual
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/16/2026 | Price change | $547,9900%$192/sqft |
Source:  REcolorado as distributed by MLS GRID #4725156 Report a problem | ||
| 6/9/2026 | Price change | $548,000-3.5%$192/sqft |
Source: REcolorado as distributed by MLS GRID #4725156 Report a problem | ||
| 5/20/2026 | Listed for sale | $568,000+3.6%$200/sqft |
Source: REcolorado as distributed by MLS GRID #4725156 Report a problem | ||
| 4/30/2026 | Sold | $548,000+56.6%$192/sqft |
Source: Public Record Report a problem | ||
| 10/26/2016 | Sold | $350,000$123/sqft |
Source:  IRES as distributed by MLS GRID #764910 Report a problem | ||
| 8/19/2016 | Price change | $350,000-2.8%$123/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
| 7/6/2016 | Price change | $359,900-0.8%$126/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
| 6/1/2016 | Price change | $362,910+1.4%$127/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
| 5/14/2016 | Price change | $357,910+1.1%$126/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
| 4/25/2016 | Price change | $353,910+0.6%$124/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
| 4/15/2016 | Listed for sale | $351,778$124/sqft |
Source: Property Colorado Inc #764910 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $5,164 +26.4% | $36,756 -1% |
| 2023 | $4,084 -1.9% | $37,112 +33.9% |
| 2022 | $4,162 +4% | $27,723 -2.8% |
| 2021 | $4,000 +1.9% | $28,522 +4.1% |
| 2020 | $3,926 +3.4% | $27,406 -0.7% |
| 2019 | $3,795 | $27,597 +7.6% |
| 2018 | $3,795 | $25,639 |
| 2017 | $3,795 +8.5% | $25,639 +11.8% |
| 2016 | $3,497 +112.8% | $22,940 +87% |
| 2015 | $1,643 | $12,270 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 9/10Carrie Martin Elementary SchoolGrades: PK-5Distance: 0.9 mi
- 4/10Bill Reed Middle SchoolGrades: 6-8Distance: 3.7 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.3 mi
Schools provided by the listing agent
- Elementary: Carrie Martin
- Middle: Bill Reed
- High: Thompson Valley
- District: Thompson R2-J
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Colorado
- Larimer County
- Berthoud
- 80513
- 825 Wagon Bend Road
Nearby cities
Nearby zip codes
Other Berthoud Topics
