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

460 Dundas Street E, Unit 1202

$649,900
2 Bed2 Bath709 sqft$917/sq ft12d on market
The Boutique Collection at Trend Living CondosbyNew Horizon Development Group
MLS# X12962144Waterdown, Hamilton · L8B 2A5
For SaleCondo Apartment

460 Dundas Street E, Unit 1202

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$649,900

$917/sq ft· Bldg avg $736/sq ft · 12 days on market

Bedrooms
2 Bed
Bathrooms
2 Bath
Size
709 sq ftMLS: 800-899
Parking
2 Underground
Locker
Owned
📐

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.
X12962242
Apr 06, 2026(13d ago)·12 DOM
$649,900
Active
800-899 sqft·ROYAL LEPAGE REAL ESTATE SERVICES LTD.
X12962144Current
Jan 01, 2024
$000,000Leased

(Sign-in required)

Listing History — Same Model (Riley)

32 sale 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 bedroom, 2 full bath condo. Cherish it's sunny West Exposure and incredible sunsets! Filled with natural light, every room is bright and inviting, showcasing a modern, thoughtfully designed layout that perfectly balances style and function.This sophisticated suite offers 874 sq ft of contemporary living with 10 ft ceilings, enhancing the sense of space and openness. The open floor plan kitchen and great room are ideal for entertaining, featuring white shaker-style cabinetry, elegant quartz countertops, under-cabinet lighting, stainless steel appliances, and an island with seating for four and a double sink.The spacious great room extends to a Juliette balcony, creating a seamless indoor-outdoor feel. The primary bedroom is a serene retreat with floor-to-ceiling windows, a walk-in closet, and a beautifully upgraded 3-piece ensuite. The second bedroom also features floor-to-ceiling windows and a double sliding door closet, offering versatility for guests, a home office, or additional living space. A stylish 4-piece main bath and convenient in-suite laundry complete the interior.Finished with Zebra blinds, tile and vinyl flooring throughout, this home blends modern elegance with easy maintenance. Many other Upgrades too. Geothermal heating and cooling ensure exceptional energy efficiency and low utility costs year-round.Residents of the sought-after Trend 2 building enjoy fabulous amenities including a party room, fitness centre, rooftop patio with BBQs, and bike storage. Ideally located minutes to Hwy 403, Hwy 407, and Aldershot GO Station. Complete with 2 premium location, underground parking spaces and 1 locker, this is elevated condo living at it's best.

Amenities

Community BBQElevatorGame RoomParty Room/Meeting RoomRooftop Deck/GardenGym

Property Details

MLS NumberX12962144
Property TypeCondo Apartment
Style1 Storey/Apt
Listing TypeFor Sale
StatusActive
Bedrooms2 Bed
Bathrooms2
Size800-899 sq ft
Year Built2023
ExposureWest
Parking Spaces2
Parking TypeUnderground
LockerOwned
Maintenance Fee$602.91/mo
Property Tax$4,052.55/yr
Days on Market12
Listed2026-04-06
CommunityWaterdown
MunicipalityHamilton
Cross StreetDundas/Riverwalk
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 17, 2026 at 03:41 p.m.