171 S Waterloo St
Aurora, CO 80018
Map
- 5 beds
- 3 baths
- 3,399 sqft
- 10,272 sqft lot
- $214 per sqft
- 2023 build
- – on site
OPEN HOUSE SATURDAY 6/28 from 12-3pm! Welcome to this stunning 5-bedroom/3-bathroom ranch-style home in the sought-after Harmony master-planned community ~ featuring a community center, 6.5-acre park, dog park, and scenic trails! Built in 2023, this modern home, in prestige condition, sits on just under a 1/4-acre corner lot that borders a greenbelt and playground, offering privacy and a vibrant neighborhood feel. Step inside to find an open concept layout with designer finishes and soaring ceilings throughout. The heart of the home is the gourmet kitchen, featuring a large quartz center island, stainless steel appliances, ample cabinet space, and a spacious pantry. The open dining area flows effortlessly into the living room with a gas fireplace and floor-to-ceiling sliding doors leading to a covered, west-facing patio. The main level features three smartly positioned bedrooms, including two secondary bedrooms at the front with a full bath, and a private primary suite at the rear with a spa-like en-suite bath featuring dual sinks, a giant glass shower, and a walk-in closet. A mudroom and laundry area complete the main floor with functional ease. Downstairs, the finished basement offers a massive family/rec room with wet bar, two additional large bedrooms with walk-in closets, and a shared bathroom-ideal space for guests, multigenerational living, or a home theater/game room. The xeriscaped backyard is beautiful, low-maintenance, and features a pergola + built-in fire pit....perfect for summer evenings. Additional features include a concrete path that wraps around the home, landscaped front yard with convenient sprinkler system, 3-car attached garage, large basement storage room, and custom window well covers. Located near I-70, E-470, and Denver International Airport. Just minutes from shopping, dining, schools, and more. Don't miss your chance to own this exceptional home in Harmony-schedule your showing today!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 26, 2025
•
MLS# 9290094 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2023
-
New Construction:false
-
Construction Materials:Wood/Frame
-
Builder Name:Richmond American Homes
-
Architectural Style:Ranch
-
Total SqFt:3,804 Sqft
-
Building Area Total:1902
-
Roof:Composition
-
Foundation Details:Slab
-
Levels:One
-
Basement:Full
-
Stories:1
-
Direction Faces:East
-
Window Features:Double Pane Windows
-
Patio And Porch Features:Patio
-
Above Grade Finished Area:1902
-
Below Grade Finished Area:1902
Interior
-
Interior Features:Eat-in Kitchen
-
Fireplace:true
-
Fireplace Features:Gas
-
Living Room Level:Main
-
Kitchen Level:Main
-
Dining Room Level:Main
-
Family Room Level:Basement
-
Laundry Features:Main Level
Room Dimensions
-
Living Area:3399
-
Living Area Units:Square Feet
-
Living Area Source:Assessor
Financial & Terms
-
Listing Terms:Cash
Location
-
Coordinates:-104.664497, 39.713226
-
Latitude:39.713226
-
Longitude:-104.664497
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Lot Features:Gutters
-
Lot Size Acres:0.24
-
Lot Size SqFt:10,272 Sqft
-
Lot Size Area:10272
-
Lot Size Units:Square Feet
-
Exclusions:Seller's Personal Property including washer, dryer, basement refrigerator, all fixtures in the garage, TVs, hanging lights, fire pit, video doorbell, thermostat, and pergola fan, and all staging items.
-
Horse:false
-
Fencing:Fenced
-
Waterfront:false
-
Road Surface Type:Paved
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$7,745
Beds
-
Bedrooms Total:5
-
Bedroom 2 Level:Main
-
Bedroom 3 Level:Main
-
Bedroom 4 Level:Basement
-
Bedroom 5 Level:Basement
-
Master Bedroom Level:Main
Baths
-
Total Baths:3
-
Three Quarter Baths:1
-
Full Baths:2
-
Master Bath Features:3/4 Primary Bath
The Listing
-
Virtual Tour URL Unbranded:https://www.zillow.com/view-imx/ce798b50-2b8e-48eb-b07f-5568dfc7f586?setAttribution=mls&wl=true&initialViewType=pano
-
Special Listing Conditions:Private Owner
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Utilities:Natural Gas Available
-
Gas:Natural Gas
-
Electric:Electric
-
Sewer:City Sewer
-
Water Source:City Water
Appliances
-
Appliances:Double Oven
Schools
-
Elementary School:Harmony Ridge P-8
-
Middle School:Harmony Ridge P-8
-
High School:Vista Peak
-
High School District:Adams-Arapahoe 28J
The Community
-
Community Features:Clubhouse
-
Association:true
-
Subdivision Name:Harmony
-
Association Fee:$342
-
Association Fee Frequency:Quarterly
-
Association Fee Includes:Trash
-
Spa:false
-
Senior Community:false
Parking
-
Garage Spaces:3
-
Garage:true
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:3
Monthly cost estimate
Asking price
$730,000
| Expense | Monthly cost |
|---|---|
|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$3,908
|
| Taxes | $645 |
| Insurance | $200 |
| HOA fees | $114 |
| Utilities | $146 See report |
| Total | $5,013/mo.* |
| *This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
6/26/25
Jun 26, 2025
|
Listed / Active | IRES | $730,000 | 4.3% (2.8% / YR) |
|
12/18/23
Dec 18, 2023
|
RECOLORADO | $699,950 | -3.4% | |
|
11/27/23
Nov 27, 2023
|
RECOLORADO | $724,950 |
