(Construction not yet started) Unobstructed mountain views! Come work with the award winning custom design-builder Robbins Contracting to design your dream modern farmhouse. With different floor plans to choose from or the ability to start from scratch, make your MODERN FARMHOUSE dream home a reality in these iconic properties! Pick corn from the field in your back yard and cook it in your GOURMET KITCHEN. Enjoy a huge lot with a paved PRIVATE driveway & MOUNTAIN & FARM VIEWS! Take a short golf cart ride to the BEACH, the POOL, RESTAURANTS, 45 HOLES OF GOLF, & more! Custom design your own farmhouse on any available Country Farm Home lot. Pricing starting in the high $800's! Price is based on attached floor plan.
- MLS# 901564
- Date Listed01/10/2020
- Bedrooms 4
- Bathrooms 3 Full baths, 1 Half baths
- Lot Size 0.42 acres (18,450 sq. ft)
- Sewer Public Sewer
- Subdivision Pelican Farms
- Property Type Single Family
- County Weld
- Year Built 2021
- Water Public
- Square Feet 3,553 sq. ft
- Price Per Sq. Ft $267.38
Interior Features
- Appliances Double Oven, Dishwasher, Refrigerator, Water Heater, Oven
- Cooling Central Air
- Heating Forced Air
Exterior / Lot Features
- Roof Composition, Metal
- Lot Size Acres 0.42
- Lot Size SQFT 18,450.00
- Lot Features Level
Directions
From I-25 & Crossroads Blvd, E on Crossroads to traffic round-about. North at round-about on 7th Street. Turn West onto private paved drive. (First Left) Look for big white Country Farm Homes sign at the entrance. Lot 5 on attached map
Financial Considerations
- HOA Fee $300 Annually
- Tax Amount $13
- Terms Cash, Conventional, FHA, VA Loan
Nearby Schools
Source: School Digger
Public • PK - 5 • Serves this home
3.33 mi
Distance
Windsor Charter Academy - Middle School
Public • 6 - 8 • Serves this home
3.71 mi
Distance
Windsor Charter Academy - Secondary
Public • 9 - 12 • Serves this home
3.71 mi
Distance
Public • PK - 5 • Serves this home
3.33 mi
Distance
Public • PK - 2
3.44 mi
Distance
Public • PK - 5
5.51 mi
Distance
Mountain View Elementary School
Public • 3 - 5
3.44 mi
Distance
Windsor Charter Academy - Middle School
Public • 6 - 8 • Serves this home
3.71 mi
Distance
Public • 6 - 8
4.33 mi
Distance
Public • 6 - 8
7.08 mi
Distance
Windsor Charter Academy - Secondary
Public • 9 - 12 • Serves this home
3.71 mi
Distance
Public • 9 - 12
4.38 mi
Distance
Public • 9 - 12
7.08 mi
Distance
Sales & Tax History
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price | Valuation Date | Valuation Price |
|---|---|---|---|---|---|---|
| 2270 Sublime Drive | Listing | 3 | 3 | Oct 11, 2025 | $465,100 | Mar 21, 2024 | $510,510 |
| 2381 Sublime Drive | 3 | 2 | Oct 24, 2025 | $468,500 | Dec 02, 2025 | - |
| 2381 Sublime Dr | 3 | 2 | Oct 24, 2025 | $468,500 | Dec 02, 2025 | - |
| 2270 Sublime Dr | 3 | 3 | Oct 11, 2025 | $465,100 | Dec 02, 2025 | - |
| 2324 Golden Way | 3 | 3 | Oct 08, 2025 | $452,670 | Dec 02, 2025 | - |
| 2324 Golden Way | 3 | 3 | Oct 08, 2025 | $452,670 | Dec 02, 2025 | - |
| 2303 Graceful St | 3 | 3 | Nov 07, 2025 | $443,375 | Dec 02, 2025 | - |
| 2297 Graceful St | 3 | 2 | Oct 28, 2025 | $446,560 | Dec 02, 2025 | - |
| 2297 Graceful Street | 3 | 2 | Oct 28, 2025 | $446,560 | Dec 02, 2025 | - |
| 2303 Graceful Street | 3 | 3 | Nov 07, 2025 | $443,375 | Dec 02, 2025 | - |
Population & Environment
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 42,076 | 36,353 | 340,903 | 335,858,263 |
| Population Density | 809 | 1,361 | 86 | 95 |
| People per Household | 2.7 | 2.8 | 2.8 | 2.6 |
| Median Age | 40.2 | 40.6 | 36.5 | 39.1 |
| Median Income | $92,503 | $92,475 | $76,870 | $66,222 |
| Average Income | $40,567 | $40,921 | $33,336 | $35,475 |
| Cost of Living Index | 105 | 107 | 106 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 15.3°F | 15.3°F | 15.6°F | 22.6°F |
| July Avg. High Temp | 85.5°F | 85.5°F | 88.7°F | 86.2°F |
| Annual Precipitation | 12.72" | 12.72" | 12.72" | 38" |
25/100
Bikable
Bike Score ®
Overview
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 7/100, Transit Score: 0/100, Bike Score: 28/100.
Property Change History
View Changes
Previous Value:
Updated Value:
View Changes
Previous Value:
Updated Value:
Points of Interest near 823 Shade Tree Dr, Windsor, CO 80550
0.27 mi
Distance
0.99 mi
Distance
1.07 mi
Distance
1.1 mi
Distance
1.11 mi
Distance
1.27 mi
Distance
1.33 mi
Distance
0.43 mi
Distance
0.45 mi
Distance
1.06 mi
Distance
0.43 mi
Distance
0.43 mi
Distance
0.43 mi
Distance
1.17 mi
Distance
1.21 mi
Distance
1.27 mi
Distance
Oklahoma School, Weld County, CO, USA
Education
1.3 mi
Distance
0.39 mi
Distance
0.63 mi
Distance
0.73 mi
Distance
0.95 mi
Distance
1.04 mi
Distance
1.3 mi
Distance
Nearby Properties
-
$825,000 Active4 bds • 3 ba • 3,073 sqft
2100 Gather Ct, Windsor, CO 80550
Exceptional Raindance home with luxurious upgrades and outdoor charm! Perfectly positioned on a large cul-de-sac lot in one of Windsor's most desirable communities, this two-story beauty blends elegant design, smart updates, and modern comfort in eve...Listing by: Rob Kittle -
$825,000 Active4 bds • 3 ba • 3,073 sqft
2100 Gather Court, Windsor, CO 80550
Exceptional Raindance home with luxurious upgrades and outdoor charm! Perfectly positioned on a large cul-de-sac lot in one of Windsor's most desirable communities, this two-story beauty blends elegant design, smart updates, and modern comfort in eve...Listing by: Rob Kittle - Kittle Real Estate -
$899,000 Active5 bds • 3 ba • 3,908 sqft
1726 Bounty Drive, Windsor, CO 80550
What a find! In the heart of the RainDance golf cart community, this tastefully landscaped corner-lot home is bursting with generous updates. With a front view over the green expanse of Barnyard Park, you're only steps away from neighborhood amenitie...Listing by: Jeremy Mitchell - Find Colorado Real Estate -
$899,000 Active5 bds • 3 ba • 3,908 sqft
1726 Bounty Dr, Windsor, CO 80550
What a find! In the heart of the RainDance golf cart community, this tastefully landscaped corner-lot home is bursting with generous updates. With a front view over the green expanse of Barnyard Park, you're only steps away from neighborhood amenitie...Listing by: Jeremy Mitchell -
$899,000 Active Under Contract5 bds • 4 ba • 3,042 sqft
1881 Frost Drive, Windsor, CO 80550
This exceptional home features over $160,000 in upgrades and is set on one of the largest lots in Festival at nearly 8,000 sq. ft. Perfectly situated on a corner lot backing to Festival Park, this home enjoys unmatched privacy, views, and natural lig...Listing by: Lani Carwin - RE/MAX Alliance-Loveland -
$899,000 Active Under Contract5 bds • 4 ba • 3,042 sqft
1881 Frost Dr, Windsor, CO 80550
This exceptional home features over $160,000 in upgrades and is set on one of the largest lots in Festival at nearly 8,000 sq. ft. Perfectly situated on a corner lot backing to Festival Park, this home enjoys unmatched privacy, views, and natural lig...Listing by: Lani Carwin -
$875,000 Active5 bds • 4 ba • 3,887 sqft
1815 Windfall Dr, Windsor, CO 80550
Remarkable ranch-style home with a finished basement, perfectly situated on a corner lot in Raindance's desirable Festival section! Designer touches shine throughout, including engineered hardwood floors in the main living areas and soaring ceilings...Listing by: Stefanie Erion -
$875,000 Active5 bds • 4 ba • 3,887 sqft
1815 Windfall Drive, Windsor, CO 80550
Remarkable ranch-style home with a finished basement, perfectly situated on a corner lot in Raindance's desirable Festival section! Designer touches shine throughout, including engineered hardwood floors in the main living areas and soaring ceilings...Listing by: Stefanie Erion - Kentwood RE Northern Prop Llc -
$915,000 Active5 bds • 4 ba • 3,576 sqft
313 Habitat Cove, Windsor, CO 80550
WATER VALLEY RESORT LIVING, situated on a quiet cul-de-sac. Property backs to sand belt with lake views and access to beach/water. Just a short distance to Pelican Lakes Clubhouse, golf course and Poudre Trails. Very open floor plan on the main with...Listing by: William Richardson - Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins -
$915,000 Active5 bds • 4 ba • 3,576 sqft
313 Habitat Cv, Windsor, CO 80550
WATER VALLEY RESORT LIVING, situated on a quiet cul-de-sac. Property backs to sand belt with lake views and access to beach/water. Just a short distance to Pelican Lakes Clubhouse, golf course and Poudre Trails. Very open floor plan on the main with...Listing by: William Richardson -
$840,000 Active5 bds • 4 ba • 3,898 sqft
2071 Dusk Ct, Windsor, CO 80550
Bring the whole family to this beautiful move-in ready single-story home! Designed with an open-concept layout, this home offers a bright and spacious living area perfect for everyday living and effortless entertaining. The gourmet kitchen features a...Listing by: Parker Bright -
$840,000 Active5 bds • 4 ba • 3,898 sqft
2071 Dusk Court, Windsor, CO 80550
Bring the whole family to this beautiful move-in ready single-story home! Designed with an open-concept layout, this home offers a bright and spacious living area perfect for everyday living and effortless entertaining. The gourmet kitchen features a...Listing by: Parker Bright - American Legend Homes LLC -
$912,000 Active4 bds • 3 ba • 3,284 sqft
1746 Abundance Dr, Windsor, CO 80550
Stunning Ranch in coveted Sugar Hills at Raindance! This beautiful home truly checks every box - style, comfort, and location. Step inside to find a thoughtfully designed floor plan filled with natural light, elegant finishes, and wide-open spaces.Th...Listing by: Jill Leichliter -
$929,000 Active4 bds • 3 ba • 3,274 sqft
1825 Flourish Drive, Windsor, CO 80550
Step into this spacious single-story home offering 4 bedrooms, 3 baths, and 3,493 square feet of open-concept living space. The well-appointed kitchen features Kitchen Aid double ovens, a large island, plenty of counter and cabinet space, a desk area...Listing by: Parker Bright - American Legend Homes LLC -
$929,000 Active4 bds • 3 ba • 3,274 sqft
1825 Flourish Dr, Windsor, CO 80550
Step into this spacious single-story home offering 4 bedrooms, 3 baths, and 3,493 square feet of open-concept living space. The well-appointed kitchen features Kitchen Aid double ovens, a large island, plenty of counter and cabinet space, a desk area...Listing by: Parker Bright -
$912,000 Active4 bds • 3 ba • 3,284 sqft
1746 Abundance Drive, Windsor, CO 80550
Stunning Ranch in coveted Sugar Hills at Raindance! This beautiful home truly checks every box - style, comfort, and location. Step inside to find a thoughtfully designed floor plan filled with natural light, elegant finishes, and wide-open spaces.Th...Listing by: Jill Leichliter - RE/MAX Alliance-Loveland -
$1,050,000 Active5 bds • 4 ba • 3,049 sqft
1728 Center Pivot Dr, Windsor, CO 80550
Welcome to resort-style living, offering an exceptional blend of luxury, convenience, and world-class amenities in Raindance. Enjoy a truly one-of-a-kind move-in ready home boasting nearly $300k upgrades and updates seen only in model homes. This Tru...Listing by: Tiffany Luthi -
$1,050,000 Active5 bds • 4 ba • 3,049 sqft
1728 Center Pivot Drive, Windsor, CO 80550
Welcome to resort-style living, offering an exceptional blend of luxury, convenience, and world-class amenities in Raindance. Enjoy a truly one-of-a-kind move-in ready home boasting nearly $300k upgrades and updates seen only in model homes. This Tru...Listing by: Tiffany Luthi - Group Centerra -
$855,000 Active5 bds • 4 ba • 4,083 sqft
8736 Blackwood Dr, Windsor, CO 80550
You will be amazed by the craftsmanship, design, and care in this beautiful home. The open-concept living space is both elegant and inviting, anchored by a chef's kitchen with high-end finishes, granite countertops, and cabinetry designed for both be...Listing by: Stephanie Zambo -
$855,000 Active5 bds • 4 ba • 4,083 sqft
8736 Blackwood Drive, Windsor, CO 80550
You will be amazed by the craftsmanship, design, and care in this beautiful home. The open-concept living space is both elegant and inviting, anchored by a chef's kitchen with high-end finishes, granite countertops, and cabinetry designed for both be...Listing by: Stephanie Zambo - Coldwell Banker Realty- Fort Collins
Similar Priced Comparison
-
$850,000 Active5 bds • 3 ba • 2914 sqft
923 Pitch Fork Drive
- Home smaller by 639 sqft
- Lot smaller by 2,993 sqft
- Older by 1 years
Listing by: Shelly Anne Goldrich - Group Harmony -
$850,000 Active5 bds • 3 ba • 2914 sqft
923 Pitch Fork Dr
- Home smaller by 639 sqft
- Lot smaller by 2,993 sqft
- Older by 1 years
Listing by: Shelly Anne Goldrich -
$895,000 Active5 bds • 5 ba • 4667 sqft
1999 Bayfront Drive
- Home larger by 1,114 sqft
- Lot smaller by 9,955 sqft
- Older by 14 years
Listing by: Dennis Schick - RE/MAX Alliance-FTC South -
$895,000 Active5 bds • 5 ba • 4667 sqft
1999 Bayfront Dr
- Home larger by 1,114 sqft
- Lot smaller by 9,955 sqft
- Older by 14 years
Listing by: Dennis Schick -
$1,050,000 Active4 bds • 4 ba • 5033 sqft
2000 Bayfront Dr
- Home larger by 1,480 sqft
- Lot smaller by 10,370 sqft
- Older by 14 years
Listing by: Julie Perich -
$1,050,000 Active4 bds • 4 ba • 5033 sqft
2000 Bayfront Drive
- Home larger by 1,480 sqft
- Lot smaller by 10,370 sqft
- Older by 14 years
Listing by: Julie Perich - Resident Realty -
$780,000 Active4 bds • 4 ba • 3441 sqft
387 Seahorse Drive
- Home smaller by 112 sqft
- Lot smaller by 12,450 sqft
- Older by 4 years
Listing by: Jacob Tillitt - Group Harmony -
$780,000 Active4 bds • 4 ba • 3441 sqft
387 Seahorse Dr
- Home smaller by 112 sqft
- Lot smaller by 12,450 sqft
- Older by 4 years
Listing by: Jacob Tillitt -
$949,000 Active4 bds • 5 ba • 4576 sqft
2025 Seagrove Court
- Home larger by 1,023 sqft
- Lot smaller by 4,473 sqft
- Older by 8 years
Listing by: Kyle Basnar - Group Mulberry -
$949,000 Active4 bds • 5 ba • 4576 sqft
2025 Seagrove Ct
- Home larger by 1,023 sqft
- Lot smaller by 4,473 sqft
- Older by 8 years
Listing by: Kyle Basnar -
$750,000 Active5 bds • 4 ba • 3689 sqft
1987 Seadrift Dr
- Home larger by 136 sqft
- Lot smaller by 7,204 sqft
- Older by 16 years
Listing by: Ryan Andre -
$750,000 Active5 bds • 4 ba • 3689 sqft
1987 Seadrift Drive
- Home larger by 136 sqft
- Lot smaller by 7,204 sqft
- Older by 16 years
Listing by: Ryan Andre - Sears Real Estate -
$949,000 Active Under Contract6 bds • 4 ba • 5327 sqft
1976 Cayman Drive
- Home larger by 1,774 sqft
- Lot smaller by 9,595 sqft
- Older by 7 years
Listing by: Desi Moss - eXp Realty LLC -
$949,000 Active Under Contract6 bds • 4 ba • 5327 sqft
1976 Cayman Dr
- Home larger by 1,774 sqft
- Lot smaller by 9,595 sqft
- Older by 7 years
Listing by: Desi Moss -
$755,000 Active6 bds • 5 ba • 4061 sqft
2150 Crop Row Dr
- Home larger by 508 sqft
- Lot smaller by 10,424 sqft
- Older by 2 years
Listing by: Amy Kilcoyne -
$755,000 Active6 bds • 5 ba • 4061 sqft
2150 Crop Row Drive
- Home larger by 508 sqft
- Lot smaller by 10,424 sqft
- Older by 2 years
Listing by: Amy Kilcoyne - Keller Williams Realty NoCo -
$724,900 Active3 bds • 2 ba • 2130 sqft
1788 Barefoot Drive
- Home smaller by 1,423 sqft
- Lot smaller by 14,757 sqft
- Newer by 1 years
Listing by: Katherine Beck - The Group Inc - Harmony -
$724,900 Active3 bds • 2 ba • 2130 sqft
1788 Barefoot Drive
- Home smaller by 1,423 sqft
- Lot smaller by 14,757 sqft
- Newer by 1 years
Listing by: Kathy Beck - Group Harmony -
$724,900 Active3 bds • 2 ba • 2130 sqft
1788 Barefoot Dr
- Home smaller by 1,423 sqft
- Lot smaller by 14,757 sqft
- Newer by 1 years
Listing by: Kathy Beck -
$725,000 Active5 bds • 5 ba • 4605 sqft
2275 Stonefish Drive
- Home larger by 1,052 sqft
- Lot smaller by 9,040 sqft
- Older by 4 years
Listing by: Kendra Benzen - Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins
Nearby Locations
Communities
- Water Valley Homes For Sale
- Raindance Homes For Sale
- Promontory Homes For Sale
- Rolling Hills Ranch Homes For Sale
- Thompson Crossing Homes For Sale
- Kerns Homes For Sale
- Highpointe Estates Homes For Sale
- Corbett Glen Homes For Sale
- Hillsboro Homes For Sale
- Windsor Town Homes For Sale
- Thompson River Ranch Homes For Sale
- Belmont Ridge Homes For Sale
- Carlson Farms Homes For Sale
- Brunner Farm Homes For Sale
- Jacoby Farm Homes For Sale
- Winter Farm Homes For Sale
- Greenspire Homes For Sale
- Highland Meadows Golf Course Homes For Sale
- Colony Pointe Homes For Sale
- Settlers Village Homes For Sale
Nearby Zips
- 80543 Homes For Sale
- 80534 Homes For Sale
- 80550 Homes For Sale
- 80634 Homes For Sale
- 80528 Homes For Sale
- 80547 Homes For Sale
- 80651 Homes For Sale
- 80620 Homes For Sale
- 80525 Homes For Sale
- 80542 Homes For Sale
- 80631 Homes For Sale
- 80513 Homes For Sale
- 80526 Homes For Sale
- 80504 Homes For Sale
- 80524 Homes For Sale
- 80650 Homes For Sale
- 80645 Homes For Sale
- 80538 Homes For Sale
- 80520 Homes For Sale
- 80615 Homes For Sale
Nearby Cities
- Koenig, CO Homes for Sale
- Johnstown, CO Homes for Sale
- Windsor, CO Homes for Sale
- Milliken, CO Homes for Sale
- Greeley, CO Homes for Sale
- Severance, CO Homes for Sale
- Timnath, CO Homes for Sale
- Loveland, CO Homes for Sale
- Evans, CO Homes for Sale
- Berthoud, CO Homes for Sale
- Platteville, CO Homes for Sale
- Mead, CO Homes for Sale
- Gowanda, CO Homes for Sale
- Campion, CO Homes for Sale
- La Salle, CO Homes for Sale
- Moore, CO Homes for Sale
- Mcclellands, CO Homes for Sale
- Fort Collins, CO Homes for Sale
- East La Salle, CO Homes for Sale
- Maddux, CO Homes for Sale
Similar Searches
- Windsor Land for Sale
- Windsor New Homes for Sale
- Windsor Single Story Homes for Sale
- Windsor Homes with Pools for Sale
- Windsor Cheap Homes for Sale
- Windsor Luxury Homes for Sale
- Windsor Condos for Sale
- Windsor Town Homes for Sale
- Windsor Commercial for Sale
- Windsor Open Houses for Sale
- Windsor Two Car Garage Homes for Sale
- Windsor Large Lots for Sale
- National Listings
- National Home Values
- Properties in CO
- Home Values in CO
- Other properties in Weld, CO
- Other properties in 80550, CO
- Home Values in Windsor, CO
Frequently Asked Questions for 823 Shade Tree Dr
Source: Realty.com
823 Shade Tree Dr, Windsor, CO 80550 is a Single Family 3,553 sq. ft. home listed for sale. Realty.com has 15 photos available of this 4 bed, 4 bath house, listed at $950,000. View sales and tax history, use our mortgage calculator and more on Realty.com
Realty.com has 15 photos of 823 Shade Tree Dr.
Our records indicate that 823 Shade Tree Dr was built in 2021.
The full address for this home is 823 Shade Tree Dr, Windsor, CO 80550.
823 Shade Tree Dr has been listed on Realty.com since Fri January 10, 2020
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 7/100, Transit Score: 0/100, Bike Score: 28/100.
There are 3 schools assigned to this home. Check out the schools near 823 Shade Tree Dr. Skyview Elementary School (Grades: PK - 5), Windsor Charter Academy - Middle School (Grades: 6 - 8), Windsor Charter Academy - Secondary (Grades: 9 - 12)
Listing provided courtesy of:
Hub Real Estate
(tel: 970-682-2251)
Listing agent:
Tyler Robbins
(tel: 970-473-6839)
(#P31999)
This content last refreshed on 2025-12-02 07:13:53. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 823 Shade Tree Dr, Windsor, CO 80550 : MLS# 901564