Sold
Last Sold Price
3 beds3,818 sqft$157/sqft
590 Wagon Bend Rd, Berthoud, CO 80513
Single FamilyProperty Type
6,969 sq ftLot Size
2018Year Built
$157/sq ftPrice per sq ft
3 carsParking Spaces

Description

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...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"!
  • Listed by: Terra Bamford 303.947.0076 bamford_terra@yahoo.com • eXp Realty, LLC
Listing closed: 05/17/2023 12:00 AM • Source: RECOLORADO as distributed by MLS GRID, MLS#: 2031213

Location

Listing Courtesy of eXp Realty, LLC, Terra Bamford

Sold By RE/MAX Town and Country, Lisa Spears

Add your commute

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$3,483 per month

30 year fixed, 6.71% Interest

Principal and Interest

$3,101

Property Taxes

$383

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 590 Wagon Bend Road

Property Details
  • Taxes: $4,593 / year
  • MLS Type: Residential / Single Family Residence
  • Structure Type: House
  • Architectural Style: Corner Lot, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Full Primary Bath, 5 Piece Primary Bath
  • Levels: One
  • Subdivision Name: Prairie Star
  • Association: No
  • Basement: Yes
Building Information
  • Year Built: 2018
  • Lot Size: 0.16 AC / 6,969 SF
Interior Area & SqFt
Interior Area & SqFt
  • Building Area Total (SqFt Total): 3818
  • Sqft Total: 3818
  • Living Area (SqFt Finished): 1909
  • Above Grade Finished Area: 1909
  • Living SqFt: 1909
  • Sq Ft Apx: 0
  • Below Grade Unfinished Area: 1909
  • PSF Total: 157
  • PSF Above Grade: 314
  • PSF Finished: 314
  • Master on Main: Yes
  • Room and Floor: Bedroom-Main-1, Bedroom-Main-2, None-Main-1, None-Main-2, Bathroom Full-Main-1, Bathroom Half-Main-1, Laundry-Main-1, Office-Main-1, Kitchen-Main-1, Family Room-Main-1
  • Room Count: 10
  • Basement: Sump Pump, Unfinished
  • Fireplaces Total: 1
  • Fireplace Features: Family Room
  • Heating: Forced Air
  • Cooling: Central Air
  • Interior Features: 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)
  • Security Features: Carbon Monoxide Detector(s), Smoke Detector(s)
  • Window Features: Window Coverings
  • Appliances: Dishwasher, Disposal, Microwave, Oven, Refrigerator
  • Laundry Features: Dishwasher, Refrigerator, Microwave, Disposal, Fire Alarm
Bed & Bath Summary
Bedrooms
  • Bedrooms Total: 3
  • Upper Level Bedrooms: 0
  • Main Level Bedrooms: 3
  • Lower Level Bedrooms: 0
  • Basement Level Bedrooms: 0
Bathrooms
  • Bathrooms Total: 3
  • Upper Level Bathrooms: 0
  • Main Level Bathrooms: 3
  • Lower Level Bathrooms: 0
  • Basement Level Bathrooms: 0
  • Bathrooms Full: 2
  • Bathrooms Three Quarter: 0
  • Bathrooms Half: 1
  • Bathrooms One Quarter: 0
Detailed Room Info
Room 1
  • Room Type: Bedroom
  • Room Level: Main
Room 2
  • Room Type: Bedroom
  • Room Level: Main
Room 3
  • Room Level: Main
Room 4
  • Room Level: Main
Room 5
  • Room Type: Bathroom Full
  • Room Level: Main
Room 6
  • Room Type: Bathroom Half
  • Room Level: Main
Room 7
  • Room Type: Laundry
  • Room Level: Main
Room 8
  • Room Type: Office
  • Room Level: Main
Room 9
  • Room Type: Kitchen
  • Room Level: Main
Room 10
  • Room Type: Family Room
  • Room Level: Main
Parking
Parking
  • Parking Features: Attached
  • Attached Garage: Yes
  • Parking Type: Garage (Attached)
  • Parking Description: Garage (Attached)-3
  • Parking Details: 3
  • Parking Total: 1
  • Garage Spaces: 3
  • Offstreet Spaces: 0
  • Parking Count: 3
  • Carport Spaces: 0
  • Reserved Spaces: 0
  • RV Spaces: 0
Association Information
Association Information
  • Association Fee Total Annual: $0
  • Senior Community: No
Site & Location Information
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
Site & Location Information
  • Lot Size Acres: .16
  • Lot Size Square Feet: 6970
  • Lot Features: Corner Lot, Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Fencing: Full
  • Accessibility Features: Corner Lot
  • Property 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.
Building Information
Green Features
  • Green Verification Count: 0
Outbuildings
  • Out Building Count: 0
  • Horse: No
Building Information
  • Construction Materials: Frame
  • Roof: Composition
  • Exterior Features: Lighting, Spa/Hot Tub
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Livable Structure Count: 0
Water & Utilities
Water & Utilities
  • Water Included: Yes
  • Water Source: Public Sewer
  • Utilities: Forced Air, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Full Primary Bath, 5 Piece Primary Bath
  • Sewer: Public Sewer

Property History for 590 Wagon Bend Road

DateEvent & SourcePriceAppreciation
May 17, 2023

Sold (Public Record)

Public Record #1510982571

$600,000

+4.2% / yr

Oct 3, 2022

Sold (Public Record)

Public Record #1498306227

$585,000

+12.2% / yr

Oct 2, 2020

Sold (Public Record)

Public Record #680007126

$464,900

+1.1% / yr

DateEvent & SourcePrice
05/17/2023

Sold (Public Record)

Public Record #1510982571

$600,000

+4.2% / yr

10/03/2022

Sold (Public Record)

Public Record #1498306227

$585,000

+12.2% / yr

10/02/2020

Sold (Public Record)

Public Record #680007126

$464,900

+1.1% / yr

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 590 Wagon Bend Road

Taxable ValueLand$7,650Additions$27,975Total$35,625
Tax Record2025$5,709 ($476 / month)
Home Facts
Beds3Total Finished SqFt1,909 SqFtAbove Grade Finished SqFt1,909 SqFtStories1Lot Size6,828 SqFtStyleSingle Family ResidenceYear Built2018CountyLARIMERAPN94023-34-004

Schools near 590 Wagon Bend Road

This home is within Thompson R2-J School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Charter - K to 12
Rating
School
Distance
Carrie Martin Elementary School
PublicPK to 5

Bill Reed Middle School
Public6 to 8

Thompson Valley High School
Public9 to 12

Loveland Classical School
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of eXp Realty, LLC, Terra Bamford

Based on information submitted to the MLS GRID as of 05/17/2026 03:03 PM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.