Recently Viewed Properties
See This Home
Save This Listing
Close

$910,000

  • Sold
  • Closed
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 2 Partial Baths
  • 4,582 Sq. Ft.
  • 3 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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

  • Sold For: $910,000
  • HOA FEE: $125/month
  • HOA FEE FREQ.: Annually
  • Taxes: $4,693 (2024)
  • Status: Closed
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1049223
  • Added to Site: 145 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, Attached
  • 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
  • Permitted 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
Sold by C3 Real Estate Solutions, LLC (970) 219-1955

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 ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 152 Two Moons Dr

Date
Details
Price
Change
Source
4/08/2026
Sold
$910,000
-3.09%
MLS
2/15/2026
Price Reduced
$939,000
-1.16%
MLS
1/09/2026
Listed
$950,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Listed by Elevations Real Estate, LLC (970) 535-2000
Sold by C3 Real Estate Solutions, LLC (970) 219-1955

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.

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 # 1054866
Listed by LIV Sotheby's Intl Realty
6308 Steppes Wy, Loveland, CO 80538 - Photo 1
$917,990

6308 Steppes Wy  Loveland, CO 80538

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 4,932
    Sq. Ft.
  • MLS # 1057047
Listed by C3 Real Estate Solutions, LLC
8609 Ranch Rd, Loveland, CO 80537 - Photo 1
$925,000

8609 Ranch Rd  Loveland, CO 80537

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 3,209
    Sq. Ft.
  • MLS # 1058579
Listed by Group Centerra
712 Colt Dr, Loveland, CO 80537 - Photo 1
$875,000

712 Colt Dr  Loveland, CO 80537

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,662
    Sq. Ft.
  • MLS # 1044602
Listed by RE/MAX Alliance-Loveland

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.

5550 Blacksmith Ave, Timnath, CO 80547 - Photo 1 New to Website
$940,000

5550 Blacksmith Ave  Timnath, CO 80547

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,325
    Sq. Ft.
  • MLS # 1060255
Listed by New Door Group (303) 859-6891
4510 Barrow Ln, Timnath, CO 80547 - Photo 1 New to Website
$432,900

4510 Barrow Ln  Timnath, CO 80547

  • Townhouse
  • Active
  • Updated 4 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,706
    Sq. Ft.
  • MLS # 1060274
Listed by Kittle Real Estate
5261 Rendezvous Pkwy, Timnath, CO 80547 - Photo 1 New to Website
$617,000

5261 Rendezvous Pkwy  Timnath, CO 80547

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,951
    Sq. Ft.
  • MLS # 7571644
Listed by HomeSmart Realty
6315 Spring Valley Rd, Timnath, CO 80547 - Photo 1 New to Website
$615,000

6315 Spring Valley Rd  Timnath, CO 80547

  • Single Family
  • Active
  • Updated 4 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,545
    Sq. Ft.
  • MLS # 1060268
Listed by RE/MAX Nexus

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.

405 Mountain Vw Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$41,000 (-1.61%)
$2,500,000

405 Mountain Vw Rd  #B  Berthoud, CO 80513

  • Warehouse
  • Active
  • Updated 6 days ago
  • MLS # 1030167
Listed by Waypoint Real Estate
5308 Beverly Dr, Berthoud, CO 80513 - Photo 1 Price Reduced
-$16,000 (-1.75%)
$899,000

5308 Beverly Dr  Berthoud, CO 80513

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 2
    Total Baths
  • 2,048
    Sq. Ft.
  • MLS # 1058414
Listed by JPAR Modern Real Estate
320 Del Monte Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$25,000 (-1.67%)
$1,475,000

320 Del Monte Rd  Berthoud, CO 80513

  • Farm
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,801
    Sq. Ft.
  • MLS # 1056869
Listed by Hayden Outdoors - Windsor
405 Mountain Vw Rd, Berthoud, CO 80513 - Photo 1 Price Reduced
-$5 (-29.41%)
$12

405 Mountain Vw Rd  #B  Berthoud, CO 80513

  • Commercial Lease
  • Active
  • Updated 6 days ago
  • MLS # 1030169
Listed by Waypoint Real Estate

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.

459 Cape Dory Dr, Loveland, CO 80537 - Photo 1 Sold
$860,000

459 Cape Dory Dr  Loveland, CO 80537

  • Single Family
  • Closed
  • 6
    Beds
  • 4
    Total Baths
  • 4,108
    Sq. Ft.
  • MLS # 1050469
Listed by Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins
Sold by The Colorado Group
5360 Lighthouse Point Ct, Loveland, CO 80537 - Photo 1 Sold
$915,000

5360 Lighthouse Point Ct  Loveland, CO 80537

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 3,978
    Sq. Ft.
  • MLS # 1046501
Listed by Group Centerra
Sold by Group Centerra
645 Deer Meadow Dr, Loveland, CO 80537 - Photo 1 Sold
$825,000

645 Deer Meadow Dr  Loveland, CO 80537

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 2,012
    Sq. Ft.
  • MLS # 1047759
Listed by RE/MAX Alliance-FTC South
Sold by Compass - Boulder
270 Meadowsweet Cir, Loveland, CO 80537 - Photo 1 Sold
$777,100

270 Meadowsweet Cir  Loveland, CO 80537

  • Single Family
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 3,588
    Sq. Ft.
  • MLS # 1046758
Listed by C3 Real Estate Solutions, LLC
Sold by Non-IRES

152 Two Moons Dr, Loveland, CO 80537 (MLS# 1049223) is a Single Family property that was sold at $910,000 on April 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.