Lake Homes Realty
Enter City, Zip or MLS

152 two moons dr

Loveland, CO 80537

$950,000

3 BEDS 2-Full 1-Half 1-¾ BATHS
2,726 SQFT0.2 AC LOT
Residential - Single Family
Image 1
Image 2
Image 3
Image 4
Bedrooms 3
Total Baths 3
Full Baths 2
Square Feet 2726
Acreage 0.21
Status Active
MLS # 1049223
County Larimer
More Info
Category Residential - Single Family
Status Active
Square Feet 2726
Acreage 0.21
MLS # 1049223
County Larimer
Built for an active Colorado lifestyle, this luxury home in gated Overlook at Mariana features an oversized RV garage and effortless main-level living- offering a true "stay & play" or "lock & leave" experience. Just minutes from golf, trails, and mountain recreation. This 3-bedroom, 4-bath home offers an exceptional open floor plan, vaulted ceilings, and quality finishes throughout. The oversized (1107 sqft) 3-bay attached garage includes an RV bay, perfect for RV, boat, or recreational storage.The main level is designed for easy living and entertaining. A dramatic double-sided stone gas fireplace connects the kitchen/dining with the living room, which boasts vaulted and beamed ceilings. The open kitchen includes wood floors, a large island, pantry, eat-in dining space, and gas stove. Main floor also includes a spacious primary suite with luxury bath and huge walk-in closet, a large laundry room with sink and cabinetry, and an additional bedroom or office with its own full bathroom. Upstairs offers a loft or office, private bedroom and balcony with mountain views and full bathroom. Unfinished basement provides excellent storage or future expansion. Additional features -- 2 central A/Cs & high-efficiency furnaces, double-pane windows, safety storm doors, oversized RV/boat garage. The home lives like a patio home with a low-maintenance yard, sprinkler system, and private patio. Perfect home for those who travel or want minimal upkeep. Situated within a gated, "Stay & Play" community offering walking trails, common areas, and a serene setting close to Mariana Butte Golf Course, lakes, and Northern Colorado recreation. A rare blend of custom quality, main-level living, and true lock-and-leave convenience in Northern Colorado. Conveniently positioned for exploring Northern Colorado, with scenic drives to Fort Collins or Longmont (30 min each), Estes Park (40 min), Boulder (50 min), and Denver (approximately 1 hour). See Video Walk-through.
Location not available

Exterior Features

  • Construction Single Family
  • Siding Wood/Frame, Stone, Stucco
  • Exterior Lighting, Balcony
  • Roof Composition
  • Garage Yes
  • Garage Description 3
  • Water District Water, Little Thompson
  • Sewer City Sewer
  • Lot Description Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Within City Limits

Interior Features

  • Appliances Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Heating Forced Air, 2 or more Heat Sources
  • Cooling Central Air, Ceiling Fan(s)
  • Basement Full, Unfinished
  • Fireplaces Description Gas, Gas Logs Included, Double Sided, Living Room, Dining Room
  • Living Area 2,726 SQFT
  • Year Built 2008
  • Stories 1

Neighborhood & Schools

  • Subdivision Overlook At Mariana 1st Sub Lov
  • Elementary School Namaqua
  • Middle School Walt Clark
  • High School Thompson Valley

Financial Information

  • Parcel ID R1644156
  • Zoning R1

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Elevations Real Estate, LLC - (970) 535-2000
Copyright 2026, Information and Real Estate Services, LLC, Colorado. All information provided is deemed reliable but is not guaranteed and should be independently verified.
Listing data is current as of 02/05/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.