NOT LISTED FOR SALE

464 Wagon Bend Rd Berthoud, CO 80513

Berthoud Area

Estimated Value: $646,194

3 Beds
3.5 Baths
3,844 Sq Ft
$168/Sq Ft Est. Value

Sale Details

Date Sold: August 25, 2025

Last sale price $637,500 $166 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $4,115 / mo

122 Days on Market

Highlights

  • Two Primary Bedrooms
  • Open Floorplan
  • Cathedral Ceiling
  • Carrie Martin Elementary School Rated 9+
  • Recreation Room
  • Wood Flooring

About This Home

As of August 2025

Welcome to 464 Wagon Bend Road, a modern oasis in Berthoud, CO, offering sophisticated one-level living with an enviable backdrop of open space. **Take advantage of the $7,500 interest rate buy down or cash incentive to qualified buyers.** As you enter through the front door, you'll be greeted by the elegance of hardwood floors that seamlessly flow throughout the main level. All ensuite bedrooms in this house make it a dream to live in. The heart of this home, a large kitchen, boasts a gas cooktop, leathered granite counters, high-end cabinets with pull-out shelves, and stainless steel appliances, making it a culinary dream.The home's design features 10-foot ceilings that amplify the expansive feel of the primary level. The ensuite primary bedroom is a retreat in itself, complete with an oversized closet, a double sink vanity, and a spacious shower. The thoughtfully crafted floor plan includes a versatile den or office, a guest bedroom with ensuite bathroom, a powder room, and a convenient laundry room.The low-maintenance backyard is an entertainer's delight, featuring a covered patio, turf, and drought-resistant landscaping, all overlooking a vast community open space. The oversized, insulated 3-car garage is equipped with 220v electric vehicle charging, and the home is powered by solar panels that generate more electricity than it consumes, ensuring energy efficiency.The finished basement offers a large living area, an office space, ample storage, and a guest suite with an ensuite bathroom and generous closet space. Experience smart, stylish living at its finest.

Last Agent to Sell the Property

Kelly McBartlett

Compass - Boulder Brokerage Phone: 9705410571 License #100042503 Listed on: 03/03/2025

Compass - Boulder

Last Buyer's Agent

Matthew Thomas

Real Broker, LLC DBA Real License #100030130

Real Broker, LLC DBA Real

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,598

Year Built

  • Built in 2018

Lot Details

  • 6,098 Sq Ft Lot
  • Open Space
  • South Facing Home
  • Wood Fence
  • Xeriscape Landscape
  • Paved or Partially Paved Lot
  • Level Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Heated Garage

Home Design

  • Slab Foundation
  • Composition Roof
  • Stone

Interior Spaces

  • 3,844 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Window Treatments
  • Family Room
  • Living Room
  • Dining Room
  • Recreation Room
  • Wood Flooring
  • Basement Fills Entire Space Under The House
  • Home Security System

Kitchen

  • Double Oven
  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Double Master Bedroom
  • Split Bedroom Floorplan
  • Primary Bathroom is a Full Bathroom
  • Primary bathroom on main floor
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Eco-Friendly Details

  • Energy-Efficient Windows
  • Energy-Efficient Thermostat
  • Solar owned by seller

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • High-Efficiency Furnace

Additional Features

  • Low Pile Carpeting
  • Patio

Listing and Financial Details

  • Assessor Parcel Number R1663358

Community Details

Overview

  • No Home Owners Association
  • Prairie Star Subdivision
  • Electric Vehicle Charging Station

Recreation

  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,598

Year Built

Built in 2018

Lot Details

6,098 Sq Ft Lot

Parking

3

