NOT LISTED FOR SALE

489 Wagon Bend Rd Berthoud, CO 80513

Estimated Value: $589,813 - $653,000

3 Beds
2.5 Baths
3,138 Sq Ft
$194/Sq Ft Est. Value

Last Sold April 13, 2023

Last sale price $600,000 $191 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,667/month

2 Days on Market

Highlights

  • City View
  • Open Floorplan
  • Contemporary Architecture
  • Carrie Martin Elementary School Rated 9+
  • River Nearby
  • Wood Flooring

About This Home

As of April 2023

Located in the desirable Prairiestar Subdivision of Berthoud; one of the best locations in the neighborhood, conveniently backing to the pond and open land, this sizeable home has much to offer; from upgraded quartz countertops in the spacious kitchen complimented with stainless steel appliances and large island, to the adjoining living and dining rooms, creating the perfect entertaining area or a place to make memories together. The main floor offers an open floor plan, modern mantle surrounding the gas fireplace, and butler/bar area with a spacious pantry, gas cooktop furthers the appeal.As you move upstairs, the expansive master bedroom leads you into the luxury 5 piece on-suite bathroom. This sought after floorplan is even further improved upon by a large 4 car garage and fully fenced and landscaped backyard. The extended back concrete patio overlooks the pond and gives West facing views, while providing a gas connection for an exterior fireplace or grill. Located with quick access for commuting as well as convenience to local shopping, this home embraces the best of Northern Colorado living. Prairiestar lends to its owners; 2 dog parks, tennis and pickleball courts, basketball court, horseshoe area, and open grass park areas which hosts community activities during the summer months.

Last Agent to Sell the Property

Nick Bukowski

The Station Real Estate Listed on: 02/08/2023

Last Buyer's Agent

Marnie Long

Group Harmony

Group Harmony

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,690

Year Built

  • Built in 2018

Lot Details

  • 6,300 Sq Ft Lot
  • East Facing Home
  • Wood Fence
  • Level Lot
  • Sprinkler System

Parking

  • 4 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle

Interior Spaces

  • 3,138 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Living Room with Fireplace
  • Loft
  • City Views

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on upper level
  • Washer and Dryer Hookup

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Eco-Friendly Details

  • Energy-Efficient HVAC

Outdoor Features

  • River Nearby
  • Patio

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Satellite Dish
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R1663369

Community Details

Overview

  • No Home Owners Association
  • Built by Richfield Homes
  • Prairiestarfiling 3 Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,690

Year Built

Built in 2018

Lot Details

0

Parking

4

Listing Details

  • Year Built: 2018
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.14
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Prairiestarfiling 3
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: HVAC
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3138
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Accessibility Features: Level Lot
  • Has Basement: Full, Unfinished, Sump Pump
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Gas, Living Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Satellite Avail, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: Richfield Homes
  • Fencing: Fenced, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Level, Within City Limits
  • View: City
  • Waterfront Features: Abuts Pond/Lake
  • Waterfront: No
  • Construction Type: Wood/Frame, Composition Siding
  • Direction Faces: East
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Berthoud
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Community Features: Park
  • Senior Community: No
  • 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: SFR
  • Lot Size Sq Ft: 6300
  • Parcel #: R1663369
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 4690

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 8, 2023
Closed on
Apr 13, 2023
Sold by
Sellers Robert A
Bought by
Den Matthew A and Boer Amelia Den
Seller's Agent
Nick Bukowski
The Station Real Estate
Buyer's Agent
Marnie Long
Group Harmony
List Price
$600,000
Sold Price
$600,000
Views
13
Current Estimated Value
$608,953

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,953
Avg. Annual Appreciation
0.55%
Original Mortgage
$250,000
Outstanding Balance
$223,047
Interest Rate
5.9%
Mortgage Type
New Conventional
Estimated Equity
$385,906

Purchase Details

Listed on
Feb 22, 2019
Closed on
Jun 4, 2019
Sold by
Richfield Homes Llc
Bought by
Sellers Robert A and Sellers Katie L
Seller's Agent
Dan Ruth
RE/MAX Professionals Greenwood Village
Buyer's Agent
Nick Bukowski
The Station Real Estate
List Price
$461,982
Sold Price
$439,950
Premium/Discount to List
-$22,032
-4.77%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.37%
Original Mortgage
$395,955
Interest Rate
4.2%
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 Buyer Sale Price Title Company
Den Matthew A $600,000 None Listed On Document
Sellers Robert A $439,950 Land Title Guarantee
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Den Matthew A $250,000
Previous Owner Sellers Robert A $395,955
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/13/2023 04/13/23 Sold $600,000 0.0% $191 / Sq Ft
02/09/2023 02/09/23 For Sale $600,000 +36.4% $191 / Sq Ft
09/03/2019 09/03/19 Off Market $439,950 -- --
06/04/2019 06/04/19 Sold $439,950 0.0% $137 / Sq Ft View Prior Sale
04/18/2019 04/18/19 Pending -- -- --
04/12/2019 04/12/19 Price Changed $439,950 -4.8% $137 / Sq Ft
02/22/2019 02/22/19 For Sale $461,982 -- $143 / Sq Ft
Source: IRES MLS

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 $5,722 $40,328 $8,201 $32,127
2024 $5,597 $40,328 $8,201 $32,127
2022 $4,603 $31,240 $6,616 $24,624
2021 $4,690 $32,139 $6,807 $25,332
2020 $4,458 $30,538 $7,200 $23,338
2019 $1,288 $8,995 $7,200 $1,795
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
See All Agents

Map

Source: IRES MLS

MLS Number: 981681

IRES MLS

APN: 94023-29-006