NOT LISTED FOR SALE

1857 Castle Hill Dr Windsor, CO 80550

Estimated Value: $590,190 - $746,000

3 Beds
2.5 Baths
3,215 Sq Ft
$207/Sq Ft Est. Value

Last Sold September 30, 2020

Last sale price $493,990 $154 Per Sq Ft

Est. 34% increase in value since last sale

Current estimated payment $3,908/month

59 Days on Market

Highlights

  • New Construction
  • Contemporary Architecture
  • Wood Flooring
  • Open Floorplan
  • Cathedral Ceiling
  • Corner Lot

About This Home

As of September 2020

Ready Now!! The Richard by Bridgewater Homes. Beautiful 2-Story home w/3 Beds, 2 1/2 Baths, open floor plan, living room w/gas fireplace, gourmet kitchen, double ovens, walk-in pantry, granite counters, hickory hardwood floors, master bedroom w/luxury 5pc bath, & full un-finished basement & 2-car garage. Exterior boasts a 14' x 10' covered patio & front yard landscaping. All Bridgewater Homes' include Refrigerator, Humidifier, & Air Conditioning!

Last Agent to Sell the Property

Leslie Moen

C3 Real Estate Solutions, LLC Listed on: 06/29/2020

C3 Real Estate Solutions, LLC

Co-Listed By

Laurie Foerster

C3 Real Estate Solutions, LLC

Last Buyer's Agent

Non-IRES Agent

Non-IRES

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2020 | New Construction

Lot Details

  • 8,112 Sq Ft Lot
  • Corner Lot
  • Level Lot
  • Sprinkler System

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

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

Interior Spaces

  • 3,215 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Bathtub and Shower Combination in Primary Bathroom

Laundry

  • Laundry on upper level
  • Washer and Dryer Hookup

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Thermostat

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

  • Grandview Elementary School
  • Windsor Middle School
  • Windsor High School

Utilities

  • Humidity Control
  • Forced Air Heating and Cooling System
  • High Speed Internet
  • Satellite Dish
  • Cable TV Available

Community Details

  • Property has a Home Owners Association
  • Association fees include management
  • Built by Bridgewater Homes
  • The Ridge At Harmony Road Subdivision

Listing and Financial Details

  • Assessor Parcel Number R8954921

Home Details

Home Type

Single Family

Year Built

Built in 2020 | New Construction

Lot Details

0

Parking

2

Listing Details

  • Year Built: 2020
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.19
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Co List Office Mls Id: JCSRE
  • Subdivision Name: The Ridge at Harmony Road
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Efficiency: HVAC, Thermostat
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3215
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Accessibility Features: Level Lot
  • Has Basement: Full, Unfinished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Satellite Avail, High Speed Internet, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings
  • Window Features: Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Tub+Shower Primary, Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Builder Name: Bridgewater Homes
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Level
  • Waterfront: No
  • Construction Type: Wood/Frame, Stone, Composition Siding
  • Exterior Features: Lighting
  • Patio And Porch Features: Patio
  • Property Condition: New Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, XCEL
  • Heating: Forced Air, Humidity Control
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: District Sewer
  • Water Source: District Water, NWCWD
  • Gas Company: Natural Gas, XCEL

Condo/Co-op/Association

  • HOA Fee Includes: Management
  • Senior Community: No
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Grandview
  • HighSchool: Windsor
  • Junior High Dist: Weld RE-4
  • Middle Or Junior School: Windsor

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 8112
  • Parcel #: R8954921
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2019

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 29, 2020
Closed on
Sep 13, 2020
Sold by
Bridgewater Homes Llc
Bought by
Weston Thomas Robert and Fahrenbruck Katelyn Grace
Seller's Agent
Leslie Moen
C3 Real Estate Solutions, LLC
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$494,100
Sold Price
$493,990
Premium/Discount to List
-$110
-0.02%
Current Estimated Value
$664,298

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$170,308
Avg. Annual Appreciation
5.76%
Original Mortgage
$395,192
Outstanding Balance
$350,707
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$313,591
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Weston Thomas Robert $493,990 First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Weston Thomas Robert $395,192
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/29/2021 12/29/21 Off Market $493,990 -- --
09/30/2020 09/30/20 Sold $493,990 0.0% $154 / Sq Ft
06/29/2020 06/29/20 For Sale $494,100 -- $154 / 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 $5,213 $42,200 $7,810 $34,390
2024 $5,213 $42,200 $7,810 $34,390
2023 $4,938 $39,230 $7,100 $32,130
2022 $4,936 $34,450 $6,460 $27,990
2021 $4,428 $33,610 $6,650 $26,960
2020 $1,692 $13,010 $13,010 $0
2019 $292 $2,260 $2,260 $0
2018 $13 $60 $60 $0
Source: Public Records

Agents Affiliated with this Home

  • Leslie Moen

    Seller's Agent in 2020

    Leslie Moen

    C3 Real Estate Solutions, LLC

    (970) 371-7966

    436 Total Sales

    Leslie Moen
    Section Image

  • L

    Seller Co-Listing Agent in 2020

    Laurie Foerster

    C3 Real Estate Solutions, LLC

    (970) 581-9324

    422 Total Sales

    Laurie Foerster
    Section Image

  • N

    Buyer's Agent in 2020

    Non-IRES Agent

    CO_IRES

See All Agents

Map

Source: IRES MLS

MLS Number: IRE916608

IRES MLS

APN: R8954921

Colorado Weld County Windsor 80550

1857 Castle Hill Dr, Windsor, CO

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Information deemed reliable but not guaranteed by the MLS.

Nearby Homes