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.
Sold for $910,000
$910,000
152 Two Moons Dr, Loveland, CO 80537
3beds
4,582sqft
Single Family Residence
Built in 2008
9,273 Square Feet Lot
$908,400 Zestimate®
$199/sqft
$3,594 Estimated rent
Home value
$908,400
$863,000 - $954,000
$3,594/mo
Zestimate® history
Owner options
List your home for rent
$3,594/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,594/mo
Rent Zestimate®
Refinance and save
$6,778/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,778/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Lisa Young 970-535-2000,
Elevations Real Estate, LLC
Bought with:
John Feeney, 100047965
C3 Real Estate Solutions, LLC
Source: IRES as distributed by MLS GRID,MLS#: 1049223
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 3
Primary bedroom
- Description: Carpet
- Features: 3/4 Primary Bath, Luxury Features Primary Bath
- Level: Main
- Area: 289 Square Feet
- Dimensions: 17 x 17
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12 x 12
Bedroom 3
- Description: Carpet
- Level: Upper
- Area: 224 Square Feet
- Dimensions: 14 x 16
Dining room
- Description: Wood
- Level: Main
- Area: 121 Square Feet
- Dimensions: 11 x 11
Kitchen
- Description: Wood
- Level: Main
- Area: 418 Square Feet
- Dimensions: 19 x 22
Laundry
- Description: Laminate
- Level: Main
- Area: 91 Square Feet
- Dimensions: 13 x 7
Living room
- Description: Carpet
- Level: Main
- Area: 357 Square Feet
- Dimensions: 21 x 17
Study
- Description: Carpet
- Level: Upper
- Area: 264 Square Feet
- Dimensions: 22 x 12
Heating
- Forced Air, 2 or more Heat Sources
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Workshop, Pantry, Natural Woodwork, Walk-In Closet(s), Kitchen Island, High Ceilings, Beamed Ceilings, Split Bedroom Plan
- Flooring: Wood
- Doors: 6-Panel Doors
- Windows: Window Coverings, Wood Frames
- Basement: Full,Unfinished
- Has fireplace: Yes
- Fireplace features: Gas, Gas Log, Multi-Sided, Living Room, Dining Room
Interior area
- Total structure area: 2,726
- Total interior livable area: 4,582 sqft
- Finished area above ground: 2,726
Property
Parking
- Total spaces: 3
- Parking features: Garage Door Opener, RV Access/Parking, Attached, >8' Garage Door, Heated Garage, Oversized, Tandem
- Attached garage spaces: 3
- Details: Attached
Accessibility
- Accessibility features: Level Lot, Level Drive, Low Carpet, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
- Levels: Two,One and One Half
- Stories: 2
- Patio & porch: Patio
- Exterior features: Sprinkler System, Balcony
- Fencing: Fenced,Other
- Has view: Yes
- View description: Mountain(s), Hills
Lot
- Size: 9,273 Square Feet
- Features: Corner Lot, Evergreen Trees, Deciduous Trees, Level, City Limits, Paved, Curbs, Gutters, Sidewalks, Street Light
Details
- Parcel number: R1644156
- Zoning: R1
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Legal Conforming
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Stucco
- Roof: Composition
Condition
- New construction: No
- Year built: 2008
Utilities & green energy
- Electric: City of Loveland
- Gas: Xcel
- Sewer: Public Sewer
- Water: District
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Green energy
- Energy efficient items: Windows, Doors, High Efficiency Furnace
Community & HOA
Community
- Features: Trail(s), Gated
- Security: Fire Alarm, Security Gate
- Subdivision: Overlook At Mariana 1st Sub Lov
HOA
- Has HOA: Yes
- Services included: Common Amenities, Utilities
- HOA fee: $1,500 annually
- HOA name: Overlook At Mariana
- HOA phone: 970-635-0498
Location
- Region: Loveland
Financial & listing details
- Price per square foot: $199/sqft
- Tax assessed value: $897,600
- Annual tax amount: $4,693
- Date on market: 1/8/2026
- Listing terms: Cash,Conventional
- Exclusions: Seller's Personal Property, Staging Items
- Electric utility on property: Yes
- Road surface type: Asphalt, Concrete
Price history
| Date | Event | Price |
|---|---|---|
| 4/8/2026 | Sold | $910,000-3.1%$199/sqft |
Source:  IRES as distributed by MLS GRID #1049223 Report a problem | ||
| 3/15/2026 | Pending sale | $939,000$205/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1049223 Report a problem | ||
| 2/15/2026 | Price change | $939,000-1.2%$205/sqft |
Source: IRES as distributed by MLS GRID #1049223 Report a problem | ||
| 1/9/2026 | Listed for sale | $950,000+22.7%$207/sqft |
Source: IRES as distributed by MLS GRID #1049223 Report a problem | ||
| 12/1/2021 | Sold | $774,000-0.1%$169/sqft |
Source: Public Record Report a problem | ||
| 10/22/2021 | Listed for sale | $775,000+47.1%$169/sqft |
Source: IRES as distributed by MLS GRID #953727 Report a problem | ||
| 2/19/2011 | Listing removed | $526,850$115/sqft |
Source: Agent:11973 #120578773 Report a problem | ||
| 1/27/2011 | Price change | $526,850+9.2%$115/sqft |
Source: Agent:11973 #120578773 Report a problem | ||
| 1/24/2011 | Price change | $482,500-8.4%$105/sqft |
Source: Agent:11973 #120578773 Report a problem | ||
| 8/19/2010 | Price change | $526,850+9.2%$115/sqft |
Source: Agent:11973 #120578773 Report a problem | ||
| 8/18/2010 | Price change | $482,500-8.4%$105/sqft |
Source: Agent:11973 #120578773 Report a problem | ||
| 7/2/2010 | Price change | $526,850+9.2%$115/sqft |
Source: Custom On-Site Builders, Inc #120578773 Report a problem | ||
| 6/27/2010 | Price change | $482,500-8.4%$105/sqft |
Source: Custom On-Site Builders, Inc #21026839 Report a problem | ||
| 3/15/2010 | Price change | $526,850+9.2%$115/sqft |
Source: Custom On-Site Builders, Inc #21026839 Report a problem | ||
| 3/14/2010 | Price change | $482,500-22.8%$105/sqft |
Source: Custom On-Site Builders, Inc #21026839 Report a problem | ||
| 3/6/2010 | Listed for sale | $625,000+28.9%$136/sqft |
Source: Custom On-Site Builders, Inc #21026839 Report a problem | ||
| 3/3/2010 | Sold | $485,000-11.8%$106/sqft |
Source: Public Record Report a problem | ||
| 12/24/2009 | Price change | $550,000-12%$120/sqft |
Source: RE/MAX Alliance #582134 Report a problem | ||
| 12/15/2009 | Price change | $625,000+13.6%$136/sqft |
Source: PJL, LLC #21026818 Report a problem | ||
| 9/6/2009 | Price change | $550,000-12%$120/sqft |
Source: RE/MAX Alliance #582134 Report a problem | ||
| 8/16/2009 | Price change | $625,000-16.1%$136/sqft |
Source: RE/MAX Alliance #582134 Report a problem | ||
| 8/14/2009 | Listed for sale | $745,000+797.6%$163/sqft |
Source: RE/MAX Alliance #582134 Report a problem | ||
| 3/7/2008 | Sold | $83,000$18/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,798 +2.2% | $56,100 -10.2% |
| 2024 | $4,693 +16.8% | $62,491 -1% |
| 2023 | $4,017 -2.7% | $63,098 +25% |
| 2022 | $4,128 -4.2% | $50,485 -2.8% |
| 2021 | $4,309 +1.7% | $51,938 -4.2% |
| 2020 | $4,237 +13.5% | $54,197 -0.7% |
| 2019 | $3,733 | $54,576 +20.3% |
| 2018 | $3,733 | $45,360 |
| 2017 | $3,733 +16.1% | $45,360 +8.4% |
| 2016 | $3,215 +5.6% | $41,846 0% |
| 2015 | $3,044 -1.2% | $41,850 +2.1% |
| 2014 | $3,081 | $40,970 |
| 2013 | -- | $40,970 +7.1% |
| 2012 | -- | $38,250 |
| 2011 | -- | $38,250 +11.6% |
| 2010 | -- | $34,270 |
| 2009 | -- | $34,270 +67.4% |
| 2008 | -- | $20,470 |
Find assessor info on the county website
Neighborhood: 80537
Nearby homes
- $822,5003 bd3 ba2.9k sqft158 Two Moons Dr, Loveland, CO 80537Sold
- $923,8003 bd3 ba2.9k sqft164 Two Moons Dr, Loveland, CO 80537Off Market
- $945,0004 bd4 ba4.3k sqft214 Cove Dr, Loveland, CO 80537Sold
- $809,6003 bd3 ba1.8k sqft205 Two Moons Dr, Loveland, CO 80537Off Market
- $1,032,2004 bd3 ba3.6k sqft145 N Cove Dr, Loveland, CO 80537Off Market
- $1,047,6004 bd2 ba2k sqft207 N Cove Dr, Loveland, CO 80537Off Market
- $889,0003 bd3 ba3.5k sqft170 Two Moons Dr, Loveland, CO 80537Off Market
- $950,8003 bd5 ba3.7k sqft219 Two Moons Dr, Loveland, CO 80537Off Market
Nearby schools
GreatSchools rating
- 4/10Namaqua Elementary SchoolGrades: K-5Distance: 1.3 mi
- 5/10Walt Clark Middle SchoolGrades: 6-8Distance: 2.1 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 2.8 mi
Schools provided by the listing agent
- Elementary: Namaqua
- Middle: Walt Clark
- High: Thompson Valley
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$908,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$908,400
- Colorado
- Larimer County
- Loveland
- 80537
- 152 Two Moons Dr
Nearby cities
Nearby zip codes
Other Loveland Topics
