$699,950
SOLD DEC 18, 2023

171 S Waterloo St Aurora, CO 80018

5 Beds
3 Baths
3,313 Sq Ft
10,019 Sq Ft Lot

Recently Sold

$211 Per Sq Ft

3% Below List Price

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
  • <<OvenToken>>
  • Cooktop<<rangeHoodToken>>
  • <<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
Source: Public Records

Similar Homes in Aurora, CO

  • 21395 E Greenwood Place, Aurora, CO 80013

    $749,000

    • 5 Beds
    • 4.5 Baths
    • 3,405 Sq Ft
    • 21395 E Greenwood Place
    • Aurora, CO

    This beautifully updated home is a must see – offering comfort, space and custom upgrades. Resting in a 1⁄2 acre low maintenance perennial landscaped corner lot- no lawn to mow, weed or feed. Quality finishes throughout – tile and wood floors, custom staircase, granite counters, custom tile backsplashes, mosaic tiled gas fireplace, stainless steel appliances. Primary bedroom with wooden floor

    John Vizzi Colorado Flat Fee Realty Inc

    Section Image
  • 27504 E 1st Place, Aurora, CO 80018

    $585,000

    • 5 Beds
    • 3 Baths
    • 2,415 Sq Ft
    • 27504 E 1st Place
    • Aurora, CO

    Live big in this bold and beautifully upgraded 5-bedroom, 3-bath home with an oversized garage designed for modern life. Inside, you’ll find a bright, open layout where the great room flows effortlessly into the kitchen and dining area—ideal for entertaining or just enjoying the moment. The main level includes a versatile bedroom and full bath, perfect for guests or a hybrid home office.Upstairs,

    Jose Medina Vantegic Real Estate

    Section Image
  • 25536 E 1st Ave, Aurora, CO 80018

    $640,000

    • 3 Beds
    • 2 Baths
    • 1,950 Sq Ft
    • 25536 E 1st Ave
    • Aurora, CO

    Rare Ranch Retreat on a Private Cul-de-Sac in Traditions!Welcome to 25536 E 1st Ave—one of the most sought-after ranch-style homes in the community, perfectly positioned on a peaceful cul-de-sac with open-space park views right out front. This immaculately maintained 3-bedroom + large study, 2-bath gem sits on an incredible park-like lot featuring lush landscaping, vibrant gardens, and an

    Gina Moritzky eXp Realty, LLC

    Section Image
  • 1066 S Eaton Park Ct, Aurora, CO 80018

    $595,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
  • 1461 S Grand Baker St, Aurora, CO 80018

    $615,000

    • 3 Beds
    • 3 Baths
    • 2,565 Sq Ft
    • 1461 S Grand Baker St
    • Aurora, CO

    Your Dream Home Just Hit the Market! Say hello to your new happy place! This stunning 3+ bedroom, 3 bathroom home backs right up to the beautiful Murphy Creek Golf Course—and it’s packed with features you’ll love.Step inside to a welcoming entryway, a huge living and dining area perfect for hosting friends, and a bright, vaulted family room with a cozy gas fireplace. The

    Colleen Teitelbaum Coldwell Banker Realty 24

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

    $594,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

    $575,000

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

    **buyer could not obtain funding**. Seller is willing to put concessions towards solar or rate buydown! 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

    Taylor Bunney eXp Realty, LLC

    Section Image
  • 2599 S Jebel Way, Aurora, CO 80013

    $580,000

    • 3 Beds
    • 2.5 Baths
    • 1,694 Sq Ft
    • 2599 S Jebel Way
    • Aurora, CO

    This is Colorado living at its best! Beautiful home, with incredible mountain views. This home is located in the highly coveted Conservatory subdivision. This home is updated with high vaulted ceilings, cozy fireplace and beautiful hardwood floors. The rooms are large and spacious. The bathrooms are updated as is the kitchen. The house has a large updated kitchen as well as family room. The back

    John Gilpin Home Navigators 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 Type Sale Price Title Company
Special Warranty Deed $2,203,500 Land Title Guarantee
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/26/2025 06/26/25 For Sale $730,000 +4.3% $215 / Sq Ft
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
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 9454070

REcolorado®

APN: 1977-09-4-20-018