NOT LISTED FOR SALE

617 Hemlock Dr Windsor, CO 80550

Estimated Value: $487,000 - $556,000

3 Beds
2.5 Baths
2,128 Sq Ft
$240/Sq Ft Est. Value

Last Sold April 05, 2021

Last sale price $430,000 $202 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $2,909/month

4 Days on Market

Highlights

  • Parking available for a boat
  • Contemporary Architecture
  • Wood Flooring
  • Deck
  • Cathedral Ceiling
  • 5-minute walk to Poudre Natural Area

About This Home

As of April 2021

Super cute 3 bed, 2.5 bath, 2-story w/ unfinished daylight basement on a huge fenced-in corner lot. So much room in the backyard, great for anybody that loves to entertain & perfect for gardeners & pet owners - complete w/ fire pit, fruit trees & chicken coop. There are also 2 decks! Deck #1 is off the kitchen leading down to a concrete BBQ patio area. Deck # 2 is off the primary bedroom. Gates on the south side open up to a poured concrete pad for camper/atv storage! Brand new carpets throughout. Hardwoods in kitchen, laundry, dining, half bath & hall way. Gas fireplace & vaulted ceilings in the living room. Tile floors in both upper bathrooms. Primary bedroom w/ walk-in closet & ensuite bath. 2 laundry chutes. 2 car garage w/ extra bump-out for small workshop area. Rough plumb for additional bathroom in basement. Hot water heater is 2 years old. Mins. to downtown Windsor. Situated on a "half moon" cul-de-sac, with no HOA or metro tax. Click on Video/Virtual tour to see the video.

Last Agent to Sell the Property

Robert Crow

Grey Rock Realty Listed on: 02/25/2021

Last Buyer's Agent

The Krafting Home Team

Realty One Group Fourpoints

Realty One Group Fourpoints

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,932

Year Built

  • Built in 1998

Lot Details

  • 9,583 Sq Ft Lot
  • Cul-De-Sac
  • Wood Fence
  • Sprinkler System

Parking

  • 2 Car Attached Garage
  • Oversized Parking
  • Parking available for a boat

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle
  • Radon Test Available

Interior Spaces

  • 2,128 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Home Office
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Laundry on main level

Kitchen

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

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Outdoor Features

  • Balcony
  • Deck

Schools

  • Tozer Elementary School
  • Windsor Middle School
  • Windsor High School

Utilities

  • Forced Air Heating and Cooling System

Community Details

  • No Home Owners Association
  • Governors Farm Subdivision

Listing and Financial Details

  • Assessor Parcel Number R6955798

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,932

Year Built

Built in 1998

Lot Details

0

Parking

2

Listing Details

  • Year Built: 1998
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.22
  • Road Frontage Type: City Street
  • Subdivision Name: Governors Farm
  • Directions: East on Hwy 392 towards downtown Windsor. South (right) on 7th. East (left) on Hemlock Drive.
  • Above Grade Finished Sq Ft: 1450
  • 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: 2128
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Has Basement: Full, Unfinished, Radon Test Available
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 678
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Walk-In Closet(s)
  • Living Area: 1450
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Carpet
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 150
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 90
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 15
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 156
  • Living Room Features: Carpet
  • Room Kitchen Area: 204
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 180
  • Room Dining Room Area: 100
  • Master Bathroom Features: Full Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Wood
  • Lot Features: Sidewalks, Lawn Sprinkler System, Cul-De-Sac
  • Waterfront: No
  • Construction Type: Wood/Frame, Composition Siding
  • Exterior Features: Balcony
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: RV/Boat Parking, Oversized
  • IRESDS_Garage Sq Ft: 463
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Xcel
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Windsor
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

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

Lot Info

  • Zoning: SFR
  • Lot Size Sq Ft: 9583
  • Parcel #: R6955798
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2020
  • Tax Annual Amount: 1932

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 25, 2021
Closed on
Apr 5, 2021
Sold by
Henderson Amy D
Bought by
Ackles Andrew and Ackles Ana
Seller's Agent
Robert Crow
Grey Rock Realty
Buyer's Agent
The Krafting Home Team
Realty One Group Fourpoints
List Price
$390,000
Sold Price
$430,000
Premium/Discount to List
$40,000
10.26%
Current Estimated Value
$511,048

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$81,048
Avg. Annual Appreciation
4.12%
Original Mortgage
$325,600
Outstanding Balance
$295,248
Interest Rate
3%
Mortgage Type
New Conventional
Estimated Equity
$219,978

Purchase Details

