NOT LISTED FOR SALE

400 Hemlock Dr Windsor, CO 80550

Estimated Value: $466,293 - $531,000

4 Beds
3 Baths
1,450 Sq Ft
$334/Sq Ft Est. Value

Last Sold September 13, 2017

Last sale price $316,500 $218 Per Sq Ft

Est. 53% increase in value since last sale

Current estimated payment $2,777/month

3 Days on Market

Highlights

  • Open Floorplan
  • No HOA
  • Brick Veneer
  • Deck
  • 2 Car Attached Garage
  • Patio

About This Home

As of September 2017

Welcome to your new home! Walk in through the front door or attached garage to an open layout with vaulted ceilings. This well kept and clean ranch home offers 4 bedrooms and 3 bathrooms, a newer roof, newer windows on the main level. The partial finished basement adds a large bedroom and bathroom. Use the rest of the space to create whatever you need. This home sits in a neighborhood with no HOA. Great deal and at this price, it won't last long!

Last Agent to Sell the Property

Paul Dargis

RE/MAX Alliance-FTC South Listed on: 08/11/2017

RE/MAX Alliance-FTC South

Last Buyer's Agent

Darin Glenn

eXp Realty LLC

eXp Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,554

Year Built

  • Built in 1998

Lot Details

  • 7,015 Sq Ft Lot
  • Wood Fence

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 1,450 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Window Treatments
  • Finished Basement
  • Laundry in Basement

Kitchen

  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Patio

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 R6964998

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,554

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.16
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Governors Farm
  • Above Grade Finished Sq Ft: 1159
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Kitchen Level: Main
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Has Basement: 25%+Finished Basement
  • Full Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1159
  • Interior Amenities: Open Floorplan
  • Living Area: 1450
  • Window Features: Window Coverings
  • Room Bedroom4 Area: 150
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Vinyl Floor
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 99
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 110
  • Room Bedroom3 Level: Main
  • Master Bedroom Master Bedroom Width: 11
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Vinyl Floor
  • Room Living Room Area: 252
  • Living Room Features: Vinyl Floor
  • Room Kitchen Area: 110
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 143
  • Room Dining Room Area: 99
  • Master Bathroom Features: 3/4 Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Fencing: Wood
  • Lot Features: Curbs, Gutters, Sidewalks
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • IRESDS_GarageType: Attached

Utilities

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

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: RES
  • Lot Size Sq Ft: 7015
  • Parcel #: R6964998
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2016
  • Tax Annual Amount: 1554

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 2, 2021
Sold by
Gomez Ernest Garred and Gomez Brittany N
Bought by
Gomez Ernest Garred
Total Days on Market
3
Current Estimated Value
$484,823

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$290,200
Outstanding Balance
$259,236
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$226,650

Purchase Details

Listed on
Aug 11, 2017
Closed on
Sep 13, 2017
Sold by
Sherlock James M and Sherlock Cynthia L
Bought by
Gomez Ernest Garred and Foster Brittany N
Seller's Agent
Paul Dargis
RE/MAX Alliance-FTC South
Buyer's Agent
Darin Glenn
eXp Realty LLC
List Price
$309,000
Sold Price
$316,500
Premium/Discount to List
$7,500
2.43%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.71%
Original Mortgage
$307,005
Interest Rate
3.93%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 7, 2008
Sold by
Crist Conrad A and Crist Gwen R
Bought by
Sherlock James M and Sherlock Cynthia L

Home Financials for this Owner

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

Purchase Details

Closed on
May 29, 2003
Sold by
Ray Theodore H and Ray Jennifer D
Bought by
Crist Conrad A and Crist Gwen R

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 17, 1998
Sold by
Bruso Homes Inc
Bought by
Ray Theodore H and Ray Jennifer D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$127,205
Interest Rate
6.87%

Purchase Details

Closed on
Jul 17, 1998
Sold by
Clarkson Land Llc
Bought by
Bruso Homes Inc

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 27, 1995
Sold by
Clarkson Investment Llc
Bought by
Clarkson Land Llc
Source: Public Records

