NOT LISTED FOR SALE

171 S Waterloo St Aurora, CO 80018

Estimated Value: $622,000 - $715,682

5 Beds
3 Baths
3,313 Sq Ft
$205/Sq Ft Est. Value

Last Sold December 18, 2023

Last sale price $699,950 $211 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $4,253/month

96 Days on Market

Highlights

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

About This Home

As of December 2023

**!!AVAILABLE NOW/MOVE IN READY!!**SPECIAL FINANCING AVAILABLE** This Arlington is waiting to impress with the convenience of its ranch-style layout along with designer finishes throughout. The main floor offers two generous bedrooms flanking a shared bath offering ideal accommodations for family or guests. The open layout leads you to the back of the home where a beautiful gourmet kitchen awaits and features a quartz center island, roomy pantry and stainless steel appliances. Beyond, the open dining room flows into the welcoming great room with a tile fireplace. Enjoy meals and conversation on the large covered patio. The nearby primary suite showcases a spacious walk-in closet and a private bath with dual sinks. A convenient laundry and mud room complete the main level. If that wasn’t enough, this exceptional home includes a finished basement that boasts a wide-open rec room with a wet bar, along with a shared bath and two large basement bedrooms with walk-in closets. **CALL 303.850.5757 TO SCHEDULE A TOUR TODAY!**

Last Agent to Sell the Property

Todd Baker

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

Last Buyer's Agent

Tasleem Roy

RE Brokers License #100098390

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,147

Year Built

  • Built in 2023 | Under Construction

Lot Details

  • 10,019 Sq Ft Lot
  • East Facing Home
  • Landscaped
  • Corner Lot
  • Front Yard Sprinklers

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

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • 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

  • 5 Bedrooms | 3 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • 2 Bedrooms 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 035445712

Community Details

Overview

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

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: One
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 1886
  • Exclusions: None
  • Living Area: 3313
  • 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: 2
  • REC_BelowGradeUnfinishedArea: 459.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.87499
  • 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 Hood
  • Fireplaces: 1
  • Interior Amenities: Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Vinyl
  • Fireplace Features: Great Room
  • Full Bathrooms: 2
  • Basement: Finished, Full, Sump Pump
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1427
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: East
  • 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: 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: 035445712
  • Lot Size Acres: 0.23
  • Building Area Total: 3772
  • Lot Features: Corner Lot, Greenbelt, Landscaped, Master Planned, Sprinklers In Front
  • Lot Size Sq Ft: 10018.8
  • 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

Closed on
Apr 14, 2023
Sold by
Melcor/Tc Aurora Llc
Bought by
Richmond American Homes Of Colorado Inc
Total Days on Market
96
Current Estimated Value
$679,171
Source: Public Records

