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.
For sale
Price cut: $60K (5/16)
$890,000
817 Shade Tree Drive, Windsor, CO 80550
4beds
3,795sqft
Single Family Residence
Built in 2017
0.42 Acres Lot
$-- Zestimate®
$235/sqft
$72/mo HOA
What's special
Cozy fireplaceSliding glass doorsExpansive windowsAbundant natural lightSpacious family roomGenerous counter spaceAmple cabinetry
- 119 days |
- 1,347 |
- 60 |
Zillow last checked:
Listing updated:
Listed by:
Bradley Brown 303-513-1149 brownb6483@gmail.com,
MB Metro Brokers Realty Oasis,
Alison Eibner 303-800-1000,
MB Metro Brokers Realty Oasis
Source: REcolorado as distributed by MLS GRID,MLS#: 2346075
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 4
- Main level bathrooms: 1
- Main level bedrooms: 1
Bedroom
- Level: Main
- Area: 225 Square Feet
- Dimensions: 15 x 15
Bedroom
- Level: Upper
- Area: 156 Square Feet
- Dimensions: 12 x 13
Bedroom
- Level: Upper
- Area: 144 Square Feet
- Dimensions: 12 x 12
Bedroom
- Level: Upper
- Area: 143 Square Feet
- Dimensions: 11 x 13
Bathroom
- Level: Upper
Bathroom
- Level: Upper
Bathroom
- Features: En Suite Bathroom, Primary Suite
- Level: Main
Bathroom
- Level: Basement
Dining room
- Level: Main
- Area: 143 Square Feet
- Dimensions: 11 x 13
Kitchen
- Level: Main
- Area: 182 Square Feet
- Dimensions: 13 x 14
Laundry
- Level: Main
- Area: 72 Square Feet
- Dimensions: 8 x 9
Living room
- Level: Main
- Area: 255 Square Feet
- Dimensions: 15 x 17
Loft
- Level: Upper
- Area: 77 Square Feet
- Dimensions: 7 x 11
Office
- Level: Main
- Area: 154 Square Feet
- Dimensions: 11 x 14
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Features
- Basement: Finished,Full
Interior area
- Total structure area: 3,795
- Total interior livable area: 3,795 sqft
- Finished area above ground: 2,212
- Finished area below ground: 854
Property
Parking
- Total spaces: 3
- Parking features: Garage - Attached
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Lighting, Rain Gutters
Lot
- Size: 0.42 Acres
Details
- Parcel number: R8953248
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cottage
- Property subtype: Single Family Residence
Materials
- Cement Siding, Frame
- Foundation: Slab
- Roof: Composition
Condition
- Year built: 2017
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: South Hill
HOA
- Has HOA: Yes
- Amenities included: Playground, Pond Seasonal
- Services included: Recycling, Road Maintenance, Sewer, Trash, Water
- HOA fee: $380 annually
- HOA name: Pelican Farms Owners Association
- HOA phone: 303-482-2213
- Second HOA fee: $40 monthly
- Second HOA name: Poudre Tech Metro District
- Second HOA phone: 303-482-2213
Location
- Region: Windsor
Financial & listing details
- Price per square foot: $235/sqft
- Tax assessed value: $775,663
- Annual tax amount: $6,859
- Date on market: 3/8/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Staging Items
- Ownership: Individual
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/16/2026 | Price change | $890,000-6.3%$235/sqft |
Source:  REcolorado as distributed by MLS GRID #2346075 Report a problem | ||
| 4/15/2026 | Price change | $950,000-9.5%$250/sqft |
Source: REcolorado as distributed by MLS GRID #2346075 Report a problem | ||
| 3/17/2026 | Price change | $1,050,000-12.5%$277/sqft |
Source: REcolorado as distributed by MLS GRID #2346075 Report a problem | ||
| 3/8/2026 | Listed for sale | $1,200,000+76.7%$316/sqft |
Source: REcolorado as distributed by MLS GRID #2346075 Report a problem | ||
| 11/14/2018 | Sold | $679,000$179/sqft |
Source:  IRES as distributed by MLS GRID #858306 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,224 +54.9% | $48,480 -4.8% |
| 2024 | $5,956 -7.4% | $50,900 -1% |
| 2023 | $6,435 +4.6% | $51,390 +12% |
| 2022 | $6,149 +46.7% | $45,880 -2.8% |
| 2021 | $4,192 | $47,200 +44.8% |
| 2020 | $4,192 +38% | $32,600 |
| 2019 | $3,038 -27.1% | $32,600 +41.5% |
| 2018 | $4,167 | $23,040 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 80550
Nearby schools
GreatSchools rating
- NAOrchard Hill ElementaryGrades: PK-5Distance: 1.3 mi
- 5/10Windsor Middle SchoolGrades: 6-8Distance: 3 mi
- 6/10Windsor High SchoolGrades: 9-12Distance: 3.1 mi
Schools provided by the listing agent
- Elementary: Mountain View
- Middle: Windsor
- High: Windsor
- District: Weld RE-4
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Colorado
- Weld County
- Windsor
- 80550
- 817 Shade Tree Drive
Nearby cities
Nearby zip codes
Other Windsor Topics
