NOT LISTED FOR SALE

166 S Waterloo St Aurora, CO 80018

Estimated Value: $673,000 - $729,000

4 Beds
3.5 Baths
3,423 Sq Ft
$207/Sq Ft Est. Value

Last Sold December 28, 2023

Last sale price $669,950 $196 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $4,327/month

181 Days on Market

Highlights

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

About This Home

As of December 2023

**!!AVAILABLE NOW/MOVE IN READY!!**SPECIAL FINANCING AVAILABLE** This Bedford is waiting to impress with two stories of smartly inspired living spaces and designer finishes throughout. The main floor provides ample room for dining and entertaining and offers a great room at the heart of the home with a contemporary fireplace. The gourmet kitchen impresses any level of chef with its quartz center island, walk-in pantry and stainless steel appliances. An adjacent sunroom offers additional seating space and offers views of the covered patio. A pocket office, powder and mudroom are added conveniences. Retreat upstairs to find a comfortable loft just outside the owner's suite which showcases a private bath and spacious walk-in closet. A convenient laundry and two generous bedrooms with a shared bath make perfect accommodations for family or guests. If that wasn't enough this home features a finished basement with rec room and an additional bedroom with a shared full bath.

Last Agent to Sell the Property

Todd Baker

Richmond Realty Inc Brokerage Phone: 303-850-5757 License #100056314 Listed on: 06/08/2023

Last Buyer's Agent

Illona Gerlock

Coldwell Banker Realty 18 License #40007170

Coldwell Banker Realty 18

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,147

Year Built

  • Built in 2023 | Under Construction

Lot Details

  • 7,405 Sq Ft Lot
  • West Facing Home
  • Landscaped

HOA Fees

  • $94 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Slab Foundation
  • Frame Construction
  • Architectural Shingle Roof
  • Composition Roof
  • Radon Mitigation System

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Gas Fireplace
  • Double Pane Windows
  • Great Room with Fireplace

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop with Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • 1 Bedroom in Basement

Schools

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

Additional Features

  • Covered patio or porch
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 035445747

Community Details

Overview

  • Association fees include ground maintenance, recycling, trash
  • Ccmc Association, Phone Number (303) 390-1222
  • Built by Richmond American Homes
  • Harmony Subdivision, Bedford / F Floorplan
  • Located in a master-planned community

Amenities

  • Clubhouse

Recreation

  • Fitness Center
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,147

Year Built

Built in 2023 | Under Construction

Lot Details

0

HOA Fees

$94 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Two
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 2489
  • Exclusions: None
  • Living Area: 3423
  • Property Condition: Under Construction
  • Directions: Follow I-225 N and CO-30 E/E 6th Ave to E Stephen D. Hogan Pkwy in Aurora. Continue on E Stephen D. Hogan Pkwy. Take E 6th Pkwy and E 6th Ave to E Maple Ave
  • SubdivisionName: Harmony
  • Ownership: Builder
  • ResoBuildingAreaSource: Builder
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 102.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.83749
  • New Home Available Options: Harmony Colorado is the beginning of a new story in Aurora. Over 1,360 acres, this new-home community is built around the power of experience, with a vibrant community center, a 6.5-acre community park, ample trails, dog park and an onsite school. It is within easy reach of shopping, dining and nearby access to I-70, E-470 and Denver International Airport.
  • Attribution Contact: 303-850-5757
  • Special Features: NewHome

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Microwave, Oven, Range, Range Hood, Sump Pump
  • Fireplaces: 1
  • Interior Amenities: Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Walk-In Closet(s)
  • Flooring: Carpet, Vinyl
  • Fireplace Features: Gas, Great Room
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Finished, Full, Sump Pump
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 934
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: West
  • Foundation Details: Slab
  • Roof: Architecural Shingle, Composition
  • Construction Materials: Frame
  • Patio and Porch Features: Covered, Patio

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Recycling, Trash
  • Association Name: CCMC
  • Association Fee Frequency: Monthly
  • Association Amenities: Clubhouse, Fitness Center, Pool
  • Association Fee: 94
  • Phone: 303-390-1222
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1128.00
  • REC_AssociationFeeTotalAnnual: 1128.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Harmony Ridge P-8

Lot Info

  • Parcel Number: 035445747
  • Lot Size Acres: 0.17
  • Building Area Total: 3525
  • Lot Features: Landscaped, Master Planned
  • Lot Size Sq Ft: 7405.2
  • ResoLotSizeUnits: Acres

Building Info

  • Builder Name: Richmond American Homes

Rental Info

  • Furnished: Unfurnished

Tax Info

  • Tax Year: 2023

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 8, 2023
Closed on
Dec 28, 2023
Sold by
Richmond American Hm/Co Inc
Bought by
Jacobs Michael Louis and Lloyd Brigitte Elayna
Seller's Agent
Todd Baker
Richmond Realty Inc
Buyer's Agent
Illona Gerlock
Coldwell Banker Realty 18
List Price
$799,950
Sold Price
$669,950
Premium/Discount to List
-$130,000
-16.25%
Views
32
Current Estimated Value
$709,938

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$39,988
Avg. Annual Appreciation
2.14%
Original Mortgage
$535,960
Outstanding Balance
$526,013
Interest Rate
5%
Mortgage Type
New Conventional
Estimated Equity
$167,215

Purchase Details

Closed on
Apr 14, 2023
Sold by
Melcor/Tc Aurora Llc
Bought by
Richmond American Homes Of Colorado Inc
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
Jacobs Michael Louis $670,000 None Listed On Document
Richmond American Homes Of Colorado Inc $2,203,500 Land Title Guarantee
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Jacobs Michael Louis $535,960
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/28/2023 12/28/23 Sold $669,950 -0.7% $196 / Sq Ft
12/06/2023 12/06/23 Pending -- -- --
11/18/2023 11/18/23 Price Changed $674,950 -3.6% $197 / Sq Ft
11/03/2023 11/03/23 Price Changed $699,950 -3.2% $204 / Sq Ft
10/31/2023 10/31/23 Price Changed $722,950 +1.1% $211 / Sq Ft
10/16/2023 10/16/23 Price Changed $714,950 -1.4% $209 / Sq Ft
09/22/2023 09/22/23 Price Changed $724,950 -4.2% $212 / Sq Ft
09/12/2023 09/12/23 Price Changed $756,950 +0.1% $221 / Sq Ft
08/29/2023 08/29/23 Price Changed $755,950 +0.3% $221 / Sq Ft
08/22/2023 08/22/23 Price Changed $753,950 +0.5% $220 / Sq Ft
08/15/2023 08/15/23 Price Changed $749,950 -1.3% $219 / Sq Ft
07/03/2023 07/03/23 Price Changed $759,950 -5.0% $222 / Sq Ft
06/08/2023 06/08/23 For Sale $799,950 -- $234 / 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 $4,147 $44,515 -- --
2023 $4,147 $24,748 $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: 9057082

REcolorado®

APN: 1977-09-4-21-003