817 Shade Tree Dr Windsor, CO 80550
Water Valley NeighborhoodEstimated payment $5,681/month
Highlights
- Primary Bedroom Suite
- Loft
- Home Office
- 0.42 Acre Lot
- Cottage
- Fireplace
About This Home
Situated on a spacious .4-acre lot, this stunning modern farmhouse blends timeless style, thoughtful design, and quality craftsmanship. From the moment you arrive, the oversized three-car side-load garage creates a welcoming first impression. Step inside to discover a bright, open-concept layout filled with expansive windows and abundant natural light that enhances the home’s warm, comfortable feel. At the heart of the home is a gorgeous chef’s kitchen featuring high-end appliances, ample cabinetry, generous counter space, and a layout that makes cooking and entertaining effortless. The kitchen flows into the spacious family room, where a cozy fireplace creates the perfect gathering place for relaxing evenings with family or hosting friends. Sliding glass doors extend the living space to a large patio ideal for dining, entertaining, or enjoying morning coffee while taking in the peaceful surroundings. The backyard offers plenty of space to and enjoy Colorado’s beautiful seasons. A private main-floor office with charming barn doors provides an ideal work-from-home space. The main-level primary suite serves as a tranquil retreat with generous space and a luxurious ensuite bath designed for comfort and relaxation. Upstairs, a versatile loft offers flexible space for a second living area, playroom, or study area. Three additional bedrooms provide room for family and guests, including one with its own private bathroom. The finished lower level expands the home’s entertainment possibilities with a large family and theater area ideal for movie nights or game days, along with a custom bar that adds a stylish touch for gatherings. An additional bedroom and bathroom provide comfortable accommodations for overnight guests, plus a large storage area for seasonal and household items. Conveniently located minutes from Windsor Town Center, Windsor Lake, and a short drive to Fort Collins, this exceptional home offers easy access to shopping, dining, recreation, and entertainment.
Listing Agent
MB Metro Brokers Realty Oasis Brokerage Email: brownb6483@gmail.com,303-513-1149 License #100071114 Listed on: 03/07/2026
Co-Listing Agent
MB Metro Brokers Realty Oasis Brokerage Email: brownb6483@gmail.com,303-513-1149 License #40025987
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,859
Year Built
- Built in 2017
Lot Details
- 18,295 Sq Ft Lot
HOA Fees
Parking
- 3 Car Attached Garage
Home Design
- Cottage
- Slab Foundation
- Frame Construction
- Composition Roof
- Cement Siding
Interior Spaces
- 2-Story Property
- Fireplace
- Living Room
- Dining Room
- Home Office
- Loft
- Finished Basement
- Basement Fills Entire Space Under The House
- Laundry Room
Bedrooms and Bathrooms
- Primary Bedroom Suite
- En-Suite Bathroom
- 4 Full Bathrooms
Outdoor Features
- Patio
- Exterior Lighting
- Rain Gutters
Schools
- Mountain View Elementary School
- Windsor Middle School
- Windsor High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
Listing and Financial Details
- Assessor Parcel Number R8953248
Community Details
Overview
- Association fees include recycling, road maintenance, sewer, trash, water
- Pelican Farms Owners Association, Phone Number (303) 482-2213
- Poudre Tech Metro District Association, Phone Number (303) 482-2213
- South Hill Subdivision
- Seasonal Pond
Recreation
- Community Playground
Map
Home Values in the Area
Average Home Value in this Area
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 | $9,224 | $48,480 | $10,310 | $38,170 |
| 2024 | $9,224 | $48,480 | $10,310 | $38,170 |
| 2023 | $5,956 | $51,390 | $11,840 | $39,550 |
| 2022 | $6,435 | $45,880 | $10,430 | $35,450 |
| 2021 | $6,149 | $47,200 | $10,730 | $36,470 |
| 2020 | $4,192 | $32,600 | $6,790 | $25,810 |
| 2019 | $4,167 | $32,600 | $6,790 | $25,810 |
| 2018 | $3,038 | $23,040 | $5,040 | $18,000 |
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/15/2026 04/15/26 | Price Changed | $950,000 | -9.5% | $310 / Sq Ft | |
| 03/17/2026 03/17/26 | Price Changed | $1,050,000 | -12.5% | $342 / Sq Ft | |
| 03/07/2026 03/07/26 | For Sale | $1,200,000 | +76.7% | $391 / Sq Ft | |
| 02/26/2019 02/26/19 | Off Market | $679,000 | -- | -- | |
| 11/14/2018 11/14/18 | Sold | $679,000 | -6.3% | $180 / Sq Ft | View Prior Sale |
| 08/03/2018 08/03/18 | For Sale | $725,000 | -- | $192 / Sq Ft |
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $679,000 | Unified Title Co | |
| Warranty Deed | -- | Unified Title Co | |
| Warranty Deed | -- | Unified Title Co |
Source: REcolorado®
MLS Number: 2346075
APN: R8953248
- 2137 Honeybee Dr
- 912 Barn Yard Dr
- 2304 Sublime Dr
- 432 Halcyon Way
- 1971 Shadow Lake Ct
- 2177 Picture Point Dr
- 2025 Seagrove Ct
- 216 Siesta Key Dr
- 101 Siesta Key Ct
- 2086 Cape Hatteras Dr
- 2020 Vineyard Ct
- 1484 First Light Dr
- 1979 Cayman Dr
- 2145 Longfin Dr
- 174 Halibut Dr
- 183 Kitty Hawk Ct
- 189 Kitty Hawk Ct
- 1910 Tidewater Ln
- 1908 Tidewater Ln
- 2083 Vineyard Dr
- 500 Apex Dr
- 2353 Sublime Dr
- 2179 Sky End Dr
- 1513 First Light Dr
- 2120 Orchard Bloom Dr
- 2115 Falling Leaf Dr
- 2067 Moon Rise Dr
- 127 Bayside Cir
- 1825 Cherry Blossom Dr
- 1280 Lake Cir
- 9 Orchid Ct
- 219 Chestnut St
- 298 E Chestnut St
- 6910 Steeplechase Dr
- 855 Maplebrook Dr
- 916 Greenbrook Dr
- 540 Edenbridge Dr
- 4685 Grand Stand Dr
- 10420 19th St
- 6205 Longstem Way
Ask me questions while you tour the home.