This home qualifies for a seller-paid rate buydown with a reduced interest rate as low as 5.25% (APR 5.868%) as of 07/02/2026 through List & Lock. Terms apply; see disclosures for details.Welcome to 1148 Wagon Bend Rd in Berthoud-an exceptional former model home built in 2016, offering luxury, space, and stunning Colorado living. Backing to open space on a .17-acre lot, this home provides added privacy, mountain views, and a fully finished walkout basement ideal for multi-generational living. The basement features a spacious rec room, three versatile rooms perfect for an office, gym, or guest space, a full bath, and backyard access.A dramatic two-story entry opens to a bright, open floor plan with abundant natural light, hardwood floors, iron spindle railings, and a cozy gas fireplace. The gourmet kitchen features quartz countertops, stainless steel appliances, tile backsplash, 42" cabinets, a large island, walk-in pantry, and eat-in dining area.Upstairs, the primary suite includes a luxurious five-piece bath with dual vanities, soaking tub, oversized shower with bench, and walk-in closet. Three additional bedrooms, a loft, full bath, and convenient laundry room complete the upper level.With seven bedrooms plus a dedicated office, this home offers exceptional flexibility. Outdoor living includes a Trex deck with mountain views, covered patio, large concrete patio with hot tub, and a fully fenced backyard with a six-foot privacy fence. Additional highlights include a mudroom with built-ins, extra parking, and a new Class 4 roof installed in March 2026.Enjoy easy access to parks, trails, sports courts, Carter Lake, downtown Berthoud, Loveland, Longmont, and Rocky Mountain National Park. Don't miss this incredible opportunity to own a truly exceptional home.
Single-familyProperty Type
2016Year Built
7,436 sq ftLot Size
$153Price/Sq.Ft.
2 car garageParking
Listed by Brad Hutchings• RE/MAX Alliance-Loveland
Est. $3,477 per month, based on comparable rentals
Sale and tax history for 1148 Wagon Bend Rd
Sale History
Tax History
Date
Event
Price
IRES as Distributed by MLS Grid #1056110
Aug 7, 2026
Sold
$683,000
$153/sq ft
Jul 3, 2026
Contingent
—
Jul 3, 2026
Price Changed
$694,500
$156/sq ft
Jun 23, 2026
Price Changed
$689,900
$155/sq ft
Jun 5, 2026
Relisted
—
May 31, 2026
Contingent
—
Apr 9, 2026
Listed
$699,900
$157/sq ft
IRES as Distributed by MLS Grid #837567
Apr 30, 2018
Sold
$499,900
$112/sq ft
Feb 1, 2018
Contingent
—
Jan 3, 2018
Price Changed
$499,900
$112/sq ft
Nov 30, 2017
Listed
$515,000
$115/sq ft
+35
Public Remarks
Beautiful 2016 2-story home, walkout basement, 7 bed + office, 4 bath with all the upgrades, wood floors, huge master suite with 5 pc bath and outstanding views. Large Trex Deck off the back with views, covered patio below. Huge Great Room adjoining beautiful, very large gourmet kitchen with 42" cabinets, quartz counters, stainless steel appliances. 2nd Fl laundry rm. 2/10 Warranty included from Builder. Colorado's only TPC PGA golf course opening across the street in Spring 2018!
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.: 594
Parking Features: Attached
Garage Spaces: 2
Interior
Virtual Tour
Bedroom Information
# of Bedrooms: 6
All Bedrooms Conform: 1
Bathroom Information
# of Full Baths (Total): 3
# of Half Baths (Total): 1
# of Full Baths (Upper): 2
# of Full Baths (Basement): 1
# of Half Baths (Main): 1
Study Information
Has Study: 1
Family Room Information
Has Family Room: 0
Basement Information
Basement Features: Full, Partially Finished, Walk-Out Access, Built-In Radon, Radon Test Available
Fireplace Information
Fireplace Features: Insert, Gas, Great Room
Heating & Cooling
Heating Information: Forced Air
Cooling Information: Central Air, Ceiling Fan(s)
Interior Features
Interior Features: Eat-in Kitchen, Open Floorplan, Pantry, Walk-in Closet(s), Kitchen Island, High Ceilings
Window Features: Window Coverings
Appliances: Electric Range, Self Cleaning Oven, Dishwasher, Refrigerator, Microwave
Exterior
Building Information
Construction Materials: Frame, Brick
Roof: Composition
Exterior Features
Patio And Porch Features: Patio, Deck
Exterior Features: Sprinkler System, Balcony, Hot Tub
Fencing: Fenced, Wood
Property Information
Levels: Two
Has Improvements: No
Sq. Ft. Upper: 1555
Sq. Ft. Main Floor: 1452
New Construction Status: Not New, Previously Owned
Property Type: Residential
Property Sub Type: Single Family Residence
Other Structures: Storage
Above Grade Finished Area: 3,007
Zoning: SFR
Land Information
Possible Use: Single Family
Lot Information
Flood Plain: Minimal Flood or C Rating
Lot Features: House Faces South, Mineral Rights Excluded
Road Surface Type: Asphalt
Road Frontage Type: City Street
Financial
Tax Information
Tax Annual Amount: $6,876
Tax Year: 2025
Utilities
Utility Information
Water Source: City
Has Water Rights: No
Is Water Meter Installed: Yes
Sewer: Public Sewer
Utilities: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Gas: Xcel
Trash: United Waste Systems
Location
School Information
Elementary School: Carrie Martin
Middle Or Junior High School: Bill Reed
High School: Thompson Valley
High School District: Thompson R2-J
Location Information
Directions: HWY 287 to Berthoud Parkway, turn North towards mountains and turn right onto Wagon Bend Rd
Public facts
Beds: 6
Baths: 3.5
Sq. Ft.: 4,066
Stories: 2.0
Lot Size: 7,436 square feet
Style: Single Family Residential
Year Built: 2015
Year Renovated: 2015
County: Larimer County
APN: R1656920
Home facts updated by county records on Aug 19, 2026
Other
Green Information
Green Energy Efficient: Southern Exposure, Windows
Home Information
Builder Name: Jack Fisher Homes
Builder Model: Wellesley-C
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.2mi
4/10
Provided by GreatSchools
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
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
88/ 100
Very good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.3 hrs
6.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$657,000 – $795,000
Reach more buyers when you sell with Redfin. Plus, you'll save $6,908 in fees.