Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$624,900

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 2,940 Sq. Ft.
  • 3 Car Garage
  • Updated 6 days ago

Next open house:

Open House: 10:00 AM - 11:30 AM

Saturday 8/22 10:00 AM - 11:30 AM

897 Shade Tree Dr,Windsor, CO 80550

897 Shade Tree DrWindsorCO80550

Get directions
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 897 Shade Tree Dr

General

  • Price: $624,900
  • HOA FEE: $31/month
  • HOA FEE FREQ.: Annually
  • Taxes: $4,888 (2025)
  • Status: Active
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1066493
  • Updated: 8/15/2026
  • Added to Site: 23 day(s) ago

Interior

  • Interior Features: Cathedral Ceiling(s), Pantry, Walk-In Closet(s), Washer/Dryer Hookup, Kitchen Island, High Ceilings
  • Fireplace: Yes
  • Fireplace(s): Living Room
  • Appliances: Gas Range, Dishwasher, Refrigerator, Microwave, Gas Bar-B-Q, Water Softener Owned, Disposal, Fire Alarm

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 3

Bedrooms

  • Total Bedrooms: 4

Exterior

  • Exterior Features: Sprinkler System, Oversized Garage
  • Porch/Patio/Deck: Patio, Deck

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Attached
  • Garage Description: Attached

Location

  • Area: Windsor
  • County: Weld
  • Subdivision: South Hill 2nd Fg

School Information

  • School District: Weld RE-4
  • Elementary School: Orchard Hill
  • Middle School: Ridgeline
  • High School: Windsor

Community

  • Association: Yes
  • Assoc. Name: Kellison Association Mgmt
  • Assoc. Fees Include: Common Amenities, Trash

Heating & Cooling

  • Cooling Type: Central Air
  • Heating Type: Forced Air

Utilities

  • Gas: Xcel
  • Water: City, District
  • Utility Description: Electricity Available, Cable Available, High-Speed Internet Available

Structural Information

  • Construction: Frame, Stone, Composition
  • Exterior Const.: Frame, Stone, Composition
  • Basement: Yes
  • Basement Desc.: Unfinished, Built-In Radon
  • Roof: Composition
  • Windows: Window Coverings
  • Square Feet: 2,940
  • Sq. Ft. Source: Assessor
  • Living Area: 2,302 Sq. Ft.
  • Year Built: 2017

Lot Features

  • Property View: Hills
  • Lot Size (Acres): 0.19
  • Lot Size (Sq. Ft.): 8,481
  • Street/Road Desc.: Concrete
  • Fence: Yes
  • Lot Features: Corner Lot, Deciduous Trees, Lake Access, Paved, Curbs, Gutters, Sidewalks, Street Light
  • Potential Use: Single-Family
  • Zoning: RES
  • Fencing (Description): Wood, Dog Run/Kennel

Financial Considerations

  • Association Fee: Yes
  • Association Fee: $375
  • Assoc Fee Freq.: Annually
  • Tax Amount: $4,888
  • Tax Year: 2025
  • Terms: Cash, Conventional, FHA, VA

Disclosures and Reports

  • Special Conditions: Private Owner
  • Exclusions: Staging furniture & decor, owners personal property, curtains.
  • Property ID: R8945933

Listed by NextHome Foundations (970) 353-5006

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 897 Shade Tree Dr —

  • NextHome Foundations

    970-353-5006

9703535006

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 897 Shade Tree Dr

School District:Windsor School District Re-4
NameGradesDistance
Windsor Middle School
900 Main Street, Windsor, CO 80550
6-83 mi
Windsor High School
1100 Main Street, Windsor, CO 80550
9-123.1 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 897 Shade Tree Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
7/29/2026
Listed
$624,900
43.66%
MLS
7/02/2019
Sold
$435,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 897 Shade Tree Dr

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,888
—
$33,830
-2%
2025
$4,888
11%
$34,550
-4%
2024
$4,395
8%
$35,810
-1%
2023
$4,051
7%
$36,150
24%
2021
$3,791
-4%
$29,100
3%
2022
$3,968
16%
$28,290
6%
2020
$3,422
3%
$26,610
3%
2019
$3,309
1%
$25,890
4%
2018
$3,291
397%
$24,960
409%
2017
$662
—
$4,900
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 897 Shade Tree Dr

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by NextHome Foundations (970) 353-5006

Similar Properties near 897 Shade Tree Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

835 Mesic Ln, Windsor, CO 80550 - Photo 1
$624,990
Open House

835 Mesic Ln  Windsor, CO 80550

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 3,512
    Sq. Ft.
  • MLS # 1061717
Listed by RE/MAX Alliance-FTC South
1642 Colorado River Dr, Windsor, CO 80550 - Photo 1
$625,000
Open House

1642 Colorado River Dr  Windsor, CO 80550

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 3,881
    Sq. Ft.
  • MLS # 7885969
