171 S Waterloo Street
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 ¼-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
-
Builder Name:Richmond American Homes
-
Construction Materials:Frame
-
Building Area Total:3804
-
Building Area Source:Public Records
-
Structure Type:House
-
Roof:Shingle, Composition
-
Foundation Details:Slab
-
Levels:One
-
Basement:true
-
Common Walls:No Common Walls
-
Direction Faces:East
-
Exterior Features:Lighting, Rain Gutters
-
Patio And Porch Features:Covered, Front Porch, Patio
-
Window Features:Double Pane Windows, Egress Windows
-
Security Features:Carbon Monoxide Detector(s), Smoke Detector(s)
-
Above Grade Finished Area:1902
-
Below Grade Finished Area:1497
-
Property Attached:false
-
Below Grade Unfinished Area:405
Interior
-
Interior Features:Ceiling Fan(s), Eat-in Kitchen, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Walk-In Closet(s), Wet Bar
-
Furnished:Unfurnished
-
Flooring:Carpet, Vinyl
-
Fireplaces Total:1
-
Fireplace Features:Gas, Living Room
-
Laundry Features:Sink, In Unit
Room Dimensions
-
Living Area:3399
Financial & Terms
-
Ownership:Individual
Location
-
Latitude:39.71322536
-
Longitude:-104.6644973
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Parcel Number:035445712
-
Lot Features:Corner Lot, Greenbelt, Landscaped, Master Planned, Sprinklers In Front
-
Lot Size Area:10272
-
Lot Size Acres:0.24
-
Lot Size SqFt:10,272 Sqft
-
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.
-
Fencing:Full
-
Horse:false
-
Vegetation:Xeriscaping
-
Road Responsibility:Public Maintained Road
-
Road Frontage Type:Public
-
Road Surface Type:Paved
Listing Agent
- Contact info:
- Agent phone:
- (720) 252-3854
- Office phone:
- (720) 252-3854
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$7,745
Beds
-
Bedrooms Total:5
-
Main Level Bedrooms:3
-
Basement Level Bedrooms:2
Baths
-
Total Baths:3
-
Full Baths:2
-
Three Quarter Baths:1
-
Main Level Baths:2
-
Basement Level Baths:1
The Listing
-
Virtual Tour URL Unbranded:https://www.zillow.com/view-imx/ce798b50-2b8e-48eb-b07f-5568dfc7f586?setAttribution=mls&wl=true&initialViewType=pano
-
Home Warranty:false
Heating & Cooling
-
Heating:Forced Air
-
Cooling:Central Air
Utilities
-
Utilities:Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available
-
Sewer:Public Sewer
-
Water Included:Yes
-
Water Source:Public
Appliances
-
Appliances:Cooktop, Dishwasher, Disposal, Double Oven, Gas Water Heater, Microwave, Range Hood, Refrigerator, Sump Pump
Schools
-
Elementary School:Harmony Ridge P-8
-
Elementary School District:Adams-Arapahoe 28J
-
Middle Or Junior School:Harmony Ridge P-8
-
Middle Or Junior School District:Adams-Arapahoe 28J
-
High School:Vista Peak
-
High School District:Adams-Arapahoe 28J
The Community
-
Subdivision Name:Harmony
-
Association Amenities:Clubhouse, Fitness Center, Park, Pool, Trail(s)
-
Association:true
-
Association Name:Harmony HOA
-
Association Fee:$342
-
Association Fee Frequency:Quarterly
-
Association Fee Annual:$1,368
-
Association Fee Total Annual:$1,368
-
Association Fee Includes:Recycling, Trash
-
Senior Community:false
Parking
-
Parking Total:6
-
Parking Features:Concrete
-
Attached Garage:true
-
Garage 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.
