NOT LISTED FOR SALE

590 Wagon Bend Rd Berthoud, CO 80513

Estimated Value: $548,879 - $602,000

3 Beds
2.5 Baths
1,909 Sq Ft
$302/Sq Ft Est. Value

Last Sold May 17, 2023

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

Est. 4% decrease in value since last sale

Current estimated payment $3,474/month

2 Days on Market

Highlights

  • Spa
  • Primary Bedroom Suite
  • Corner Lot
  • Carrie Martin Elementary School Rated 9+
  • Open Floorplan
  • High Ceiling

About This Home

As of May 2023

If you've been searching for a spacious ranch home on a corner lot with MOUNTAIN VIEWS, look no further! This home boasts 3,800 square feet, 3 bedrooms, 3 bathrooms and is located in the highly sought after community of Berthoud. Upon entering the home, you are greeted with dark wood laminate floors throughout the common areas, 10 foot ceilings and a grand foyer which showcases a beautiful chandelier. To the left of the foyer, you will find a spacious office with french doors, two bedrooms and one full bathroom. Continue past the foyer and you will find the family room complete with gas fireplace and tons of windows allowing for ample natural light throughout the day and showcase the home's beautiful MOUNTAIN VIEWS! The kitchen is conveniently located next to the family room which is perfect for entertaining. The kitchen boasts white cabinets, granite countertops, stainless steel appliances, decorative subway tiles, a large kitchen island, and pantry. Off of the kitchen, you will find the prelit partially covered large extended concrete patio and professionally landscaped backyard. The patio features a newer hot tub- perfect for those cold Colorado nights and is included with the sale of the home! The spacious primary bedroom has a 5-piece en suite bathroom, complete with a large seated shower, and DUAL WALK-IN closets! To round off the main level, there is a laundry room and mud room conveniently located off of the garage to help keep the house clean and tidy! The large unfinished basement has a bathroom rough in and has endless possibilities. This home is located with quick access to I-25 for commuting, close proximity to local shopping, and a short distance to TPC Colorado Golf Course. The neighborhood features open grass park areas which host community activities during the summer months, tennis court, pickleball courts, basketball court, horseshoe area, and 2 dog parks. All that's left to say is "Welcome home"!

Last Agent to Sell the Property

Terra Bamford

eXp Realty, LLC License #100085275 Listed on: 04/06/2023

eXp Realty, LLC

Last Buyer's Agent

Lisa Spears

RE/MAX Town and Country License #100073949

RE/MAX Town and Country

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,593

Year Built

  • Built in 2018

Lot Details

  • 6,970 Sq Ft Lot
  • Property is Fully Fenced
  • Landscaped
  • Corner Lot
  • Front and Back Yard Sprinklers

Parking

  • 3 Car Attached Garage

Home Design

  • Frame Construction
  • Composition Roof

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • High Ceiling
  • Ceiling Fan
  • Window Treatments
  • Entrance Foyer
  • Family Room with Fireplace
  • Home Office
  • Unfinished Basement
  • Sump Pump
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Bedrooms and Bathrooms

  • 3 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Spa
  • Covered Patio or Porch
  • Exterior Lighting

Schools

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

Additional Features

  • Smoke Free Home
  • Forced Air Heating and Cooling System

Community Details

  • No Home Owners Association
  • Prairie Star Subdivision

Listing and Financial Details

  • Exclusions: Washer and dryer, cement cow statue in backyard, patio furniture, fire pit, all outdoor pots, freezer in garage, curtains in office/study, and Sellers' personal property.
  • Assessor Parcel Number 1664576

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,593

Year Built

