NOT LISTED FOR SALE

551 Madera Way Windsor, CO 80550

Estimated Value: $1,464,000 - $1,589,000

5 Beds
5 Baths
5,604 Sq Ft
$270/Sq Ft Est. Value

Last Sold August 02, 2018

Last sale price $963,800 $172 Per Sq Ft

Est. 57% increase in value since last sale

Current estimated payment $8,588/month

201 Days on Market

Highlights

  • Built in 2018 | Newly Remodeled
  • Mountain View
  • Farmhouse Style Home
  • Open Floorplan
  • Wood Flooring
  • Home Office

About This Home

As of August 2018

One of the last remaining lots in this subdivision! Close to Windsor for schools, shopping, recreation. Great subdivision with nice custom home. Build your dream home with some space between your neighbors! Easy access to Fort Collins, Greeley, Loveland. Raw water has been dedicated to Town of Windsor for water tap. Septic system required.

Last Agent to Sell the Property

Robert Miner

Black Timber Real Estate LLC License #40027736 Listed on: 12/14/2017

Last Buyer's Agent

Kim Summitt

Group Centerra

Group Centerra

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2018 | Newly Remodeled

Lot Details

  • 2.22 Acre Lot
  • Property is zoned RL

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Tandem Parking

Home Design

  • Farmhouse Style Home
  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 5,604 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Gas Fireplace
  • Home Office
  • Mountain Views
  • Laundry on main level

Kitchen

  • Double Oven
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

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

Finished Basement

  • Basement Fills Entire Space Under The House
  • Natural lighting in basement

Schools

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

Additional Features

  • Garage doors are at least 85 inches wide
  • Patio
  • Forced Air Heating and Cooling System

Community Details

  • Built by Martin Homes
  • Ventana Subdivision

Listing and Financial Details

  • Assessor Parcel Number R8891000

Home Details

Home Type

Single Family

Year Built

Built in 2018 | Newly Remodeled

Lot Details

0

HOA Fees

$58 per month

Parking

4

Listing Details

  • Year Built: 2018
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 2.22
  • Subdivision Name: Ventana Subdivision
  • Architectural Style: Farm House, Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: Yes
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 5604
  • Special Features: NewHome
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave
  • Has Basement: Full, 75%+Finished Basement, Daylight
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Basement
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath, Luxury Features Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Builder Name: Martin Homes
  • View: Mountain(s)
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Patio And Porch Features: Patio
  • Property Condition: New Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: >8' Garage Door, Oversized, Tandem
  • 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, City
  • Gas Company: Natural Gas, Atmos

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 700
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

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

Lot Info

  • Zoning: RL
  • Lot Size Sq Ft: 96703
  • Parcel #: R8891000
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2017

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 21, 2023
Sold by
Nerby Craig L
Bought by
Craig And Anne Nerby Revocable Trust
Current Estimated Value
$1,512,870

Purchase Details

Listed on
Dec 14, 2017
Closed on
Jul 26, 2018
Sold by
Martin Homes Llc
Bought by
Nerby Craig L and Nerby Anne
Seller's Agent
Robert Miner
Black Timber Real Estate LLC
Buyer's Agent
Kim Summitt
Group Centerra
List Price
$929,000
Sold Price
$963,800
Premium/Discount to List
$34,800
3.75%

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.17%
Original Mortgage
$915,610
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Listed on
Sep 9, 2017
Closed on
Oct 4, 2017
Sold by
Wagener Sirena L and Wagener John
Bought by
Mattin Homes Llc
Seller's Agent
Martin West
West & Associates
Buyer's Agent
Robert Miner
Black Timber Real Estate LLC
List Price
$174,900
Sold Price
$176,000
Premium/Discount to List
$1,100
0.63%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
675.76%

Purchase Details

Closed on
Jul 29, 2014
Sold by
Mccrea Bernadette M and Sage Robert H
Bought by
Wagener Charles J

Home Financials for this Owner

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

Purchase Details

Listed on
Oct 8, 2011
Closed on
Apr 9, 2012
Sold by
Ventana Holdings Iii Llc
Bought by
Mccrea Bernadette M and Sage Robert H
Seller's Agent
Marnie Long
Group Harmony
Buyer's Agent
Marnie Long
Group Harmony
List Price
$70,000
Sold Price
$60,000
Premium/Discount to List
-$10,000
-14.29%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
26.24%

Purchase Details

Closed on
Aug 14, 2006
Sold by
Ventana Holdings Ii Llc
Bought by
Ventana Holdings Iii Llc
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
Craig And Anne Nerby Revocable Trust -- --
Nerby Craig L $963,800 Heritage Union Title Co Ltd
Mattin Homes Llc $176,000 None Available
Wagener Charles J $125,000 Tggt
Mccrea Bernadette M $60,000 Land Title Guarantee Company
Ventana Holdings Iii Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Nerby Craig L $915,610
Previous Owner Wagener Charles J $112,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/28/2019 01/28/19 Off Market $176,000 -- --
01/28/2019 01/28/19 Off Market $963,800 -- --
01/28/2019 01/28/19 Off Market $60,000 -- --
08/02/2018 08/02/18 Sold $963,800 +3.7% $172 / Sq Ft
07/03/2018 07/03/18 Pending -- -- --
12/14/2017 12/14/17 For Sale $929,000 +427.8% $166 / Sq Ft
10/04/2017 10/04/17 Sold $176,000 +0.6% $31 / Sq Ft View Prior Sale
09/09/2017 09/09/17 For Sale $174,900 +191.5% $31 / Sq Ft
04/09/2012 04/09/12 Sold $60,000 -14.3% $11 / Sq Ft View Prior Sale
03/10/2012 03/10/12 Pending -- -- --
10/08/2011 10/08/11 For Sale $70,000 -- $12 / Sq Ft
Source: IRES MLS

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 $7,893 $83,410 $12,810 $70,600
2024 $7,893 $83,410 $12,810 $70,600
2023 $7,247 $86,890 $13,870 $73,020
2022 $6,207 $63,680 $12,510 $51,170
2021 $5,458 $61,790 $12,870 $48,920
2020 $4,958 $57,220 $12,870 $44,350
2019 $4,914 $57,220 $12,870 $44,350
2018 $3,289 $36,250 $36,250 $0
2017 $3,481 $36,250 $36,250 $0
2016 $1,274 $13,400 $13,400 $0
2015 $1,136 $12,840 $12,840 $0
2014 $482 $4,940 $4,940 $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: IRE838267

IRES MLS

APN: R8891000