Connect Asset Management logo
HomeNeighbourhoodsMapBlogBrokerage

Connect Asset Management

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 →
Royal LePage Signature Connect.ca Realty logo

Ryan Coyle

Broker of Record

Royal LePage Signature Connect.ca Realty

495 Wellington Street West Suite 100

Phone: 416-800-9272

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 Connect Asset Management. All rights reserved.

Data powered by

Privacy PolicyTerms of Service
MLS# X12951060Waterdown, Hamilton · L8B 2A6
For SaleCondo Apartment

470 Dundas Street, Unit 502

$529,900
2 Bed2 Bath709 sqft$747/sq ft18d on market
The Boutique Collection at Trend Living CondosbyNew Horizon Development Group
MLS# X12951060Waterdown, Hamilton · L8B 2A6
For SaleCondo Apartment

470 Dundas Street, Unit 502

The Boutique Collection at Trend Living CondosbyNew Horizon Development Group

$529,900

$747/sq ft· Bldg avg $736/sq ft · 18 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

Apr 02, 2026(18d ago)·18 DOM
$529,900
Active
800-899 sqft·Royal LePage Real Estate Services Ltd., Brokerage
X12951060Current

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(5d ago)·Unit 1009·6 DOM
$2,500
Active
709 sqft700-799 sqft·South East·ROYAL LEPAGE STATE REALTY
X12999102
Apr 06, 2026(14d ago)·Unit 1009·14 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

Welcome to this stunning corner two-bedroom condo featuring rare side-by-side parking spots and breathtaking, unobstructed sunset views. This bright, modern suite showcases 10-foot ceilings and expansive floor-to-ceiling windows, filling the space with natural light.Enjoy sleek vinyl flooring throughout, custom-fitted roller blinds, and a spacious oversized balcony-perfect for relaxing or entertaining.Convenience is key with two side-by-side parking spaces located close to the elevator, along with a same-floor storage locker for added ease.Residents benefit from a wide range of well-appointed amenities, including multiple fitness centres, stylish party rooms, and rooftop terraces complete with BBQs. The building also offers on-site property management and a superintendent for peace of mind.Ideally located with quick access to highways and the GO Train, this home is perfect for commuters, while nearby parks and trails make it equally appealing for nature lovers.

Amenities

Community BBQElevatorGame RoomParty Room/Meeting RoomRooftop Deck/GardenGym

Property Details

MLS NumberX12951060
Property TypeCondo Apartment
Style1 Storey/Apt
Listing TypeFor Sale
StatusActive
Bedrooms2 Bed
Bathrooms2
Size800-899 sq ft
Year Built2023
ExposureNorth West
Parking Spaces2
Parking TypeUnderground
LockerOwned
Maintenance Fee$634.77/mo
Property Tax$2,020/yr
Days on Market18
Listed2026-04-02
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 & nearby

│

470 Dundas Street

Nearby schools

Closest publicly funded schools within 5 km · tap a row for EQAO breakdown

Elementary

3 schools
  • Paul A Fisher Public School
    Public·Grades JK-6
    Top 50% in Ontario
    3.4 km79StrongDetails ▾
    EQAO breakdown
    Grade 3R86%▼ 8.0W86%▼ 5.0M60%▼ 34.0
    Grade 6R100%W93%▲ 4.0M51%▼ 19.0
    320 studentsSpEd 10%Gifted 0%
  • St. Mark Catholic Elementary School
    Catholic·Grades JK-8
    Top 50% in Ontario
    3.4 km76StrongDetails ▾
    EQAO breakdown
    Grade 3R73%▼ 10.0W71%▼ 16.0M79%▼ 4.0
    Grade 6R92%▲ 1.0W86%▼ 5.0
  • Brant Hills Public School
    Public·Grades JK-8
    Top 50% in Ontario
    3.5 km82ExcellentDetails ▾
    EQAO breakdown
    Grade 3R95%▲ 13.0W73%▲ 2.0M91%▲ 32.0
    Grade 6R90%▲ 22.0W93%▲ 13.0

Secondary

3 schools
  • M M Robinson High School
    Public·Grades 9-12
    4.9 km72StrongDetails ▾
    EQAO breakdown
    Grade 9 Math58%▲ 5.0
    OSSLT pass rate86%
    1,155 studentsSpEd 33%Gifted 5%
  • Aldershot High School
    Public·Grades 9-12
    Top 50% in Ontario

Source: Ontario Ministry of Education · EQAO scores 0–100 · straight-line distances

Public Catholic French
📐

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 502? 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., Brokerage

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 19, 2026 at 03:42 p.m.

M57%▲ 12.0
450 studentsSpEd 15%Gifted 0%
M50%▲ 18.0
325 studentsSpEd 30%Gifted 0%
5.0 km84ExcellentDetails ▾
EQAO breakdown
Grade 9 Math73%▲ 3.0
OSSLT pass rate95%▲ 1.0
720 studentsSpEd 21%Gifted 6%
  • eLearning Campus
    Public·Grades 9-12
    5.0 km