{{::listingStatusInfo.daysOnMarket | timeAgo }}
 New Today
RENTED CONDITIONALLY
SOLD CONDITIONALLY
RENTED CONDITIONALLY WITH ESCAPE
SOLD CONDITIONALLY WITH ESCAPE
on {{::listingStatusInfo.soldAsOf | momentFormat }}
on {{::listingStatusInfo.soldAsOf | momentFormat }}
AS OF {{::listingStatusInfo.inactiveAsOf }}

$2,495,000Asking Price

342 Mountain Brow Road, Hamilton, ON L7P 5A3

Waterdown, Hamilton

Detached
4 + 2
Bedrooms
5
Baths
18
Parking
Days on Market

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.

Thank you for your inqury! We’ll be in touch shortly about your request.
Tour this home:

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.

Key Info

  • 2-Storey Detached
  • 15-Car Driveway
  • 3-Car Attached Garage
  • Waterdown Rd
  • 3000-3500 Approximate Sq Feet
  • Basement: Full, Finished
  • 1 Kitchen
  • Forced Air Gas Heating
  • Central Air

Property

  • Lot Size 240.45 x 387.2 Feet
  • Stone Exterior
  • Taxes were $13,006 in 2025
  • Possession: Flexible

Details

  • Fireplace
  • Family Room
  • Inground Pool
  • Sewers
  • Municipal Water
  •  
  • MLS #X13166680
  • ROYAL LEPAGE STATE REALTY

Extras

Room Floor Dimensions Details
1 Foyer Main 16.50' x 13.75'
2 Kitchen Main 10.83' x 12.76'
3 Other Main 8.43' x 12.76'
4 Office Main 12.76' x 14.17'
5 Bathroom Main 5.25' x 8.60' 3-PieceBath
6 Office Main 12.76' x 14.17'
7 Bathroom Main 4.43' x 7.74' 2-PieceBath
8 Laundry Main 9.84' x 9.42'
Washroom1 2-Piece Bathroom on Main Floor
Washroom1 3-Piece Bathroom on Main Floor
Washroom2 4-Piece Bathrooms
Washroom1 2-Piece Bathroom

Who lives here?

Waterdown, Hamilton is a west GTA neighbourhood notable for its university grads, executives, business, science and education, law & public sector professionals and salespeople. Residents tend to be younger with a significant number of babies, kids aged 5 to 14, youth aged 15 to 19 and adults aged 30 to 54.

Families

Kids Per Family

1.2

kids per family
in the neighbourhood.

Hamilton  (1.2)

Singles

36% of residents are
single and loving it.

36% singles

Hamilton (46%)

Renters

15% of residents
are renters.

15% renters

Hamilton (32%)

Education

38% of residents are
university grads.

38% university grads

Hamilton (28%)

Income

Average Household Income

$151K

is the average household
income in the neighbourhood.

Hamilton  ($106K)

Professions

Professions

Sales 16%
Business 12%
Government 11%
Management 10%
Trades 8%

Immigrants

16% of residents were
born outside of Canada.

16% immigrants

Hamilton (25%)

Birthplace - All

UK was once home to 3.2% of immigrants.
India 1.2%
Caribbean 0.9%
USA 0.8%
Poland 0.7%

3.2% from UK
All-time

Birthplace - Recent

UK was once home to 0.5% of immigrants.
India 0.3%
USA 0.3%
Poland 0.2%
Southern Africa 0.1%

0.5% from UK
Recent

Foreign Languages

Foreign Languages

French 1%
Italian 1%
Polish 1%
Punjabi 1%
Spanish 1%

Religions

Religions

Christian 67%
Jewish 1%
Muslim 1%
Sikh 1%
Hindu 1%