Skip main navigation
New construction
  • Price cut: $5.1K (5/30)
    $739,900

    188 S Waterloo Street, Aurora, CO 80018

    4beds
    3,721sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2023
    7,128 Square Feet Lot
    $652,400 Zestimate®
    $199/sqft
    $94/mo HOA

    What's special

    STILL AVAILABLE!!! Spectacular Hemingway by Richmond American, get ready to be impressed, Spacious home with an Open layout great for entertaining, Backs to open space with Amazing views. Great room is welcoming and screams relaxation. The gourmet kitchen will impresses any level of chef with its Over sized Large Quartz center island, walk-in pantry and stainless steel appliances, Gourmet kitchen, Hooded oven and Double ovens. A Flex room/Office, powder bath and mudroom complete the main floor. Retreat upstairs to find a Spacious Loft and 4 bedrooms that provide ideal accommodations for family or guests. Primary suite which showcases a private five piece bath and spacious walk-in closet. If that wasn't enough, this home includes a unfinished basement left with over 1000 sq feet with Endless possibilities. Don't Miss out on this Opportunity to call Harmony home in this Award Winning Community that has a State of the Art Clubhouse with gyms, conference rooms, pools, volleyball court, tennis court and basketball court, Pickleball in progress and a community garden within walking distance from the house.
    86 days
    |
    140
    |
    7
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Blessed Barrack 720-628-3623 blessedblessed31@gmail.com,

    Equity Colorado Real Estate

    Source: REcolorado as distributed by MLS GRID,MLS#: 2409006MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      • Main level bathrooms: 1
      Bedroom
      • Description: Perfect Size
      • Features: Primary Suite
      • Level: Upper
      Bedroom
      • Description: Perfectly Sized Children's Bedroom
      • Level: Upper
      Bedroom
      • Description: Perfect Size 3rd
      • Level: Upper
      Bedroom
      • Description: 4th Bedroom
      • Level: Upper
      Bathroom
      • Description: Quartz Countertops, Amazing Views Of Open Space
      • Features: Primary Suite
      • Level: Upper
      Bathroom
      • Description: Kids/Guest Bathroom With Quartz Countertops
      • Level: Upper
      Bathroom
      • Description: Perfectly Sized Guest Bath
      • Level: Main
      Dining room
      • Description: Spacious Can Fit A Large Table Amazing Views
      • Level: Main
      Great room
      • Description: Has Alot To Offer Open Concept Floor Plan
      • Level: Main
      Kitchen
      • Description: Huge Island With Quartz Countertops All White, Beautiful Backslash
      • Level: Main
      Laundry
      • Description: Perfect Size With Some Storage
      • Level: Upper
      Loft
      • Description: Spacious Loft Great For Entertaining
      • Level: Upper
      Office
      • Description: Tucked In Off The Main Entrance
      • Level: Main
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Microwave, Oven, Range, Refrigerator, Tankless Water Heater, Washer
      • Laundry: In Unit
      Features
      • Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Quartz Counters, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)
      • Flooring: Carpet, Wood
      • Windows: Bay Window(s)
      • Basement: Full,Unfinished
      Interior area
      • Total structure area: 3,721
      • Total interior livable area: 3,721 sqft
      • Finished area above ground: 2,713
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 3
      • Parking features: Concrete
      • Carport spaces: 3
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Deck, Front Porch, Patio
      • Exterior features: Garden, Private Yard
      • Pool features: Outdoor Pool
      • Has view: Yes
      • View description: City
      Lot
      • Size: 7,128 Square Feet
      • Features: Greenbelt, Sprinklers In Front
      Details
      • Parcel number: 035445771
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Brick, Frame, Stone
      • Foundation: Concrete Perimeter
      • Roof: Composition
      Condition
      • New Construction,Updated/Remodeled
      • New construction: Yes
      • Year built: 2023
      Details
      • Builder model: Hemingway
      • Builder name: Richmond American Homes
      • Warranty included: Yes

      Utilities & green energy

      • Water: Public
      • Utilities for property: Cable Available

      Community & HOA

      Community
      • Security: Carbon Monoxide Detector(s), Security System, Smoke Detector(s)
      • Subdivision: Harmony
      HOA
      • Has HOA: Yes
      • Amenities included: Clubhouse, Fitness Center, Park, Pool, Spa/Hot Tub, Tennis Court(s), Trail(s)
      • Services included: Reserve Fund, Exterior Maintenance w/out Roof, Sewer, Snow Removal
      • HOA fee: $86 monthly
      • HOA name: Harmony Association
      • HOA phone: 303-390-1222
      • Second HOA fee: $25 quarterly
      • Second HOA name: Powhaton Road Metro District
      • Second HOA phone: 303-858-1800
      Location
      • Region: Aurora

      Financial & listing details

      • Price per square foot: $199/sqft
      • Tax assessed value: $722,900
      • Annual tax amount: $7,790
      • Date on market: 4/23/2026
      • Listing terms: Cash,Conventional,FHA,Other,Owner Will Carry,Private Financing Available,Assumable,USDA Loan,VA Loan
      • Exclusions: Personal Property,
      • Ownership: Individual
      • Electric utility on property: Yes

        Estimated market value

        $652,400

        $620,000 - $685,000

        $3,601/mo

        Price history

        DateEventPrice
        5/30/2026Price change$739,900-0.7%$199/sqft
        Source: REcolorado as distributed by MLS GRID #2409006 Report a problem
        4/23/2026Listed for sale$745,000+10.4%$200/sqft
        Source: REcolorado as distributed by MLS GRID #2409006 Report a problem
        6/13/2025Listing removed$4,300$1/sqft
        Source: REcolorado as distributed by MLS GRID #7378115 Report a problem
        5/21/2025Price change$4,300-4.4%$1/sqft
        Source: REcolorado as distributed by MLS GRID #7378115 Report a problem
        5/7/2025Listed for rent$4,500$1/sqft
        Source: REcolorado as distributed by MLS GRID #7378115 Report a problem
        1/8/2024Sold$675,000$181/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$7,790 +87.8%$45,181 +0.1%
        2024$4,147 +6%$45,125 +82.3%
        2023$3,911 +8811.4%$24,748 +7.2%
        2022$44 $23,087
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Starfall Horizon

        Getting around

        0 / 100
        Car-Dependent
        0 / 100
        No Nearby Transit
        24 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Harmony Ridge P-8
        • Middle: Harmony Ridge P-8
        • High: Vista Peak
        • District: Adams-Arapahoe 28J

        Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes