NOT LISTED FOR SALE

166 S Waterloo St Aurora, CO 80018

Aurora Area

Estimated Value: $675,000 - $695,000

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

Sale Details

Date Sold: April 27, 2026

Last sale price $680,000 $199 Per Sq Ft

22 Days on Market

Highlights

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

About This Home

As of April 2026

Welcome to this beautifully designed, move-in ready home nestled in the highly desirable Harmony master-planned community! This home blends modern style, functional layout, and everyday comfort. From the moment you step inside, you’ll be greeted by luxury vinyl flooring, an open floorplan filled with natural light, and elegant finishes throughout. The main level features a stunning kitchen complete with quartz countertops, GE appliances, a large center island with seating, and a spacious pantry perfect for entertaining or everyday living. The dining and living areas flow seamlessly, highlighted by a gas fireplace that creates a warm and inviting atmosphere for gatherings. A convenient half bath and mudroom complete the main level functionality. Upstairs, you’ll find three generously sized bedrooms including the primary suite with a walk-in closet, and a luxurious en-suite bathroom featuring quartz countertops, dual sinks, and a beautiful tile shower. The upper level also includes a versatile loft space, along with an upper-level laundry room with quartz surfaces and a utility sink for added convenience. The finished basement expands your living options with a large family room ideal for recreation or movie nights, an additional bedroom, and a full bathroom with stylish tile finishes. Situated on a landscaped 0.17-acre lot with a covered patio, and private outdoor space, this home is perfect for Colorado outdoor living. Enjoy the incredible Harmony community that 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 DIA. With a three-car attached garage providing ample storage and parking space, this home truly has it all. Don’t miss the opportunity to own in one of the area’s most desirable neighborhoods, where comfort, community, and modern living come together beautifully! SHOWS BEAUTIFULLY!

Last Agent to Sell the Property

Illona Gerlock

Coldwell Banker Realty 18 Brokerage Email: Illona@GerlockHomes.com,303-809-1235 License #40007170 Listed on: 03/05/2026

Coldwell Banker Realty 18

Co-Listed By

Gerlock Homes

Coldwell Banker Realty 18 Brokerage Email: Illona@GerlockHomes.com,303-809-1235

Last Buyer's Agent

Soyan Amin

Compass - Denver License #100087921

Compass - Denver

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,168

Year Built

  • Built in 2023

Lot Details

  • 7,405 Sq Ft Lot
  • Open Space
  • Property is Fully Fenced
  • Landscaped
  • Front Yard Sprinklers
  • Private Yard
  • Garden

HOA Fees

  • $94 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Frame Construction
  • Shingle Roof
  • Composition Roof
  • Radon Mitigation System

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Mud Room
  • Family Room with Fireplace
  • Living Room
  • Dining Room
  • Loft
  • Finished Basement
  • 1 Bedroom in Basement
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

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

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
  • 110 Volts
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Seller's personal property and/or staging materials. Washer, Dryer, and Curtains.
  • 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

$8,168

Year Built

Built in 2023

Lot Details

7,405 Sq Ft Lot

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
  • Below Grade Sq Ft: 102
  • Exclusions: Seller's personal property and/or staging materials. Washer, Dryer, and Curtains.
  • Living Area: 3423
  • SubdivisionName: Harmony
  • Co List Office Mls Id: RECCBR18
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.97143
  • REC_AdditionalLivingStructureYN: 0
  • Special Features: VirtualTour

Interior Features

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

Exterior Features

  • Roof: Shingle, Composition
  • Construction Materials: Frame
  • Exterior Features: Garden, Private Yard, Rain Gutters
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

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

Utilities

  • Utilities: Cable Available, Electricity Available, Internet Access (Wired), Natural Gas Available, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V

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

Schools

  • Middle Or Junior School: Harmony Ridge P-8

Lot Info

  • Parcel Number: 035445747
  • Lot Size Acres: 0.17
  • Fencing: Full
  • Building Area Total: 3525
  • Lot Features: Landscaped, Master Planned, Open Space, Sprinklers In Front
  • Lot Size Sq Ft: 7405

Building Info

  • Builder Name: Richmond American Homes

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 8168

MLS Schools

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

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 5, 2026
Closed on
Apr 27, 2026
Sold by
Bought by
Seller's Agent
Illona Gerlock
Coldwell Banker Realty 18
Buyer's Agent
Soyan Amin
Compass - Denver
List Price
$700,000
Sold Price
$680,000
Premium/Discount to List
-$20,000
-2.86%
Views
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
3.46%
Original Mortgage
$485,500
Interest Rate
0.0622%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 8, 2023
Closed on
Dec 28, 2023
Sold by
Bought by
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

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.64%
Original Mortgage
$535,960
Interest Rate
0.05%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 14, 2023
Sold by
Bought by
Source: Public Records
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$680,000 Guardian Title
$670,000 None Listed On Document
$2,203,500 Land Title Guarantee
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $485,500
Closed $535,960
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/27/2026 04/27/26 Sold $680,000 -2.9% $199 / Sq Ft
03/05/2026 03/05/26 For Sale $700,000 +4.5% $204 / Sq Ft
12/28/2023 12/28/23 Sold $669,950 -0.7% $196 / Sq Ft View Prior Sale
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $8,168 $42,026
2025 $8,168 $42,919
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
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 9086020

REcolorado®

APN: 1977-09-4-21-003

Your Personal Tour Guide

Ask me questions while you tour the home.