Lake Homes Realty
Enter City, Zip or MLS

4821 hay wagon ct

Loveland, CO 80537

$1,575,000

5 BEDS 5 BATHS
4,993 SQFT18121 AC LOT
Residential - Single Family
New Listing
Image 1: Location Location Location and offering incredible views of Boedecker Lake, the Rocky Mountains and of Nature
Image 2: Hard to find, custom and luxurious ranch style home
Image 3: Must see this home to truly appreciate how peaceful it is.
Image 4: Cul-De-Sac, corner lot and backs to open space
Bedrooms 5
Total Baths 5
Full Baths 1
Square Feet 4993
Acreage 18121
Status Active
MLS # 1053610
County Larimer
More Info
Category Residential - Single Family
Status Active
Square Feet 4993
Acreage 18121
MLS # 1053610
County Larimer
Open House Sat 3/14 1-4pm & Sun 3/15 from 1-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.
Location not available

Exterior Features

  • Style In-Law Area, Legal Conforming, Contemporary
  • Construction Single Family Residence
  • Siding Frame, Stone, Cedar
  • Exterior Sprinkler System, Balcony, ">8 Garage Door", Oversized Garage
  • Roof Composition
  • Garage Yes
  • Garage Description Garage Door Opener, Attached
  • Sewer Public Sewer
  • Lot Description Cul-De-Sac, Corner Lot, Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Rolling Lot, Sloping Lot, House Faces South, Unincorporated, Paved, Fire Hydrant within 500 Feet

Interior Features

  • Appliances Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal, Fire Alarm
  • Heating Forced Air, Humidity Control, 2 or more H20 Heaters
  • Cooling Central Air, Ceiling Fan(s)
  • Basement Partially Finished, Walk-Out Access, Structural Floor, Built-In Radon, Radon Test Available, Sump Pump
  • Fireplaces 1
  • Fireplaces Description Gas, Gas Log, Living Room, Family Room, Great Room
  • Living Area 4,993 SQFT
  • Year Built 2021

Neighborhood & Schools

  • Subdivision Hay Wagon Planned Dev
  • Elementary School Namaqua
  • Middle School Walt Clark
  • High School Thompson Valley

Financial Information

  • Parcel ID R1629558
  • Zoning PD

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of null - (970) 481-1250
Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 03/14/2026 04:21:02 UTC. 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.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 IRESDS MLS, Inc.
Listing data is current as of 03/14/2026.

Contact Our Agent

By clicking “Submit”, you agree that Lake Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.