Back on the market through no fault of the home. The buyers financing fell through. Now is your chance! Come see why Loveland, CO is frequently voted as one of the best places to live or retire in America. Known as the City of Love, Loveland is the gateway to Estes Park and Rocky Mountain National Park, and offers outstanding restaurants, entertainment, breweries, community festivities, trails, parks, and recreation. Incredible Boedecker Lake and Rocky Mountain views. This home offers luxury living at its finest and you can enjoy nature and wildlife from nearly every window. This custom-built ranch style property offers something for everyone with over 5,400 total square feet. 5 beds, 5 baths and an oversized 4 car finished garage with southern exposure for plenty of natural snow melt. The main floor features a split floor plan with an expansive primary bedroom taking the entire east wing. Both guest bedrooms are spacious and feature private baths and patio access. The gourmet kitchen features a walk-in pantry, stainless steel appliances, 5-burner gas range, double ovens, pot-filler, granite slab countertops and a center island with breakfast bar. Large dining area overlooks the open space and lake. The primary suite with retreat features a large walk-in closet plus a 5-piece luxury bath with oversized shower and freestanding clawfoot tub. The family room offers spectacular views, vaulted ceilings, and a gas fireplace with floor to ceiling stone. The walk-out basement features 9' ceilings, 2 additional bedrooms (one currently used as an office), media corner, billiard room, wet bar, and plenty of storage. The oversized covered and uncovered patio features Trex decking, iron railing, and landscape lights. Additional features include central A/C, 2 40-gallon water heaters, active radon system, wood-burning fire-pit with pergola, sprinkler and drip system, hardwood floors, high-end light fixtures, humidifier, and so much more.
Sold for $1,475,000
$1,475,000
4821 Hay Wagon Ct, Loveland, CO 80537
5beds
5,410sqft
Single Family Residence
Built in 2021
0.42 Acres Lot
$1,465,500 Zestimate®
$273/sqft
$4,978 Estimated rent
Home value
$1,465,500
$1.39M - $1.54M
$4,978/mo
Zestimate® history
Owner options
List your home for rent
$4,978/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,978/mo
Rent Zestimate®
Refinance and save
$7,525/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$7,525/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Billiard roomTrex deckingWalk-in pantrySprinkler and drip systemPrimary suite with retreatVaulted ceilingsDouble ovens
Zillow last checked:
Listing updated:
Listed by:
John Simmons 970-481-1250,
C3 Real Estate Solutions, LLC,
Michelle Metzger 970-567-9359,
C3 Real Estate Solutions, LLC
Bought with:
Lael Pierce, 100040185
RE/MAX Alliance-FTC South
Source: IRES as distributed by MLS GRID,MLS#: 1056526
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 1
- 3/4 bathrooms: 3
- 1/2 bathrooms: 1
- Main level bathrooms: 4
Primary bedroom
- Description: Wood
- Features: Luxury Features Primary Bath, 5 Piece Primary Bath
- Level: Main
- Area: 270 Square Feet
- Dimensions: 15 x 18
Bedroom 2
- Description: Wood
- Level: Main
- Area: 180 Square Feet
- Dimensions: 12 x 15
Bedroom 3
- Description: Wood
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12 x 12
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 165 Square Feet
- Dimensions: 11 x 15
Bedroom 5
- Description: Carpet
- Level: Basement
- Area: 180 Square Feet
- Dimensions: 12 x 15
Dining room
- Description: Wood
- Level: Main
- Area: 168 Square Feet
- Dimensions: 12 x 14
Family room
- Description: Carpet
- Level: Basement
- Area: 588 Square Feet
- Dimensions: 21 x 28
Kitchen
- Description: Wood
- Level: Main
- Area: 266 Square Feet
- Dimensions: 14 x 19
Laundry
- Description: Tile
- Level: Main
- Area: 64 Square Feet
- Dimensions: 8 x 8
Living room
- Description: Wood
- Level: Main
- Area: 357 Square Feet
- Dimensions: 17 x 21
Recreation room
- Description: Carpet
- Level: Basement
- Area: 600 Square Feet
- Dimensions: 30 x 20
Heating
- Forced Air, Humidity Control, 2 or more H20 Heaters
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Natural Woodwork, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings, Beamed Ceilings, Crown Molding, Split Bedroom Plan, In-Law Floorplan
- Flooring: Wood
- Doors: French Doors
- Windows: Window Coverings
- Basement: Partially Finished,Walk-Out Access,Built-In Radon,Radon Test Available,Sump Pump
- Has fireplace: Yes
- Fireplace features: Gas, Gas Log, Living Room, Family Room, Great Room
Interior area
- Total structure area: 2,705
- Total interior livable area: 5,410 sqft
- Finished area above ground: 2,705
Property
Parking
- Total spaces: 4
- Parking features: Garage Door Opener, Attached, >8' Garage Door, Oversized
- Attached garage spaces: 4
- Details: Attached
Accessibility
- Accessibility features: Near Bus, Low Carpet, Accessible Doors, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
- Exterior features: Sprinkler System, Balcony
- Has view: Yes
- View description: Hills, Plains View, City, Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 0.42 Acres
- Features: Cul-De-Sac, Corner Lot, Wooded, Evergreen Trees, Deciduous Trees, Native Plants, Rolling Slope, Sloped, Unincorporated, Paved, Fire Hydrant within 500 Feet
Details
- Parcel number: R1629558
- Zoning: PD
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Legal Conforming,Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Cedar
- Foundation: Structural Floor
- Roof: Composition
Condition
- New construction: No
- Year built: 2021
Utilities & green energy
- Electric: PV REA
- Gas: Xcel
- Sewer: Public Sewer
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Green energy
- Energy efficient items: Southern Exposure, Windows, Doors, High Efficiency Furnace, Thermostat
Community & HOA
Community
- Features: Park
- Security: Security System, Fire Alarm
- Subdivision: Hay Wagon Planned Dev
HOA
- Has HOA: Yes
- Services included: Snow Removal, Management
- HOA fee: $650 annually
- HOA name: Oneway Community Management
- HOA phone: 970-515-5004
Location
- Region: Loveland
Financial & listing details
- Price per square foot: $273/sqft
- Tax assessed value: $863,000
- Annual tax amount: $6,133
- Date on market: 4/15/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Electric utility on property: Yes
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 5/8/2026 | Sold | $1,475,000-1%$273/sqft |
Source:  IRES as distributed by MLS GRID #1056526 Report a problem | ||
| 4/20/2026 | Pending sale | $1,490,000$275/sqft |
Source:  REcolorado as distributed by MLS GRID #1942294 Report a problem | ||
| 4/15/2026 | Price change | $1,490,000-5.4%$275/sqft |
Source: REcolorado as distributed by MLS GRID #1942294 Report a problem | ||
| 3/17/2026 | Listed for sale | $1,575,000$291/sqft |
Source: REcolorado as distributed by MLS GRID #1942294 Report a problem | ||
| 3/16/2026 | Pending sale | $1,575,000$291/sqft |
Source: REcolorado as distributed by MLS GRID #1942294 Report a problem | ||
| 3/12/2026 | Price change | $1,575,000-6%$291/sqft |
Source: REcolorado as distributed by MLS GRID #1942294 Report a problem | ||
| 2/20/2026 | Listed for sale | $1,675,000-6.4%$310/sqft |
Source: IRES as distributed by MLS GRID #1051774 Report a problem | ||
| 8/6/2025 | Listing removed | $1,790,000$331/sqft |
Source: IRES as distributed by MLS GRID #1033284 Report a problem | ||
| 5/7/2025 | Price change | $1,790,000-5.3%$331/sqft |
Source: IRES as distributed by MLS GRID #1033284 Report a problem | ||
| 1/23/2025 | Listed for sale | $1,890,000-1.5%$349/sqft |
Source: IRES as distributed by MLS GRID #1025035 Report a problem | ||
| 10/1/2024 | Listing removed | $1,919,000$355/sqft |
Source: IRES as distributed by MLS GRID #1013633 Report a problem | ||
| 8/9/2024 | Price change | $1,919,000-0.4%$355/sqft |
Source: IRES as distributed by MLS GRID #1013633 Report a problem | ||
| 7/5/2024 | Listed for sale | $1,927,000-1.2%$356/sqft |
Source: IRES as distributed by MLS GRID #1013633 Report a problem | ||
| 7/2/2024 | Listing removed | $1,950,000$360/sqft |
Source: IRES as distributed by MLS GRID #1004700 Report a problem | ||
| 4/15/2024 | Price change | $1,950,000-1.3%$360/sqft |
Source: IRES as distributed by MLS GRID #1004700 Report a problem | ||
| 3/8/2024 | Listed for sale | $1,975,000+1134.4%$365/sqft |
Source: IRES as distributed by MLS GRID #1004700 Report a problem | ||
| 8/2/2019 | Listing removed | $160,000$30/sqft |
Source: Windermere Fort Collins, LLC #7040655 Report a problem | ||
| 6/12/2019 | Pending sale | $160,000$30/sqft |
Source: Windermere Fort Collins, LLC #7040655 Report a problem | ||
| 6/12/2019 | Listed for sale | $160,000+18.5%$30/sqft |
Source: Windermere Fort Collins, LLC #7040655 Report a problem | ||
| 9/4/2018 | Sold | $135,000-15.6%$25/sqft |
Source: Public Record Report a problem | ||
| 1/26/2018 | Listed for sale | $160,000+14.4%$30/sqft |
Source: Windermere Fort Collins #840430 Report a problem | ||
| 7/3/2009 | Listing removed | $139,900$26/sqft |
Source: NRT Denver #575125 Report a problem | ||
| 7/14/2008 | Listed for sale | $139,900-4.8%$26/sqft |
Source: NRT Denver #575125 Report a problem | ||
| 8/10/2005 | Sold | $147,000$27/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $6,133 -6.6% | $53,938 -14% |
| 2024 | $6,563 +49.1% | $62,719 -1% |
| 2023 | $4,401 +18.7% | $63,328 +56.3% |
| 2022 | $3,709 +0.8% | $40,525 +18.4% |
| 2021 | $3,681 +1.4% | $34,213 -12.6% |
| 2020 | $3,628 -35.4% | $39,150 |
| 2019 | $5,617 | $39,150 -32.5% |
| 2018 | $5,617 | $58,000 |
| 2017 | $5,617 +13.3% | $58,000 +9.3% |
| 2016 | $4,958 +7.1% | $53,070 |
| 2015 | $4,631 +104.6% | $53,070 +110.3% |
| 2014 | $2,264 | $25,230 |
| 2013 | -- | $25,230 -6.5% |
| 2012 | -- | $26,970 |
| 2011 | -- | $26,970 -32.3% |
| 2010 | -- | $39,850 |
| 2009 | -- | $39,850 +14.5% |
| 2008 | -- | $34,800 |
| 2007 | -- | $34,800 +31.3% |
| 2006 | -- | $26,510 +219.4% |
| 2005 | -- | $8,300 |
Find assessor info on the county website
Neighborhood: 80537
Nearby homes
- $500-- bd-- ba-- sqft4766 Single Tree Dr, Loveland, CO 80537Off Market
- $1,232,6004 bd3 ba5.4k sqft4779 Hay Wagon Ct, Loveland, CO 80537Off Market
- $881,8003 bd3 ba3.5k sqft4820 Hay Wagon Ct, Loveland, CO 80537Off Market
- $1,100,0005 bd4 ba2.9k sqft4778 Hay Wagon Ct, Loveland, CO 80537Sold
- $968,0004 bd5 ba4.2k sqft4881 Single Tree Dr, Loveland, CO 80537Off Market
- $621,4004 bd2 ba1.5k sqft4710 14th St SW, Loveland, CO 80537Off Market
- $956,4005 bd4 ba4.3k sqft4903 Single Tree Dr, Loveland, CO 80537Off Market
- $925,0003 bd4 ba4.4k sqft4880 Single Tree Dr, Loveland, CO 80537Sold
Nearby schools
GreatSchools rating
- 4/10Namaqua Elementary SchoolGrades: K-5Distance: 1.5 mi
- 5/10Walt Clark Middle SchoolGrades: 6-8Distance: 1.8 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 2.5 mi
Schools provided by the listing agent
- Elementary: Namaqua
- Middle: Walt Clark
- High: Thompson Valley
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,465,500
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,465,500
- Colorado
- Larimer County
- Loveland
- 80537
- 4821 Hay Wagon Ct
Nearby cities
Nearby zip codes
Other Loveland Topics
