NOT LISTED FOR SALE

335 Keystone Dr Windsor, CO 80550

Estimated Value: $621,000 - $674,000

5 Beds
3.5 Baths
3,566 Sq Ft
$183/Sq Ft Est. Value

Last Sold August 26, 2022

Last sale price $630,000 $177 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $4,030/month

2 Days on Market

Highlights

  • Open Floorplan
  • Contemporary Architecture
  • Main Floor Bedroom
  • Deck
  • Cathedral Ceiling
  • Balcony

About This Home

As of August 2022

Property Id: 970066

This is a large, beautiful, 5 bed / 4 bath, home with HUGE oversized 3-car tandem garage, located just a half mile walk from Windsor Lake and less than half a mile from Northern Lights Park and Hollister Lake Elementary. Outstanding floorplan with 17-ft vaulted ceiling in the living room, open concept kitchen and dining with large island and stone countertops. Master suite is on the main floor with 3 additional bedrooms and another bath upstairs. The basement has been professionally finished with a large bonus room complete with bar, additional bedroom and bathroom as well as unfinished space for storage.
No Smoking small dog negotiable with pet deposit and monthly pet rent.
Tenant responsible for all utilities and basic yard maintenance.
Household income must be 3x rent, and credit must be 680 or better.

Last Agent to Sell the Property

Susan Herlihy

Group Harmony Listed on: 07/19/2022

Group Harmony

Last Buyer's Agent

Sage Oglesby

Close to Home Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,043

Year Built

  • Built in 2013

Lot Details

  • 6,787 Sq Ft Lot
  • East Facing Home
  • Vinyl Fence
  • Sprinkler System

HOA Fees

  • $10 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Tandem Parking
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle
  • Stone

Interior Spaces

  • 3,566 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Bar Fridge
  • Cathedral Ceiling
  • Ceiling Fan
  • Electric Fireplace
  • Window Treatments
  • Living Room with Fireplace
  • Carpet
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Exterior Lighting
  • Outdoor Gas Grill

Schools

  • Mountain View Elementary School
  • Severance Middle School
  • Severance High School

Utilities

  • Forced Air Heating and Cooling System
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number R2909104

Community Details

Overview

  • Association fees include common amenities, management
  • Winter Farm Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,043

Year Built

Built in 2013

Lot Details

0

HOA Fees

$10 per month

Parking

3

Listing Details

  • Year Built: 2013
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.16
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Winter Farm
  • Directions: From I-25 & Hwy 392, Go East on 392/CR 68, North on Hollister Lake Road/ CR 19, East on Sundance, North on Keystone
  • Above Grade Finished Sq Ft: 2184
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3566
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
  • Accessibility Features: Main Level Bedroom, Main Level Laundry
  • Has Basement: Full, 90%+ Finished Basement
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1382
  • Fireplace Features: Electric, Living Room
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s)
  • Living Area: 3248
  • Window Features: Window Coverings
  • Room Bedroom4 Area: 132
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Other Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 132
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 168
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 14
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Bedroom5 Area: 182
  • Room Kitchen Features: Other Floor
  • Room Living Room Area: 304
  • Living Room Features: Other Floor
  • Room Kitchen Area: 208
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 196
  • Room Dining Room Area: 140
  • Master Bathroom Features: 3/4 Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Vinyl
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
  • Waterfront: No
  • Construction Type: Wood/Frame, Stone, Composition Siding
  • Direction Faces: East
  • Exterior Features: Gas Grill, Lighting, Balcony
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Tandem
  • IRESDS_Garage Sq Ft: 904
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, Xcel Energy
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Windsor
  • Gas Company: Natural Gas, Xcel Energy

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Community Features: Park
  • Senior Community: No
  • Association Fee: 125
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Mountain View,Tozer
  • HighSchool: Severance High School
  • Junior High Dist: Weld RE-4
  • Middle Or Junior School: Severance

