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.
New construction
Price cut: $5.1K (5/30)
$739,900
188 S Waterloo Street, Aurora, CO 80018
4beds
3,721sqft
Single Family Residence
Built in 2023
7,128 Square Feet Lot
$652,400 Zestimate®
$199/sqft
$94/mo HOA
What's special
- 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#: 2409006
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
Video & virtual tour
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
Zestimate®
$652,400
Estimated sales range
$620,000 - $685,000
Rent Zestimate®
$3,601/mo
Price history
| Date | Event | Price |
|---|---|---|
| 5/30/2026 | Price change | $739,900-0.7%$199/sqft |
Source: | ||
| 4/23/2026 | Listed for sale | $745,000+10.4%$200/sqft |
Source: | ||
| 6/13/2025 | Listing removed | $4,300$1/sqft |
Source: REcolorado as distributed by MLS GRID #7378115 Report a problem | ||
| 5/21/2025 | Price change | $4,300-4.4%$1/sqft |
Source: REcolorado as distributed by MLS GRID #7378115 Report a problem | ||
| 5/7/2025 | Listed for rent | $4,500$1/sqft |
Source: REcolorado as distributed by MLS GRID #7378115 Report a problem | ||
| 1/8/2024 | Sold | $675,000$181/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll 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
Nearby schools
GreatSchools rating
- 6/10Harmony Ridge P-8Grades: PK-8Distance: 0.6 mi
- 5/10Vista Peak 9-12 PreparatoryGrades: 9-12Distance: 2.1 mi
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.
- $694,9505 bd4 ba3.5k sqft201 S Waterloo St, Aurora, CO 80018Sold
Save 
- $789,9506 bd5 ba4.7k sqft191 S Waterloo St, Aurora, CO 80018Sold
Save 
- $--3 bd1 ba1.2k sqft211 S Waterloo St #2, Aurora, CO 80018Off Market
Save 
- $800,0006 bd5 ba4.7k sqft211 S Waterloo St, Aurora, CO 80018Sold
Save 
- $690,0005 bd4 ba2.5k sqft181 S Waterloo St, Aurora, CO 80018Sold
Save - $790,0004 bd4 ba2.7k sqft221 S Waterloo St, Aurora, CO 80018Sold
Save - $709,9505 bd3 ba4.5k sqft198 S Waterloo St, Aurora, CO 80018Sold
Save - $730,0005 bd3 ba3.8k sqft171 S Waterloo St, Aurora, CO 80018Sold
Save
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $579,9004 bd3 ba1.9k sqft47 S Titus Street, Aurora, CO 80018For Sale
Save 
MLS ID #9276854, Blessed Barrack, Equity Colorado Real Estate. REcolorado as distributed by MLS GRID - $615,0004 bd3 ba3.7k sqft97 N Jackson Gap Way, Aurora, CO 80018For Sale
Save 
MLS ID #7223690, Anne Barrington, The Barrington Group Real Estate, Inc.. REcolorado as distributed by MLS GRID - $550,0004 bd3 ba2.2k sqft134 S Uriah Street, Aurora, CO 80018For Sale
Save 
MLS ID #6691133, Lorri DeLaney, Coldwell Banker Realty 56. REcolorado as distributed by MLS GRID - $609,9004 bd4 ba3.3k sqft196 N Millbrook Street, Aurora, CO 80018For Sale
Save 
MLS ID #2347201, The Knoll Team, West and Main Homes Inc. REcolorado as distributed by MLS GRID - $539,0003 bd2 ba1.8k sqft86 S Vandriver Way, Aurora, CO 80018For Sale
Save
MLS ID #5821294, John Vizzi, Colorado Flat Fee Realty Inc. REcolorado as distributed by MLS GRID - $732,5004 bd4 ba4.1k sqft3845 Eaton Park Street, Aurora, CO 80019For Sale
Save
MLS ID #7484103, John Tanguma, Your Castle Real Estate Inc. REcolorado as distributed by MLS GRID - $625,0004 bd4 ba3.9k sqft24306 E Ohio Drive, Aurora, CO 80018For Sale
Save
MLS ID #2076854, Alyssa Healey, Keller Williams Preferred Realty. REcolorado as distributed by MLS GRID - $674,9005 bd5 ba3.5k sqft21986 E Oberlin Place, Aurora, CO 80018For Sale
Save
MLS ID #5222284, Jennifer Barnes, LPT Realty. REcolorado as distributed by MLS GRID - $730,0004 bd4 ba3.7k sqft8078 S Yantley Court, Aurora, CO 80016For Sale
Save
MLS ID #1691842, Taylor Bunney, eXp Realty, LLC. REcolorado as distributed by MLS GRID - $710,0005 bd3 ba3.8k sqft5795 S Grand Baker Court, Aurora, CO 80016For Sale
Save
MLS ID #5323825, Lisa Blake, Real Broker, LLC DBA Real. REcolorado as distributed by MLS GRID - $760,0005 bd4 ba3.2k sqft26712 E Hinsdale Place, Aurora, CO 80016For Sale
Save
MLS ID #1524403, Ryan Mutschelknaus, Madison & Company Properties. REcolorado as distributed by MLS GRID - $725,0005 bd4 ba4.5k sqft4778 S Biloxi Way, Aurora, CO 80016For Sale
Save
MLS ID #8522784, Tamara Heuckroth, Your Castle Real Estate Inc. REcolorado as distributed by MLS GRID - $795,0004 bd4 ba4.1k sqft5646 S Grand Baker Court, Aurora, CO 80016For Sale
Save
MLS ID #4676836, Steven Izzi, Redfin Corporation. REcolorado as distributed by MLS GRID - $660,0004 bd3 ba3.4k sqft3906 N Catawba Way, Aurora, CO 80019For Sale
Save
MLS ID #3504135, Aureliano Yepez, Keller Williams Realty Downtown LLC. REcolorado as distributed by MLS GRID - $725,0003 bd2 ba3.1k sqft23676 E Del Norte Place, Aurora, CO 80016For Sale
Save
MLS ID #3124251, Colleen Teitelbaum, Coldwell Banker Realty 24. REcolorado as distributed by MLS GRID - $674,0004 bd4 ba3.6k sqft25748 E Calhoun Place, Aurora, CO 80016For Sale
Save
MLS ID #7158545, Story Home Group, LPT Realty. REcolorado as distributed by MLS GRID - $659,9004 bd4 ba3k sqft7151 S Oak Hill Circle, Aurora, CO 80016For Sale
Save
MLS ID #8261148, Chelsea Caldwell, Weichert Realtors Professionals. REcolorado as distributed by MLS GRID - $663,9003 bd2 ba4.2k sqft3966 N Catawba Way, Aurora, CO 80019For Sale
Save
MLS ID #4954900, John R Martin, Brokers Guild Real Estate. REcolorado as distributed by MLS GRID - $690,0005 bd4 ba3.1k sqft7566 S Quantock Court, Aurora, CO 80016For Sale
Save
MLS ID #2566619, Jordan Wagner, Real Broker, LLC DBA Real. REcolorado as distributed by MLS GRID - $665,0003 bd2 ba3.6k sqft3836 N Catawba Way, Aurora, CO 80019For Sale
Save
MLS ID #8753794, Talitha Powers, eXp Realty, LLC. REcolorado as distributed by MLS GRID
- Request a tour
as early as tomorrow at 11:00 am
Contact agent
- Colorado
- Arapahoe County
- Aurora
- 80018
- Starfall Horizon
- 188 S Waterloo Street