OFF MARKET

Off market apr 2025 for $670K

$698,348

Est. refi paymentEst. refi $3,969/mo

•

3,818

sq ft

404 Wagon Bend Rd, Berthoud, CO 80513

About this home

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!

Single-familyProperty Type

2019Year Built

7,831 sq ftLot Size

$183Est. Price/Sq.Ft.

3 car garageParking

Listed by Holly Vejrostek • Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie

Contact: hollysellsco@gmail.com,720-556-0080

Bought with Amy Tallent • Tallent Co. Real Estate

Redfin checked: a minute ago

•Source:REColorado as Distributed by MLS Grid #6162140

Listing provided courtesy of Metrolist,Inc. (REColorado)

Redfin Estimate

$698,348

$28K since sold in April 2025$1,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 11.7% higher than the average sale price ($625K) of 6 comparable homes.

SOLD OCT 28, 2026
$605,000
A
4 beds3.5 baths3,389 sq ft
525 Wagon Bend Rd, Berthoud, CO 80513
SOLD JUL 23, 2026
$610,000
B
4 beds2.5 baths3,890 sq ft
1212 Tipton St, Berthoud, CO 80513
SOLD SEP 8, 2026
$599,999
C
5 beds4.5 baths3,818 sq ft
719 Wagon Bend Rd, Berthoud, CO 80513
SOLD SEP 22, 2026
$557,500
D
4 beds3.5 baths3,599 sq ft
853 Jenny Ln, Berthoud, CO 80513
SOLD MAY 15, 2026
$650,000
E
4 beds3.5 baths3,030 sq ft
810 Ranchhand Dr, Berthoud, CO 80513
SOLD JUL 28, 2026
$729,000
F
5 beds4 baths3,960 sq ft
1281 Coffman Dr, Berthoud, CO 80513

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$135,178

Est. take-home

List your home with Redfin and save $6,983

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,472/mo

Redfin rental estimate

List your home for rent

Market trends in 80513, CO

Last updated October 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

98.9%

+0.3% MoM

Median sale price

$610K

$25K MoM

Avg. days on market

79d

15 days MoM

Recently sold homes

2 MoM

New listings for sale

COMING SOON
$1,075,000
3 beds2.5 baths2,708 sq ft
1846 Little Acres Ln, Berthoud, CO 80513
COMING SOON
$350,000
2 beds2.5 baths1,080 sq ft
2726 Center Park Way, Berthoud, CO 80513
$825,000
5 beds3 baths3,936 sq ft
2243 Breckenridge Dr, Berthoud, CO 80513
EmpowerHome Team Colorado • Keller Williams Realty Northern Colorado
3D WALKTHROUGH
$890,000
4 beds3.5 baths4,733 sq ft
722 Sophie St, Berthoud, CO 80513
3D WALKTHROUGH
$624,900
4 beds3 baths3,542 sq ft
1657 Vantage Pkwy, Berthoud, CO 80513
$139,000
2 beds2 baths1,088 sq ft
227 N 2nd St #4, Berthoud, CO 80513
3D WALKTHROUGH
$640,000
5 beds3.5 baths3,115 sq ft
1252 Sun River Rd, Berthoud, CO 80513
3D WALKTHROUGH
$490,000
3 beds2 baths2,986 sq ft
1544 Brant St, Berthoud, CO 80513
3D WALKTHROUGH
$1,650,000
5 beds4 baths6,569 sq ft
1030 Berthoud Peak Dr, Berthoud, CO 80513
Ann Yuska • RE/MAX Nexus
3D WALKTHROUGH
$990,000
4 beds3 baths3,248 sq ft
4901 Beverly Dr, Berthoud, CO 80513
Ann Yuska • RE/MAX Nexus
See all

Provided by Redfin

Sale history for 404 Wagon Bend Rd

Date

Event

Price

REColorado as Distributed by MLS Grid #6162140

Apr 25, 2025

Sold

$670,000

$175/sq ft

Apr 6, 2025

Pending

—

Apr 4, 2025

Listed

$665,000

$174/sq ft

Apr 1, 2025

Coming Soon

$665,000

$174/sq ft

+45

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!

Public Records

Apr 17, 2019

Sold

$547,990

$144/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$6,292 (−2.5%)

$7,650 + $31,613

$39,263

2024

$6,451 (+2.2%)

$7,650 + $31,613

