Public Remarks: Welcome home to this comfortable two-story home offering the perfect blend of small-town charm and modern living. With spacious interiors and breathtaking mountain views, this home is ready to impress! Step inside to an open-concept main level featuring beautiful wood flooring and abundant natural light. The kitchen offers stainless steel appliances, granite countertops, a large island, and ample storage space, perfect for everyday meals or entertaining guests. The adjoining living room is warm and inviting, centered around a cozy gas fireplace. Upstairs, retreat to the expansive primary suite with a spa-like ensuite bath and large walk-in closet. Three additional bedrooms provide flexibility for family, guests, or a home office. A versatile loft area offers even more space to relax or work. Enjoy Colorado's sunny days on the covered back patio ideal for barbecues or simply unwinding. With a 3-car tandem garage, ample storage, and a full unfinished basement ready for your creative touch, this home checks all the boxes. Located minutes from downtown Berthoud, local schools, parks, and easy access to Loveland, Longmont, and Fort Collins... this is Northern Colorado living at its best.
The popular "Holly" floor plan is now available for quick move in. The home backs future open space and trail in the new home community Prairie Star by Richfield Homes. Experience the lifestyle offered at Prairie Star with community gardens, dog park, Equestrian center, neighborhood park, swimming pool and more. Enjoy a 9000 sq ft lot fully landscaped yard with a sprinkler system. There is a 3 car garage (tandem) (South facing). A/C, appliances and garage door opener are included.
IRES as Distributed by MLS Grid #823816
Jul 26, 2017
Listing Removed
—
Jun 17, 2017
Listed
$439,900
$118/sq ft
IRES as Distributed by MLS Grid #807085
Dec 23, 2016
Listing Removed
—
Nov 18, 2016
Listed
$420,000
$112/sq ft
IRES as Distributed by MLS Grid #796934
Nov 14, 2016
Listing Removed
—
Jul 12, 2016
Listed
$450,000
$121/sq ft
IRES as Distributed by MLS Grid #789374
Jul 12, 2016
Listing Removed
—
Apr 25, 2016
Listed
$450,000
$121/sq ft
IRES as Distributed by MLS Grid #779419
Jan 27, 2016
Sold
$407,519
$109/sq ft
Dec 19, 2015
Pending
—
Nov 16, 2015
Listed
$407,444
$109/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,486 (+2.5%)
$7,650 + $32,825
$40,475
2024
$6,326 (+2.2%)
$7,650 + $32,825
$40,475
2023
$6,188 (+26.2%)
$8,201 + $35,992
$44,193
2022
$4,905 (−1.9%)
$8,201 + $35,992
$44,193
2021
$4,998 (−0.7%)
$6,616 + $26,674
$33,290
2020
$5,033 (+1.9%)
$6,807 + $27,442
$34,249
2019
$4,939 (+4.0%)
$7,200 + $27,284
$34,484
2018
$4,748 (+8.5%)
$7,200 + $27,284
$34,484
2017
$4,375 (+89.8%)
$7,128 + $24,948
$32,076
2016
$2,305 (+36,085.2%)
$7,128 + $24,948
$32,076
2014
$6
$12,270
Tax history for 878 Wagon Bend Rd
Year
Property tax
Land + Additions
Assessment*
2025
$6,486 (+2.5%)
$7,650 + $32,825
$40,475
2024
$6,326 (+2.2%)
$7,650 + $32,825
$40,475
2023
$6,188 (+26.2%)
$8,201 + $35,992
$44,193
2022
$4,905 (−1.9%)
$8,201 + $35,992
$44,193
2021
$4,998 (−0.7%)
$6,616 + $26,674
$33,290
2020
$5,033 (+1.9%)
$6,807 + $27,442
$34,249
2019
$4,939 (+4.0%)
$7,200 + $27,284
$34,484
2018
$4,748 (+8.5%)
$7,200 + $27,284
$34,484
2017
$4,375 (+89.8%)
$7,128 + $24,948
$32,076
2016
$2,305 (+36,085.2%)
$7,128 + $24,948
$32,076
2014
$6
$12,270
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
9,000 Sq. Ft.
Year renovated
2015
Sq. Ft.
2,704
Year built
2015
Style
Single Family Residential
County
Larimer County
APN
R1656933
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 30, 2026.
PUD
Planned Unit Development Overlay District
The Planned Unit Development PUD Overlay District was used as an overlay zone to supplements one or more underlying standard zone districts as found in this Code. The PUD Overlay District is no longer available as an option to zoning. Previously-approved PUDs are recognized. Any unimproved property with an approved PUD is encouraged to rezone their property to a zone district recognized in the Town's Zoning Chapter of the Development Code. Amendments to an existing PUD Overlay District will require the applicant to rezone the property and provide a Neighborhood Master Plan. Further subdivision processes may be required.
Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Abuts Private Open Space, Within City Limits
Road Frontage Type: City Street
Zoning: RES
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Prairiestar
MLS Area Major: Loveland/Berthoud
Building Information
Above Grade Finished Area: 2704
Below Grade Finished Area: 1030
Builder Name: Richfield
Building Area Total: 2704
Construction Materials: Wood/Frame, Stone, Wood Siding
Financial
Tax Information
Parcel Number: R1656933
Tax Annual Amount: 6326
Tax Year: 2024
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric,Xcel Energy
Gas: Natural Gas,Xcel Energy
Sewer: City Sewer
Location
HOA Information
Association: No
Association Fee Includes: Common Amenities, Management
Community Features: Clubhouse, Pool, Fitness Center
School Information
High School District: Thompson R2-J
Elementary School: Carrie Martin
Middle or Junior School: Bill Reed
High School: Thompson Valley
Location Information
Directions: From Berthoud Pkwy and 287, head N on Berthoud Pkwy, E onto Wagon Bend Rd, home is on the L.
Unparsed Address: 878 Wagon Bend Rd Berthoud CO 80513
Street Number: 878
Street Name: Wagon Bend
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.08925,40.3413
Latitude: 40.3413
Longitude: -105.08925
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,704
Stories: 2.0
Lot Size: 9,000 square feet
Style: Single Family Residential
Year Built: 2015
Year Renovated: 2015
County: Larimer County
APN: R1656933
Home facts updated by county records on Jul 30, 2026
Other
Miscellaneous Information
Exclusions: Clothes Washer, Clothes Dryer, Garage Refrigerator, TVs mounted in the living room, primary bedroom, and secondary bedrooms, personal property, and staging items.
Listing Information
Attribution Contact: 9705325096
Close Price: $615,000
Photos Count: 36
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, June 6, 2025
Cumulative Days on Market: 57
Days on Market: 57
Listing Contract Date: Thursday, April 10, 2025
Modification Timestamp: Saturday, June 7, 2025 12:09 AM
Home Information
Direction Faces: South
Levels: Two
Window Features: Window Coverings, Double Pane Windows
Year Built: 2015
Green Information
Green Energy Efficient: Thermostat
Around this home
Schools
Carrie Martin Elementary School
Public PreK-5 • Assigned • 0.9mi
8/10
Bill Reed Middle School
Public 6-8 • Assigned • 3.7mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.3mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
2/10 Fire Factor
0.00% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 18 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
6 unhealthy days expected this year, 7 days in 30 years
Provided by First Street
Historical weather
Berthoud, CO • 80513
Average low and high temperatures (°F)
42
17
52
23
65
36
65
38
72
46
85
56
89
61
86
59
82
53
69
42
55
30
53
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 5.9 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
5.9 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$609,000 – $738,000
Reach more buyers when you sell with Redfin. Save up to $6,409 in fees.3 minutes to get started.