303-409-4455

The Brian Petrelli Team HUD Metro Brokers

loveland Real Estate Team

Local Experts for loveland Homes

	SEARCH HOMES	BUYERS	SELLERS	LOW DOWN PAYMENT MORTGAGES	About Us	HOA INFO	LOGIN

152 two moons drive loveland, CO 80537

Image #0 for 152 two moons drive,loveland, Colorado

MLS Image #0 for 152 two moons drive,loveland, Colorado

Image #1 for 152 two moons drive,loveland, Colorado

MLS Image #1 for 152 two moons drive,loveland, Colorado

Image #2 for 152 two moons drive,loveland, Colorado

MLS Image #2 for 152 two moons drive,loveland, Colorado

Image #3 for 152 two moons drive,loveland, Colorado

MLS Image #3 for 152 two moons drive,loveland, Colorado

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

Image #4 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

< >

Virtual Tour Available
Login To View

Sold

What is my home worth?

Sold On: 2026-04-08
But Similar Homes Are Available:
loveland Homes For Sale

Click on Photo For Larger Image

MLS Image #0 for 152 two moons drive,loveland, Colorado

Click on Photo For Larger Image

MLS Image #1 for 152 two moons drive,loveland, Colorado

Click on Photo For Larger Image

MLS Image #2 for 152 two moons drive,loveland, Colorado

There are 47 more photos to see.
To view all photos, login here. or Register for Free in 15 Seconds.

$939,000

Beds: 3
Baths: 4
Fin SqFt: 2726
MLS Number:
IR1049223

Calculate Mortgage Payment
Est. $5,717 / month

What's My Home Worth?

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.

Status: Closed

Listing Office:
elevations real estate, llc

Interior Features:

Eat-in Kitchen
Kitchen Island
Open Floorplan
Pantry
Vaulted Ceiling(s)
Walk-In Closet(s)

Exterior Features:

Balcony

Site Features:

Corner Lot
Level
Sprinklers In Front

School Information
Elementary School: Login to display
Jr High / Middle School: Login to display
Sr High School: Login to display
Get School Reports.

Login for Details or Register for Free in 15 Seconds.

HOA Information & Taxes

Taxes: Login to display

HOA Fees: Login to display
Fees Quoted: Login to display
Mulitple HOA's: Login to display
Fees Include: Login to display

HOA Name: Login to display
Subdivision: Login to display

Login for Details or Register for Free in 15 Seconds.

Square Footage Information

Square Footage Details:
Finshed Square Feet: Login to display
Lower Square Feet: Login to display
Main Square Feet: Login to display
Upper Square Feet: Login to display
Basement Square Feet: Login to display

Basement Type: Login to display
Basement Finished: Login to display
Basement Size: Login to display

Acres: Login to display

Login for Details or Register for Free in 15 Seconds.

Construction Information

Property Type: Login to display

Construction Style: Login to display
Construction Details: Login to display
Construction Year: Login to display
Construction Materials: Login to display
Construction Methods: Login to display

Number of Fireplaces: Login to display
Fireplace Locations: Login to display
Fireplace Features: Login to display

Faces: Login to display

Horses: Login to display
Horse Property Features: Login to display

Car Storage: Login to display
Spaces: Login to display
Heat Type: Login to display

Login for Details or Register for Free in 15 Seconds.

Want to schedule a private showing on this home or another home in loveland? Call us at 303-726-1874 or email us at properties@petrelliteam.com.

Still Have Questions? Ask our team a question and get a fast response between 8 a.m. and 8 p.m.
Question:
or Specific Question:

Your Email:

The Brian Petrelli Team is your Overlook At Mariana 1st Sub Lov, loveland home specialist.

Our team of local loveland experts have over 200 years of combined expertise in the Colorado Real Estate market. Give us a call today to put our knowledge and experience to work for you as you buy or sell your next Overlook At Mariana 1st Sub Lov home.

Don't see what you're looking for here? Contact our team for a free, custom search.

The Brian Petrelli Team
Phone: 303-726-1874
properties@petrelliteam.com

Click here to create your own custom home search. You will be able to search every loveland home currently on the market.

Search For Nearby Homes:

See All Homes For Sale in 80537 Zip Code

See More Homes For these Schools:

More loveland Home Searches:

Homes Near 152 Two Moons Drive Loveland, Co 80537

509 w 5th street
loveland 80537
Status: Pending

$800,000.00
Beds: 3 Baths: 3

5275 cedar valley drive
loveland 80537
Status: Pending

$1,075,000.00
Beds: 5 Baths: 5

5418 nantucket court
loveland 80537
Status: Pending

