TheCondoPortal logo
HomeNeighbourhoodsMapBlogBrokerage

TheCondoPortal

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

Get in Touch

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

Send a Message →

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

Data powered by

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

470 DUNDAS Street E, Unit 1211

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

470 DUNDAS Street E, Unit 1211

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$2,700/mo

194 days on market

Bedrooms
2 Bed
Bathrooms
1 Bath
Size
709 sq ftMLS: 700-799
Parking
1 Underground
Locker
Exclusive
📐

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.
Oct 07, 2025(6mo ago)·194 DOM
$2,700
Active
700-799 sqft·ROYAL LEPAGE REAL ESTATE SERVICES LTD.
X12449272Current
Jan 01, 2024
$000,000Leased

(Sign-in required)

Jan 01, 2024
$000,000Leased

(Sign-in required)

Listing History — Same Model (Riley)

30 lease listings for this same model in the building

Sign in to see sold listing details.
Apr 15, 2026(4d ago)·Unit 1009·4 DOM
$2,500
Active
709 sqft700-799 sqft·South East·ROYAL LEPAGE STATE REALTY
X12999102
Apr 06, 2026(13d ago)·Unit 1009·12 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

Exceptional PENTHOUSE Living in a PREMIUM corner 2-bedroom, featuring 10-ft ceilings, floor-to-ceiling windows, and stunning LAKE views. Open Floor Plan Kitchen and Great Room. Kitchen offers White shaker style cabinetry, Elegant White Quartz Counter tops, new Stainless Steel Appliances and Island with double sink and seating for 4. Great Room with outdoor access to SOUTH WEST Balcony with SUN all day! Watch SPECTACULAR SUNSETS from your Balcony and Great Room. Primary Bedroom and second Bedroom with walk-in closets. LUXURIOUS 4 piece bathroom complete with soaker tub. Amazing Floor to Ceiling Windows tastefully upgraded with modern Zebra blinds provide plenty of Natural Light in every room and other upgrades! Convenient in suite laundry, laminate floors. Includes 1 Premium Parking Space Location #A565 and storage unit #114. Enjoy All of the Fabulous Amenities that this Building has to Offer Including Environmentally Friendly Geothermal Heating and AC, Party Rooms, Modern Fitness Facilities, Bike Room, 5th Floor access to Terrace with BBQs. Property Is Conveniently Located Minutes Away From Hwy 403 & Hwy 407, Aldershot GO Station. Enjoy a Hike along the Amazing trails and view the Smokey Hollow Waterfall close by. Enjoy living in this bright, sleek and stylish PENTHOUSE and experience Trend 3 living at its finest! Available Immediately.

Amenities

Bike StorageParty Room/Meeting RoomRooftop Deck/GardenVisitor ParkingGym

Property Details

MLS NumberX12449272
Property TypeCondo Apartment
StyleApartment
Listing TypeFor Lease
StatusActive
Bedrooms2 Bed
Bathrooms1
Size700-799 sq ft
Year Built2023
ExposureSouth
Parking Spaces1
Parking TypeUnderground
LockerExclusive
Days on Market194
Listed2025-10-07
CommunityWaterdown
MunicipalityHamilton
Cross StreetDUNDAS ST - 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 & Scores

📐

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 1211? 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 ROYAL LEPAGE REAL ESTATE SERVICES LTD.

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 18, 2026 at 01:05 a.m.