404 Wagon Bend Road


















































Description
- Listed by: Holly Vejrostek 720.556.0080 hollysellsco@gmail.com • Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie
Location
Sold By Tallent Co. Real Estate, Amy Tallent
$4,114 per month
30 year fixed, 7.03% Interest
$3,577
$538
$0
Property Information for 404 Wagon Bend Road
Property Details
- Taxes: $6,451 / year
- MLS Type: Residential / Single Family Residence
- County: Larimer County
- Structure Type: House
- Architectural Style: Cul-De-Sac, Level, House Faces South, Paved, Eat-in Kitchen, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, Full Primary Bath
- Levels: One
- Subdivision Name: Prairie Star
- Association: No
- Basement: Yes
Building Information
- Year Built: 2019
- Lot Size: 0.18 AC / 7,831 SF
Interior Area & SqFt
- Building Area Total (SqFt Total): 3818
- Sqft Total: 3818
- Living Area (SqFt Finished): 3031
- Above Grade Finished Area: 1909
- Living SqFt: 1909
- Sq Ft Apx: 1122
- Area Source: Public Records
- PSF Total: 175
- PSF Above Grade: 351
- PSF Finished: 221
- Master on Main: Yes
- Entry Location: Ground
- Direction Faces: South
- Room and Floor: Bedroom-Main-1, Bathroom (Full)-Main-1, Bathroom (1/2)-Main-1, Dining Room-Main-1, Kitchen-Main-1, Living Room-Main-1, Primary Bedroom-Main-1, Primary Bathroom (Full)-Main-1, Laundry-Main-1, Mud Room-Main-1, Family Room-Basement-1, Kitchen-Basement-1, Bedroom-Basement-1, Bedroom-Basement-2, Bathroom (Full)-Basement-1
- Room Count: 15
- Basement: Finished, Full
- Fireplaces Total: 1
- Fireplace Features: Living Room
- Heating: Forced Air
- Cooling: Central Air
- 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
- Security Features: Security System
- Flooring: Carpet, Laminate, Tile
- Window Features: Double Pane Windows
- Appliances: Dishwasher, Microwave, Oven, Range, Refrigerator
- Laundry Features: In Unit
- Virtual Tour URL Unbranded: https://media.cineflyfilms.com/404-Wagon-Bend-Rd
- Virtual Tour URL Unbranded 2: https://www.zillow.com/view-imx/85e6b921-44df-407a-a2e5-f42a9a54476b?setAttribution=mls&wl=true&initialViewType=pano
Bed & Bath Summary
- Bedrooms Total: 4
- Upper Level Bedrooms: 0
- Main Level Bedrooms: 2
- Lower Level Bedrooms: 0
- Basement Level Bedrooms: 2
- Bathrooms Total: 4
- Upper Level Bathrooms: 0
- Main Level Bathrooms: 3
- Lower Level Bathrooms: 0
- Basement Level Bathrooms: 1
- Bathrooms Full: 3
- Bathrooms Three Quarter: 0
- Bathrooms Half: 1
- Bathrooms One Quarter: 0
Detailed Room Info
- Room Type: Bedroom
- Room Level: Main
- Room Length: 12
- Room Width: 17
- Room Type: Bathroom (Full)
- Room Level: Main
- Room Length: 8
- Room Width: 4
- Room Type: Bathroom (1/2)
- Room Level: Main
- Room Length: 5
- Room Width: 5
- Room Type: Dining Room
- Room Level: Main
- Room Length: 13
- Room Width: 10
- Room Type: Kitchen
- Room Level: Main
- Room Length: 13
- Room Width: 22
- Room Type: Living Room
- Room Level: Main
- Room Length: 16
- Room Width: 17
- Room Type: Primary Bedroom
- Room Level: Main
- Room Length: 14
- Room Width: 19
- Room Type: Primary Bathroom (Full)
- Room Level: Main
- Room Length: 16
- Room Width: 16
- Room Type: Laundry
- Room Level: Main
- Room Length: 6
- Room Width: 7
- Room Type: Mud Room
- Room Level: Main
- Room Length: 10
- Room Width: 4
- Room Type: Family Room
- Room Level: Basement
- Room Length: 31
- Room Width: 25
- Room Type: Kitchen
- Room Level: Basement
- Room Length: 12
- Room Width: 9
- Room Type: Bedroom
- Room Level: Basement
- Room Length: 14
- Room Width: 12
- Room Type: Bathroom (Full)
- Room Level: Basement
- Room Length: 4
- Room Width: 8
- Room Type: Bedroom
- Room Level: Basement
- Room Length: 4
- Room Width: 12
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 Fee Total Annual: $0
- Senior Community: No
Site & Location 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
- Lot Size Acres: .18
- Lot Size Square Feet: 7831
- Lot Features: Cul-De-Sac, Level
- Zoning: RES
- Fencing: Full
- Accessibility Features: Cul-De-Sac, Level, House Faces South, Paved
- Property Exclusions: Sellers Personal Property
Building Information
- Green Verification Count: 0
- Out Building Count: 0
- Number of Out Buildings: 1.0
- Horse: No
- Construction Materials: Frame
- Roof: Composition
- Patio And Porch Features: Covered, Patio
- Livable Structure Count: 0
Water & Utilities
- Water Included: Yes
- Water Source: Public
- Utilities: Electricity Connected
- Sewer: Public Sewer
Property History for 404 Wagon Bend Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Apr 25, 2025 | Sold (Public Record) Public Record #1556663250 | $670,000 | +3.4% / yr |
| Apr 25, 2025 | Sold RECOLORADO #6162140 | $670,000 | — |
| Apr 25, 2025 | Sold IRES #6162140 | $670,000 | — |
| Apr 6, 2025 | Pending RECOLORADO #6162140 | — | |
| Apr 6, 2025 | Pending IRES #6162140 | — | |
| Apr 4, 2025 | Listed (Active) RECOLORADO #6162140 | $665,000 | — |
| Apr 4, 2025 | Listed (Active) IRES #6162140 | $665,000 | — |
| Sep 27, 2019 | Sold (Public Record) Public Record #654070305 | $556,559 | — |
| Date | Event & Source | Price |
|---|---|---|
| 04/25/2025 | Sold (Public Record) Public Record #1556663250 | $670,000 +3.4% / yr |
| 04/25/2025 | Sold RECOLORADO #6162140 | $670,000 |
| 04/25/2025 | Sold IRES #6162140 | $670,000 |
| 04/06/2025 | Pending RECOLORADO #6162140 | — |
| 04/06/2025 | Pending IRES #6162140 | — |
| 04/04/2025 | Listed (Active) RECOLORADO #6162140 | $665,000 |
| 04/04/2025 | Listed (Active) IRES #6162140 | $665,000 |
| 09/27/2019 | Sold (Public Record) Public Record #654070305 | $556,559 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public records
404 Wagon Bend Road
Beds
4Total Finished SqFt
3,031 SqFtAbove Grade Finished SqFt
1,909 SqFtFinished Basement SqFt
1,122 SqFtStories
1Lot Size
7,831 SqFtSchools near 404 Wagon Bend Road
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
Explore Nearby Homes
- Heritage Ridge Homes for Sale
- Prairie Star Homes for Sale
- Rural Southwest Loveland Homes for Sale
- Southwest Loveland-Campion Homes for Sale
- Vantage Homes for Sale
- Southeast Loveland Homes for Sale
- Sorrento Homes for Sale
- Sherri Mar Homes for Sale
- Longmont Tech Center Homes for Sale
- Southwest Loveland-Thompson Homes for Sale
- Terry Lake Homes for Sale
- The Ridge at Johnstown Homes for Sale
- East Side Homes for Sale
- West Central Loveland Homes for Sale
- Lanyon Homes for Sale
- Mead Homes for Sale
- Johnstown Homes for Sale
- Berthoud Homes for Sale
- Loveland Homes for Sale
- Longmont Homes for Sale
- Lyons Homes for Sale
- Firestone Homes for Sale
- Windsor Homes for Sale
- Milliken Homes for Sale
- Greeley Homes for Sale
- Frederick Homes for Sale
- Platteville Homes for Sale
- Fort Collins Homes for Sale
- Niwot Homes for Sale
- Erie Homes for Sale
- 80540 Homes for Sale
- 80503 Homes for Sale
- 80504 Homes for Sale
- 80534 Homes for Sale
- 80542 Homes for Sale
- 80537 Homes for Sale
- 80651 Homes for Sale
- 80501 Homes for Sale
- 80538 Homes for Sale
- 80543 Homes for Sale
- 80515 Homes for Sale
- 80550 Homes for Sale
- 80526 Homes for Sale
- 80621 Homes for Sale
- 80634 Homes for Sale
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 Berkshire Hathaway HomeServices Colorado Real Estate, LLC – Erie, Holly Vejrostek
Based on information submitted to the MLS GRID as of 04/25/2025 01:34 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.


1