$670,000
SOLD APR 25, 2025

404 Wagon Bend Rd Berthoud, CO 80513

4 Beds
3.5 Baths
3,031 Sq Ft
7,831 Sq Ft Lot

Recently Sold

$221 Per Sq Ft

1% Above List Price

1 Day on Market

Highlights

  • Primary Bedroom Suite
  • High Ceiling
  • No HOA
  • Carrie Martin Elementary School Rated 9+
  • Mud Room
  • Covered Patio or Porch

About This Home

As of April 2025

Welcome to 404 Wagon Bend Rd., Berthoud, CO 80513—a stunning residence nestled at the end of a quiet cul-de-sac, offering exceptional upgrades, luxury finishes, and an inviting layout perfect for modern living. This home is the epitome of comfort and style, enhanced by thoughtful design elements throughout. Step inside and be greeted by 10-foot ceilings and grand 8-foot doors, creating a sense of space and sophistication in every room. The heart of the home features an upgraded gourmet kitchen, beautifully designed for both function and flair with premium appliances, sleek countertops, and ample cabinetry—ideal for home chefs and entertainers alike. Enjoy the warmth of brand-new flooring throughout, including plush carpet and elegant LVP, offering a fresh, move-in-ready ambiance. The finished basement adds additional flexible living space, perfect for a home office, gym, guest suite, or recreational area. The covered back patio provides a tranquil outdoor escape, perfect for morning coffee or summer BBQs, and the outdoor storage shed offers practical space for tools, bikes, and seasonal items. Located in a peaceful neighborhood in Berthoud, this property offers a quiet cul-de-sac setting while still providing easy access to parks, schools, shopping, and community events. Don't miss your opportunity to own this beautifully upgraded home that blends luxury and practicality in one exceptional package. Schedule your private showing today and experience the charm of 404 Wagon Bend Rd for yourself!

Last Agent to Sell the Property

Holly Vejrostek

LPT Realty Brokerage Email: hollysellsco@gmail.com,720-556-0080 License #100071644 Listed on: 04/04/2025

LPT Realty

Last Buyer's Agent

Amy Tallent

Tallent Co. Real Estate License #100088195

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,451

Year Built

  • Built in 2019

Lot Details

  • 7,831 Sq Ft Lot
  • Cul-De-Sac
  • South Facing Home
  • Property is Fully Fenced
  • Level Lot

Parking

  • 3 Car Attached Garage

Home Design

  • Frame Construction
  • Composition Roof

Interior Spaces

  • 1-Story Property
  • Wet Bar
  • High Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Mud Room
  • Entrance Foyer
  • Family Room
  • Living Room with Fireplace
  • Dining Room
  • Home Security System
  • Laundry Room

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

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

Finished Basement

  • Basement Fills Entire Space Under The House
  • 2 Bedrooms in Basement

Schools

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

Additional Features

  • Smoke Free Home
  • Covered Patio or Porch
  • Ground Level
  • Forced Air Heating and Cooling System

Community Details

  • No Home Owners Association
  • Prairie Star Subdivision

Listing and Financial Details

  • Exclusions: Sellers Personal Property
  • Assessor Parcel Number R1663363

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,451

Year Built

Built in 2019

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: One
  • Year Built: 2019
  • Above Grade Finished Sq Ft: 1909
  • Entry Location: Ground
  • Exclusions: Sellers Personal Property
  • Living Area: 3031
  • Directions: From Downtown Berthoud: Head east on Lake Ave toward N 4th St. Turn left onto N 4th St. Continue onto N Co Rd 15C. Turn left onto County Rd 10E. Turn right onto Berthoud Pkwy. At the traffic circle, take the 1st exit onto Grand Market Ave/Urban Pl. Continue to follow Urban Pl. Turn right onto Wagon Bend Rd. At the traffic circle, continue straight to stay on Wagon Bend Rd.
  • SubdivisionName: Prairie Star
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 787.00
  • REC_ExpectedActiveDate: 2025-04-04
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00752
  • Attribution Contact: hollysellsco@gmail.com,720-556-0080
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Microwave, Oven, Range, Refrigerator
  • Fireplaces: 1
  • Interior Amenities: Breakfast Nook, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, High Ceilings, Kitchen Island, Pantry, Primary Suite, Smoke Free, Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Laminate, Tile
  • Fireplace Features: Living Room
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Finished, Full
  • Basement: Yes
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1122
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 2
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: South
  • Roof: Composition
  • Construction Materials: Frame
  • Patio and Porch Features: Covered, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

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