Built in 2018

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: One
  • Year Built: 2018
  • Above Grade Finished Sq Ft: 1909
  • Exclusions: Washer and dryer, cement cow statue in backyard, patio furniture, fire pit, all outdoor pots, freezer in garage, curtains in office/study, and Sellers' personal property.
  • Living Area: 1909
  • SubdivisionName: Prairie Star
  • Ownership: Individual
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 1909.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Oven, Refrigerator
  • Fireplaces: 1
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Smoke Free, Hot Tub, Walk-In Closet(s)
  • Fireplace Features: Family Room
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Sump Pump, Unfinished
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 3
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Construction Materials: Frame
  • Exterior Features: Lighting, Spa/Hot Tub
  • Patio and Porch Features: Covered, Front Porch, Patio

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • 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: 1664576
  • Lot Size Acres: 0.16
  • Fencing: Full
  • Building Area Total: 3818
  • Lot Features: Corner Lot, Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 6969.6
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 4593.26

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 6, 2023
Closed on
May 17, 2023
Sold by
Fields Jeffrey B
Bought by
Beese Mark E and Beese Ryan D
Seller's Agent
Terra Bamford
eXp Realty, LLC
Buyer's Agent
Lisa Spears
RE/MAX Town and Country
List Price
$599,900
Sold Price
$600,000
Premium/Discount to List
$100
0.02%
Views
10
Current Estimated Value
$577,220

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$22,780
Avg. Annual Appreciation
-1.46%
Original Mortgage
$589,132
Outstanding Balance
$572,420
Interest Rate
6.28%
Mortgage Type
FHA
Estimated Equity
$4,800

Purchase Details

Listed on
Aug 18, 2022
Closed on
Oct 3, 2022
Sold by
Brown Ted
Bought by
Fields Jeffrey B and Fields Carolyn M
Seller's Agent
Vivi Gloriod
HomeSmart
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$585,000
Sold Price
$585,000

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.17%

Purchase Details

Listed on
Jul 21, 2020
Closed on
Oct 2, 2020
Sold by
Holloway Arthur C and Holloway Aimee L
Bought by
Brown Ted
Seller's Agent
Rob Kittle
Kittle Real Estate
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$485,000
Sold Price
$464,900
Premium/Discount to List
-$20,100
-4.14%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.18%
Original Mortgage
$225,000
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 23, 2018
Sold by
Richfield Homes Llc
Bought by
Holloway Arthur C and Holloway Aimee L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$352,000
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 6, 2018
Sold by
Hdp Prairie Star Llc
Bought by
Richfield Homes Llc
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
Beese Mark E $600,000 Land Title
Fields Jeffrey B $585,000 --
Brown Ted $464,900 Heritage Title Co
Holloway Arthur C $455,052 Land Title Guarantee Co
Richfield Homes Llc $772,200 Land Title Guarantee
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Beese Mark E $589,132
Previous Owner Brown Ted $225,000
Previous Owner Holloway Arthur C $352,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/17/2023 05/17/23 Sold $600,000 0.0% $314 / Sq Ft
04/08/2023 04/08/23 Pending -- -- --
04/06/2023 04/06/23 For Sale $599,900 +2.5% $314 / Sq Ft
10/03/2022 10/03/22 Sold $585,000 0.0% $153 / Sq Ft View Prior Sale
08/28/2022 08/28/22 Pending -- -- --
08/25/2022 08/25/22 For Sale $585,000 +25.8% $153 / Sq Ft
12/31/2021 12/31/21 Off Market $464,900 -- --
10/02/2020 10/02/20 Sold $464,900 0.0% $122 / Sq Ft View Prior Sale
08/25/2020 08/25/20 Price Changed $464,900 -4.1% $122 / Sq Ft
07/21/2020 07/21/20 For Sale $485,000 -- $127 / 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 $5,473 $38,733 $8,201 $30,532
2024 $5,354 $38,733 $8,201 $30,532
2022 $4,593 $31,177 $6,616 $24,561
2021 $4,681 $32,075 $6,807 $25,268
2020 $4,683 $32,082 $7,200 $24,882
2019 $4,595 $32,082 $7,200 $24,882
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
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 2031213

REcolorado®

APN: 94023-34-004