970.232.4844
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Loveland » 80537 » 4821 Hay Wagon Ct, Loveland, CO, 80537
$1,675,000

4821 Hay Wagon Ct, Loveland, CO, 80537

5 Beds
5 Baths
4,993 Square Feet

Open House

February 28 1:00 pm - 3:00 pm

Open House Sat 2/28 1-3pm & Sun 3/1 12-3pm. 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. For a full list of features, floor plan, or to schedule a showing, please contact the brokers.
Offered By
John Simmons, C3 Real Estate Solutions, LLC

Property Details

Property Type Residential
Status Active
Bedrooms 5
Bathrooms (Full) 1
Property Sub Type Single Family Residence
Square Feet 4,993
MLS # 1051774
Bathrooms (¾) 3
Bathrooms (Half) 1

Market Trends

New Properties On Market
65
171% Increase In New Listings
Average Asking Price
$585,654
$319,051 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$277
$156 Decrease In List Price/Sq. Ft.
Average Days On Market
29
34 Day Decrease In Days On Market
Data as of Feb 27, 2026. Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 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

196 Mule Deer Dr, Loveland, CO 80537 Listing Photo  1
$1,850,000
196 Mule Deer Dr
Loveland, CO
3 Beds
|
4 Baths
|
4,317 Square Feet
Offered By Eric Lewis Coldwell Banker Realty-NOCO
1601 E 1st St, Loveland, CO 80537 Listing Photo  1
$1,750,000
1601 E 1st St
Loveland, CO
2 Beds
|
2 Baths
|
1,233 Square Feet
Offered By Kristin Snow Group Centerra
2712 S County Road 29, Loveland, CO 80537 Listing Photo  1
$1,739,000
2712 S County Road 29
Loveland, CO
3 Beds
|
3 Baths
|
3,515 Square Feet
Offered By Patricia Phillips Group Mulberry
555 James Park Trl, Loveland, CO 80537 Listing Photo  1
$1,695,000
555 James Park Trl
Loveland, CO
4 Beds
|
5 Baths
|
4,338 Square Feet
Offered By Doug Card RE/MAX Alliance-FTC South