970.232.4844
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Loveland » 80537 » 152 Two Moons Dr, Loveland, CO, 80537
$950,000

152 Two Moons Dr, Loveland, CO, 80537

3 Beds
4 Baths
4,582 Square Feet
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.
Offered By
Lisa Young 9705352000, Elevations Real Estate, LLC

Property Details

Property Type Residential
Status Active
Bedrooms 3
Bathrooms (Full) 2
Property Sub Type Residential-Detached
Square Feet 4,582
MLS # 1049223
Bathrooms (¾) 1
Bathrooms (Half) 1

Market Trends

New Properties On Market
33
50% Increase In New Listings
Average Asking Price
$847,044
$16,361 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$323
$25 Increase In List Price/Sq. Ft.
Average Days On Market
21
22 Day Decrease In Days On Market
Data as of Jan 27, 2026. Remaining statistics above are calculated on activity within the period from Nov 01, 2025 to Dec 31, 2025.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

965 Stone Mountain Ranch Rd, Loveland, CO 80537 Listing Photo  1
$995,000
965 Stone Mountain Ranch Rd
Loveland, CO
2 Beds
|
2 Baths
|
1,987 Square Feet
Offered By Roni Froelich Group Harmony
4601 N Sunshine Ct, Loveland, CO 80537 Listing Photo  1
$975,000
4601 N Sunshine Ct
Loveland, CO
4 Beds
|
3 Baths
|
3,194 Square Feet
Offered By Bryan Sanburg NextHome Rocky Mountain
5418 Nantucket Ct, Loveland, CO 80537 Listing Photo  1
$965,000
5418 Nantucket Ct
Loveland, CO
4 Beds
|
4 Baths
|
4,279 Square Feet
Offered By Paul Schnaitter Group Centerra
Information deemed reliable but not guaranteed by the MLS. Listing information is provided exclusively 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. Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2025 IRES. Property data was last updated on 1/25/2026 at 12:34 am