$39,263

2023

$6,311 (+21.7%)

$8,201 + $36,796

$44,997

2022

$5,184 (−1.9%)

$8,201 + $36,796

$44,997

2021

$5,283 (+7.1%)

$6,616 + $28,571

$35,187

2020

$4,932 (+58.5%)

$6,807 + $29,394

$36,201

2019

$3,111 (+27.2%)

$7,200 + $26,591

$33,791

2018

$2,447 (+40,678.7%)

$21,721

2017

$16,530

2016

$12,499

Tax history for 404 Wagon Bend Rd

Year

Property tax

Land + Additions

Assessment*

2025

$6,292 (−2.5%)

$7,650 + $31,613

$39,263

2024

$6,451 (+2.2%)

$7,650 + $31,613

$39,263

2023

$6,311 (+21.7%)

$8,201 + $36,796

$44,997

2022

$5,184 (−1.9%)

$8,201 + $36,796

$44,997

2021

$5,283 (+7.1%)

$6,616 + $28,571

$35,187

2020

$4,932 (+58.5%)

$6,807 + $29,394

$36,201

2019

$3,111 (+27.2%)

$7,200 + $26,591

$33,791

2018

$2,447 (+40,678.7%)

$21,721

2017

$16,530

2016

$12,499

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

7,831 Sq. Ft.

Year renovated

2019

Sq. Ft.

3,031

Year built

2019

Style

Single Family Residential

County

Larimer County

APN

R1663363

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 21, 2026.

PUD

Planned Unit Development Overlay District

The Planned Unit Development PUD Overlay District was used as an overlay zone to supplements one or more underlying standard zone districts as found in this Code. The PUD Overlay District is no longer available as an option to zoning. Previously-approved PUDs are recognized. Any unimproved property with an approved PUD is encouraged to rezone their property to a zone district recognized in the Town's Zoning Chapter of the Development Code. Amendments to an existing PUD Overlay District will require the applicant to rezone the property and provide a Neighborhood Master Plan. Further subdivision processes may be required.

Property details

Parking

Parking/Garage Information
Parking Total: 3
Garage Spaces: 3
AttachedGarageYN: Yes

Interior

Virtual Tour Information

Bedroom Information
Bedrooms Total: 4
Main Level Bedrooms: 2
Basement Level Bedrooms: 2

Bathroom Information
Bathrooms Total Integer: 4
Bathrooms Full: 3
Bathrooms Half: 1
Main Level Bathrooms: 3
Basement Level Bathrooms: 1

Room 1 Information
Bedroom
Length: 12.03
Width: 17.08
Level: Main

Room 2 Information
Bathroom (Full)
Length: 8.02
Width: 4.1
Level: Main

Room 3 Information
Bathroom (1/2)
Length: 5.03
Width: 5.04
Level: Main

Room 4 Information
Dining Room
Length: 13.03
Width: 10.03
Level: Main

Room 5 Information
Kitchen
Length: 13.03
Width: 22.01
Level: Main

Room 6 Information
Living Room
Length: 16.04
Width: 17.04
Level: Main

Room 7 Information
Primary Bedroom
Length: 14.01
Width: 19.03
Level: Main

Room 8 Information
Primary Bathroom (Full)
Length: 16.13
Width: 16.02
Level: Main

Room 9 Information
Laundry
Length: 6.05
Width: 7.1
Level: Main

Room 10 Information
Mud Room
Length: 10.04
Width: 4.1
Level: Main

Room 11 Information
Family Room
Length: 31.13
Width: 25.2
Level: Basement

Room 12 Information
Kitchen
Length: 12.07
Width: 9.02
Level: Basement

Room 13 Information
Bedroom
Length: 14.1
Width: 12.05
Level: Basement

Room 14 Information
Bathroom (Full)
Length: 4.11
Width: 8.1
Level: Basement

Room 15 Information
Bedroom
Length: 4.1
Width: 12.02
Level: Basement

Interior Features
Interior Features: 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
Appliances: Dishwasher, Microwave, Oven, Range, Refrigerator
Flooring: Carpet, Laminate, Tile
Window Features: Double Pane Windows
Laundry Features: In Unit

Basement Information
Has Basement
Basement: Finished, Full

Fireplace Information
Fireplaces Total: 1
Fireplace Features: Living Room

Exterior

