Welcome to 897 Shade Tree Drive, an absolute entertainer's dream perfectly positioned on a premier corner lot in Windsor's highly sought-after Pelican Farms subdivision in Water Valley. This stunning 4-bedroom plus office, 3-bathroom home seamlessly blends sophisticated interior upgrades with an unmatched outdoor oasis. The main floor is anchored by a chef-inspired kitchen featuring elegant granite countertops, premium black stainless-steel appliances, and a gas range. Step down 3 easy stairs into the sunken living room, where a beautiful fireplace serves as the perfect centerpiece for relaxing evenings after a day out in the community. Thoughtfully designed for comfort, the home boasts spacious bedrooms with newer carpeting throughout. Your large primary suite provides a private daily retreat, complete with a luxurious tiled shower and a soaking tub. An unfinished basement offers a blank canvas to expand your living space, while the oversized three-car garage provides abundant room for vehicles, golf carts, and toys. Step outside to discover the ultimate backyard escape. Host family and friends effortlessly with a professional-grade outdoor kitchen with a built in smoker, grill, blackstone, gas burner, trash cans, and cooler. The impressive, 6 foot wide stacked stone outdoor fireplace serves as both the outdoor focal point and integrated privacy. Beyond the property lines, you are stepping into a vibrant, active community lifestyle. Take the neighborhood golf cart trails to dine at multiple community restaurants, or spend sunny weekends fishing, swimming, and boating at the coveted Water Valley lakes. Embrace the outdoors with immediate access to a true farm-to-table experience, featuring community fields, orchards, and extensive trail systems right outside your door. This property offers a rare opportunity to experience luxury, connection, and the absolute best of Northern Colorado living. Don't wait, this one will go fast!
For sale
$624,900
897 Shade Tree Dr, Windsor, CO 80550
4beds
2,940sqft
Single Family Residence
Built in 2017
8,481 Square Feet Lot
$-- Zestimate®
$213/sqft
$31/mo HOA
What's special
Beautiful fireplaceOversized three-car garageLarge primary suiteLuxurious tiled showerGas rangePremium black stainless-steel appliancesSoaking tub
- 6 days |
- 1,498 |
- 111 |
Zillow last checked:
Listing updated:
Listed by:
Julie Love 970-353-5006,
NextHome Foundations
Source: IRES as distributed by MLS GRID,MLS#: 1066493
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Description: Carpet
- Features: Tub+Shower Primary
- Level: Upper
- Area: 234 Square Feet
- Dimensions: 18 x 13
Bedroom 2
- Description: Carpet
- Level: Upper
- Area: 130 Square Feet
- Dimensions: 13 x 10
Bedroom 3
- Description: Carpet
- Level: Upper
- Area: 154 Square Feet
- Dimensions: 14 x 11
Bedroom 4
- Description: Carpet
- Level: Lower
- Area: 156 Square Feet
- Dimensions: 13 x 12
Dining room
- Description: Luxury Vinyl
- Level: Main
- Area: 120 Square Feet
- Dimensions: 10 x 12
Kitchen
- Description: Luxury Vinyl
- Level: Main
- Area: 210 Square Feet
- Dimensions: 15 x 14
Living room
- Description: Carpet
- Level: Lower
- Area: 210 Square Feet
- Dimensions: 15 x 14
Study
- Description: Carpet
- Level: Main
- Area: 168 Square Feet
- Dimensions: 14 x 12
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Microwave, Gas Bar-B-Q, Water Softener Owned, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Cathedral Ceiling(s), Pantry, Walk-In Closet(s), Kitchen Island, High Ceilings
- Windows: Window Coverings
- Basement: Unfinished,Built-In Radon
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 2,302
- Total interior livable area: 2,940 sqft
- Finished area above ground: 2,302
Property
Parking
- Total spaces: 3
- Parking features: Garage Door Opener, Attached, Oversized
- Attached garage spaces: 3
- Details: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom
Features
- Levels: Four
- Stories: 4
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Fencing: Wood,Dog Run/Kennel
- Has view: Yes
- View description: Hills
- Waterfront features: Lake Privileges
Lot
- Size: 8,481 Square Feet
- Features: Corner Lot, Deciduous Trees, Paved, Curbs, Gutters, Sidewalks, Street Light
Details
- Parcel number: R8945933
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Composition
- Roof: Composition
Condition
- New construction: No
- Year built: 2017
Utilities & green energy
- Electric: Poudre Valley REA
- Gas: Xcel
- Water: City, District
- Utilities for property: Electricity Available, Cable Available, High Speed Avail
Community & HOA
Community
- Features: Park, Trail(s)
- Security: Fire Alarm
- Subdivision: South Hill 2nd Fg
HOA
- Has HOA: Yes
- Services included: Common Amenities, Trash
- HOA fee: $375 annually
- HOA name: Kellison Association Mgmt
- HOA phone: 970-494-0609
Location
- Region: Windsor
Financial & listing details
- Price per square foot: $213/sqft
- Tax assessed value: $552,798
- Annual tax amount: $4,888
- Date on market: 8/14/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Staging furniture & decor, owners personal property, curtains.
- Electric utility on property: Yes
- Road surface type: Concrete
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/14/2026 | Listed for sale | $624,900+43.7%$213/sqft |
Source:  IRES as distributed by MLS GRID #1066493 Report a problem | ||
| 7/2/2019 | Sold | $435,000$148/sqft |
Source: IRES as distributed by MLS GRID #878810 Report a problem | ||
| 6/3/2019 | Pending sale | $435,000$148/sqft |
Source: The Group Inc. #878810 Report a problem | ||
| 5/30/2019 | Price change | $435,000-0.9%$148/sqft |
Source: The Group Inc. #878810 Report a problem | ||
| 4/24/2019 | Listed for sale | $439,000+19.7%$149/sqft |
Source: Group Loveland #878810 Report a problem | ||
| 8/25/2017 | Sold | $366,682$125/sqft |
Source: IRES as distributed by MLS GRID #816274 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $4,888 +11.2% | $33,830 -2.1% |
| 2025 | $4,395 +8.5% | $34,550 -3.5% |
| 2024 | $4,051 +2.1% | $35,810 -0.9% |
| 2023 | $3,968 +4.7% | $36,150 +27.8% |
| 2022 | $3,791 +10.8% | $28,290 -2.8% |
| 2021 | $3,422 | $29,100 +9.4% |
| 2020 | $3,422 +4% | $26,610 +2.8% |
| 2019 | $3,291 -0.5% | $25,890 +3.7% |
| 2018 | $3,309 +0.5% | $24,960 +409.4% |
| 2017 | $3,291 | $4,900 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 80550
Nearby schools
GreatSchools rating
- 7/10Orchard Hill ElementaryGrades: PK-5Distance: 1.1 mi
- 5/10Windsor Middle SchoolGrades: 6-8Distance: 3 mi
- 7/10Windsor High SchoolGrades: 9-12Distance: 3.1 mi
Schools provided by the listing agent
- Elementary: Orchard Hill,Windsor Charter Academy
- Middle: Ridgeline
- High: Windsor
Source: IRES 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.
- $511,5003 bd3 ba1.9k sqft889 Shade Tree Dr, Windsor, CO 80550Off Market
- $555,0003 bd3 ba3.1k sqft871 Shade Tree Dr, Windsor, CO 80550Sold
- $580,4003 bd3 ba2.2k sqft890 Shade Tree Dr, Windsor, CO 80550Off Market
- $944,0004 bd4 ba2.8k sqft2187 Pelican Farm Rd, Windsor, CO 80550Off Market
- $--0.37 acres847 Shade Tree Dr, Windsor, CO 80550Off Market
- $646,1004 bd3 ba2.8k sqft2158 Pelican Farm Rd, Windsor, CO 80550Off Market
- $649,1005 bd4 ba1.8k sqft876 Shade Tree Dr, Windsor, CO 80550Off Market
- $757,5006 bd5 ba3.8k sqft2162 Pelican Farm Rd, Windsor, CO 80550Off Market
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.
Similar homes
- $675,0004 bd3 ba3.7k sqft1880 Los Cabos Dr, Windsor, CO 80550For Sale
MLS ID #1065882, Ryan Livingston, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID - $585,0005 bd4 ba2.6k sqft1709 Green River Dr, Windsor, CO 80550For Sale
MLS ID #1063275, Brent Duggar, Group Harmony. IRES as distributed by MLS GRID - $559,0004 bd3 ba3.4k sqft480 Wind River Dr, Windsor, CO 80550For Sale
MLS ID #1065737, TR Smith, Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins. IRES as distributed by MLS GRID - $585,0004 bd3 ba3.2k sqft1553 Grand Ave, Windsor, CO 80550For Sale
MLS ID #1063559, Jeremiah Rom, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID - $548,0004 bd3 ba2.5k sqft912 Charlton Dr, Windsor, CO 80550For SaleMLS ID #1065776, Kelly Bartunek, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID
- $510,0003 bd3 ba2.5k sqft1992 Thundercloud Drive, Windsor, CO 80550For Sale
MLS ID #9337018, Katrina Hunt, LPT Realty. REcolorado as distributed by MLS GRID - $690,0004 bd3 ba3.5k sqft7409 Rosecroft Dr, Windsor, CO 80550For SaleMLS ID #1059456, Brad Clarkson, RE/MAX of Boulder, Inc. IRES as distributed by MLS GRID
- $614,9005 bd4 ba3.9k sqft1937 Raindrop Dr, Windsor, CO 80550For SaleMLS ID #1055242, TR Smith, Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins. IRES as distributed by MLS GRID
- $675,0005 bd4 ba3.1k sqft623 Vermilion Peak Dr, Windsor, CO 80550For SaleMLS ID #1063709, Joe Krevinghaus, Reliable House Partners. IRES as distributed by MLS GRID
- $549,9004 bd4 ba3.1k sqft1670 Sorenson Dr, Windsor, CO 80550For SaleMLS ID #1062020, Josh Landers, RE/MAX Nexus. IRES as distributed by MLS GRID
- $565,0005 bd4 ba2.8k sqft860 Camberly Dr, Windsor, CO 80550For SaleMLS ID #1063889, Jacob Tillitt, Group Harmony. IRES as distributed by MLS GRID
- $620,0004 bd4 ba3.5k sqft1456 Moraine Valley Dr, Severance, CO 80550For SaleMLS ID #1062797, Ryan Livingston, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $569,9005 bd3 ba3.2k sqft1252 Wild Basin Rd, Severance, CO 80550For SaleMLS ID #1066037, Jeff Butler, Resident Realty. IRES as distributed by MLS GRID
- $810,0004 bd3 ba3.5k sqft1799 Tinkers Dr, Windsor, CO 80550For SaleMLS ID #1065588, Kimberley Hattem, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $570,0005 bd3 ba3.2k sqft1593 Sierra Plaza St, Severance, CO 80550For SaleMLS ID #1064300, Lori Lindholm, Lindholm Realty, Inc.. IRES as distributed by MLS GRID
- $480,0004 bd3 ba2.7k sqft1512 Lake Vista Way, Severance, CO 80550For SaleMLS ID #1065398, Tamara Yaromy, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID
- $625,0004 bd3 ba2.6k sqft6399 Verna Ct, Timnath, CO 80547For SaleMLS ID #1062326, Nicole Huntsman, Group Harmony. IRES as distributed by MLS GRID
- $530,0004 bd3 ba2.2k sqft375 Aurelia Dr, Windsor, CO 80550For SaleBHHS broker feed
- $570,0004 bd3 ba2.8k sqft714 62nd Ave, Greeley, CO 80634For SaleMLS ID #1066010, Sonja Belfiore, eXp - Greeley. IRES as distributed by MLS GRID
- $729,0004 bd4 ba3k sqft6241 Vernazza Way #1, Windsor, CO 80550For SaleMLS ID #1059109, Jennifer Borg, Orchard Brokerage LLC. IRES as distributed by MLS GRID
