1 day on Market

342 Mountain Brow Rd, Hamilton, Ontario L7P 5A3

Detached
4 + 2
5
~3000-3500 sqft
$2,495,000
Get pre-qualifiedPowered by nesto
Detached
4 + 2
5
~3000-3500 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market1 day

Estimated valueNot available

Price/Sqft$772/sqft

Monthly cost

Open Calculator

Description

Set on nearly 1.7 acres with incredible panoramic views, this stately all-brick home offers a rare opportunity to enjoy resort-style living surrounded by privacy, mature trees, and breathtaking natural scenery-all just minutes from Waterdown, Burlington, Aldershot GO Station, Highway 403, and scenic trails including the Bruce Trail and Smokey Hollow Falls. Hidden from the road on professionally landscaped grounds, the property makes an unforgettable first impression with a newly completed paver stone circular driveway, elegant fountain feature, oversized triple garage, and over 240 feet of frontage. The spectacular backyard feels like a private resort featuring a massive heated concrete pool, sauna, stunning two-tiered patio with glass railings, extensive entertaining areas, expansive green space perfect for lawn games, and complete privacy in every direction. Beautiful irrigated landscaping surrounds the home, while a large storage area beneath the upper terrace adds exceptional functionality. Offering over 4,400 sq. ft. of finished living space including 3,108 sq. ft. above grade, the home features a sprawling main level with expansive formal living spaces ideal for entertaining and family living. Elegant limestone tile welcomes you through the grand foyer, while rich hardwood flooring extends throughout most of the main and upper levels. The formal living room features a gas fireplace, while the family room is centered around a wood-burning fireplace. Scenic views can be enjoyed from every room, and the home offers an incredible opportunity to renovate, redesign, or create a spectacular legacy estate tailored to your vision. The upper-level features 4 spacious bedrooms and there are 5 total bathrooms in the home, including a stunning primary retreat with renovated ensuite and private balcony overlooking the grounds. The raised-height basement features a walk-up entrance and direct garage access, creating excellent in-law or multi-generational living potential.


Property Details

Style2-Storey
ViewCity, Garden, Lake, Panoramic, Pool, Trees/Woods
Age of property-
SqFt~3000-3500 SqFt
Lot Size93,102 SqFt(387.2 x 240.45)
Parking Spaces18
MLS ®NumberX13166680
Community NameFlamborough
Data SourceTRREB
Listing byROYAL LEPAGE STATE REALTY

Features

Heating: Forced Air
Cooling: Central Air
Fireplace
Basement: Full, Finished

Main Floor

Foyer

5.03 x 4.19

Living

3.84 x 6.07

Dining

3.94 x 3.28

Family

4.93 x 4.98


Features

Lot size: 93,102 SqFt
Pool: Inground

Parking

Garage spaces 3

Garage type Attached

Other parking spaces 15

Total parking spaces 18


Property History

May 23, 2026
ListedActive
$2,495,000
1 day on market
history photo preview50
Listing by trreb®
Property listed by ROYAL LEPAGE STATE REALTY, Brokerage
Agent Banner Image
Interested in this property?Get in touch to get the inside scoop.

Market Data - Flamborough

Geo Zone Map ThumbnailFlamborough

Balanced Market

View Market Data

Detached house - for the past 30 days

Buyer's market Seller's market

Avg. Days on Market

Past 30 days

46 days

Compared to

2025

34 days

2024

28 days

2023

22 days

New Listings

Past 30 days

112 listings

Compared to

2025

127 listings

2024

119 listings

2023

61 listings

Units sold

Past 30 days

41 units

Compared to

2025

44 units

2024

53 units

2023

47 units

Median Sold Price

Past 30 days

$1,225,000

Compared to

2025

$1,115,000

2024

$1,190,000

2023

$1,200,000


Population and Demographics

Overview

Total population 46428
Average household income $164,302

Age (%)

0 to 19
24%
20 to 34
17%
35 to 49
20%
50 to 64
23%
65 and plus
17%

Household composition (%)

Single family
80%
Single person
17%
Multi person
2%
Multi family
1%

Mother tongue (%)

English
89%
Others
9%

House tenancy (%)

Owners
88%
Renters
12%

What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget