$850,000
UNDER CONTRACT

Estimated payment $5,115/month

Total Views 120
4 Beds
3.5 Baths
3,903 Sq Ft
$218 Price per Sq Ft

Highlights

  • Hot Property
  • Open Floorplan
  • Contemporary Architecture
  • 0.42 Acre Lot
  • Mountain View
  • Recreation Room

About This Home

In a world surrounded by cookie-cutter, 817 Shade Tree is anything but!! From the moment you arrive, you know it's different...in the best way possible. Set back from the street with timeless modern farmhouse styling, this custom home delivers the character, craftsmanship, and thoughtful design today's buyers have been searching for. A welcoming covered front porch invites you to slow down, relax, and take in the sunset views. Inside, soaring vaulted ceilings, custom built-ins, and a striking fireplace create a warm, inviting great room that's equally suited for entertaining and everyday living. The open kitchen is a dream for home chefs, featuring high-end appliances, abundant prep space, and seamless flow to the living and dining areas. Designed with convenience in mind, the main level offers a dedicated office, laundry room, and a private primary retreat complete with a luxurious five-piece bath and direct access to the back patio-your own everyday escape. Upstairs, a cozy loft joins two spacious bedrooms and a shared bath with double vanity, giving everyone room to spread out. The finished basement expands your living space with a generous family room perfect for movie nights, game days, or gatherings with friends. A fourth bedroom and full bath create an ideal guest suite, while the unfinished storage area and oversized three-car garage provide plenty of room for all your gear. Out back, the expansive patio and large backyard offer space to dine, play, and unwind while enjoying open views. With trails just outside your front door and convenient access to Windsor, Greeley, Johnstown, Loveland, and everyday amenities, this is more than just another home-it's one you'll remember long after the showing ends.

Listing Agent

Marsha Petrovic

Group Mulberry Brokerage Phone: 9709806045 Listed on: 07/16/2026

Group Mulberry

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,859

Year Built

  • Built in 2017

Lot Details

  • 18,295 Sq Ft Lot
  • Northwest Facing Home
  • Fenced
  • Paved or Partially Paved Lot
  • Level Lot
  • Sprinkler System
  • Landscaped with Trees

HOA Fees

  • $32 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Farmhouse Style Home
  • Composition Roof

Interior Spaces

  • 3,903 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Window Treatments
  • Family Room
  • Living Room
  • Dining Room
  • Recreation Room
  • Wood Flooring
  • Mountain Views
  • Basement Fills Entire Space Under The House

Kitchen

  • Double Oven
  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Dryer
  • Washer

Schools

  • Orchard Hill Elementary School
  • Ridgeline Middle School
  • Windsor High School

Utilities

  • Forced Air Heating and Cooling System
  • Cable TV Available

Additional Features

  • Patio
  • Near Farm

Listing and Financial Details

  • Assessor Parcel Number R8953248

Community Details

Overview

  • Pelican Farms Association
  • Pelican Farms, South Hill Subdivision

Recreation

  • Community Playground
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,859

Year Built

Built in 2017

Lot Details

0.42 Acres

HOA Fees

$32 per month

Parking

3

Listing Details

  • Year Built: 2017
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.42
  • Road Frontage Type: City Street
  • Road Surface Type: Asphalt
  • Subdivision Name: Pelican Farms, South Hill
  • Architectural Style: Farmhouse, Contemporary
  • Unit Levels: Two
  • New Construction: No
  • Property Attached Yn: No
  • Attribution Contact: 9709806045
  • RoomType: Bedroom 4
  • RoomType: Dining Room
  • RoomType: Family Room
  • RoomType: Kitchen
  • RoomType: Laundry
  • RoomType: Living Room
  • RoomFeatures: Luxury Features Primary Bath, 5 Piece Primary Bath
  • IRE_AssociationFeeYN: Yes
  • IRE_AssociationYN2: 0
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 3903
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • RoomType: Primary Bedroom
  • RoomType: Recreation Room
  • RoomType: Study
  • IRE_AssociationFee2YN: No
  • IRE_HasFamilyRoom: 1
  • Special Features: UnderContract

Interior Features

  • Possible Use: Single Family
  • Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave
  • Has Basement: Full, Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Flooring: Wood
  • Interior Amenities: Cathedral Ceiling(s), Open Floorplan, Pantry, Washer/Dryer Hookup
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Fencing: Fenced
  • Lot Features: Evergreen Trees, Deciduous Trees, Level, Abuts Farm Land, House/Lot Faces NW, Paved, Curbs, Gutters, Sidewalks
  • View: Mountain(s)
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Frame
  • Exterior Features: Sprinkler System
  • Patio And Porch Features: Patio

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached
  • IRE_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: REA
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
  • Sewer: Public Sewer
  • Water Source: City

Condo/Co-op/Association

  • Community Features: Playground, Park, Trail(s)
  • Association Fee: 380
  • Association Fee Frequency: Annually
  • Association Name: Pelican Farms
  • 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 #: R8953248
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 6859

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 $6,859 $47,990 $10,210 $37,780
2025 $9,224 $48,480 $10,310 $38,170
2024 $9,224 $48,480 $10,310 $38,170
2023 $5,956 $51,390 $11,840 $39,550
2022 $6,435 $45,880 $10,430 $35,450
2021 $6,149 $47,200 $10,730 $36,470
2020 $4,192 $32,600 $6,790 $25,810
2019 $4,167 $32,600 $6,790 $25,810
2018 $3,038 $23,040 $5,040 $18,000
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/16/2026 07/16/26 For Sale $850,000 +25.2% $218 / Sq Ft
02/26/2019 02/26/19 Off Market $679,000 -- --
11/14/2018 11/14/18 Sold $679,000 -6.3% $180 / Sq Ft View Prior Sale
08/03/2018 08/03/18 For Sale $725,000 -- $192 / 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 $679,000 Unified Title Co
Warranty Deed -- Unified Title Co
Warranty Deed -- Unified Title Co
Source: Public Records

Source: IRES MLS

MLS Number: IRE1064395

IRES MLS

APN: R8953248

Your Personal Tour Guide

Ask me questions while you tour the home.