152 Two Moons Drive, Loveland, CO 80537 (MLS # IR1049223)

Save to Favorites
Print
Share
PRICE $950,000 dsIDX morgage calculator
BEDS 3
BATHS 4
HOME SIZE 2,726 sqft
LOT SIZE 9,148 sqft

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.

DAYS ON MARKET 1 LAST UPDATED 1/8/2026
TRACT Overlook At Mariana 1st Sub Lov YEAR BUILT 2008
GARAGE SPACES 3.0 COUNTY Larimer
STATUS Active PROPERTY TYPE(S) Single Family

SCHOOLS
Elementary School Namaqua
Jr. High School Other
High School Thompson Valley


ADDITIONAL DETAILS
AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
BASEMENT Bath/Stubbed, Full, Unfinished, Yes
CONSTRUCTION Frame, Stone, Stucco
EXTERIOR Balcony
FIREPLACE Yes
GARAGE Yes
HEAT Forced Air
HOA DUES 1450|Annually
INTERIOR Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
LOT 9148 sq ft
LOT DESCRIPTION Corner Lot, Level, Sprinklers In Front, Wooded
PARKING Heated Garage, Oversized, RV Access/Parking, Tandem, Attached
SEWER Public Sewer
STORIES One, Two
SUBDIVISION Overlook At Mariana 1st Sub Lov
TAXES 4693
UTILITIES Cable Available, Electricity Available, Natural Gas Available
VIEW Yes
VIEW DESCRIPTION Mountain(s)
WATER Public
MORTGAGE CALCULATOR
   

TOTAL MONTHLY PAYMENT

0
P
I
*Estimate only

SATELLITE VIEW



 
CONTACT US ABOUT 152 TWO MOONS DRIVE
 / 
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Tower Team to contact you even if your name is on a Federal or State "Do not call List".

Listing provided by Lisa Young, Elevations Real Estate, LLC
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Compass are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

© 2011-2026 REcolorado® - All Rights Reserved. Disclaimer

This IDX solution is (c) Diverse Solutions 2026.