NOT LISTED FOR SALE

29 N Waterloo St Aurora, CO 80018

Estimated Value: $609,000 - $655,000

5 Beds
3 Baths
2,652 Sq Ft
$239/Sq Ft Est. Value

Last Sold December 28, 2022

Last sale price $576,270 $217 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $4,075/month

151 Days on Market

Highlights

  • Fitness Center
  • Primary Bedroom Suite
  • Clubhouse
  • Located in a master-planned community
  • Open Floorplan
  • Traditional Architecture

About This Home

As of December 2022

***MOVE-IN READY***
Welcome to the Henley! This home has 5 bedrooms including one on the main floor. 3 full baths,2.5 car garage, main floor study and upstairs loft and laundry. Home is located on an Over-sized Lot! This Henley has everything to offer with an open flow between great room, kitchen and dining. Stylish décor includes elegant grayish brown maple cabinetry with crown molding, gorgeous granite kitchen counters, stainless gas range, microwave, dishwasher, and easy maintenance laminate wood floors on most of main level. We offer an extensive list of features in our homes such as 8' front door, 2 panel interior doors, A/C, tankless water heater, front yard landscaping, exterior fencing, 8' tall garage doors with Smart openers plus Smart Home features such as Smart speakers, video doorbell, Smart thermostat, Smart lighting and door lock control, and more! 10/2/1 year New home warranty for peace of mind is also included. You are sure to enjoy your beautiful new home in a friendly area with community pool, community center, volleyball and basketball courts, park, playground and picnic area!
***Photos are not of actual home - for representation only.***

Last Agent to Sell the Property

Jodi Bright

D.R. Horton Realty, LLC License #40028178 Listed on: 06/14/2022

D.R. Horton Realty, LLC

Last Buyer's Agent

Juan Butanda

Key Team Real Estate Corp. License #100090754

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,280

Year Built

  • Built in 2022 | Under Construction

Lot Details

  • 0.25 Acre Lot
  • Property is Fully Fenced
  • Front Yard Sprinklers
  • Private Yard

HOA Fees

  • $78 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Smart Garage Door

Home Design

  • Traditional Architecture
  • Frame Construction
  • Architectural Shingle Roof
  • Cement Siding
  • Concrete Block And Stucco Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,652 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • Double Pane Windows
  • Smart Doorbell

Kitchen

  • Self-Cleaning Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Laminate Countertops
  • Disposal

Flooring

  • Laminate
  • Concrete
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • Primary Bedroom Suite
  • Walk-In Closet

Basement

  • Sump Pump
  • Crawl Space

Home Security

  • Smart Locks
  • Smart Thermostat
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Covered Patio or Porch
  • Rain Gutters

Schools

  • Harmony Ridge P-8 Elementary And Middle School
  • Vista Peak High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected
  • Tankless Water Heater
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 035442748

Community Details

Overview

  • Association fees include ground maintenance, recycling, trash
  • Ccmc Association, Phone Number (303) 390-1222
  • Visit Association Website
  • Built by D.R. Horton, Inc
  • Harmony Subdivision, Henley Floorplan
  • Located in a master-planned community
  • The community has rules related to covenants, conditions, and restrictions

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Fitness Center
  • Community Pool
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,280

Year Built

Built in 2022 | Under Construction

Lot Details

0

HOA Fees

