Public Remarks: Open houses cancelled! Looking for mountain views and a private backyard this is it! This beautiful 4 bedroom 3 bath home with a walk out basement is practically brand new! The backyard is perfect for entertaining with a deck as well as a patio. With no direct neighbors behind, and backing to a walking trail enjoy quiet evenings, or walk down the street to the neighborhood park. This home will meet all of your needs with a main floor office/flex space as well as an open concept living area it is perfect for gatherings. The kitchen is perfect with a pantry and island, plenty of room for cooking. The gas stove is an added bonus! Heading upstairs you will find 4 bedrooms, laundry, as well as a large loft/flex space that is perfect for an additional living area! The master bedroom is spacious and don't miss the walk in closet that has been upgraded with custom shelving, as well as your own master bathroom. The walkout basement is an amazing feature and could be easily finished.
$1000 TOTAL MOVE IN AVAILABLE! The Columbia plan is a beautiful, 2 story home that features an open floor plan, 4 BR/3 BA. This new home comes with several upgrades including all Whirlpool kitchen appliances, custom Maple cabinets in a rich Java color & an attached two car garage, separate dining room, a large laundry room, a fully fenced backyard & front yard landscape. The Columbia showcases a Master Suite complete with walk-in closet & bathroom features a garden tub & shower.
*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
8,005 Sq. Ft.
Year renovated
2018
Sq. Ft.
2,166
Year built
2018
Style
Single Family Residential
County
Larimer County
APN
R1656924
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: 2
Garage: Yes
Attached Garage: Yes
Garage Spaces: 2
Interior
Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 4
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Disposal
Study Area, Satellite Avail, High Speed Internet, Open Floorplan, Pantry, Walk-In Closet(s)
Laundry Features: Upper Level
Room Information
Basement: Unfinished
Exterior
Exterior Features
Fencing: Fenced
Patio and Porch Features: Patio, Deck
Roof: Composition
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System
Zoning: RES
Property Information
Property Type: Residential
Waterfront: No
Subdivision Information
Subdivision Name: PRAIRIESTAR FILING NO 1
MLS Area Major: Loveland/Berthoud
Building Information
Above Grade Finished Area: 2166
Below Grade Finished Area: 910
Building Area Total: 2166
Construction Materials: Wood/Frame
Financial
Tax Information
Parcel Number: R1656924
Tax Annual Amount: 4207.03
Tax Year: 2020
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric
Gas: Natural Gas
Location
HOA Information
Association: No
Association Fee Includes: Common Amenities
Community Features: Tennis Court(s), Pool, Playground, Fitness Center, Park
School Information
High School District: Thompson R2-J
Elementary School: Carrie Martin
Middle or Junior School: Bill Reed
High School: Thompson Valley
Location Information
Unparsed Address: 1048 Wagon Bend Rd Berthoud CO 80513
Street Number: 1048
Street Name: Wagon Bend
Street Suffix: Rd
City: Berthoud
State or Province: CO
County or Parish: Larimer
Country: US
Postal Code: 80513
Coordinates: -105.09143,40.34126
Latitude: 40.34126
Longitude: -105.09143
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,166
Stories: 2.0
Lot Size: 8,005 square feet
Style: Single Family Residential
Year Built: 2018
Year Renovated: 2018
County: Larimer County
APN: R1656924
Home facts updated by county records on Jul 30, 2026
Other
Miscellaneous Information
Exclusions: Sellers personal property, Washer/Dryer, curtains on windows (negotiable)
Listing Information
Attribution Contact: 3035433083
Close Price: $510,000
Photos Count: 38
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Monday, August 9, 2021
Cumulative Days on Market: 33
Days on Market: 33
Listing Contract Date: Monday, July 5, 2021
Modification Timestamp: Thursday, August 1, 2024 12:51 PM
Home Information
Levels: Two
Window Features: Window Coverings
Year Built: 2018
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, 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
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
$566,000 – $685,000
Reach more buyers when you sell with Redfin. Save up to $5,956 in fees.3 minutes to get started.