970.481.5015
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Berthoud » 80513 » 825 Wagon Bend Rd, Berthoud, CO, 80513
$568,000

825 Wagon Bend Rd, Berthoud, CO, 80513

5 Beds
4 Baths
2,847 Square Feet
Welcome to Berthoud living! Lyman Homes presents this beautiful, five-bedroom three-and-a-half-bath 2-story with home a two car garage in the prestigious Prairie Star community. With four bedrooms upstairs and one in the finished basement (with its own updated bath & walk-in shower), this floor plan is ideal for a variety of situations, including multigenerational living! Main level laundry room with washer & dryer included, plus additional washer/dryer hookups in the basement for increased utility & flexibility. From the open entertainer's kitchen to the large master suite with ensuite five-piece bath and huge walk-in closet, this house has all the details. The finished basement includes high ceilings and large egress windows that keep the whole space flooded with natural light. The kitchen includes a large island and plenty of cabinet space, giving the chef room to really spread out! Main level living room plus an extra comfy family room in the basement - not to mention plenty of storage space for the toys! The oversized 2-car garage includes additional space for storage or for a future workbench. The rear of the home includes a fully fenced & landscaped backyard with an awesome covered concrete patio with recessed lighting! Great for Summertime BBQ's or family gatherings. This home is within walking distance of Starbucks, banking & restaurants - a perfect combination of small town vibes with city conveniences! This place has it all - schedule your showing now!
Offered By
Noah Lyman, Blue Pebble Homes

Property Details

Property Type Residential
Status Active
Bedrooms 5
Bathrooms (Full) 2
Property Sub Type Single Family Residence
Square Feet 2,847
MLS # 4725156
Bathrooms (¾) 1
Bathrooms (Half) 1

Market Trends

New Properties On Market
71
15% Increase In New Listings
Average Asking Price
$1,202,365
$330,664 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$339
$69 Increase In List Price/Sq. Ft.
Average Days On Market
8
24 Day Decrease In Days On Market
Data as of Jun 03, 2026. Remaining statistics above are calculated on activity within the period from Apr 01, 2026 to May 31, 2026.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

882 Jenny Ln, Berthoud, CO 80513 Listing Photo  1
$650,000
882 Jenny Ln
Berthoud, CO
4 Beds
|
4 Baths
|
3,818 Square Feet
Offered By Todd Maltzahn Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins
185 Buckwheat Ln, Berthoud, CO 80513 Listing Photo  1
$649,990
185 Buckwheat Ln
Berthoud, CO
3 Beds
|
4 Baths
|
2,718 Square Feet
Offered By Batey McGraw DFH Colorado Realty LLC
1159 Navajo Pl, Berthoud, CO 80513 Listing Photo  1
$649,900
1159 Navajo Pl
Berthoud, CO
3 Beds
|
3 Baths
|
3,515 Square Feet
Offered By Kristine Leoffler Realty One Group Fourpoints
101 Sioux Dr, Berthoud, CO 80513 Listing Photo  1
$649,900
101 Sioux Dr
Berthoud, CO
3 Beds
|
3 Baths
|
3,438 Square Feet
Offered By Rose Merkey RE/MAX Alliance-FTC South