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# X13053824Waterdown, Hamilton · L8B 1Z2
For SaleCondo Apartment

470 Dundas Street E, Unit 904

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

470 Dundas Street E, Unit 904

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.
X13053824Current
Jan 01, 2024
$000,000Leased

(Sign-in required)

Jan 01, 2024
$000,000Leased

(Sign-in required)

Listing History — Same Model (Flair)

16 sale listings for this same model in the building

Sign in to see sold listing details.
Apr 28, 2026(4d ago)·Unit 804·3 DOM
$379,990
Active
584 sqft500-599 sqft·North·RE/MAX ESCARPMENT REALTY INC.
X13053792
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

Stunning 1 bed, 1 bath condo showcasing a bright, open-concept design with modern finishes throughout. Featuring an upgraded kitchen with stainless steel appliances, a spacious island with built-in storage, and elegant pendant lighting, this unit flows effortlessly into the sun-filled living area with expansive windows and beautiful views. The generous bedroom is complemented by a contemporary 4-piece bath and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Enjoy premium building amenities including a party room, gym, rooftop patios, and bike storage. Ideally located in the sought-after Waterdown community, just minutes to dining, shopping, parks, and a quick 5-minute drive to downtown Burlington or Aldershot GO Station.

Property Details

MLS NumberX13053824
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 904? 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