Condos Homes logo
HomeNeighbourhoodsMapBlogBrokerage

Condos Homes

Red Bricks is your destination for pre-construction condos, townhouses, and homes. Access platinum listings, launching soon projects, and more.

Discover

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

Company

  • About Us
  • Our Team
  • Contact
  • Assignments 2
  • Sample 2
  • Sample 3
  • An Explanation of Condo Maintenance Fees

Get in Touch

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

Send a Message →
RE/MAX Premier Inc., Brokerage logo

Suzan McKenzie

RE/MAX Premier Inc., Brokerage

1885 Wilson Avenue Ste 200A, Toronto, Ontario, M9M1A2

Phone: 416-743-2000

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 Condos Homes. All rights reserved.

Data powered by

Privacy PolicyTerms of Service
MLS# X12905810Waterdown, Hamilton · L8B 2A6
For LeaseCondo Apartment

470 Dundas Street, Unit 710

$2,700/mo
2 Bed1 Bath709 sqft$3.81/sq ft33d on market
The Boutique Collection at Trend Living CondosbyNew Horizon Development Group
MLS# X12905810Waterdown, Hamilton · L8B 2A6
For LeaseCondo Apartment

470 Dundas Street, Unit 710

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$2,700/mo

33 days on market

Bedrooms
2 Bed
Bathrooms
1 Bath
Size
709 sq ftMLS: 600-699
Parking
1 Underground
Locker
Exclusive
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

Mar 21, 2026(1mo ago)·33 DOM
$2,700
Active
600-699 sqft·RE/MAX ESCARPMENT REALTY INC.
X12905810Current

Listing History — Same Model (Riley)

31 lease listings for this same model in the building

Sign in to see sold listing details.
Apr 15, 2026(8d ago)·Unit 1009·8 DOM
$2,500
Active
709 sqft700-799 sqft·South East·ROYAL LEPAGE STATE REALTY
X12999102
Apr 06, 2026(17d ago)·Unit 1009·16 DOM
$529,000
Active
709 sqft700-799 sqft·South East·ROYAL LEPAGE STATE REALTY
X12960854
Jan 01, 2024
$000,000Leased

(Sign-in required)

Jan 01, 2024
$000,000Terminated

(Sign-in required)

Jan 01, 2024
$000,000Terminated

(Sign-in required)

About This Listing

Stylish upgraded 2-bedroom, 1-bathroom condo for lease in the heart of Waterdown. This bright, carpet-free unit features an open-concept layout, a modern kitchen with quartz countertops, backsplash, and upgraded appliances, plus in-suite laundry and contemporary finishes throughout. Enjoy exceptional outdoor living with an oversized private terrace (28'11" x 20'5") plus a second balcony! Residents have access to premium amenities including rooftop terraces with BBQs, fitness centres, party rooms, and visitor parking. Ideally located close to highways, Aldershot GO Station, shopping, dining, parks, and top-rated schools. This is modern condo living at its best.

Amenities

ElevatorGymParty Room/Meeting RoomRooftop Deck/GardenVisitor ParkingCommunity BBQ

Property Details

MLS NumberX12905810
Property TypeCondo Apartment
StyleApartment
Listing TypeFor Lease
StatusActive
Bedrooms2 Bed
Bathrooms1
Size600-699 sq ft
ExposureEast
Parking Spaces1
Parking TypeUnderground
LockerExclusive
Days on Market33
Listed2026-03-21
CommunityWaterdown
MunicipalityHamilton
Cross StreetDundas St E and Mallard 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: 9 · $736/sqftFor Rent: 8 · $3.31/sqft
Bike Storage RoomGym FacilitiesOutdoor TerraceParty Room with Kitchen
View full building profile

Location & nearby

│
0
Walk
0
Transit

470 Dundas Street

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.5 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

3 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, Unit 710? Schedule a showing or ask a question.

1
Date
2
Time
3
Details
4
Confirm

Select a date

Choose from available dates below

April 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: April 22, 2026 at 03: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

5.0 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

eLearning Campus

5.0 km
PublicGrades 9-12
EQAO data not available