$78 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: Two
  • Above Grade Price per Sq Ft: 217.30
  • Finished Price per Sq Ft: 217.30
  • Total Price per Sq Ft: 217.30
  • Year Built: 2022
  • Above Grade Finished Sq Ft: 2652.00
  • Annual Association Fee: 936.00
  • Living Area: 2652.00
  • P P A: 2305080.00
  • Restrictions Covenants: Deed Restrictions
  • Restrictions Covenants: Yes
  • Special Assessment Description: $350 Assoc. Transfer Amount + .2% New Owner Fee
  • Upper Level Bathrooms: 2
  • Upper Level Bedrooms: 4
  • Water Included: Yes
  • Property Condition: Under Construction
  • Directions: E-470 N, Take Exit 16 head east on E Jewell Ave to S Powhaton Rd-turn left, right on Alameda, Left on Trussville St, Left on Robertsdale St, go past park and take first left onto S. Scottsburg Court. DR Horton is located at the end of the cul-de-sac (last house on the East Side).
  • SubdivisionName: Harmony
  • Special Features: NewHome

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Range, Self Cleaning Oven, Sump Pump, Tankless Water Heater
  • Interior Amenities: Granite Counters, Kitchen Island, Laminate Counters, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Walk-In Closet(s), Wired for Data
  • Flooring: Concrete, Laminate, Tile, Vinyl
  • Full Bathrooms: 2
  • Room Count: 13
  • Common Walls: No Common Walls
  • Basement: Crawl Space
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Roof: Architectural Shingles
  • Construction Materials: Cement Siding, Concrete, Frame
  • Exterior Features: Private Yard, Rain Gutters
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public Road
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Smart Garage Door
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Water Tap Paid Yn: Yes
  • Electric: 110V, 220 Volts
  • Security: Carbon Monoxide Detector(s), Smart Locks, Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Recycling, Trash
  • Annual Association Fees: 936.00
  • Association Name: CCMC
  • Association Fee Frequency: Monthly
  • Association Management Type: Professionally Managed
  • Association Amenities: Clubhouse, Fitness Center, Park, Playground, Pool, Trail(s)
  • Association Fee: 78.00
  • Phone: 303-390-1222
  • Association Website: http://www.ccmcnet.com/
  • Association: Yes

Schools

  • School District: Adams-Arapahoe 28J
  • Elementary School: Harmony Ridge P-8
  • Middle School: Harmony Ridge P-8
  • High School: Vista Peak
  • Middle Or Junior School: Harmony Ridge P-8

Lot Info

  • Parcel Number: 035442748
  • Lot Size Acres: 0.25
  • Fencing: Full
  • Building Area Total: 2652.00
  • Lot Features: Master Planned, Sprinklers In Front
  • Lot Size Sq Ft: 10870.00

Building Info

  • Builder Name: D.R. Horton, Inc

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 7280.00

MLS Schools

  • Elementary School: Harmony Ridge P-8
  • High School: Vista Peak

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 14, 2022
Closed on
Dec 28, 2022
Sold by
Melody Homes Inc
Bought by
Alvarez Uriel Zarco
Seller's Agent
Jodi Bright
D.R. Horton Realty, LLC
Buyer's Agent
Juan Butanda
Key Team Real Estate Corp.
List Price
$600,000
Sold Price
$576,270
Premium/Discount to List
-$23,730
-3.96%
Views
2
Current Estimated Value
$634,786

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$58,516
Avg. Annual Appreciation
4.09%
Original Mortgage
$460,000
Interest Rate
6.61%
Mortgage Type
New Conventional
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
Alvarez Uriel Zarco $576,270 Dhi Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gonzalez Francisco Alberto $484,330
Closed Alvarez Uriel Zarco $460,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/28/2022 12/28/22 Sold $576,270 +0.2% $217 / Sq Ft
11/12/2022 11/12/22 Pending -- -- --
10/25/2022 10/25/22 Price Changed $575,000 -4.5% $217 / Sq Ft
10/03/2022 10/03/22 Price Changed $602,380 +0.4% $227 / Sq Ft
09/29/2022 09/29/22 For Sale $600,000 0.0% $226 / Sq Ft
07/16/2022 07/16/22 Pending -- -- --
07/12/2022 07/12/22 Price Changed $600,000 -6.3% $226 / Sq Ft
06/17/2022 06/17/22 Price Changed $640,000 -1.5% $241 / Sq Ft
06/14/2022 06/14/22 For Sale $650,000 -- $245 / Sq Ft
Source: REcolorado®

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 $6,777 $40,441 -- --
2023 $6,777 $40,441 $0 $0
2022 $3,911 $23,087 $0 $0
2021 $3,911 $23,087 -- --
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4400123

REcolorado®

APN: 1977-09-4-10-018