152 Two Moons Dr, Loveland, CO 80537

$910,000
3
BD
4
BA
2,726
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Courtesy of Elevations Real Estate, LLC . 9705352000

Selling Office: C3 Real Estate Solutions, LLC.

Sold Price
$910,000
List Price
$939,000
Closing Date
Apr 08, 2026
Type
Single Family Residential
Status
CLOSED
MLS Number
IR1049223
Bedrooms
3
Bathrooms
4
Finished Sqft
2,726
Subdivision
Overlook At Mariana 1st Sub Lov
Year Built
2008

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.

Additional Information

Taxes
$4,693
School District
Thompson R2-J
Elementary School
Namaqua
Middle School
Other
High School
Thompson Valley
Parking Spaces
3
Basement
Bath/Stubbed, Full, Unfinished
Total HOA Fees
$1,500
HOA Frequency
Annually
Fee Includes
Reserve Fund
Type
Single Family Residence
Sewer
Public Sewer
Lot Size
9,273
Acres
0.21
Water
Public
View
Mountain(s)

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks


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 eXp Realty 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. IDX Terms and Conditions