Ask Redfin
OPEN SUN, 1PM TO 3PM
For sale
$599,900
Est. $3,965/mo —
4
bd
•
2.5 ba
•
3,818
sq ft

590 Wagon Bend Rd, Berthoud, CO 80513

map-entry

About this home

Single-familyProperty Type
2018Year Built
6,828 sq ftLot Size
$157Price/Sq.Ft.
3 car garageParking
Listed by Elliot Roffman • eXp Realty - Hub
Contact: 9707999645
Listing updated:
Redfin checked: a minute ago
•Source:IRES as Distributed by MLS Grid #1072183
32 hours on Redfin • 38 views • 1 favorites

Payment calculator

$3,965 per month

Principal and interest$3,315
Property taxes
HOA dues
Home insurance
Utilities
Down payment
20% ($119,980)
Home price
$599,900
Loan details
30-yr fixed, 7.38%
5 minutes to get started. No credit impact. 

See this home in person

Open houses
Sunday, Nov 22
1:00pm - 3:00pm

Around this home

Schools

Carrie Martin Elementary School

Public PreK-5 • Assigned • 1.0mi

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
About Prairie
Star

Provided by Walk Score and Local Logic

Offer insights

590 Wagon Bend Rd · $599,900
$603K and above
75% chance or better to win
Why $603K+ is a strong offer
DAYS ON MARKET
2 days
The average home goes pending in 67 days.
SALE-TO-LIST
98.0%
Most homes are selling 2% below list price.
About offer insights

Property details

Kitchen

Bathroom

Bedroom

Living

Dining

  • Interior features
  • Open floorplan
  • Window coverings
  • Family room
  • Unfinished basement
  • Sump pump
  • One fireplace in the family room
  • Bedrooms
  • 4 bedrooms
  • Bathrooms
  • 2 full bathrooms
  • 1 half bathroom
  • 1 bathroom rough-in
  • Kitchen
  • Eat-in kitchen
  • Pantry
  • Kitchen island
  • Gas range
  • Dishwasher
  • Refrigerator
  • Disposal
  • Laundry & utility
  • Washer
  • Dryer
  • Heating & cooling
  • Forced-air heating
  • Central air conditioning
  • Ceiling fans

Sale and tax history for 590 Wagon Bend Rd

Public record

Beds
3
Baths
2.5
Stories
1
Lot width
—
Lot depth
—
Lot size
6,828 Sq. Ft.
Year renovated
2018
Finished Sq. Ft.
1,909
Unfinished Sq. Ft.
—
Total Sq. Ft.
1,909
Year built
2018
Style
Single Family Residential
County
Larimer County
APN
R1664576
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 21, 2026.

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

3/10 Fire Factor

0.15% 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

83/ 100

Very good sunlight

Sunscore

There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

9.6 hrs
5.7 hrs
JuneDecember
Provided by Shadowmap

Redfin Estimate for 590 Wagon Bend Rd

$599,395
$505 under list price of $600K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $575K to $729K.

More resources

Rental earnings

Est. $3,033 per month, based on comparable rentals

Tour for free, no strings attached

Make a winning offer with the help of a local agent
Details provided by IRES as Distributed by MLS Grid and may not match the public record. Learn more.
Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store
GreatSchools Ratings provided by GreatSchools.org.