Open space behind you and sunsets to the west. This one-owner ranch with finished basement in Prairie Star offers an exceptional combination of space, location, and functionality, including a true side-by-side 3-car garage. Surrounded by walking trails and backing directly to open space you will fall in love with the lifestyle this home. With added privacy, quiet, and no neighbors behind - you'll feel like you've escaped from the ordinary. Everything you need is close by; shops, restaurants, golf, play, mountains, Carter Lake, The Berthoud Rec Center and so much more all with the convenience of i25 and hwy 287 access. This thoughtfully designed ranch floor plan features 10' ceilings, fully finished basement, 4 generously sized bedrooms, 3 baths, and comfortable living spaces on both levels. The kitchen is finished with granite countertops, gas range, ample cabinetry, and an open connection to the main living area. Pride of ownership is evident throughout, and the home has been well cared for over the years without pets. Located on Wagon Bend Rd., the northernmost street in Prairie Star, this home offers convenient access in and out of the neighborhood. With its true 3-car garage, finished basement, open-space setting, ranch design, and desirable location, this is a combination that is difficult to find in the highly desired Prairie Star neighborhood.
Single-familyProperty Type
2017Year Built
7,260 sq ftLot Size
$224Price/Sq.Ft.
3 car garageParking
Listed by Robyn Neven• Resident Realty North Metro
Est. $3,079 per month, based on comparable rentals
Sale and tax history for 778 Wagon Bend Rd
Sale History
Tax History
Date
Event
Price
IRES as Distributed by MLS Grid #1068744
Nov 3, 2026
Sold
$575,000
$224/sq ft
Oct 7, 2026
Contingent
—
Oct 1, 2026
Relisted
—
Sep 22, 2026
Pending
—
Sep 18, 2026
Listed
$575,000
$224/sq ft
Sep 15, 2026
Coming Soon
$575,000
$224/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,572 (+5.3%)
$7,650 + $27,119
$34,769
2024
$5,292 (+2.2%)
$7,650 + $27,119
$34,769
2023
$5,177 (+21.9%)
$8,201 + $29,373
$37,574
2022
$4,245 (−1.9%)
$8,201 + $29,373
$37,574
2021
$4,326 (+9.1%)
$6,616 + $22,198
$28,814
2020
$3,965 (+1.9%)
$6,807 + $22,837
$29,644
2019
$3,891 (+200.7%)
$7,200 + $19,963
$27,163
2018
$1,294 (+21,463.7%)
$7,200 + $19,963
$27,163
2017
$6
$7,128 + $1,613
$8,741
2016
$6
$12,499
Public record
Public record
Zoning
Beds
4
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
7,260 Sq. Ft.
Year renovated
2017
Sq. Ft.
1,913
Year built
2017
Style
Single Family Residential
County
Larimer County
APN
R1663263
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 Information
Garage Type: Attached
Garage Sq. Ft.: 633
Parking Features: Garage Door Opener, Attached
Garage Spaces: 3
Interior
Virtual Tour
Bedroom Information
# of Bedrooms: 4
All Bedrooms Conform: 1
Bathroom Information
# of Full Baths (Total): 2
# of Three Quarter Baths (Total): 1
# of Full Baths (Main): 1
# of Full Baths (Lower): 1
# of Three Quarters Baths (Main): 1
Study Information
Has Study: 0
Family Room Information
Has Family Room: 1
Basement Information
Basement Features: Rough-in for Radon, Sump Pump
Fireplace Information
Fireplace Features: None
Heating & Cooling
Heating Information: Forced Air
Cooling Information: Central Air, Ceiling Fan(s)
Interior Features
Interior Features: Eat-in Kitchen, Separate Dining Room, Open Floorplan, Pantry, Walk-in Closet(s), Kitchen Island, High Ceilings
Appliances: Gas Range, Self Cleaning Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
Exterior
Building Information
Construction Materials: Frame
Roof: Composition
Exterior Features
Patio And Porch Features: Deck, Enclosed
Exterior Features: Sprinkler System
Fencing: Partial
Property Information
Levels: One
Has Improvements: No
Sq. Ft. Main Floor: 1467
New Construction Status: Not New, Previously Owned
Property Type: Residential
Property Sub Type: Single Family Residence
Accessibility Features: Low Carpet, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry
Above Grade Finished Area: 1,467
Zoning: RES
Land Information
Possible Use: Single Family
Lot Information
Flood Plain: Minimal Flood or C Rating
Lot Features: Abuts Private Open Space, House Faces South, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet, Mineral Rights Excluded
Road Surface Type: Asphalt
Road Frontage Type: City Street
Financial
Tax Information
Tax Annual Amount: $5,572
Tax Year: 2025
Utilities
Utility Information
Water Source: Public
Has Water Rights: No
Is Water Meter Installed: Yes
Utilities: Natural Gas Available, Electricity Available, High Speed Avail
Gas: Xcel
Location
School Information
Elementary School: Ivy Stockwell
Elementary School: Berthoud
Middle Or Junior High School: Turner
High School: Berthoud
High School District: Thompson R2-J
Location Information
Directions: From 287 turn North on Berthoud Pkwy and go East on Wagon Bend Rd.
Community Information
Community Features: Playground, Trail(s)
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 1,913
Stories: 1.0
Lot Size: 7,260 square feet
Style: Single Family Residential
Year Built: 2017
Year Renovated: 2017
County: Larimer County
APN: R1663263
Home facts updated by county records on Oct 21, 2026
Other
Green Information
Green Energy Efficient: Southern Exposure, Windows, High Efficiency Furnace
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
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
2% 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
77/ 100
Good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
8.9 hrs
5.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$564,000 – $683,000
Reach more buyers when you sell with Redfin. Plus, you'll save $5,934 in fees.