SearchCondos logo
HomeNeighbourhoodsMapBlog

SearchCondos

Compare active MLS resale listings and exclusive pre-construction projects in one place. Search Canada's complete condo and home database instantly.

Discover

  • Home
  • Neighbourhoods
  • Map
  • Blog
  • Developers
  • Cities

Company

  • About Us
  • Our Team
  • Contact

Get in Touch

Have questions about a project? We're here to help.

Send a Message →

ILAN JOSEPH

SearchCondos.com · Ilan Joseph | Sutton Group Admiral Realty Inc., Brokerage

1881 Steeles Avenue West, Toronto, ON

Phone: 416-419-7001

Listing data is provided under license from the Toronto Regional Real Estate Board (TRREB). TRREB assumes no responsibility for the accuracy of the information contained herein. Data is updated periodically and may not reflect the most current market activity. Not intended to solicit buyers or sellers currently under contract. MLS®, REALTOR®, and the associated logos are certification marks owned by the Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.

© 2026 SearchCondos. All rights reserved.

Data powered by

Privacy PolicyTerms of Service
MLS# X13053792Waterdown, Hamilton · L8B 1Z2
For SaleCondo Apartment

470 Dundas Street E, Unit 804

$379,990
1 Bed1 Bath584 sqft$651/sq ft3d on market
The Boutique Collection at Trend Living CondosbyNew Horizon Development Group
MLS# X13053792Waterdown, Hamilton · L8B 1Z2
For SaleCondo Apartment

470 Dundas Street E, Unit 804

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$379,990

$651/sq ft· Bldg avg $720/sq ft · 3 days on market

Bedrooms
1 Bed
Bathrooms
1 Bath
Size
584 sq ftMLS: 500-599
Parking
1 Underground
Locker
Owned
OverviewHistoryDetailsBuildingNeighbourhood
📐

Floor Plan

Match Found

Unit 1702 — 524 sq ft

We matched this unit to a floor plan

Sign in to see the exact layout, verified size, and developer pricing history

Listing History — This Unit

Sign in to see the full listing history.
Apr 28, 2026(4d ago)·3 DOM
$379,990
Active
500-599 sqft·RE/MAX ESCARPMENT REALTY INC.
X13053792Current
Jan 01, 2024
$000,000Leased

(Sign-in required)

Listing History — Same Model (Flair)

18 sale listings for this same model in the building

Sign in to see sold listing details.
Apr 28, 2026(4d ago)·Unit 904·3 DOM
$379,990
Active
584 sqft500-599 sqft·North·RE/MAX ESCARPMENT REALTY INC.
X13053824
Apr 24, 2026(8d ago)·Unit 119·7 DOM
$359,900
Active
584 sqft500-599 sqft·North·KRONAS REAL ESTATE
X13043284
Jan 01, 2024
$000,000Terminated

(Sign-in required)

Jan 01, 2024
$000,000Leased

(Sign-in required)

Mar 16, 2026(1mo ago)·Unit 220·47 DOM
$2,099
Active
578 sqft600-699 sqft·North·NEWGEN REALTY EXPERTS
X12888852

About This Listing

Beautiful 1 bed, 1 bath condo offering a bright, open-concept layout with modern finishes throughout. The stylish kitchen features stainless steel appliances, a breakfast bar, and contemporary cabinetry, flowing effortlessly into the spacious living area with large windows and plenty of natural light. The well-sized bedroom offers comfort and great views, complemented by a sleek 4-piece bathroom and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Residents have access to excellent amenities including a party room, gym, rooftop patios, and bike storage. Located in the highly desirable Waterdown community, close to dining, shopping, schools, parks, and just a 5-minute drive to downtown Burlington or Aldershot GO Station.

Property Details

MLS NumberX13053792
Property TypeCondo Apartment
Style1 Storey/Apt
Listing TypeFor Sale
StatusActive
Bedrooms1 Bed
Bathrooms1
Size500-599 sq ft
ExposureNorth
Parking Spaces1
Parking TypeUnderground
LockerOwned
Maintenance Fee$553.7/mo
Property Tax$1,184.89/yr
Days on Market3
Listed2026-04-28
CommunityWaterdown
MunicipalityHamilton
Cross StreetMallard Trail
The Boutique Collection at Trend Living Condos

The Boutique Collection at Trend Living Condos

Red Bricks Data

by New Horizon Development Group · Dundas Street East & Mallard Trail

