152 Two Moons Dr, Loveland, CO 80537
- Beds
- 3
- Baths
- 4
- Sqft
- 2,726
- Garage
- Yes
View property features, location on map, relevant school information and overview from seller's agent.
- 3
- 0
Overview
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
Full feature list
Basic info
- Property type
- House
- Number of bedrooms
- 3
- Number of bathrooms
- 4
- Square feet
- 2,726
- Lot size (acres)
- 0.21
- Year built
- 2008
Interior features
- Basement
- Yes, Unfinished
Exterior features
- Area amenities
- Gated Community
Garage and parking
- Garage parking spaces
- 3
Utilities
- Heating
- Forced air
- Cooling
- Central air, Ceiling fan(s)
- Sewer
- Public sewer
- Water
- Public
Estimated monthly costs
- HOA Fees
- $125
Taxes
- Tax Annual Amount (2024)
- $4,693
Public schools
Disclaimer: Certain information displayed on this listing has been derived from parties other than Final Offer, LLC. Information provided and their sources have been deemed reliable, but accuracy of information is not guaranteed and therefore should be independently verified.
Sourced from: IRES MLS MLS®#: 1049223 Last checked: …

Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. Copyright © IRES. Broker Reciprocity is the current compilation of active listings of all Broker Reciprocity subscribers except those listings where the seller or the seller's agency has opted out of Internet publication by so indicating on the listing contract or by written notice to the Multiple Listing Service. Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user, Information deemed reliable but not Guaranteed. Information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Copyright ©2026 Information and Real Estate Services, LLC. All rights reserved.