See Home Value
Windsor 80550
897 Shade Tree Dr
$620,000
● House - Off Market

897 Shade Tree Dr

Windsor, CO 80550
bedrooms
4 Beds
bathrooms
3 Baths
square feet
2,302 Ft²
$3,507
Est. Monthly
$31
HOA / Fees

About This Property

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!
Unit Size
2,302 Ft²
Days on Market
-
Land Size
0.19 acres
Price per sqft
$271
Property Type
House
Property Taxes
$407
HOA Dues
$31
Year Built
2017

Payment Calculator

Cap Rate Calculator

Last updated: 4 days ago (IRES MLS #IRE1066493)

Price History

Date / Event Date Event Price
Oct 9, 2026 Sold
Sold
Aug 27, 2026 In contract -
In contract
Jul 29, 2026 Listed $624,900
Listed
Jul 3, 2019 Sold
Sold
Aug 28, 2017 Sold
Sold
Show More

Property Highlights

Garage
Air Conditioning
Fireplace
With View

Building Info

Overview

    General

  • Year Built: 2017
  • Effective Year Built: 2017
  • Building Count: 1
  • Bedroom Count: 4
  • Bathroom Count: 3
  • Full Bathrooms: 3
  • Partial Bathrooms: 3
  • Bathroom Plumbing Fixtures: 14
  • Building Condition: 0
  • Building Quality: 0
  • Construction Type: 6
  • Building Style: 41
  • Exterior Walls Type: 23
  • Interior Walls Type: 3
  • Roof Shape Type: 0
  • Roof Cover Type: 3
  • Floor Count: 200
  • Floor Cover: 0
  • Basement Type: 9
  • Basement Area: 641
  • Garage Type: 1
  • Garage Square Area: 803
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 36
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 8,481
  • Total Building Area: 3,746
  • Gross Building Area: 3,746
  • Building Area: 2,302
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 2,302
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: SOUTH HILL 2ND FG
  • Land Acres: 0000000195
  • Standard Land Use Code: 1001
  • County Land Use Code: 1212
  • Legal Description 1: LOT 1 BLOCK 15 SOUTH HILL 2ND FG

Neighborhood

  • School District Name: Windsor School District RE-4
  • Census Tract: 002210

Geography

  • Account Number: R8945933
  • Parcel: R8945933
  • Block: 15
  • Lot: 1
  • Latitude: 40.4373
  • Longitude: -104.913

    Address

  • Full Address: 897 Shade Tree Dr
  • Address - House Number: 897
  • Address - Street Name: Shade Tree
  • Address - Suffix Type: Dr
  • State: CO
  • City Name: Windsor
  • Carrier Code: R013
  • 4-Digit Zip Code: 3428
  • Zip Code: 80550

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $405,118
  • Tax Rate Code Area: 0452

    Appraisal Valuation

  • Standard Deviation: 0.1607
  • Valuation Date: Apr 03, 2024
  • Confidence Score: 79
  • Final Value: 621,784
  • High Value: 721,720
  • Low Value: 521,849

    Market Valuation

  • Market Total Value: $534,344
  • Market Land Value: $105,000
  • Market Improvement Value: $429,344

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $35,810
  • Assessed Land Value: $7,040
  • Assessed Improvements Value: $28,770

    Sales

  • Current Sale Contract Date: Jul 02, 2019
  • Current Sale Recording Date: Jul 03, 2019
  • Current Sale Price:
  • Current Sale Document Type: 71
  • Current Sale Input Document Number: 4503258
  • Previous Sale Recording Date: Aug 28, 2017
  • Previous Sale Contract Date: Aug 25, 2017
  • Previous Sale Amount: $366,682
  • Previous Sale Document Type: 68
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Windsor


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 897 Shade Tree Drive built and last sold?
The property at 897 Shade Tree Drive was built in 2017 and last sold on Jul 2, 2019 for $435,000.
How much is this home worth?
The estimated value of the home located at 897 Shade Tree Drive is $608,250.
What are some comparable homes to 897 Shade Tree Drive?
There are currently no comparable homes to 897 Shade Tree Drive.