Public Remarks: This home has a 3 bay garage, mud area, powder bath & study on the main level. Once you pass the staircase, you see the kitchen, nook & great room lit up with natural light. The kitchen will include granite countertops, maple cabinets & stainless steel appliances. The flooring will be a mixture of engineered hardwood, ceramic tile & carpet. The great room has a fireplace & the home has a back covered patio. The 2nd level of this home will have 3 bedrooms, 3 baths, laundry room and a large loft.
Single-familyProperty Type
2019Year Built
6,300 sq ftLot Size
$163Est. Price/Sq.Ft.
3 car garageParking
Listed by Dan Ruth• RE/MAX Professionals Greenwood Village
*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
3
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
6,300 Sq. Ft.
Year renovated
2018
Sq. Ft.
2,526
Year built
2018
Style
Single Family Residential
County
Larimer County
APN
R1663370
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 21, 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.
Property details
Parking
Parking Features
Covered Spaces: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Parking Features: Tandem
Interior
Bathroom Information
Bathrooms (Full): 3
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 3
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Gas Range/Oven, Self Cleaning Oven, Dishwasher, Microwave
Fireplace: Yes
Fireplace Features: Gas, Great Room
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Abuts Public Open Space
Zoning: RES
Property Information
Under Construction
Property Type: Residential
Waterfront: No
Subdivision Information
Subdivision Name: Prairie Star
MLS Area Major: Loveland/Berthoud
Building Information
Above Grade Finished Area: 2560
Below Grade Finished Area: 1175
Builder Name: Richfield Homes
Building Area Total: 2560
Construction Materials: Wood/Frame, Stone, Composition Siding
Financial
Tax Information
Parcel Number: R1663370
Tax Annual Amount: 5088
Tax Year: 2018
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan, USDA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,Xcel
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
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: Travel North on I-25 to Highway 56. Go West to Highway 287. Go right (North) to County Road 17. Go left on County Road 17 for about 2 blocks and find PrairieStar on your right.
Unparsed Address: 501 Wagon Bend Rd Berthoud CO 80513
Street Number: 501
Street Name: Wagon Bend
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.083292,40.340131
Latitude: 40.340131
Longitude: -105.083292
Public facts
Beds: 3
Baths: 3.5
Sq. Ft.: 2,526
Stories: 2.0
Lot Size: 6,300 square feet
Style: Single Family Residential
Year Built: 2018
Year Renovated: 2018
County: Larimer County
APN: R1663370
Home facts updated by county records on Oct 21, 2026
Other
Listing Information
Attribution Contact: 3037719400
Close Price: $456,950
Photos Count: 31
Possible Use: Single Family
Special Listing Conditions: Builder
Standard Status: Closed
Listing Date Information
Close Date: Thursday, June 13, 2019
Cumulative Days on Market: 189
Days on Market: 189
Listing Contract Date: Wednesday, October 31, 2018
Modification Timestamp: Wednesday, August 21, 2024 10:57 PM
Home Information
Levels: Two
New Construction: Yes
Window Features: Double Pane Windows
Year Built: 2019
Green Information
Green Energy Efficient: Southern Exposure
Around this home
Schools
K - 12
Preschool & daycare
Carrie Martin Elementary School
Public PreK-5 • Assigned • 1.1mi
8/10
Bill Reed Middle School
Public 6-8 • Assigned • 3.7mi
3/10
Thompson Valley High School
Public 9-12 • Assigned • 3.4mi
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, 19 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
91
62
86
59
79
52
66
41
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
$578,000 – $700,000
Reach more buyers when you sell with Redfin. Save up to $6,080 in fees.3 minutes to get started.