$849,900.00
Beds: 4 Baths: 4

214 n cove drive
loveland 80537
Status: Active

$1,125,000.00
Beds: 4 Baths: 4

503 eagle crest court
loveland 80537
Status: Active

$999,000.00
Beds: 5 Baths: 5

5416 ferryboat court
loveland 80537
Status: Active

$985,000.00
Beds: 5 Baths: 5

Want to see more properties in Overlook At Mariana 1st Sub Lov , loveland or the surrounding areas? Email us for a full list at properties@petrelliteam.com.

The Brian Petrelli Team Group Photo

The Brian Petrelli Team Group Photo

Call us today and find out why we're leaders for Houses in loveland, Colorado and the most most qualified REALTORS in Overlook At Mariana 1st Sub Lov. We can show you any available home in loveland, Colorado and provide you with the expertise and knowledge to make sure you get the best value for your money. In addition, we have access to $0 down mortgage programs to make financing easier. Best of all, as a buyer, our services cost you nothing! What are you waiting for? Call us today!
303-726-1874

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 The Brian Petrelli Team 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.

Denver Area Foreclosure and HUD House Searches:
Aurora Foreclosures and HUD Homes, Arvada Foreclosures and HUD Homes, Brighton Foreclosures and HUD Homes, Broomfield Foreclosures and HUD Homes, Castle Rock Foreclosures and HUD Homes, Centennial Foreclosures and HUD Homes, Commerce City Foreclosures and HUD Homes, Denver Foreclosures and HUD Homes, Englewood Foreclosures and HUD Homes, Frederick Foreclosures and HUD Homes, Firestone Foreclosures and HUD Homes, Golden Foreclosures and HUD Homes, Henderson Foreclosures and HUD Homes, Highlands Ranch Foreclosures and HUD Homes, Lakewood Foreclosures and HUD Homes, Littleton Foreclosures and HUD Homes, Lone Tree Foreclosures and HUD Homes, Longmont Foreclosures and HUD Homes, Northglenn Foreclosures and HUD Homes, Parker Foreclosures and HUD Homes, Thornton Foreclosures and HUD Homes, Westminster Foreclosures and HUD Homes
Denver Area Luxury Foreclosure and Luxury HUD House Searches:
Denver Area Luxury Foreclosures, Aurora Luxury Foreclosures, Arvada Luxury Foreclosures, Brighton Luxury Foreclosures, Broomfield Luxury Foreclosures, Castle Rock Luxury Foreclosures, Centennial Luxury Foreclosures, Commerce City Luxury Foreclosures, Denver Luxury Foreclosures, Englewood Luxury Foreclosures, Golden Luxury Foreclosures, Highlands Ranch Luxury Foreclosures, Lakewood Luxury Foreclosures, Littleton Luxury Foreclosures, Northglenn Luxury Foreclosures, Parker Luxury Foreclosures, Thornton Luxury Foreclosures, Westminster Luxury Foreclosures
Denver Area Distressed Properties and Fix and Flip Homes:
Aurora Distressed Properties, Arvada Distressed Properties, Brighton Distressed Properties, Broomfield Distressed Properties, Castle Rock Distressed Properties, Centennial Distressed Properties, Commerce Distressed Properties, Denver Distressed Properties, Englewood Distressed Properties, Golden Distressed Properties, Highlands Ranch Distressed Properties, Lakewood Distressed Properties, Littleton Distressed Properties, Northglenn Distressed Properties, Parker Distressed Properties, Thornton Distressed Properties, Westminster Distressed Properties
Denver Area Condo Searches:
Aurora Condos and Townhomes, Arvada Condos and Townhomes, Brighton Condos and Townhomes, Broomfield Condos and Townhomes, Castle Rock Condos and Townhomes, Centennial Condos and Townhomes, Commerce City Condos and Townhomes, Denver Condos and Townhomes, Englewood Condos and Townhomes, Golden Condos and Townhomes, Highlands Ranch Condos and Townhomes, Lakewood Condos and Townhomes, Littleton Condos and Townhomes Northglenn Condos and Townhomes, Parker Condos and Townhomes, Thornton Condos and Townhomes, Westminster Condos and Townhomes,
Denver Area Home Searches:
Homes for sale Aurora colorado, Homes for sale Arvada colorado, Homes for sale Brighton colorado, Homes for sale Broomfield colorado, Homes for sale Castle Rock colorado, Homes for sale Centennial colorado, Homes for sale Commerce City colorado, Homes for sale Denver colorado, Homes for sale Englewood colorado, Homes for sale in Firestone Colorado, Homes for sale in Frederick Colorado, Homes for sale Golden colorado, Homes for sale in Henderson Colorado, Homes for sale Highlands Ranch colorado, Homes for sale Lakewood colorado, Homes for sale Littleton colorado, Homes for sale Lone Tree colorado, Homes for sale in Longmont Colorado, Homes for sale Northglenn colorado, Homes for sale Parker colorado, Roxborough Park Homes for Sale, Homes for sale Thornton colorado, Homes for sale Westminster colorado, Denver Area Homes by Zip Code
Denver Area Short Sales House Searches:
Aurora Short Sale Homes, Arvada Short Sale Homes, Brighton Short Sale Homes, Broomfield Short Sale Homes, Castle Rock Short Sale Homes, Centennial Short Sale Homes, Commerce City Short Sale Homes, Denver Short Sale Homes, Englewood Short Sale Homes, Golden Short Sale Homes, Highlands Ranch Short Sale Homes, Lakewood Short Sale Homes, Littleton Short Sale Homes, Northglenn Short Sale Homes, Parker Short Sale Homes, Thornton Short Sale Homes, Westminster Short Sale Homes
Denver Area Short Sales Condo and Townhome Searches:
Aurora Short Sale Condos and Townhomes, Arvada Short Sale Condos and Townhomes, Brighton Short Sale Condos and Townhomes, Broomfield Short Sale Condos and Townhomes, Castle Rock Short Sale Condos and Townhomes, Centennial Short Sale Condos and Townhomes, Commerce City Short Sale Condos and Townhomes, Denver Short Sale Condos and Townhomes, Englewood Short Sale Condos and Townhomes, Golden Short Sale Condos and Townhomes, Highlands Ranch Short Sale Condos and Townhomes, Lakewood Short Sale Condos and Townhomes, Littleton Short Sale Condos and Townhomes, Northglenn Short Sale Condos and Townhomes, Parker Short Sale Condos and Townhomes, Thornton Short Sale Condos and Townhomes, Westminster Short Sale Condos and Townhomes
Denver Area Luxury Homes Searches:
Denver Area Luxury Homes, Aurora Luxury Homes, Arvada Luxury Homes, Brighton Luxury Homes, Broomfield Luxury Homes, Castle Rock Luxury Homes, Centennial Luxury Homes, Commerce City Luxury Homes, Denver Luxury Homes, Englewood Luxury Homes, Golden Luxury Homes, Highlands Ranch Luxury Homes, Lakewood Luxury Homes, Littleton Luxury Homes, Northglenn Luxury Homes, Parker Luxury Homes, Thornton Luxury Homes, Westminster Luxury Homes
Denver Area New Houses
New Homes in Aurora , New Homes in Arvada , New Homes in Castle Rock , New Homes in Centennial , New Homes in Denver , New Homes in Englewood , New Homes in Golden , New Homes in Highlands Ranch , New Homes in Lakewood , New Homes in Littleton , New Homes in Parker , New Homes in Thornton , New Homes in Westminster
Denver Area New Condos and Townhomes
New Condos and Townhomes in Aurora , New Condos and Townhomes in Arvada , New Condos and Townhomes in Castle Rock , New Condos and Townhomes in Centennial , New Condos and Townhomes in Denver , New Condos and Townhomes in Englewood , New Condos and Townhomes in Golden , New Condos and Townhomes in Highlands Ranch , New Condos and Townhomes in Lakewood , New Condos and Townhomes in Littleton , New Condos and Townhomes in Parker , New Condos and Townhomes in Thornton , New Condos and Townhomes in Westminster
Colorado Springs Houses:
Calhan Homes for Sale Colorado Springs Homes for Sale Divide Homes for Sale Elbert Homes for Sale Florissant Homes for Sale Fountain Homes for Sale Larkspur Homes for Sale Manitou Springs Homes for Sale Monument Homes for Sale Peyton Homes for Sale Pueblo Homes for Sale Woodland Park Homes for Sale
Colorado Springs Foreclosures and HUD Home Searches:
Calhan Foreclosures and HUD Homes Colorado Springs Foreclosures and HUD Homes Divide Foreclosures and HUD Homes Elbert Foreclosures and HUD Homes Florissant Foreclosures and HUD Homes Fountain Foreclosures and HUD Homes Larkspur Foreclosures and HUD Homes Manitou Springs Foreclosures and HUD Homes Monument Foreclosures and HUD Homes Peyton Foreclosures and HUD Homes Pueblo Foreclosures and HUD Homes Woodland Park Foreclosures and HUD Homes
Google

Copyright 2026 The Brian Petrelli Team. All rights reserved.