$624,900

Estimated payment $3,873/month

Total Views 23
4 Beds
3 Baths
2,940 Sq Ft
$213 Price per Sq Ft

Highlights

  • Access To Lake
  • Deck
  • Main Floor Bedroom
  • View of Hills
  • Cathedral Ceiling
  • Corner Lot

About 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!

Listing Agent

Julie Love

NextHome Foundations Brokerage Phone: 9703535006 License #100111204 Listed on: 07/29/2026

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,888

Year Built

  • Built in 2017

Lot Details

  • 8,276 Sq Ft Lot
  • Kennel or Dog Run
  • Wood Fence
  • Corner Lot
  • Paved or Partially Paved Lot
  • Sprinkler System
  • Landscaped with Trees

HOA Fees

  • $31 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Composition Roof
  • Stone

Interior Spaces

  • 2,940 Sq Ft Home
  • 4-Story Property
  • Cathedral Ceiling
  • Window Treatments
  • Living Room with Fireplace
  • Dining Room
  • Views of Hills
  • Washer and Dryer Hookup
  • Unfinished Basement

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Primary bathroom on main floor
  • Bathtub and Shower Combination in Primary Bathroom
  • Soaking Tub

Home Security

  • Radon Detector
  • Fire and Smoke Detector

Outdoor Features

  • Access To Lake
  • Deck
  • Patio
  • Outdoor Gas Grill

Schools

  • Windsor Charter Academy Elementary School
  • Ridgeline Middle School
  • Windsor High School

Utilities

  • Forced Air Heating and Cooling System
  • Water Softener is Owned
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R8945933

Community Details

Overview

  • Association fees include common amenities, trash
  • Kellison Association Mgmt Association, Phone Number (970) 494-0609
  • South Hill 2Nd Fg Subdivision

Recreation

  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,888

Year Built

Built in 2017

Lot Details

8,276 Sq Ft Lot

HOA Fees

$31 per month

Parking

3

Listing Details

  • Year Built: 2017
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.19
  • Road Surface Type: Concrete
  • Subdivision Name: South Hill 2nd Fg
  • Unit Levels: Four
  • New Construction: No
  • Property Attached Yn: No
  • Attribution Contact: 9703535006
  • RoomType: Bedroom 4
  • RoomType: Dining Room
  • RoomType: Kitchen
  • RoomType: Living Room
  • RoomFeatures: Tub+Shower Primary
  • RoomType: Primary Bedroom
  • RoomType: Study
  • IRE_AssociationFeeYN: Yes
  • IRE_AssociationYN2: 0
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 2940
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • IRE_HasFamilyRoom: 0
  • IRE_ElementarySchool2: Windsor Charter Academy
  • Special Features: None

Interior Features

  • Possible Use: Single Family
  • Appliances: Gas Range, Dishwasher, Refrigerator, Microwave, Gas Bar-B-Q, Water Softener Owned, Disposal, Fire Alarm
  • Accessibility Features: Main Floor Bath, Main Level Bedroom
  • Has Basement: Unfinished, Built-In Radon
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: Living Room
  • Interior Amenities: Cathedral Ceiling(s), Pantry, Walk-In Closet(s), Washer/Dryer Hookup, Kitchen Island, High Ceilings
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Fencing: Wood, Dog Run/Kennel
  • Lot Features: Corner Lot, Deciduous Trees, Lake Access, Paved, Curbs, Gutters, Sidewalks, Street Light
  • View: Hills
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Frame, Stone, Composition
  • Exterior Features: Sprinkler System, Oversized Garage
  • Patio And Porch Features: Patio, Deck

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Attached
  • IRE_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Poudre Valley REA
  • Heating: Forced Air
  • Utilities: Electricity Available, Cable Available, High Speed Avail
  • Water Source: City, District

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Trash
  • Community Features: Park, Trail(s)
  • Association Fee: 375
  • Association Fee Frequency: Annually
  • Association Name: Kellison Association Mgmt
  • Phone: 970-494-0609
  • Association: Yes

Schools

  • Elementary School: Orchard Hill
  • HighSchool: Windsor
  • Junior High Dist: Weld RE-4
  • Middle Or Junior School: Ridgeline

Lot Info

  • Zoning: RES
  • Parcel #: R8945933
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 4888

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $4,888 $33,830 $6,120 $27,710
2025 $4,395 $34,550 $6,250 $28,300
2024 $4,395 $34,550 $6,250 $28,300
2023 $4,051 $36,150 $7,100 $29,050
2022 $3,968 $28,290 $6,260 $22,030
2021 $3,791 $29,100 $6,440 $22,660
2020 $3,422 $26,610 $6,790 $19,820
2019 $3,309 $25,890 $6,790 $19,100
2018 $3,291 $24,960 $5,040 $19,920
2017 $662 $4,900 $4,900 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/29/2026 07/29/26 For Sale $624,900 +43.7% $213 / Sq Ft
09/30/2019 09/30/19 Off Market $435,000 -- --
07/02/2019 07/02/19 Sold $435,000 0.0% $148 / Sq Ft View Prior Sale
05/30/2019 05/30/19 Price Changed $435,000 -0.9% $148 / Sq Ft
04/24/2019 04/24/19 For Sale $439,000 +19.7% $149 / Sq Ft
01/28/2019 01/28/19 Off Market $366,682 -- --
08/25/2017 08/25/17 Sold $366,682 +1.7% $131 / Sq Ft View Prior Sale
07/26/2017 07/26/17 Pending -- -- --
04/07/2017 04/07/17 For Sale $360,625 -- $129 / Sq Ft
Source: IRES MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $435,000 Capital Title
Special Warranty Deed $366,682 Heritage Title Co
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $285,000 New Conventional
Previous Owner $293,345 Commercial
Source: Public Records

Source: IRES MLS

MLS Number: IRE1066493

IRES MLS

APN: R8945933

Your Personal Tour Guide

Ask me questions while you tour the home.