P
Seller's Agent in 2024
Phillip Rangel
Rangel Realty
(970) 388-2100
4 Total Sales
551 Reservoir Dr Loveland, CO 80537
Estimated Value: $879,000 - $1,538,000
5
Beds
5
Baths
5,004
Sq Ft
$263/Sq Ft
Est. Value
Highlights
- Water Views
- Horses Allowed On Property
- Contemporary Architecture
- Big Thompson Elementary School Rated A-
- Open Floorplan
- Wood Flooring
About This Home
As of April 2024Stunning Multi-Generational Home with Breathtaking Views. Nestled on a sprawling 2.24-acre lot, this custom built 5 bedroom, 5 bathroom home offers spectacular 360 degree views of the foothills, city, and both Flatiron & Chimney Hollow Reservoirs. Step inside to discover a modern, open-concept floor plan that seamlessly blends the beauty of the outdoors with contemporary comfort. The primary bedroom is a luxurious retreat with its own sitting area. The 5-piece primary bathroom, complete with a walk-in shower and freestanding tub, adds to the sense of opulence. A see-through stone fireplace links the formal dining room and living room, creating a warm and inviting atmosphere. 2 more spacious bedrooms, 2 additional bathrooms, a kitchen with eat-in area, an office and a laundry room, complete the main floor. The newly finished walkout basement is designed for multi-generational living, featuring two additional bedrooms, two bathrooms, a living room, a full kitchen, and a second laundry room. This space is perfect for extended family members or guests. Multiple patios provide the perfect setting to enjoy the breathtaking views and abundant wildlife year-round. The property includes a heated 3-car garage, a heated concrete driveway, and a heated front porch, ensuring comfort and convenience during the winter months. The availability of plans for a future shop allows you to further customize the property to your liking. With its unique multi-generational living setup and stunning views, this home is a rare find.
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $4,710
Year Built
- Built in 2020
Lot Details
- 2.24 Acre Lot
- Open Space
- North Facing Home
- Sloped Lot
- Sprinkler System
HOA Fees
- $50 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Heated Garage
- Garage Door Opener
Property Views
- Water
- Panoramic
- City
Home Design
- Contemporary Architecture
- Wood Frame Construction
- Composition Roof
- Stucco
- Stone
Interior Spaces
- 5,004 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Crown Molding
- Ceiling height of 9 feet or more
- Ceiling Fan
- Gas Log Fireplace
- Double Pane Windows
- Window Treatments
- Great Room with Fireplace
- Family Room
- Dining Room
- Home Office
- Radon Detector
Kitchen
- Eat-In Kitchen
- Gas Oven or Range
- Self-Cleaning Oven
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Carpet
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- Primary bathroom on main floor
Laundry
- Laundry on main level
- Washer and Dryer Hookup
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Accessible Home Design
- Accessible Entrance
- Low Pile Carpeting
Schools
- Namaqua Elementary School
- Clark Middle School
- Thompson Valley High School
Utilities
- Humidity Control
- Forced Air Heating and Cooling System
- Propane
- Septic System
- High Speed Internet
- Satellite Dish
Additional Features
- Energy-Efficient HVAC
- Patio
- Mineral Rights Excluded
- Horses Allowed On Property
Community Details
- Association fees include snow removal
- Pittington Rlup 05 S2447 Subdivision
Listing and Financial Details
- Assessor Parcel Number R1643675
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 10, 2023
Closed on
Apr 4, 2024
Sold by
Rangel Roman A and Rangel Janell M
Bought by
Wilson Jordan and Wilson Megan
Seller's Agent
Phillip Rangel
Rangel Realty
Buyer's Agent
Benjamin Cole
Coldwell Banker Realty- Fort Collins
List Price
$1,500,000
Sold Price
$1,483,000
Premium/Discount to List
-$17,000
-1.13%
Views
152
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
-$168,449
Avg. Annual Appreciation
-7.44%
Original Mortgage
$434,000
Outstanding Balance
$427,540
Interest Rate
6.9%
Mortgage Type
New Conventional
Estimated Equity
$887,011
Purchase Details
Listed on
Jun 12, 2018
Closed on
Aug 12, 2019
Sold by
Foothills Vista Development Inc
Bought by
Rangel Roman A and Rangel Janell M
Seller's Agent
Chad Brent
Group Loveland
Buyer's Agent
Phillip Rangel
Rangel Realty
List Price
$167,000
Sold Price
$212,000
Premium/Discount to List
$45,000
26.95%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
51.94%
Original Mortgage
$500,000
Interest Rate
3.7%
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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Wilson Jordan | $1,483,000 | Stewart Title | |
| Rangel Roman A | $212,000 | The Group Guarantee Title |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Wilson Jordan | $434,000 | |
| Previous Owner | Rangel Roman A | $500,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/04/2024 04/04/24 | Sold | $1,483,000 | -1.1% | $296 / Sq Ft | |
| 02/27/2024 02/27/24 | For Sale | $1,500,000 | 0.0% | $300 / Sq Ft | |
| 02/03/2024 02/03/24 | Pending | -- | -- | -- | |
| 10/13/2023 10/13/23 | For Sale | $1,500,000 | +607.5% | $300 / Sq Ft | |
| 11/12/2019 11/12/19 | Off Market | $212,000 | -- | -- | |
| 08/12/2019 08/12/19 | Sold | $212,000 | +26.9% | -- | View Prior Sale |
| 06/07/2019 06/07/19 | For Sale | $167,000 | -21.2% | -- | |
| 06/06/2019 06/06/19 | Off Market | $212,000 | -- | -- | |
| 06/12/2018 06/12/18 | For Sale | $167,000 | -- | -- |
Source: IRES MLS
Tax History Compared to Growth
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 | $6,417 | $77,506 | $12,395 | $65,111 |
| 2024 | $6,208 | $77,506 | $12,395 | $65,111 |
| 2022 | $4,710 | $55,190 | $12,163 | $43,027 |
| 2021 | $3,798 | $44,297 | $17 | $44,280 |
| 2020 | $472 | $5,480 | $17 | $5,463 |
| 2019 | $6 | $17 | $17 | $0 |
| 2018 | $7 | $17 | $17 | $0 |
| 2017 | $6 | $17 | $17 | $0 |
| 2016 | $6 | $15 | $15 | $0 |
| 2015 | $6 | $10 | $10 | $0 |
| 2014 | $6 | $10 | $10 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Phillip Rangel
-
Benjamin Cole
Buyer's Agent in 2024
Benjamin Cole
Coldwell Banker Realty- Fort Collins
(970) 227-1515
83 Total Sales
-
Chad Brent
Seller's Agent in 2019
Chad Brent
Group Loveland
(970) 461-7145
107 Total Sales
-
Sally Brent
Seller Co-Listing Agent in 2019
Sally Brent
Group Loveland
(970) 481-2037
123 Total Sales
Map
Source: IRES MLS
MLS Number: 997881
APN: 05282-05-007
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.
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.
Nearby Homes
- 12422 W County Road 18 E
- 555 James Park Trail
- 834 Green Mountain Dr
- 230 Green Mountain Dr
- 60 Sylvia Ct
- 321 Greenwood Dr
- 291 Newell Dr
- 400 Rugged Rock Rd
- 3204 Indian Blind Trail
- 965 Stone Mountain Ranch Rd
- 9209 Four Wheel Dr
- 0 Tbd Bartram Park Rd
- 4012 Lakefront Dr
- 196 Mule Deer Dr
- 8701 Rock Hill Rd
- 16235 W County Road 18 E
- 38 Jasper Lake Rd
- 1031 W Us Highway 34
- 1350 S County Road 29
- 114 Jasper Lake Rd
- 554 Reservoir Dr
- 468 Reservoir Dr
- 463 Reservoir Dr
- 437 Reservoir Dr
- 663 Reservoir Dr
- 662 Reservoir Dr
- 406 Reservoir Dr
- 675 Reservoir Dr
- 375 Reservoir Dr
- 249 Reservoir Dr
- 356 Reservoir Dr
- 327 Reservoir Dr
- 223 Reservoir Dr
- 334 Reservoir Dr
- 288 Reservoir Dr
- 220 Reservoir Dr
- 11051 Flatiron Mountain Rd
- 11040 Flatiron Mountain Rd
- 676 Lowder Rd
- 11012 Flatiron Mountain Rd