Lake Homes Realty
Enter City, Zip or MLS

152 two moons drive

Loveland, CO 80537

$950,000

3 BEDS 4 BATHS
2,726 SQFT
Residential - Single Family
Image 1: 152 Two Moons Drive in the Overlook at Mariana in western Loveland Colorado, a gated community close to outdoor activities and reflects nature in architecture and style.
Image 2: 152 Two Moons Dr, Loveland CO - a beautiful 3 bed, 4 bath home with garage for cars, RVs or Boats.
Image 3: Gorgeous Open Floorplan.  Living Room boasts double-sided gas fireplace, built-in cabinetry, oversized windows and vaulted, beamed ceiling.
Image 4: Welcome Home!  Comfort and Luxury meet in this West Loveland CO home.
Bedrooms 3
Total Baths 4
Full Baths 2
Square Feet 2726
Status Active
MLS # IR1049223
County Larimer
More Info
Category Residential - Single Family
Status Active
Square Feet 2726
MLS # IR1049223
County Larimer
Listed By: Listing Agent Lisa Young
Elevations Real Estate, LLC - (970) 535-2000
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 Residence
  • Siding Stone, Stucco, Frame
  • Exterior Balcony
  • Roof Composition
  • Garage Yes
  • Garage Description Heated Garage, Oversized, Oversized Door, RV Access/Parking, Tandem
  • Water Public
  • Sewer Public Sewer
  • Lot Description Corner Lot, Level, Sprinklers In Front

Interior Features

  • Appliances Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
  • Heating Forced Air
  • Cooling Ceiling Fan(s), Central Air
  • Fireplaces Description Dining Room, Gas, Gas Log, Living Room, Other
  • Living Area 2,726 SQFT
  • Year Built 2008

Neighborhood & Schools

  • Subdivision Overlook At Mariana 1st Sub Lov
  • Elementary School Namaqua
  • Middle School Other
  • 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
Listings courtesy of the RE Colorado MLS as distributed by MLS GRID.

IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interestedin purchasing, that the data 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 02/05/2026 04:38:09 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 RE Colorado MLS, Inc.
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.