Lot Info

  • Zoning: SFR
  • Lot Size Sq Ft: 6787
  • Parcel #: R2909104
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 4043

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 19, 2022
Closed on
Aug 26, 2022
Sold by
Toohey-Gerlach Joan M
Bought by
Puls David and Puls Anna
Seller's Agent
Susan Herlihy
Group Harmony
Buyer's Agent
Sage Oglesby
Close to Home Real Estate
List Price
$625,000
Sold Price
$630,000
Premium/Discount to List
$5,000
0.8%
Current Estimated Value
$654,268

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$24,268
Avg. Annual Appreciation
-0.23%
Original Mortgage
$395,000
Outstanding Balance
$378,572
Interest Rate
5.3%
Mortgage Type
New Conventional
Estimated Equity
$247,233

Purchase Details

Listed on
Aug 5, 2020
Closed on
Sep 17, 2020
Sold by
Caton Samuel L and Caton Misty D
Bought by
Toohey Gerlach Joan M and Gerlach William R
Seller's Agent
Susan Herlihy
Group Harmony
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$445,000
Sold Price
$456,000
Premium/Discount to List
$11,000
2.47%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
18.13%
Original Mortgage
$466,488
Interest Rate
2.8%
Mortgage Type
VA

Purchase Details

Listed on
Mar 20, 2018
Closed on
Jul 9, 2018
Sold by
Urias Joy
Bought by
Caton Samuel L and Caton Misty D
Seller's Agent
Stephanie Nealy
eXp Realty LLC
Buyer's Agent
Heather Gordon
Resident Realty
List Price
$440,000
Sold Price
$395,000
Premium/Discount to List
-$45,000
-10.23%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.78%
Original Mortgage
$355,500
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 1, 2015
Sold by
Urias Joy and Waters Joy
Bought by
Urias Joy

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$54,000
Interest Rate
4.13%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jun 12, 2012
Sold by
Winter Farm Windsor Llc
Bought by
Waters Joy

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$41,190
Interest Rate
3.86%
Mortgage Type
Seller Take Back
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Puls David $630,000 --
Toohey Gerlach Joan M $456,000 Guaranteed Title Group Llc
Caton Samuel L $395,000 Heritage Title Co
Urias Joy -- Land Title Guarantee Company
Waters Joy $40,900 Land Title Guarantee Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Puls David $395,000
Previous Owner Toohey Gerlach Joan M $466,488
Previous Owner Caton Samuel L $355,500
Previous Owner Urias Joy $100,000
Previous Owner Urias Joy $303,750
Previous Owner Urias Joy $54,000
Previous Owner Urias Joy $288,000
Previous Owner Waters Joy $289,000
Previous Owner Waters Joy $179,200
Previous Owner Prestige Homes Llc $171,150
Previous Owner Waters Joy $41,190
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/21/2025 05/21/25 Off Market $3,500 -- --
04/19/2025 04/19/25 For Rent $3,500 0.0% --
08/26/2022 08/26/22 Sold $630,000 +0.8% $177 / Sq Ft
07/22/2022 07/22/22 For Sale $625,000 +37.1% $175 / Sq Ft
12/17/2020 12/17/20 Off Market $456,000 -- --
09/17/2020 09/17/20 Sold $456,000 +2.5% $128 / Sq Ft
08/05/2020 08/05/20 For Sale $445,000 +12.7% $125 / Sq Ft
10/07/2019 10/07/19 Off Market $395,000 -- --
07/09/2018 07/09/18 Sold $395,000 -10.2% $112 / Sq Ft
06/09/2018 06/09/18 Pending -- -- --
03/20/2018 03/20/18 For Sale $440,000 -- $125 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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
2025 $4,886 $39,900 $7,500 $32,400
2024 $4,886 $39,900 $7,500 $32,400
2023 $4,592 $42,150 $6,770 $35,380
2022 $4,213 $31,100 $6,320 $24,780
2021 $4,043 $32,000 $6,510 $25,490
2020 $3,953 $30,690 $5,010 $25,680
2019 $3,955 $30,690 $5,010 $25,680
2018 $3,981 $28,290 $5,040 $23,250
2017 $4,072 $28,290 $5,040 $23,250
2016 $3,624 $24,980 $3,420 $21,560
2015 $3,464 $24,980 $3,420 $21,560
2014 $3,119 $10,150 $10,150 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 971363

IRES MLS

APN: R2909104