Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$950,000

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 2 Partial Baths
  • 4,582 Sq. Ft.
  • 3 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
152 Two Moons Dr, Loveland, COVideo Tour of 152 Two Moons Dr, Loveland, CO.
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.

Full Property Details for 152 Two Moons Dr

General

  • Price: $950,000
  • HOA FEE: $125/month
  • HOA FEE FREQ.: Annually
  • Taxes: $4,693 (2024)
  • Status: Active
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1049223
  • Updated: 1/13/2026
  • Added to Site: 7 day(s) ago

Interior

  • Interior Features: Eat-In Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Workshop, Pantry, Wood Windows, Natural Woodwork, Walk-In Closet(s), Washer/Dryer Hookup, Kitchen Island, 6-Panel Doors, High Ceilings, Beamed Ceilings, Split Bedroom Plan
  • Fireplace: Yes
  • Fireplace(s): Gas, Gas Log, Multi-Sided, Living Room, Dining Room
  • Appliances: Gas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
  • Flooring: Wood

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 2
  • 3/4 Bathrooms: 1
  • Half Bathrooms: 1
  • Main Floor Baths: 1

Bedrooms

  • Total Bedrooms: 3

Other Rooms

  • Laundry: Sink

Additional Information

  • Security/Safety: Fire Alarm

Exterior

  • Exterior Features: Sprinkler System, Balcony, Garage Door More Than 8 Feet High, Heated Garage, Oversized Garage, Tandem Garage
  • Porch/Patio/Deck: Patio

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, RV Access/Parking
  • Garage Description: Attached

Location

  • Area: Loveland
  • County: Larimer
  • Subdivision: Overlook At Mariana 1st Sub Lov

School Information

  • School District: Thompson R2-J
  • Elementary School: Namaqua
  • Middle School: Walt Clark
  • High School: Thompson Valley

Community

  • Association: Yes
  • Assoc. Name: Overlook At Mariana
  • Assoc. Fees Include: Common Amenities, Utilities

Heating & Cooling

  • Cooling Type: Central Air, Ceiling Fan(s)
  • Heating Type: Forced Air, 2 or more Heat Sources

Utilities

  • Gas: Yes
  • Gas: Xcel
  • Sewer: Public Sewer
  • Water: District
  • Utility Description: Natural Gas Available, Electricity Available, Cable Available, Satellite Available, High-Speed Internet Available

Structural Information

  • Architectural Style: Legal Conforming
  • Construction: Frame, Stone, Stucco
  • Exterior Const.: Frame, Stone, Stucco
  • Basement: Yes
  • Basement Desc.: Full, Unfinished
  • Roof: Composition
  • Windows: Window Coverings
  • Square Feet: 4,582
  • Sq. Ft. Source: Other
  • Living Area: 2,726 Sq. Ft.
  • Year Built: 2008

Lot Features

  • Property View: Mountain(s), Hills
  • Mountain views: Yes
  • Lot Size (Acres): 0.21
  • Lot Size (Sq. Ft.): 9,273
  • Frontage: City Street, Security Gate
  • Street/Road Desc.: Asphalt, Concrete
  • Fence: Yes
  • Lot Features: Corner Lot, Evergreen Trees, Deciduous Trees, Level, City Limits, Paved, Curbs, Gutters, Sidewalks, Street Light
  • Potential Use: Single-Family
  • Zoning: R1
  • Fencing (Description): Fenced, Other

Green Features

  • Energy Efficient: Windows, Doors, High Efficiency Furnace

Financial Considerations

  • Association Fee: Yes
  • Association Fee: $1,500
  • Assoc Fee Freq.: Annually
  • Tax Amount: $4,693
  • Tax Year: 2024
  • Terms: Cash, Conventional

Disclosures and Reports

  • Special Conditions: Private Owner
  • Exclusions: Seller's Personal Property, Staging Items
  • Property ID: R1644156

Listed by Elevations Real Estate, LLC (970) 535-2000

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 152 Two Moons Dr —

  • Elevations Real Estate, LLC

    970-535-2000

9705352000

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 152 Two Moons Dr

School District:Thompson School District R-2j
NameGradesDistance
Namaqua Elementary School
209 North County Road 19e, Loveland, CO 80537
K-51.3 mi
Walt Clark Middle School
2605 Carlisle Drive, Loveland, CO 80537
6-82.1 mi
Thompson Valley High School
1669 Eagle Drive, Loveland, CO 80537
9-122.6 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 152 Two Moons Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
1/09/2026
Listed
$950,000
22.74%
MLS
11/22/2021
Sold
$774,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 152 Two Moons Dr

Year
Property Taxes
Change
Tax Assessment
Change
2024
$4,693
4%
$62,491
—
2023
$4,526
10%
$62,491
20%
2021
$4,128
3%
$51,938
3%
2022
$4,017
-3%
$50,485
-7%
2021
$4,128
11%
$54,197
19%
2018
$3,733
16%
$45,360
—
2017
$3,215
5%
$45,360
8%
2016
$3,069
1%
$41,846
—
2015
$3,044
-1%
$41,846
2%
2014
$3,081
-27%
$40,970
-24%
2019
$4,237
37%
$54,197
32%
2013
$3,086
—
$40,970
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 152 Two Moons Dr

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Elevations Real Estate, LLC (970) 535-2000