Building Information
Building Area Total: 3,818
Building Area Source: Public Records
Structure Type: House
Construction Materials: Frame

Exterior Features
Patio And Porch Features: Covered, Patio
Fencing: Full
Roof: Composition

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Property Unattached
Living Area: 3,031
Above Grade Finished Area: 1,909
Below Grade Finished Area: 1,122
Below Grade Unfinished Area: 787
Entry Location: Ground
Levels: One
Direction Faces: South
Ownership: Individual
Security Features: Security System

Lot Information
Lot Size Square Feet: 7,831
Lot Size Acres: 0.18
Lot Features: Cul-De-Sac, Level
Water Source: Public
Road Surface Type: Paved
Road Frontage Type: Public
Road Responsibility: Public Maintained Road
Zoning: RES

Financial

Tax Information
Tax Annual Amount: $6,451
Tax Year: 2024
Parcel Number: R1663363

Utilities

Utility Information
Utilities: Electricity Connected
Sewer: Public Sewer

Heating & Cooling
Cooling: Central Air
Heating: Forced Air

Location

School Information
Elementary School: Carrie Martin
Elementary School District: Thompson R2-J
Middle Or Junior School: Bill Reed
Middle Or Junior School District: Thompson R2-J
High School: Thompson Valley
High School District: Thompson R2-J

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 3,031
Stories: 1.0
Lot Size: 7,831 square feet
Style: Single Family Residential
Year Built: 2019
Year Renovated: 2019
County: Larimer County
APN: R1663363

Home facts updated by county records on Oct 21, 2026

Around this home

Schools

K - 12
Preschool & daycare

Carrie Martin Elementary School

Public PreK-5 • Assigned • 1.2mi

8/10

Bill Reed Middle School

Public 6-8 • Assigned • 3.8mi

3/10

Thompson Valley High School

Public 9-12 • Assigned • 3.5mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

2/10 Fire Factor

0.00% chance of being in a wildfire in next 30 years

3/10 Heat Factor

7 days above 92° expected this year, 18 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

4/10 Air Factor

6 unhealthy days expected this year, 7 days in 30 years

Provided by First Street

Historical weather

Berthoud, CO • 80513

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.5 hours in June and 5.9 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

5.9 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$664,000 – $804,000

Reach more buyers when you sell with Redfin. Save up to $6,983 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$800,000

3 beds1 bath1,230 sq ft

515 E County Road 8, Berthoud, CO 80513

Fully fenced acres • Wood burning stove • Multiple sheds

Listing provided by REColorado as Distributed by MLS Grid

$1,175,000

3 beds3 baths3,208 sq ft

5215 E County Road 16, Loveland, CO 80537

11 acres • Spacious kitchen • Extensive cabinetry

NEW CONSTRUCTION

$2,495,000

5 beds5.5 baths4,989 sq ft

1836 E State Highway 60, Loveland, CO 80537

Longs peak views • Hand-selected stone • Chef's kitchen

$529,000

4 beds2 baths2,076 sq ft

307 E Michigan Ave, Berthoud, CO 80513

Broad front porches • Private backyard • Mature landscaping

NEW CONSTRUCTION3D WALKTHROUGH

$1,324,999

5 beds3.5 baths4,462 sq ft

1424 Burt Ave, Berthoud, CO 80513

Corner lot • Finished basement • Private retreat

$1,400,000

5 beds4 baths4,367 sq ft

3338 Paddy Ln, Loveland, CO 80537

Ranch style home • Expansive views • Finished basement

New listings for sale in 80513

COMING SOON

$1,075,000

3 beds2.5 baths2,708 sq ft

1846 Little Acres Ln, Berthoud, CO 80513

3 acre property • Corrals & arena • 3 acre lot

COMING SOON

$350,000

2 beds2.5 baths1,080 sq ft

2726 Center Park Way, Berthoud, CO 80513

Longs peak views • Off-street parking • Detached garage

$825,000

5 beds3 baths3,936 sq ft

2243 Breckenridge Dr, Berthoud, CO 80513

Front courtyard • Covered back porch • Garden boxes

Listing provided by REColorado as Distributed by MLS Grid

3D WALKTHROUGH

$890,000

4 beds3.5 baths4,733 sq ft

722 Sophie St, Berthoud, CO 80513

Full acre • Approved for a shop • In-ground pool

3D WALKTHROUGH

$624,900

4 beds3 baths3,542 sq ft

