Seller's Agent in 2026
Lisa Young
Elevations Real Estate, LLC
(970) 219-1955
53 Total Sales
152 Two Moons Dr Loveland, CO 80537
Loveland AreaEstimated Value: $908,000 - $937,548
3
Beds
3.5
Baths
4,582
Sq Ft
$202/Sq Ft
Est. Value
Highlights
- RV Access or Parking
- Open Floorplan
- Cathedral Ceiling
- Gated Community
- Mountain View
- Wood Flooring
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
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 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
- Paved or Partially Paved Lot
- Level Lot
- Sprinkler System
- Landscaped with Trees
- Property is zoned R1
HOA Fees
- $125 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Heated Garage
- Tandem Garage
- Garage Door Opener
- Driveway Level
- RV Access or Parking
Property Views
- Mountain
- Hills
Home Design
- Composition Roof
- Stucco
- Stone
Interior Spaces
- 4,582 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Woodwork
- Beamed Ceilings
- Cathedral Ceiling
- Ceiling Fan
- Gas Log Fireplace
- Window Treatments
- Six Panel Doors
- Living Room with Fireplace
- Dining Room
- Workshop
- Wood Flooring
- Unfinished Basement
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Kitchen
- Eat-In Kitchen
- Gas Range
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- Main Floor Bedroom
- Split Bedroom Floorplan
- 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
Eco-Friendly Details
- Energy-Efficient Windows
- Energy-Efficient Doors
Outdoor Features
- Balcony
- Patio
Schools
- Namaqua Elementary School
- Walt Clark Middle School
- Thompson Valley High School
Utilities
- Forced Air Heating and Cooling System
- High-Efficiency Furnace
- 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
Recreation
- Trails
Security
- Gated Community
Ownership 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
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 8, 2026
Closed on
Apr 8, 2026
Sold by
Ann Torreano
Bought by
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
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$18,367
Avg. Annual Appreciation
4.10%
Original Mortgage
$210,000
Outstanding Balance
$209,367
Interest Rate
5.98%
Mortgage Type
New Conventional
Estimated Equity
$715,020
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
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $910,000 | Fidelity National Title | ||
| Torreano Margaret Ann | $774,000 | Guaranteed Title Group Llc | |
| Anderson Living Trust | -- | None Available | |
| Anderson Melvern K | $485,000 | Heritage Title | |
| Custom On Site Builders Inc | $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 | Borrower | Loan Amount |
|---|---|---|---|
| Open | $210,000 | ||
| Previous Owner | Custom On Site Builders Inc | $444,265 |
Source: Public Records
Property 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 | 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
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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
86 Total Sales
-
Jay Roup
Seller's Agent in 2021
Jay Roup
Group Centerra
(970) 590-3438
96 Total Sales
-
Matt Kurtz
Seller Co-Listing Agent in 2021
Matt Kurtz
Group Centerra
(970) 962-4630
129 Total Sales
-
Michelle Kramer
Buyer's Agent in 2021
Michelle Kramer
Coldwell Banker Realty- Fort Collins
(970) 825-6601
81 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
- 5418 Nantucket Ct
- 5639 Mountain Iris Ct
- 5053 W County Road 20
- 629 Deer Meadow Dr
- 5206 Deer Meadow Ct
- 512 Deer Meadow Dr
- 4953 W 1st St
- 763 Deer Meadow Dr
- 5275 Cedar Valley Dr
- 263 Rossum Dr
- 5794 Jackdaw Dr
- 450 N County Road 23 E
- 516 Mariana Pointe Dr
- 4615 Twin Peaks Ct
- 6206 Fox Tail Ct
- 4453 Pika Dr
- 1012 Willowrock Dr
- 4692 Mariana Hills Cir
- 4281 Bluffview Dr
- 4237 Martinson Dr
- 158 Two Moons Dr
- 164 Two Moons Dr
- 214 N Cove Dr
- 205 Two Moons Dr
- 145 N Cove Dr
- 207 N Cove Dr
- 170 Two Moons Dr
- 219 Two Moons Dr
- 228 N Cove Dr
- 5461 Nantucket Ct
- 5479 Nantucket Ct
- 225 N Cove Dr
- 204 Two Moons Dr
- 951 N Cove Dr
- 176 Two Moons Dr
- 233 Two Moons Dr
- 5579 Stone Church Ct
- 5447 Nantucket Ct
- 216 Two Moons Dr
- 5601 Red Thunder Ct
Your Personal Tour Guide
Ask me questions while you tour the home.