Listed by NAV Real Estate
6259 Oak Grove St, Timnath, CO 80547 - Photo 1
$640,000

6259 Oak Grove St  Timnath, CO 80547

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,475
    Sq. Ft.
  • MLS # 8587831
Listed by Dawn Mathis (970) 481-5263
7320 Tamarisk Dr, Fort Collins, CO 80528 - Photo 1 New to Website
$640,000

7320 Tamarisk Dr  Fort Collins, CO 80528

  • Single Family
  • Active
  • Updated 1 hour ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,275
    Sq. Ft.
  • MLS # 1066980
Listed by Group Harmony

Just Listed near 897 Shade Tree Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

809 Elias Tarn Dr, Severance, CO 80550 - Photo 1 New to Website
$450,000
Open House

809 Elias Tarn Dr  Severance, CO 80550

  • Single Family
  • Active
  • Updated 15 hours ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,797
    Sq. Ft.
  • MLS # 1066894
Listed by Real
905 Scotch Pine Dr, Severance, CO 80550 - Photo 1 New to Website
$475,000

905 Scotch Pine Dr  Severance, CO 80550

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,824
    Sq. Ft.
  • MLS # 1066728
Listed by Kentwood RE Northern Prop Llc
[Address not provided], Severance, CO 80546 - Photo 1 New to Website
$1,100,000

[Address not provided]  Severance, CO 80546

  • Farm
  • Active
  • Updated 9 hours ago
  • MLS # 1066959
Listed by Hayden Outdoors - Windsor
99 Pike Ln, Severance, CO 80550 - Photo 1 New to Website
$470,000
Open House

99 Pike Ln  Severance, CO 80550

  • Single Family
  • Active
  • Updated 1 day ago
  • 5
    Beds
  • 3
    Total Baths
  • 1,920
    Sq. Ft.
  • MLS # 1066881
Listed by Realty One Group Fourpoints and Non-IRES

Price Reduced near 897 Shade Tree Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

39230 Longs Peak Ct, Severance, CO 80610 - Photo 1 Price Reduced
-$35,000 (-2.03%)
$1,690,000

39230 Longs Peak Ct  Severance, CO 80610

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 4,912
    Sq. Ft.
  • MLS # 1045052
Listed by Group Mulberry
938 Scotch Pine Dr, Severance, CO 80550 - Photo 1 Price Reduced
-$5,000 (-0.84%)
$593,000

938 Scotch Pine Dr  Severance, CO 80550

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,451
    Sq. Ft.
  • MLS # 1064647
Listed by Kittle Real Estate
92 Summit View Rd, Severance, CO 80550 - Photo 1 Price Reduced
-$5,100 (-1.07%)
$469,900

92 Summit View Rd  Severance, CO 80550

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,576
    Sq. Ft.
  • MLS # 7218082
Listed by Evernest, LLC
1512 Lk Vis Wy, Severance, CO 80550 - Photo 1 Price Reduced
-$5,000 (-1.03%)
$480,000

1512 Lk Vis Wy  Severance, CO 80550

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,775
    Sq. Ft.
  • MLS # 1065398
Listed by C3 Real Estate Solutions, LLC

Recent Sales near 897 Shade Tree Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

946 Tail Water Dr, Windsor, CO 80550 - Photo 1 Sold
$675,000

946 Tail Water Dr  Windsor, CO 80550

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 3,448
    Sq. Ft.
  • MLS # 1049106
Listed by Real
Sold by Kittle Real Estate
1780 Barefoot Dr, Windsor, CO 80550 - Photo 1 Sold
$599,900

1780 Barefoot Dr  Windsor, CO 80550

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 2,154
    Sq. Ft.
  • MLS # 1036272
Listed by Group Harmony
Sold by Alysha Melaragno
1792 Barefoot Dr, Windsor, CO 80550 - Photo 1 Sold
$660,000

1792 Barefoot Dr  Windsor, CO 80550

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 3,086
    Sq. Ft.
  • MLS # 1044333
Listed by Group Harmony
Sold by Non-IRES
1476 First Light Dr, Windsor, CO 80550 - Photo 1 Sold
$549,999

1476 First Light Dr  Windsor, CO 80550

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 2,638
    Sq. Ft.
  • MLS # 4063382
Listed by Compass - Denver
Sold by RE/MAX Alliance-Windsor

897 Shade Tree Dr, Windsor, CO 80550 (MLS# 1066493) is a Single Family property with 4 bedrooms and 3 full bathrooms. 897 Shade Tree Dr is currently listed for $624,900 and was received on July 29, 2026. Want to learn more about 897 Shade Tree Dr? Do you have questions about finding other Single Family real estate for sale in Windsor? You can browse all Windsor real estate or contact a Coldwell Banker agent to request more information.

Tour this property