1657 Vantage Pkwy, Berthoud, CO 80513

Granite counters • Covered porch • Outdoor pools

$139,000

2 beds2 baths1,088 sq ft

227 N 2nd St #4, Berthoud, CO 80513

Private bedrooms • Walk-in tile showers • Large kitchen island

3D WALKTHROUGH

$640,000

5 beds3.5 baths3,115 sq ft

1252 Sun River Rd, Berthoud, CO 80513

Main-level living • Large pantry • Open kitchen

3D WALKTHROUGH

$490,000

3 beds2 baths2,986 sq ft

1544 Brant St, Berthoud, CO 80513

Corner lot • New roof • Fresh exterior paint

3D WALKTHROUGH

$1,650,000

5 beds4 baths6,569 sq ft

1030 Berthoud Peak Dr, Berthoud, CO 80513

Custom home • Spacious lot • Dedicated office

Listing provided by REColorado as Distributed by MLS Grid

Home values near 404 Wagon Bend Rd

Data from public records.

Address	Redfin Estimate
500 Wagon Bend Rd, Berthoud, CO 5 Beds \| 3.5 Baths \| 2981 Sq. Ft.	$616,086
464 Wagon Bend Rd, Berthoud, CO 3 Beds \| 3.5 Baths \| 3844 Sq. Ft.	$640,268
428 Wagon Bend Rd, Berthoud, CO 3 Beds \| 2.5 Baths \| 3272 Sq. Ft.	$578,877
441 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3.5 Baths \| 3138 Sq. Ft.	$645,747
477 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3 Baths \| 2513 Sq. Ft.	$562,588
5001 South Iowa Ave, Loveland, CO 6 Beds \| 3 Baths \| 2250 Sq. Ft.	$531,216
5105 South Iowa Ave, Loveland, CO 3 Beds \| 2 Baths \| 1248 Sq. Ft.	$323,944

Address	Redfin Estimate
488 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3 Baths \| 2958 Sq. Ft.	$598,387
452 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3 Baths \| 2547 Sq. Ft.	$576,352
416 Wagon Bend Rd, Berthoud, CO 4 Beds \| 5 Baths \| 3504 Sq. Ft.	$700,155
453 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3.5 Baths \| 3739 Sq. Ft.	$636,980
489 Wagon Bend Rd, Berthoud, CO 3 Beds \| 2.5 Baths \| 3138 Sq. Ft.	$593,569
5007 South Iowa Ave, Loveland, CO 2 Beds \| 2 Baths \| 1698 Sq. Ft.	$430,029
404 Country Rd, Berthoud, CO 3 Beds \| 2 Baths \| 1435 Sq. Ft.	$470,624

Address	Redfin Estimate
476 Wagon Bend Rd, Berthoud, CO 3 Beds \| 2.5 Baths \| 2293 Sq. Ft.	$559,447
440 Wagon Bend Rd, Berthoud, CO 4 Beds \| 4 Baths \| 3818 Sq. Ft.	$650,974
429 Wagon Bend Rd, Berthoud, CO 4 Beds \| 4.5 Baths \| 3504 Sq. Ft.	$703,587
465 Wagon Bend Rd, Berthoud, CO 4 Beds \| 3.5 Baths \| 3412 Sq. Ft.	$619,946
501 Wagon Bend Rd, Berthoud, CO 3 Beds \| 3.5 Baths \| 3735 Sq. Ft.	$607,985
5101 South Iowa Ave, Loveland, CO 3 Beds \| 1 Baths \| 1056 Sq. Ft.	$355,426
376 Country Rd, Berthoud, CO 3 Beds \| 2.5 Baths \| 2123 Sq. Ft.	$514,797

Property information provided by REColorado as Distributed by MLS Grid when last listed in 2025. This data may not match . Learn more.

More real estate resources

Cities
Zip Codes
Neighborhoods
Popular Searches

Berthoud homes for sale
Boulder homes for sale
Fort Collins homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Campion	Agents near me	Fort Collins, CO homes for sale	Campion Housing Market
Houses for sale near me	Denver, CO homes for sale	Aurora, CO homes for sale
Land for sale near me	Colorado Springs, CO homes for sale	Arvada, CO homes for sale
Open Houses near me	Boulder, CO homes for sale	Campion Property Records
Condos for sale near me	Littleton, CO homes for sale	CO New Listings