$649,000
SOLD DEC 31, 2024

440 Wagon Bend Rd Berthoud, CO 80513

4 Beds
3.5 Baths
3,031 Sq Ft
6,300 Sq Ft Lot

Recently Sold

$214 Per Sq Ft

34 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Living Room with Fireplace
  • Carrie Martin Elementary School Rated 9+
  • Contemporary Architecture
  • Recreation Room

About This Home

As of December 2024

Welcome to this exquisite residence, which offers 4 bedrooms and 4 bathrooms with expansive living spaces indoors and out. Experience one-level living yet accommodate large family holiday gatherings and stays! The open kitchen, adorned with granite countertops, large island, stainless steel appliances, and distinguished builder upgrades, is a culinary enthusiast's dream. Step out the oversized glass slider door to an outdoor haven complete with sitting areas, a cook station, gas fire pit and access to the adjacent open space. The home features high ceilings, providing an airy and spacious ambiance, and is equipped with air conditioning, forced air and two fireplaces to ensure year-round comfort. A main level office with French doors, bright primary suite with walk-in closet system, laundry room, additional bedroom with ensuite, and half bath round out this flowing floorplan. The attached 3-car garage offers ample storage and parking space. The lower level is designed for entertaining, featuring a wet bar with granite counters, a large sink and four stools. Additionally, the bonus recreation room offers an attached large screen TV and an LED fireplace...plenty of room for a movie night with family and friends. You'll also find two bedrooms and a full bath as well as two mechanical/storage rooms and a large workout room on this basement level. Additionally, the friendly neighborhood, south facing driveway and sidewalks, and proximity to a walking trail and dog park enhance the appeal of this exceptional home. This residence truly encapsulates comfort and convenience.

Last Agent to Sell the Property

Robert Martin

Compass - Denver Brokerage Email: mountainrealestategroup@msn.com,303-882-8450 License #1328160 Listed on: 10/03/2024

Compass - Denver

Co-Listed By

Lori Eitel

Compass - Denver Brokerage Email: mountainrealestategroup@msn.com,303-882-8450 License #100099975

Last Buyer's Agent

Cynthia Hogarth Melek

WK Real Estate License #100074790

WK Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,174

Year Built

  • Built in 2019

Lot Details

  • 6,300 Sq Ft Lot
  • South Facing Home
  • Partially Fenced Property
  • Xeriscape Landscape
  • Front Yard Sprinklers
  • Grass Covered Lot

Parking

  • 3 Car Attached Garage
  • Parking Storage or Cabinetry

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Cement Siding
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • High Ceiling
  • Electric Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Mud Room
  • Entrance Foyer
  • Family Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Dining Room
  • Home Office
  • Recreation Room
  • Bonus Room
  • Game Room
  • Utility Room
  • Laundry Room

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms | 2 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Fireplace in Basement
  • 2 Bedrooms in Basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Fire Pit
  • Outdoor Grill

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Connected
  • Gas Water Heater

Community Details

  • No Home Owners Association
  • Prairiestar Filing 3 Subdivision
  • Greenbelt

Listing and Financial Details

  • Exclusions: Sellers' personal property and Clothes Washer and Dryer, and Vintage Red Refrigerator are excluded.
  • Assessor Parcel Number R1663360

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,174

Year Built