Similar Properties near 152 Two Moons Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5272 Fox Hollow Ct, Loveland, CO 80537 - Photo 1
$925,000
Open House

5272 Fox Hollow Ct  Loveland, CO 80537

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 5,256
    Sq. Ft.
  • MLS # 1044571
Listed by Core Property Group (970) 223-6500 and Barbara Giesey (970) 222-4035
1412 Hiwan Ct, Fort Collins, CO 80525 - Photo 1
$925,000

1412 Hiwan Ct  Fort Collins, CO 80525

  • Single Family
  • Active
  • Updated 7 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 4,794
    Sq. Ft.
  • MLS # 1046169
Listed by RE/MAX Alliance-FTC South
321 Greenwood Dr, Loveland, CO 80537 - Photo 1
$925,000

321 Greenwood Dr  Loveland, CO 80537

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,534
    Sq. Ft.
  • MLS # 1044689
Listed by Group Mulberry
3051 Newfound Lk Rd, Berthoud, CO 80513 - Photo 1
$915,000

3051 Newfound Lk Rd  Berthoud, CO 80513

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,632
    Sq. Ft.
  • MLS # 1041707
Listed by LIV Sotheby's Intl Realty

Just Listed near 152 Two Moons Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

922 Logan Peak Way, Berthoud, CO 80513 - Photo 1 New to Website
$400,000

922 Logan Peak Way  Berthoud, CO 80513

  • Duplex
  • Active
  • Updated 6 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,500
    Sq. Ft.
  • MLS # 8459999
Listed by D.R. Horton Realty, LLC
230 N 2nd St, Berthoud, CO 80513 - Photo 1 New to Website
$105,900

230 N 2nd St  Berthoud, CO 80513

  • Mobile Home
  • Active
  • Updated 4 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,056
    Sq. Ft.
  • MLS # 6691
Listed by RE/MAX Nexus
227 N 2nd St, Berthoud, CO 80513 - Photo 1 New to Website
$69,000

227 N 2nd St  #20  Berthoud, CO 80513

  • Mobile Home
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 960
    Sq. Ft.
  • MLS # 6685
Listed by RE/MAX Nexus
235 N 2nd St, Berthoud, CO 80513 - Photo 1 New to Website
$75,000

235 N 2nd St  Berthoud, CO 80513

  • Mobile Home
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,056
    Sq. Ft.
  • MLS # 2241249
Listed by Metro 21 Real Estate Group

Price Reduced near 152 Two Moons Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1521 Sun River Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$14,100 (-2.24%)
$614,900

1521 Sun River Rd  Berthoud, CO 80513

  • Single Family
  • Active
  • Updated 11 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,522
    Sq. Ft.
  • MLS # 3266533
Listed by Trelora Realty, Inc.
593 Country Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$15,000 (-3.23%)
$450,000

593 Country Rd  Berthoud, CO 80513

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,433
    Sq. Ft.
  • MLS # 7869116
Listed by MB Team Lassen
230 N 2nd St, Berthoud, CO 80513 - Photo 1 Price Reduced
-$2,900 (-3.72%)
$75,000

230 N 2nd St  #83  Berthoud, CO 80513

  • Mobile Home
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,056
    Sq. Ft.
  • MLS # 6539
Listed by JPAR Modern Real Estate
1562 Sun River Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$4,000 (-0.66%)
$605,500

1562 Sun River Rd  Berthoud, CO 80513

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 3,136
    Sq. Ft.
  • MLS # 4382814
Listed by Littleton Real Estate Company

Recent Sales near 152 Two Moons Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5287 Deer Meadow Ct, Loveland, CO 80537 - Photo 1 Sold
$975,000

5287 Deer Meadow Ct  Loveland, CO 80537

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 3,147
    Sq. Ft.
  • MLS # 1044839
Listed by Elevations Real Estate, LLC
5365 Lighthouse Point Ct, Loveland, CO 80537 - Photo 1 Sold
$815,000

5365 Lighthouse Point Ct  Loveland, CO 80537

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 3,242
    Sq. Ft.
  • MLS # 1040690
Listed by Group Loveland and Group Centerra
637 Deer Meadow Dr, Loveland, CO 80537 - Photo 1 Sold
$875,000

637 Deer Meadow Dr  Loveland, CO 80537

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 4,308
    Sq. Ft.
  • MLS # 1034363
Listed by Erich Menzel
466 Cove Dr, Loveland, CO 80537 - Photo 1 Sold
$920,000

466 Cove Dr  Loveland, CO 80537

  • Single Family
  • Closed
  • 5
    Beds
  • 5
    Total Baths
  • 4,327
    Sq. Ft.
  • MLS # 1038121
Listed by Live West Realty

152 Two Moons Dr, Loveland, CO 80537 (MLS# 1049223) is a Single Family property with 3 bedrooms, 2 full bathrooms and 2 partial bathrooms. 152 Two Moons Dr is currently listed for $950,000 and was received on January 08, 2026. Want to learn more about 152 Two Moons Dr? Do you have questions about finding other Single Family real estate for sale in Loveland? You can browse all Loveland real estate or contact a Coldwell Banker agent to request more information.

Tour this property