Listing Details

  • Year Built: 2018
  • MLS Status: Sold
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.14
  • Road Frontage Type: City Street
  • Road Surface Type: Asphalt
  • Standard Status: Closed
  • Subdivision Name: Prairie Star
  • Directions: From Berthoud Parkway and HWY 287, north on Berthoud Parkway, east on Wagon Bend Rd to property on left.
  • Architectural Style: Legal Conforming
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Windows, High Efficiency Furnace, Thermostat, Photovoltaic Owned
  • Property Attached Yn: No
  • Power Production Type: 1
  • Attribution Contact: 9705410571
  • RoomType: Dining Room
  • RoomType: Family Room
  • RoomType: Kitchen
  • RoomType: Laundry
  • RoomType: Living Room
  • RoomFeatures: Full Primary Bath, Luxury Features Primary Bath
  • RoomType: Primary Bedroom
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 3844
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • RoomType: Recreation Room
  • RoomType: Study
  • IRE_HasFamilyRoom: 1
  • Special Features: None

Interior Features

  • Possible Use: Single Family
  • Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave
  • Accessibility Features: Level Lot, Low Carpet, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry
  • Has Basement: Full, Partially Finished, Slab
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 3
  • Flooring: Wood
  • Interior Amenities: Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Two Primary Suites, High Ceilings, Split Bedroom Plan
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Wood
  • Lot Features: Native Grass, Level, Abuts Private Open Space, House Faces South, City Limits, Xeriscape, Paved, Curbs, Gutters, Sidewalks, Street Light, Fire Hydrant within 500 Feet
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Frame, Stone
  • Exterior Features: Sprinkler System, >8' Garage Door, Heated Garage, Oversized Garage
  • Patio And Porch Features: Patio

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached
  • IRE_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Xcel Energy
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Security: Security System
  • Sewer: Public Sewer
  • Water Source: City

Condo/Co-op/Association

  • Community Features: Park, Trail(s)
  • Association: No

Schools

  • Elementary School: Carrie Martin
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Bill Reed

Lot Info

  • Zoning: RES
  • Parcel #: R1663358
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 5598.38

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 3, 2025
Closed on
Aug 25, 2025
Sold by
Espeseth Cynthia
Bought by
Seller's Agent
Kelly McBartlett
Compass - Boulder
Buyer's Agent
Matthew Thomas
Real Broker, LLC DBA Real
List Price
$665,000
Sold Price
$637,500
Premium/Discount to List
-$27,500
-4.14%
Views
41
Current Estimated Value
$646,194

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,694
Avg. Annual Appreciation
1.29%
Original Mortgage
$299,500
Outstanding Balance
$296,290
Interest Rate
6.72%
Mortgage Type
VA
Estimated Equity
$349,904

Purchase Details

Closed on
May 28, 2019
Sold by
Richfield Homes Llc
Bought by
Espeseth Cynthia

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$310,826
Interest Rate
4.1%
Mortgage Type
New Conventional
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Berthoud, CO

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$637,500 Land Title Guarantee
Espeseth Cynthia $465,826 Land Title Guarantee Co
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $299,500
Previous Owner Espeseth Cynthia $361,000
Previous Owner Espeseth Cynthia $310,826
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/25/2025 08/25/25 Sold $637,500 -0.4% $166 / Sq Ft
06/11/2025 06/11/25 Price Changed $639,900 -1.5% $166 / Sq Ft
05/12/2025 05/12/25 Price Changed $649,900 -1.2% $169 / Sq Ft
04/28/2025 04/28/25 Price Changed $657,500 -1.1% $171 / Sq Ft
03/03/2025 03/03/25 For Sale $665,000 -- $173 / Sq Ft
Source: IRES MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,598 $35,356 $7,650 $27,706
2024 $5,476 $39,537 $8,201 $31,336
2022 $4,565 $30,983 $6,616 $24,367
2021 $4,652 $31,875 $6,807 $25,068
2020 $4,546 $31,145 $7,200 $23,945
2019 $1,291 $9,016 $7,200 $1,816
2018 $2,447 $16,530 $16,530 $0
2017 $6 $10 $10 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE1027491

IRES MLS

APN: 94023-28-005

Your Personal Tour Guide

Ask me questions while you tour the home.