Utilities

  • Utilities: Electricity Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Laundry Features: In Unit
  • Security: Security System

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: R1663363
  • Lot Size Acres: 0.18
  • Fencing: Full
  • Building Area Total: 3818
  • Lot Features: Cul-De-Sac, Level
  • Lot Size Sq Ft: 7831
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 6451

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 4, 2025
Closed on
Apr 25, 2025
Sold by
Stahl Mary Kaye
Bought by
Adams Alicia Joy and Adams Kenneth Martin
Seller's Agent
Holly Vejrostek
LPT Realty
Buyer's Agent
Amy Tallent
Tallent Co. Real Estate
List Price
$665,000
Sold Price
$670,000
Premium/Discount to List
$5,000
0.75%
Views
14
Current Estimated Value
$671,067

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,067
Avg. Annual Appreciation
-0.37%
Original Mortgage
$469,000
Outstanding Balance
$467,763
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$201,325

Purchase Details

Closed on
Sep 27, 2019
Sold by
Richfield Homes Llc
Bought by
Stahl Mary Kaye

Home Financials for this Owner

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

Similar Homes in Berthoud, CO

  • 942 Wagon Bend Rd, Berthoud, CO 80513

    $618,900

    • 5 Beds
    • 3 Baths
    • 2,618 Sq Ft
    • 942 Wagon Bend Rd
    • Berthoud, CO

    WOW! $40,000 Under Market Value for the largest floor plan for sale in the neighborhood. Better hurry. This stunning, expansive 5-bedroom home with a walkout basement offers the perfect blend of comfort, convenience, and natural beauty. Five large bedrooms provide room for family, guests, generational accommodations, or take one for your private home office or gym! The Walkout Basement provides

    Kevin Communal Your Castle Real Estate Inc

    Section Image
  • 2332 Tabor St, Berthoud, CO 80513

    $685,000

    • 4 Beds
    • 2.5 Baths
    • 3,946 Sq Ft
    • 2332 Tabor St
    • Berthoud, CO

    NOW OFFERING A 2/1 RATE BUYDOWN WHEN YOU USE OUR PREFERRED LENDER! Save HUNDREDS A MONTH! Room to grow, space to play, and a home that's anything but ordinary. This 4-bedroom, 3-bath home offers a layout designed for everyday comfort and unforgettable weekends. The main floor features open, airy living spaces, an upgraded kitchen that flows beautifully for entertaining, a show stopping living

    Jessica Persson Spears eXp Realty LLC

    Section Image
  • 1471 Sabin Ct, Berthoud, CO 80513

    $684,900

    • 5 Beds
    • 4 Baths
    • 3,872 Sq Ft
    • 1471 Sabin Ct
    • Berthoud, CO

    NOW OFFERING $5000 CREDIT! Tucked into a quiet cul-de-sac just minutes from TPC Colorado, this beautifully maintained ranch offers over 3,800 square feet of flexible living space -including a fully finished basement with a wet bar, pool table (included!), and room to relax or entertain. Upstairs, you'll find an open-concept main living area with wood floors, granite counters, stainless steel

    Jessica Persson Spears eXp Realty LLC

    Section Image
  • 1591 Sun River Rd, Berthoud, CO 80513

    $634,000

    • 4 Beds
    • 2.5 Baths
    • 3,462 Sq Ft
    • 1591 Sun River Rd
    • Berthoud, CO

    Assumable VA Loan at 5% - Rare Opportunity! Lock in a lower interest rate without being a Veteran (subject to lender approval).This beautifully maintained home sits on an oversized corner lot right next to the community park and playground. With 2,460 sq ft of living space and an 8,973 sq ft lot, this home offers both space and style. Inside, you'll love the flex room on the main level, granite

    Michelle Clifford Compass - Boulder

    Section Image
  • 790 Lowry Ln, Berthoud, CO 80513

    $649,900

    • 4 Beds
    • 3 Baths
    • 3,476 Sq Ft
    • 790 Lowry Ln
    • Berthoud, CO

    Inviting ranch home welcomes you in with 10 ft tall ceilings in the main living area and abundant natural light throughout the home. Upgraded home with timeless finishes have been thoughtfully added. 1 Year Home Warranty included and roof pre-inspected and certified. Luxury vinyl plank for beauty and ease of clean up in foyer, kitchen and living room. Gourmet kitchen with glass accent glass

    Christine Torres RE/MAX Alliance-Loveland

    Section Image
  • 437 Buckskin Rd, Berthoud, CO 80513

    $659,900

    • 5 Beds
    • 4.5 Baths
    • 3,662 Sq Ft
    • 437 Buckskin Rd
    • Berthoud, CO

    Welcome to this beautifully updated 5-bedroom, 5-bath home at 437 Buckskin Rd, Berthoud, CO offering 3,662 sq ft of modern living space. Every detail has been thoughtfully designed with all-new finishes throughout. The spacious kitchen features granite countertops, updated cabinetry, and plenty of prep space-perfect for both everyday cooking and entertaining.The open layout flows seamlessly into

    Jamie Goodvin JPAR Modern Real Estate

    Section Image
  • 667 Wagon Bend Rd, Berthoud, CO 80513

    $585,000

    • 4 Beds
    • 3.5 Baths
    • 2,526 Sq Ft
    • 667 Wagon Bend Rd
    • Berthoud, CO

    Nestled in the family-friendly community of Prairiestar, this two-story residence offers over 2,500 sqft of finished functional living and entertaining space with thoughtful updates throughout. Beautiful engineered hardwood floors, a neutral palette, and abundant natural light greet you upon entry and seamlessly tie together the main living areas. The gas fireplace with stone surround and mantel

    Carrie Terrones RE/MAX Professionals

    Section Image
  • 719 Wagon Bend Rd, Berthoud, CO 80513

    $649,999

    • 5 Beds
    • 4.5 Baths
    • 3,818 Sq Ft
    • 719 Wagon Bend Rd
    • Berthoud, CO

    This stunning 5-bedroom, 5-bathroom home in Berthoud's desirable PrairieStar community offers over 3,800 finished square feet of thoughtfully designed living space. This well kept move-in-ready property combines open-concept living, modern finishes, and functional upgrades throughout. The main floor features a spacious kitchen with granite countertops, stainless steel appliances including a gas

    Nick Bukowski The Station Real Estate

    Section Image
  • 853 Jenny Ln, Berthoud, CO 80513

    $635,000

    • 4 Beds
    • 3.5 Baths
    • 3,599 Sq Ft
    • 853 Jenny Ln
    • Berthoud, CO

    Turn-Key Beauty in the Heart of Prairiestar!This move-in ready 2-story home is a true gem, featuring a private backyard oasis and 3-car garage. From the inviting covered front porch to the thoughtfully designed interior, this home feels nearly brand new and offers exceptional living space.Step into a welcoming formal living room that flows seamlessly into a butler's pantry and a chef-inspired

    Chris Martinez RE/MAX Alliance-Longmont

    Section Image

Range of Values:

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 $670,000 None Listed On Document
Special Warranty Deed $556,559 Land Title Guarantee
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $469,000 New Conventional
Previous Owner $237,000 New Conventional
Previous Owner $237,000 New Conventional
Previous Owner $250,000 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/25/2025 04/25/25 Sold $670,000 +0.8% $221 / Sq Ft
04/04/2025 04/04/25 For Sale $665,000 -- $219 / 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,451 $44,997 $8,201 $36,796
2024 $6,311 $44,997 $8,201 $36,796
2022 $5,184 $35,187 $6,616 $28,571
2021 $5,283 $36,201 $6,807 $29,394
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
See All Agents

Map

Source: REcolorado®

MLS Number: 6162140

REcolorado®

APN: 94023-28-010