Listed on
May 16, 2019
Closed on
Jun 18, 2019
Sold by
Beahm Erika J V and Beahm Andrew T
Bought by
Henderson Amy D
Seller's Agent
Alexis Foster
Group Centerra
Buyer's Agent
Robert Crow
Grey Rock Realty
List Price
$350,000
Sold Price
$352,500
Premium/Discount to List
$2,500
0.71%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.81%
Original Mortgage
$322,801
Interest Rate
4%
Mortgage Type
FHA

Purchase Details

Listed on
Jan 25, 2013
Closed on
Mar 21, 2013
Sold by
Banner Investments Llc
Bought by
Beahm Andrew T and Beahm Erika J
Seller's Agent
David Fredlake
Northern Colorado Realty
Buyer's Agent
Lisa Michie
Cobblestone Realty
List Price
$205,000
Sold Price
$202,000
Premium/Discount to List
-$3,000
-1.46%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.29%
Original Mortgage
$191,900
Interest Rate
3.59%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 25, 2013
Closed on
Jan 30, 2013
Sold by
Schmidt Robert and Schmidt Rebekah
Bought by
Banner Investment Llc
Seller's Agent
David Fredlake
Northern Colorado Realty
Buyer's Agent
Lisa Michie
Cobblestone Realty
List Price
$205,000
Sold Price
$202,000
Premium/Discount to List
-$3,000
-1.46%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$191,900
Interest Rate
3.59%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 1, 2011
Sold by
Schmit Robert and Schmit Rebekah
Bought by
Schmit Robert

Purchase Details

Closed on
Jan 2, 2008
Sold by
Bank Of New York
Bought by
Schmit Robert and Schmit Rebekah

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$153,000
Interest Rate
6.23%
Mortgage Type
Unknown

Purchase Details

Closed on
Jun 11, 2007
Sold by
Shimp Todd E and Caballero Grace D
Bought by
Bank Of New York

Purchase Details

Closed on
Mar 14, 2005
Sold by
Mcguire Dwane T and Mcguire Bobbie L
Bought by
Shimp Todd E and Caballero Grace D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$162,400
Interest Rate
6.5%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Dec 10, 1998
Sold by
Bernhardt Homes Inc
Bought by
Mcguire Dwane T and Mcguire Bobbie L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$121,560
Interest Rate
6.81%

Purchase Details

Closed on
Sep 27, 1995
Sold by
Clarkson Investment Llc
Bought by
Clarkson Land Llc
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
Ackles Andrew $430,000 First American
Henderson Amy D $352,500 First American
Beahm Andrew T $202,000 Land Title Guarantee Company
Banner Investment Llc -- None Available
Schmit Robert -- None Available
Schmit Robert $170,000 Fahtco
Bank Of New York -- None Available
Shimp Todd E $203,000 --
Mcguire Dwane T $151,950 --
Clarkson Land Llc -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ackles Andrew $325,600
Previous Owner Henderson Amy D $322,801
Previous Owner Beahm Andrew T $191,900
Previous Owner Schmit Robert $153,000
Previous Owner Shimp Todd E $162,400
Previous Owner Mcguire Dwane T $121,560
Closed Shimp Todd E $40,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/04/2022 07/04/22 Off Market $430,000 -- --
04/05/2021 04/05/21 Sold $430,000 +10.3% $202 / Sq Ft
02/25/2021 02/25/21 For Sale $390,000 +10.6% $183 / Sq Ft
09/24/2020 09/24/20 Off Market $352,500 -- --
06/27/2019 06/27/19 Sold $352,500 +0.7% $175 / Sq Ft
05/16/2019 05/16/19 For Sale $350,000 +73.3% $173 / Sq Ft
01/28/2019 01/28/19 Off Market $202,000 -- --
03/21/2013 03/21/13 Sold $202,000 -1.5% $95 / Sq Ft
02/19/2013 02/19/13 Pending -- -- --
01/25/2013 01/25/13 For Sale $205,000 -- $96 / 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 $2,385 $28,500 $5,630 $22,870
2024 $2,385 $28,500 $5,630 $22,870
2023 $2,190 $28,850 $4,740 $24,110
2022 $2,178 $22,340 $4,870 $17,470
2021 $2,030 $22,980 $5,010 $17,970
2020 $1,931 $22,290 $4,650 $17,640
2019 $1,914 $22,290 $4,650 $17,640
2018 $1,708 $18,830 $2,880 $15,950
2017 $1,808 $18,830 $2,880 $15,950
2016 $1,554 $16,350 $2,790 $13,560
2015 $1,446 $16,350 $2,790 $13,560
2014 $1,420 $15,050 $2,790 $12,260
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: IRES MLS

MLS Number: 934133

IRES MLS

APN: R6955798