6 Storeys55 SuitesPre-ConstructionWalk 20Transit 24

Maint. Fees

0.55

Occupancy

2023

Live MLSFor Sale: 12 · $720/sqftFor Rent: 7 · $3.22/sqft
Bike Storage RoomGym FacilitiesOutdoor TerraceParty Room with Kitchen
View full building profile

Location & nearby

│
0
Walk
0
Transit

470 Dundas Street E

Nearby schools

Closest publicly funded schools within 5 km, ranked by EQAO standardized test scores

Elementary

3 schools

Paul A Fisher Public School

3.4 km
PublicGrades JK-6
EQAO scoreStrong
79 / 100

Top 50% of Ontario elementary schools

Per-grade breakdown & demographics▾
Per-grade EQAO breakdown
Grade 3R86%▼ 8.0W86%▼ 5.0M60%▼ 34.0
Grade 6R100%W93%▲ 4.0M51%▼ 19.0

R = Reading · W = Writing · M = Math · arrows show 3-year change

320 students10% Special Ed0% Gifted

St. Mark Catholic Elementary School

3.4 km
CatholicGrades JK-8
EQAO scoreStrong
76 / 100

Top 50% of Ontario elementary schools

Per-grade breakdown & demographics▾
Per-grade EQAO breakdown
Grade 3R73%▼ 10.0W71%▼ 16.0M79%▼ 4.0
Grade 692%

Brant Hills Public School

3.6 km
PublicGrades JK-8
EQAO scoreExcellent
82 / 100

Top 50% of Ontario elementary schools

Per-grade breakdown & demographics▾
Per-grade EQAO breakdown
Grade 3R95%▲ 13.0W73%▲ 2.0M91%▲ 32.0
Grade 690%

Secondary

2 schools

M M Robinson High School

4.9 km
PublicGrades 9-12
EQAO scoreStrong
72 / 100
Per-grade breakdown & demographics▾
Per-grade EQAO breakdown
Grade 9 Math58%▲ 5.0
OSSLT literacy pass rate86%

Arrows show 3-year change

1,155 students33% Special Ed5% Gifted

EQAO score is the average of available reading, writing & math results, 0–100 · Source: Ontario Ministry of Education

PublicCatholicFrench
📐

Floor Plan

Match Found

Unit 1702 — 524 sq ft

We matched this unit to a floor plan

Sign in to see the exact layout, verified size, and developer pricing history

Builder Documents

Sign in to download

Request a Showing

Interested in 470 Dundas Street E, Unit 804? Schedule a showing or ask a question.

1
Date
2
Time
3
Details
4
Confirm

Select a date

Choose from available dates below

May 2026

Sun
Mon
Tue
Wed
Thu
Fri
Sat
Available
Unavailable

Listing provided by RE/MAX ESCARPMENT REALTY INC.

Based on information from the Toronto Regional Real Estate Board (TRREB). All information deemed reliable but not guaranteed and should be independently verified. The accuracy of information is not guaranteed, has not been verified, and does not constitute professional advice.

IDX information is provided exclusively for consumers' personal, non-commercial use. It may not be used for any purpose other than identifying prospective properties consumers may be interested in purchasing or renting.

Sold and leased listing data is provided under the Virtual Office Website (VOW) data feed and is available only to registered users who have agreed to the Terms of Use. This data is for personal, non-commercial use only and may not be copied, redistributed, or retransmitted.

MLS®, REALTOR®, and the associated logos are certification marks owned by the Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.

This listing content is not intended to solicit properties already listed for sale or individuals who are currently under contract with a brokerage.

Data last updated: May 2, 2026 at 09:43 a.m.

R
▲ 1.0
W86%▼ 5.0
M57%▲ 12.0

R = Reading · W = Writing · M = Math · arrows show 3-year change

450 students15% Special Ed0% Gifted
R
▲ 22.0
W93%▲ 13.0
M50%▲ 18.0

R = Reading · W = Writing · M = Math · arrows show 3-year change

325 students30% Special Ed0% Gifted

Aldershot High School

4.9 km
PublicGrades 9-12
EQAO scoreExcellent
84 / 100

Top 50% of Ontario secondary schools

Per-grade breakdown & demographics▾
Per-grade EQAO breakdown
Grade 9 Math73%▲ 3.0
OSSLT literacy pass rate95%▲ 1.0

Arrows show 3-year change

720 students21% Special Ed6% Gifted