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# X12962242Waterdown, Hamilton · L8B 2A5
For LeaseCondo Apartment

460 DUNDAS Street E, Unit 1202

$2,750/mo
2 Bed2 Bath709 sqft$3.88/sq ft12d on market
The Boutique Collection at Trend Living CondosbyNew Horizon Development Group
MLS# X12962242Waterdown, Hamilton · L8B 2A5
For LeaseCondo Apartment

460 DUNDAS Street E, Unit 1202

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$2,750/mo

12 days on market

Bedrooms
2 Bed
Bathrooms
2 Bath
Size
709 sq ftMLS: 800-899
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.
Apr 07, 2026(12d ago)·12 DOM
$2,750
Active
800-899 sqft·ROYAL LEPAGE REAL ESTATE SERVICES LTD.
X12962242Current
Apr 06, 2026(13d ago)·12 DOM
$649,900
Active
800-899 sqft·ROYAL LEPAGE REAL ESTATE SERVICES LTD.
X12962144
Jan 01, 2024
$000,000Leased

(Sign-in required)

Listing History — Same Model (Riley)

32 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

PENTHOUSE luxury living at its finest! Spectacular floor to ceiling views from the 12th floor PENTHOUSE of this PREMIUM corner 2 Bedrooms, 2 full bath condo. Cherish its sunny WEST Exposure and incredible sunsets! Tons of Natural Light in every room! Bright, sleek & stylish suite in popular Trend 2 building, desirable Waterdown! Modern 874 Sq Ft, offers 10ft ceilings, in suite laundry. Tastefully Upgraded w/ Zebra blinds. Tile & laminate flooring. Open Kitchen & Great Room. White shaker style cabinetry, Opulent Quartz Counter tops, under cabinet lighting, SS Appliances & Island w/ double sink & seating for 4. Large Great room w/ Juliette Balcony. Primary Bedroom w/ Floor to Ceiling Windows, Upgraded 3 Piece Ensuite & Walk-In Closet. Second Bedroom also has Floor to Ceiling Windows w/ double sliding door closet. Beautiful 4 piece main bath. Geothermal heating and cooling ensure exceptional energy efficiency and low utility costs year-round 1 premium location Underground Parking & 1 Locker. Fabulous Amenities Includes Party Rooms, Fitness Facilities, Rooftop Patio & BBQs, Bike Storage. Minutes from Hwy 403 & 407, Aldershot GO Station. Available June 1, 2026

Amenities

Bike StorageExercise RoomParty Room/Meeting RoomRooftop Deck/GardenVisitor Parking

Property Details

MLS NumberX12962242
Property TypeCondo Apartment
StyleApartment
Listing TypeFor Lease
StatusActive
Bedrooms2 Bed
Bathrooms2
Size800-899 sq ft
Year Built2023
ExposureWest
Parking Spaces1
Parking TypeUnderground
LockerExclusive
Days on Market12
Listed2026-04-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 460 DUNDAS Street E, Unit 1202? 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:03 a.m.