Seller's Agent in 2026
Lisa Young
Elevations Real Estate, LLC
(970) 219-1955
21 in this area
55 Total Sales
152 Two Moons Dr Loveland, CO 80537
3
Beds
3.5
Baths
4,582
Sq Ft
9,148
Sq Ft Lot Lot
Highlights
- Gated Community
- Mountain View
- Wood Flooring
- Open Floorplan
- Vaulted Ceiling
- Main Floor Bedroom
About This Home
As of April 2026Built 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.
Last Agent to Sell the Property
Elevations Real Estate, LLC Brokerage Phone: 9705352000 License #100066586 Listed on: 01/08/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $4,693
Year Built
- Built in 2008
Lot Details
- 9,148 Sq Ft Lot
- Fenced
- Corner Lot
- Level Lot
- Property is zoned R1
HOA Fees
- $125 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Garage Door Opener
- Driveway Level
Home Design
- Composition Roof
- Stucco
- Stone
Interior Spaces
- 4,582 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Beamed Ceilings
- Vaulted Ceiling
- Ceiling Fan
- Gas Fireplace
- Window Treatments
- Living Room with Fireplace
- Dining Room
- Wood Flooring
- Mountain Views
- Unfinished Basement
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Kitchen
- Eat-In Kitchen
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
- Primary bathroom on main floor
- Walk-in Shower
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
- Sink Near Laundry
Accessible Home Design
- Low Pile Carpeting
Outdoor Features
- Balcony
- Patio
Schools
- Namaqua Elementary School
- Walt Clark Middle School
- Thompson Valley High School
Utilities
- Forced Air Heating and Cooling System
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number R1644156
Community Details
Overview
- Association fees include common amenities, utilities
- Overlook At Mariana Association, Phone Number (970) 635-0498
- Overlook At Mariana 1St Sub Lov Subdivision
Security
- Gated Community
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 8, 2026
Closed on
Apr 8, 2026
Sold by
Ann Torreano
Bought by
Knoell Thomas and Knoell Nancy R
Seller's Agent
Lisa Young
Elevations Real Estate, LLC
Buyer's Agent
John Feeney
C3 Real Estate Solutions, LLC
List Price
$950,000
Sold Price
$910,000
Premium/Discount to List
-$40,000
-4.21%
Views
160
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
25.07%
Original Mortgage
$210,000
Outstanding Balance
$210,000
Interest Rate
5.98%
Mortgage Type
New Conventional
Estimated Equity
$731,049
Purchase Details
Listed on
Oct 22, 2021
Closed on
Nov 22, 2021
Sold by
Anderson Living Trust
Bought by
Torreano Margaret Ann
Seller's Agent
Jay Roup
Group Centerra
Buyer's Agent
Michelle Kramer
Coldwell Banker Realty- Fort Collins
List Price
$775,000
Sold Price
$774,000
Premium/Discount to List
-$1,000
-0.13%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.77%
Purchase Details
Closed on
May 21, 2010
Sold by
Anderson Melvern K
Bought by
Anderson Living Trust
Purchase Details
Closed on
Mar 2, 2010
Sold by
Custom On Site Builders Inc
Bought by
Anderson Melvern K
Purchase Details
Closed on
Feb 29, 2008
Sold by
Timber Wind Land Llc
Bought by
Custom On Site Builders Inc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$444,265
Interest Rate
5.47%
Mortgage Type
Construction
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Special Warranty Deed | $910,000 | Fidelity National Title | |
| Warranty Deed | $774,000 | Guaranteed Title Group Llc | |
| Interfamily Deed Transfer | -- | None Available | |
| Warranty Deed | $485,000 | Heritage Title | |
| Warranty Deed | $83,000 | Fahtco |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $210,000 | New Conventional | |
| Previous Owner | $444,265 | Construction |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/08/2026 04/08/26 | Sold | $910,000 | -3.1% | $199 / Sq Ft | |
| 02/15/2026 02/15/26 | Price Changed | $939,000 | -1.2% | $205 / Sq Ft | |
| 01/09/2026 01/09/26 | For Sale | $950,000 | +22.7% | $207 / Sq Ft | |
| 02/22/2022 02/22/22 | Off Market | $774,000 | -- | -- | |
| 11/24/2021 11/24/21 | Sold | $774,000 | -0.1% | $177 / Sq Ft | View Prior Sale |
| 10/22/2021 10/22/21 | For Sale | $775,000 | -- | $177 / Sq Ft |
Source: IRES MLS
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $4,693 | $56,100 | $15,250 | $40,850 |
| 2024 | $4,526 | $62,491 | $16,348 | $46,143 |
| 2022 | $4,017 | $50,485 | $9,869 | $40,616 |
| 2021 | $4,128 | $51,938 | $10,153 | $41,785 |
| 2020 | $4,309 | $54,197 | $10,153 | $44,044 |
| 2019 | $4,237 | $54,197 | $10,153 | $44,044 |
| 2018 | $3,733 | $45,360 | $11,160 | $34,200 |
| 2017 | $3,215 | $45,360 | $11,160 | $34,200 |
| 2016 | $3,069 | $41,846 | $6,925 | $34,921 |
| 2015 | $3,044 | $41,850 | $6,930 | $34,920 |
| 2014 | $3,081 | $40,970 | $6,370 | $34,600 |
Source: Public Records
Agents Affiliated with this Home
-
Lisa Young
-
John Feeney
Buyer's Agent in 2026
John Feeney
C3 Real Estate Solutions, LLC
(970) 231-4172
18 in this area
88 Total Sales
-
Jay Roup
Seller's Agent in 2021
Jay Roup
Group Centerra
(970) 590-3438
41 in this area
100 Total Sales
-
Matt Kurtz
Seller Co-Listing Agent in 2021
Matt Kurtz
Group Centerra
(970) 962-4630
54 in this area
136 Total Sales
-
Michelle Kramer
Buyer's Agent in 2021
Michelle Kramer
Coldwell Banker Realty- Fort Collins
(970) 825-6601
10 in this area
76 Total Sales
Map
Source: IRES MLS
MLS Number: IRE1049223
APN: 95173-40-034
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. 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.
Information deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID
Nearby Homes
- 5602 Red Thunder Ct
- 5418 Nantucket Ct
- 5639 Mountain Iris Ct
- 5053 W County Road 20
- 339 Meadowsweet Cir
- 629 Deer Meadow Dr
- 5206 Deer Meadow Ct
- 512 Deer Meadow Dr
- 4953 W 1st St
- 508 Deer Meadow Dr
- 734 Rossum Dr
- 263 Rossum Dr
- 451 Clubhouse Ct
- 483 Clubhouse Ct
- 4601 Twin Peaks Ct
- 4578 Twin Peaks Dr
- 908 Willowrock Dr
- 6206 Fox Tail Ct
- 4347 Bluffview Dr
- 4692 Mariana Hills Cir
Your Personal Tour Guide
Ask me questions while you tour the home.