Public Remarks: Welcome to an amazing home in north Berthoud! This meticulously maintained home offers the ease of main floor living including master bedroom, 5-piece master bath, and laundry. Features include mountain views, open floor plan, eat-in kitchen, an abundance of natural light, four car garage, a professionally finished basement perfect for entertaining (complete with wet bar, bedroom, and full bathroom), and a fully landscaped yard with an expansive composite deck. Home is adjacent to community park and trails and only a few minutes from the TPC golf course. Don't miss your opportunity to own this amazing home.
Single-familyProperty Type
2015Year Built
9,429 sq ftLot Size
$171Est. Price/Sq.Ft.
4 car garageParking
Listed by Marshall Massaro• RE/MAX Traditions, Inc
Contact: 3037723800
Bought with Dustin Duff• RE/MAX Momentum Westminster
*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
5
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
9,429 Sq. Ft.
Year renovated
2015
Sq. Ft.
3,881
Year built
2015
Style
Single Family Residential
County
Larimer County
APN
R1656931
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.
Property details
Parking
Parking Features
Covered Spaces: 4
Garage: Yes
Attached Garage: Yes
Garage Spaces: 4
Parking Features: Garage Door Opener, RV/Boat Parking, Oversized, Tandem
Interior
Bathroom Information
Bathrooms (Full): 3
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 5
Heating & Cooling
Cooling: Yes
Central Air, Ceiling Fan(s)
Heating: Yes
Forced Air
Interior Features
Accessibility Features: Main Floor Bath, Main Level Bedroom, Main Level Laundry
Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
Fireplace Features: None
Flooring: Wood Floors
Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: Full, Daylight, Structural Floor, Rough-in for Radon, Sump Pump
Exterior
Exterior Features
Lighting
Fencing: Fenced, Wood
Patio and Porch Features: Patio, Deck
Roof: Composition
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Sloped, Within City Limits
Other Structures: Storage, Outbuildings
Road Frontage Type: City Street
Zoning: SFR
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Prairie Star
MLS Area Major: Loveland/Berthoud
Building Information
Above Grade Finished Area: 2554
Below Grade Finished Area: 1585
Builder Name: Richfield
Building Area Total: 2554
Construction Materials: Wood/Frame, Stone, Composition Siding, Painted/Stained
Foundation Details: Pillar/Post/Pier
Financial
Tax Information
Parcel Number: R1656931
Tax Annual Amount: 4946
Tax Year: 2019
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric,Xcel
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
Community Features: Pool, Playground, Park
School Information
High School District: Thompson R2-J
Elementary School: Carrie Martin,Other
Middle or Junior School: Bill Reed
High School: Thompson Valley
Location Information
Directions: From the intersection of HWY 287 & CR 17 (S. Taft Ave./Berthoud Parkway), go north ~1/3-mile to Wagon Bend Road, turn right (east), go ~1/4-mile east on Wagon Bend Road, property is on left (north) side of road.
Unparsed Address: 890 Wagon Bend Rd Berthoud CO 80513
Street Number: 890
Street Name: Wagon Bend
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.089803,40.341243
Latitude: 40.341243
Longitude: -105.089803
Public facts
Beds: 5
Baths: 3.5
Sq. Ft.: 3,881
Stories: 2.0
Lot Size: 9,429 square feet
Style: Single Family Residential
Year Built: 2015
Year Renovated: 2015
County: Larimer County
APN: R1656931
Home facts updated by county records on Jul 30, 2026
Other
Miscellaneous Information
Exclusions: Washer/Dryer, Window Drapes, TV Wall Mount, Pergola, Wisenet & NEST Systems, Keyless Front Door Lock
Listing Information
Attribution Contact: 3037723800
Close Price: $535,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Tuesday, October 6, 2020
Cumulative Days on Market: 44
Days on Market: 44
Listing Contract Date: Monday, August 24, 2020
Modification Timestamp: Thursday, August 1, 2024 2:48 AM
Home Information
Direction Faces: South
Levels: Two
Structure Type: Legal Conforming
Window Features: Window Coverings, Double Pane Windows
Year Built: 2015
Green Information
Green Energy Efficient: Southern Exposure, HVAC
Around this home
Schools
Carrie Martin Elementary School
Public PreK-5 • Assigned • 0.8mi
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
$673,000 – $815,000
Reach more buyers when you sell with Redfin. Save up to $7,083 in fees.3 minutes to get started.