Metro Denver Luxury Homes For Sale

Property Description

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.

Features
: Forced Air
: Central Air, Ceiling Fan(s)
: Full, Unfinished, Bath/Stubbed
: Mountain(s)
: Gas, Gas Log, Living Room, Other, Dining Room
: Smoke Detector(s), Fire Alarm
: Patio
: 3
: Dryer, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Oven
: Trail(s)
: Heated Garage, Oversized, Tandem, Oversized Door, RV Access/Parking
: Composition
: Public Sewer
Address Map
CO
Larimer
Loveland
80537
Two Moons
152
Drive
W106° 50' 51.9''
N40° 23' 36.1''
Additional Information
$1,450
Annually
: Reserves
: Frame, Stone, Stucco
Namaqua
: Balcony
: Laminate, Wood
3
Thompson Valley
: Pantry, Open Floorplan, Kitchen Island, Eat-in Kitchen, Vaulted Ceiling(s), Walk-In Closet(s)
Yes
Yes
Cash, Conventional
: Level, Corner Lot, Sprinklers In Front
Other
Elevations Real Estate, LLC
R1644156
: House
Overlook At Mariana 1st Sub Lov
$4,693
2024
: Cable Available, Electricity Available, Natural Gas Available, Internet Access (Wired)
: Double Pane Windows, Window Coverings
R1
01/08/2026
4582
Active
Yes
1
Thompson R2-J
Thompson R2-J
In Unit
01/09/2026
Residential
01/09/2026
Public
: Two, One

Overlook At Mariana 1st Sub Lov

152 Two Moons Drive, Loveland, CO 80537

3 Bedrooms
4 Total Baths
2,726 Square Feet
$950,000
Listing ID #IR1049223
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : IR1049223
Price : $950,000
Bedrooms : 3
Rooms : 12
Total Baths : 4
Full Bathrooms : 2
3/4 Bathrooms : 1
1/2 Bathrooms : 1
Square Footage : 2,726 Square Feet
Year Built : 2008
Lot Acres : 0.21
Property Sub Type : Single Family Residence
Status : Active
Originating System Name : REcolorado
Mortgage Calculator
$
$ %
years
%
$ %per year
$ %per year

$
Contact Agent
Open Dates
  • 1. 2026-01-10 (Start time: 2026-01-10T18:00:00Z - End time: 2026-01-10T21:00:00Z)