• Sign Up
  • Log In
Shawn Holmes | Group Centerra
Shawn Holmes
(970) 301-2598sholmes@thegroupinc.com
  • Home
  • Communities
    • Larimer County
    • Weld County
    • Boulder County
    • Loveland
    • Windsor
    • Fort Collins
    • Johnstown
    • Berthoud
  • Buying
    • Buying Info
    • Mortgage Calculator
  • Selling
    • Selling Info
    • Home Valuation
  • Heros
  • About
    • Learn More
    • Meet Shawn
    • Our Testimonials
  • Contact
  • Shawn Holmes(970) 301-2598
    sholmes@thegroupinc.com
    Copy Email
  • 5401 Stone Creek Cir
    Loveland, CO 80538

Home

  • Home
  • Communities
  • Buying
  • Selling
  • Heros
  • About
  • Contact
Shawn Holmes | Group Centerra - Footer Logo
  • Notice of Exclusive Property Listing
  • Notice of Exclusive Property Listing
  • Privacy
  • Terms
  • DMCA
  • Accessibility
  • Fair Housing
© 2026 The Group, Inc. All rights reserved.
Website built by CloseHack.
Information and Real Estate Services, LLC

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES. Information deemed reliable but not guaranteed by the MLS. The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

$950,000
Coming Soon

152 Two Moons Drive

Loveland, CO 80537
2726 sqft | 3 beds | 2.5 baths | 0.21 acres | #1049223
  • Save
  • Contact
  • Share
  • Price Change Alerts
Listing OfficeZADEL REALTY
43 photos
Type:Purchase
Structure:House
Zone:Residential

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.

  • Property Details
      • InteriorStudy Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorpl
      • Lot DescriptionCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level, Within City Limits
      • Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
      • Utility SourceDistrict Water, Little Thompson
      • SubdivisionOverlook At Mariana 1st Sub Lov
      • ViewMountain(s), Foothills View
      • Property SubtypeResidential-Detached
      • Exterior MaterialsLighting, Balcony
      • BasementFull, Unfinished
      • High SchoolThompson Valley
      • Sewer InformationCity Sewer
      • Middle SchoolWalt Clark
      • Property TypePurchase
      • Elementary SchoolNamaqua
      • CountyLarimer
      • MLS #1049223
      • MLS #1049223
      • Cost950000
      • Acres0.21
      • Square Feet2726
      • Year Built2008
      • Hoa Fees1450
      • Bathrooms2.5
      • Bedrooms3
      • Full Baths2
      • Half Baths1
      • Parking Spaces3

Location

Legal

Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES. Information deemed reliable but not guaranteed by the MLS. The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. 

Last Updated: Today at 12:36 PM. Source: IRES

Provided By
Listing Agent: Lisa Young (#P17892), Phone: (970) 535-2000
Listing Office: ZADEL REALTY (#ELVRE)

Shawn Holmes | Group CenterraReal Estate Group
Facebook
Google
OR