Built in 2019

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: One
  • Year Built: 2019
  • Above Grade Finished Sq Ft: 1909
  • Exclusions: Sellers' personal property and Clothes Washer and Dryer, and Vintage Red Refrigerator are excluded.
  • Living Area: 3031
  • Directions: From I-25, take Exit 250 for CO-56 W toward Berthoud. Head west and at the traffic circle, take the 3rd exit onto CO-56. At the traffic circle, take the 1st exit onto N 1st St. Continue 1.5 miles and turn left onto County Rd 10E. Continue for 1 mile and turn right onto Berthoud Parkway. At the traffic circle, take the 2nd exit and stay on Berthoud Pkwy. Turn right onto Wagon Bend Rd. At the traffic circle continue straight to stay on Wagon Bend Rd. 440 Wagon Bend Rd will be on your left.
  • SubdivisionName: Prairiestar Filing 3
  • Co List Office Mls Id: RECCCLL2
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 787.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 0
  • Ratio Close Price By Original Li: 1.00000
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Gas Water Heater, Microwave, Oven, Range
  • Fireplaces: 2
  • Interior Amenities: Entrance Foyer, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Wood
  • Fireplace Features: Basement, Electric, Gas, Living Room, Recreation Room
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Finished
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1122
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 2
  • Window Features: Double Pane Windows, Window Coverings, Window Treatments

Exterior Features

  • Direction Faces: South
  • Foundation Details: Concrete Perimeter, Slab
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame
  • Exterior Features: Barbecue, Fire Pit
  • Patio and Porch Features: Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Storage
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Utilities: Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00

Schools

  • Middle Or Junior School: Bill Reed

Lot Info

  • Parcel Number: R1663360
  • Lot Size Acres: 0.14
  • Fencing: Partial
  • Building Area Total: 3818
  • Lot Features: Greenbelt, Landscaped, Sprinklers In Front
  • Lot Size Sq Ft: 6300
  • ResoLotSizeUnits: SquareFeet

Multi Family

  • Number Of Units Total: 1

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 6174

MLS Schools

  • Elementary School: Carrie Martin
  • High School: Thompson Valley

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 3, 2024
Closed on
Dec 30, 2024
Sold by
Barnett Anthony K and Barnett Sandra B
Bought by
Rogan Edward and Rogan Jeri
Seller's Agent
Robert Martin
Compass - Denver
Buyer's Agent
Cynthia Hogarth Melek
WK Real Estate
List Price
$649,000
Sold Price
$649,000
Views
18
Current Estimated Value
$663,376

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$14,376
Avg. Annual Appreciation
2.38%
Original Mortgage
$616,550
Outstanding Balance
$612,244
Interest Rate
6.78%
Mortgage Type
New Conventional
Estimated Equity
$51,132

Purchase Details

Listed on
Apr 19, 2019
Closed on
Aug 8, 2019
Sold by
Richfield Homes Ltd
Bought by
Barnett Anthony K and Barnett Sandra B
Seller's Agent
Dan Ruth
RE/MAX Professionals Greenwood Village
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$508,088
Sold Price
$508,088

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.64%
Original Mortgage
$406,450
Interest Rate
3.73%
Mortgage Type
New Conventional
Source: Public Records

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $649,000 Land Title Guarantee
Special Warranty Deed $649,000 Land Title Guarantee
Special Warranty Deed $508,088 Land Title Guarantee Co
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $616,550 New Conventional
Closed $616,550 New Conventional
Previous Owner $406,450 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/31/2024 12/31/24 Sold $649,000 0.0% $214 / Sq Ft
11/06/2024 11/06/24 Pending -- -- --
10/03/2024 10/03/24 For Sale $649,000 +27.7% $214 / Sq Ft
11/07/2019 11/07/19 Off Market $508,088 -- --
08/08/2019 08/08/19 Sold $508,088 0.0% $141 / Sq Ft View Prior Sale
05/17/2019 05/17/19 Pending -- -- --
04/19/2019 04/19/19 For Sale $508,088 -- $141 / Sq Ft
Source: REcolorado®

Tax History Compared to Growth

Source: Public Records

Tax History

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 $6,311 $44,100 $8,201 $35,899
2024 $6,174 $44,100 $8,201 $35,899
2022 $5,096 $34,590 $6,616 $27,974
2021 $5,193 $35,586 $6,807 $28,779
2020 $4,932 $33,791 $7,200 $26,591
2019 $3,111 $21,721 $21,721 $0
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
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 9660401

REcolorado®

APN: 94023-28-007