Similar Homes in Windsor, CO

  • 2283 Stonefish Dr, Windsor, CO 80550

    $575,000

    • 4 Beds
    • 2.5 Baths
    • 2,534 Sq Ft
    • 2283 Stonefish Dr
    • Windsor, CO

    Back on the Market, no fault of property! Massive Price Improvement: This beautiful 2-story home offers 3,336 square feet of comfortable living space, featuring 4 bedrooms, 2.5 bathrooms, and an open-concept design perfect for entertaining. The main level boasts an office for those who work from home, and the spacious living area is highlighted by a dramatic cathedral ceiling and custom stone

    Shawna Blair The Colorado RE Group LLC

    Section Image
  • 8211 Lighthouse Lane Ct, Windsor, CO 80528

    $550,000

    • 3 Beds
    • 2 Baths
    • 2,017 Sq Ft
    • 8211 Lighthouse Lane Ct
    • Windsor, CO

    Welcome to 8211 Lighthouse Lane Court, a superior well maintained home nestled in the desirable community of Windsor, CO. This beautifully maintained 3-bedroom, 2-bathroom. (Bedroom 3 is technically an office) residence offers an ideal blend of modern comfort and classic charm. The open-concept floor plan is perfect for both family living and entertaining. The spacious main level features a

    Jimmy Stewart Coldwell Banker Realty-NOCO

    Section Image
  • 201 Valley Ct, Windsor, CO 80550

    $515,000

    • 4 Beds
    • 3 Baths
    • 2,966 Sq Ft
    • 201 Valley Ct
    • Windsor, CO

    Welcome to this beautifully maintained ranch-style gem in the heart of Windsor, Colorado-where comfort, convenience, and freedom come together in one perfect package. Tucked into a peaceful neighborhood with no HOA or metro district, this home offers the kind of flexibility and charm that's hard to find. RV Parking is what makes this property unique! Step inside to a spacious tiled foyer that

    Vicky Rath Coldwell Banker Realty-NOCO

    Section Image
  • 205 Maple Ct, Windsor, CO 80550

    $499,900

    • 4 Beds
    • 3 Baths
    • 2,197 Sq Ft
    • 205 Maple Ct
    • Windsor, CO

    Spacious ranch-style home on a corner lot, located just across the street from the library and local school, blocks from Windsor Park, and only half a mile from downtown Windsor. No HOA and no metro tax! This inviting property features an oversized family room with mountain views and a well-appointed kitchen complete with custom birch cabinetry and a generous pantry.The dining room comfortably

    Robert Crow Grey Rock Realty

    Section Image
  • 135 Beacon Way, Windsor, CO 80550

    $449,000

    • 4 Beds
    • 2 Baths
    • 1,863 Sq Ft
    • 135 Beacon Way
    • Windsor, CO

    This centrally located 4 bed 2 bath Water Valley Patio home is a great fit for owners who like to travel. With the HOA taking care of the lawn maintenance, snow removal, trash, and neighborhood security, this is truly a lock and leave property. Enjoy resort style living in this elevated ranch home with full finished basement that's adjacent to all the great amenities the Water Valley community

    Tom Washburn Bison Real Estate Group

    Section Image
  • 1403 Boardwalk Dr, Windsor, CO 80550

    $500,000

    • 3 Beds
    • 3 Baths
    • 2,210 Sq Ft
    • 1403 Boardwalk Dr
    • Windsor, CO

    Lovely Water Valley patio home! Enjoy all of the lakes, trails, amenities, and recreation of this ever-popular community, with the added convenience of included lawn care, snow removal and trash service. Upon entering, the versatile open concept flows effortlessly through living and dining spaces into the upgraded kitchen and out to the low-maintenance composite deck. The primary bedroom includes

    Jesse Myers Group Harmony

    Section Image
  • 944 Maplebrook Dr, Windsor, CO 80550

    $490,000

    • 3 Beds
    • 2 Baths
    • 1,419 Sq Ft
    • 944 Maplebrook Dr
    • Windsor, CO

    Welcome to this gently lived-in ranch-style gem located in Windsor's newer phase of the Village East neighborhood. Thoughtfully designed for effortless main-level living, this 3-bedroom, 2-bath home features vaulted ceilings in the main living area, a cozy gas fireplace, and a bright, open floorplan that feels both spacious and welcoming. In the primary bedroom, you will enjoy the convenience of

    Christie Duggar Group Harmony

    Section Image
  • 945 Maplebrook Dr, Windsor, CO 80550

    $475,000

    • 3 Beds
    • 2 Baths
    • 1,319 Sq Ft
    • 945 Maplebrook Dr
    • Windsor, CO

    Welcome to 945 Maplebrook Drive in the Village East neighborhood. This 2022 ranch-style home offers a spacious open floor plan with vaulted ceilings, creating a bright and inviting atmosphere throughout. Just inside, a thoughtfully designed entryway features a built-in bench and space to hang coats-an ideal spot to welcome you home. The kitchen includes upgraded cabinetry and stainless steel

    Christine Gwinnup LPT Realty, LLC.

    Section Image
  • 116 Walnut St, Windsor, CO 80550

    $419,000

    • 3 Beds
    • 2 Baths
    • 1,536 Sq Ft
    • 116 Walnut St
    • Windsor, CO

    Historic Old Town Windsor charmer available now, Within walking distance to Windsor's historic downtown area plus Boardwalk Park. Easy commute to Fort Collins, Loveland and Greeley. No Metro District. New HVAC unit installed. This property has a newer sprinkler system, laminate flooring and carpet. Very spacious living areas plus plenty of storage spaces throughout. New shed placed in 2024.

    Laurel Kross Laurel Kross

    Section Image

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
Gomez Ernest Garred -- Fidelity National Title Co
Gomez Ernest Garred $316,500 Fidelity National Title
Sherlock James M $205,000 None Available
Crist Conrad A $187,900 Stewart Title
Ray Theodore H $133,900 --
Bruso Homes Inc $64,000 --
Clarkson Land Llc -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Raisa Funding I Llc $0
Open Gomez Ernest Garred $290,200
Closed Gomez Ernest Garred $307,005
Previous Owner Sherlock James M $164,000
Previous Owner Crist Conrad A $38,037
Previous Owner Crist Conrad A $150,300
Previous Owner Ray Theodore H $20,000
Previous Owner Ray Theodore H $127,205
Previous Owner Bruso Homes Inc $101,175
Previous Owner Bruso Homes Inc $9,015
Closed Crist Conrad A $37,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/28/2019 01/28/19 Off Market $316,500 -- --
09/13/2017 09/13/17 Sold $316,500 +2.4% $218 / Sq Ft
08/14/2017 08/14/17 Pending -- -- --
08/11/2017 08/11/17 For Sale $309,000 -- $213 / 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
2024 $2,442 $27,950 $5,630 $22,320
2023 $2,243 $29,460 $4,740 $24,720
2022 $2,222 $22,800 $4,870 $17,930
2021 $2,072 $23,460 $5,010 $18,450
2020 $1,959 $22,610 $4,650 $17,960
2019 $1,942 $22,610 $4,650 $17,960
2018 $1,708 $18,820 $2,880 $15,940
2017 $1,807 $18,820 $2,880 $15,940
2016 $1,554 $16,350 $2,790 $13,560
2015 $1,446 $16,350 $2,790 $13,560
2014 $1,398 $14,820 $2,790 $12,030
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 829373

IRES MLS

APN: R6964998