Similar Homes in Aurora, CO

  • 1066 S Eaton Park Ct, Aurora, CO 80018

    $600,000

    • 3 Beds
    • 2.5 Baths
    • 2,136 Sq Ft
    • 1066 S Eaton Park Ct
    • Aurora, CO

    Welcome to this stunning single-family home located in the desirable Waterstone community of Aurora, Colorado. This spacious residence offers 3 bedrooms, 2 full bathrooms, and 1 half bathroom, all within an impressive 2,136 square feet. With a two-car garage and a beautifully designed layout, this home is perfect for families seeking comfort and style in a suburban setting.As you enter,

    Barry Overton eXp Realty, LLC

    Section Image
  • 24197 E Ada Ave, Aurora, CO 80018

    $695,000

    • 3 Beds
    • 2 Baths
    • 1,983 Sq Ft
    • 24197 E Ada Ave
    • Aurora, CO

    Step into this beautifully upgraded and meticulously maintained Graham model by Lennar Homes! This popular single-story layout offers spacious living with soaring ceilings, expansive windows, and an abundance of natural light throughout. The home features two generously sized bedrooms that share a stylishly upgraded full bathroom, along with a large laundry room offering ample storage space. The

    Mark Eibner MB Metro Brokers Realty Oasis

    Section Image
  • 247 N Coolidge Way, Aurora, CO 80018

    $590,000

    • 4 Beds
    • 3.5 Baths
    • 2,921 Sq Ft
    • 247 N Coolidge Way
    • Aurora, CO

    PREFERRED LENDER GIVING FREE NO FEE REFINANCING FOR LIFE OF THE LOAN - AND - .5% INTEREST RATE REDUCTION - SAVES YOU AROUND $170/MONTH ON A 500K LOAN*...some restrictions do apply.Charming 4-Bedroom Home with Finished Basement – 247 N Coolidge Way, Aurora - check out the 3D tour! ADA accessible home with ramp in garage (can be removed upon request).Welcome to this well maintained 4-bedroom,

    Hunter Deegan Orchard Brokerage LLC

    Section Image
  • 1957 S Coolidge Way, Aurora, CO 80018

    $599,990

    • 3 Beds
    • 2 Baths
    • 1,796 Sq Ft
    • 1957 S Coolidge Way
    • Aurora, CO

    Welcome to Your Relaxing Place. Incredible Mountain and Golf Course Views. Hole 8 Murphy Creek and Mountain Views!!! Does it get any better? You Bet!!! This New Construction Ranch home features 3 beds/2 baths on the main floor, plus a flex room. Full Size Laundry room with Appliances and upper cabinets. Quartz Countertops, and a cooks kitchen. Counter Bar seating and off the side dining

    Donna M. Jarock Coldwell Banker Realty 24

    Section Image
  • 4104 Picadilly Ct, Aurora, CO 80019

    $585,000

    • 4 Beds
    • 2.5 Baths
    • 2,372 Sq Ft
    • 4104 Picadilly Ct
    • Aurora, CO

    Absolutely beautiful 4 bedroom home with upgrades you will not find in any new build. Sellers went above and beyond at the design center and this home truly looks like a model home with $100,000 spent in upgrades. Some including: tankless water heater, upgraded carpet and padding, stunning LVP floors, fence security, higher end appliance package (including gas cook top), built in speakers on the

    Taylor Bunney eXp Realty, LLC

    Section Image
  • 2843 S Jericho Way, Aurora, CO 80013

    $559,900

    • 3 Beds
    • 2 Baths
    • 1,676 Sq Ft
    • 2843 S Jericho Way
    • Aurora, CO

    Welcome to your ranch home in The Conservatory neighborhood! Inside you'll be greeted by warm wood flooring and an inviting atmosphere. The open-concept kitchen is a chef’s dream, featuring granite countertops, a gas range, a spacious island, and seamless flow into the dining area—perfect for everyday living and entertaining. The cozy living room has a gas fireplace, ideal for chilly Colorado

    Julie Maeda Guardian Real Estate Group

    Section Image
  • 4238 S Netherland Cir, Aurora, CO 80013

    $635,000

    • 5 Beds
    • 3 Baths
    • 2,918 Sq Ft
    • 4238 S Netherland Cir
    • Aurora, CO

    Ranch Home!!! Enjoy an energy-efficient low maintenance home a fan favorite built by Meritage Homes. Boasting a welcoming covered front porch & a beautifully designed interior perfect for any family. As you make your way into the home take note of the beautiful hardwood flooring with its warm and inviting color. The expansive entry way makes greeting your guests a delight. At the front of the

    Donna M. Jarock Coldwell Banker Realty 24

    Section Image
  • 4834 S Wenatchee St, Aurora, CO 80015

    $669,000

    • 3 Beds
    • 2 Baths
    • 1,724 Sq Ft
    • 4834 S Wenatchee St
    • Aurora, CO

    Beautifully maintained 3 Bedroom 2 Bath ranch in Copperleaf with mountain views, no rear neighbors, and a brand-new roof (April 2025). Open floorplan with high ceilings, natural light, and smart updates throughout. Two front bedrooms and full bath offer flexible space for guests or a home office. Chef’s kitchen features a granite island, stainless appliances, gas cooktop, farmhouse sink, and

    Desiree Miller LIV Sotheby's International Realty

    Section Image
  • 22527 E Layton Cir, Aurora, CO 80015

    $775,000

    • 4 Beds
    • 3 Baths
    • 3,308 Sq Ft
    • 22527 E Layton Cir
    • Aurora, CO

    Welcome to this spacious and beautifully appointed 4-bedroom home, thoughtfully designed for both everyday living and elegant entertaining. As you step inside, you’re greeted by a dedicated main-level office and a formal dining room that sets the tone for refined gatherings.The heart of the home features upgraded light fixtures throughout, adding warmth and modern flair. Upstairs, you’ll find a

    Christopher Morrison Action Team Realty

    Section Image

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
Richmond American Homes Of Colorado Inc $2,203,500 Land Title Guarantee
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/18/2023 12/18/23 Sold $699,950 -3.4% $211 / Sq Ft
11/23/2023 11/23/23 For Sale $724,950 +3.6% $219 / Sq Ft
11/22/2023 11/22/23 Pending -- -- --
11/17/2023 11/17/23 Off Market $699,950 -- --
11/03/2023 11/03/23 Price Changed $724,950 -5.0% $219 / Sq Ft
10/31/2023 10/31/23 Price Changed $762,950 +1.1% $230 / Sq Ft
10/16/2023 10/16/23 Price Changed $754,950 -1.3% $228 / Sq Ft
10/10/2023 10/10/23 Price Changed $764,950 -1.3% $231 / Sq Ft
09/22/2023 09/22/23 Price Changed $774,950 -4.0% $234 / Sq Ft
09/12/2023 09/12/23 Price Changed $806,950 +0.1% $244 / Sq Ft
08/29/2023 08/29/23 Price Changed $805,950 +0.2% $243 / Sq Ft
08/22/2023 08/22/23 Price Changed $803,950 +0.5% $243 / Sq Ft
08/17/2023 08/17/23 For Sale $799,950 -- $241 / 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,863 -- --
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: 9454070

REcolorado®

APN: 1977-09-4-20-018