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.
Address
342 Mountain Brow Road
List Price
$2,495,000
MLS® Status
New
Expiration Date
2026-10-20
Property Type
Residential Freehold
Type of Dwelling
Detached
Style of Home
2-Storey
Transaction Type
Sale
Area
Hamilton
Sub-Area
Waterdown
Bedrooms
4 + 2
Bedrooms (Total)
6
Rooms Above Grade
15
Rooms Below Grade
4
Bathrooms
5
Floor Area
3000-3500 Sq. Ft.
Lot Size Source
GeoWarehouse
Lot Depth
387.2
Lot Shape
Irregular
Lot Size Units
Feet
Lot Width
240.45
Parcel Number
175010801
Occupant Type
Owner
Cross Street
Waterdown Rd
MLS® Number
X13166680
Listing Brokerage
ROYAL LEPAGE STATE REALTY
Basement Area
Full, Finished, Walk-Up
Postal Code
L7P 5A3
Posession Details
Flexible
Parking
Circular Drive, Private Triple
Parking Places (Total)
18
Parking Spaces
15
Tax Amount
$13,006.98
Tax Year
2025
Site Influences
Awnings, Cul de Sac/Dead End, Hospital, Landscape Lighting, Landscaped, Lawn Sprinkler System, Library, Lighting, Patio, Privacy, Rec./Commun.Centre, School, Wooded/Treed
Exterior Features
Awnings, Landscape Lighting, Landscaped, Lawn Sprinkler System, Lighting, Patio, Privacy
Interior Features
Auto Garage Door Remote, Floor Drain
Property Features
Cul de Sac/Dead End, Hospital, Library, Rec./Commun.Centre, School, Wooded/Treed
Cable
Yes
Central Vacuum
No
Family Room
Yes
Hydro
Yes
Ensuite Laundry
No
Special Designation
Unknown
Standard Status
Active
Board Or Association
Toronto Regional Real Estate Board
Heat Source
Gas
Heat Type
Forced Air
Cooling Features
Central Air
Construction Materials
Stone
Direction Faces
South
Fireplace
Yes
Fireplace Features
Natural Gas, Wood
Foundation Details
Poured Concrete
Garage
Yes
Garage Type
Attached
Covered Spaces
3
Kitchens Total
1
Kitchens Above Grade
1
Other Structures
Sauna, Shed
Pool Features
Inground
Roof
Asphalt Shingle
Tax Legal Description
PART LOT 6 CON 2 EAST FLAMBOROUGH, PTS 2 & 4, 62R823, EXCEPT PTS 1, 2, & 4, 62R10799 & PTS 1 & 2 62320591L; S/T CD41429, T/W CD59671, S/T & T/W VM29982 CITY OF HAMILTON
View Type
City, Garden, Lake, Panoramic, Pool, Trees/Woods
Waterfront
No
Sewer
Sewer
Rooms
| Floor | Type | Dimensions | Features |
|---|---|---|---|
| Main | Foyer | 5.03 x 4.19 | |
| Main | Living Room | 3.84 x 6.07 | |
| Main | Dining Room | 3.94 x 3.28 | |
| Main | Family Room | 4.93 x 4.98 | |
| Main | Kitchen | 3.3 x 3.89 | |
| Main | Other | 2.57 x 3.89 | |
| Main | Office | 3.89 x 4.32 | |
| Main | Bathroom | 1.6 x 2.62 | 3 Pc Bath |
| Main | Office | 3.89 x 4.32 | |
| Main | Bathroom | 1.35 x 2.36 | 2 Pc Bath |
| Main | Laundry | 3 x 2.87 | |
| Second | Primary Bedroom | 3.84 x 5.87 | |
| Second | Bathroom | 3.17 x 2.34 | 4 Pc Ensuite |
| Second | Bedroom 2 | 4.17 x 3.28 | |
| Second | Bedroom 3 | 3.89 x 3.23 | |
| Second | Bedroom 4 | 3.89 x 4.14 | |
| Second | Bathroom | 2.24 x 2.34 | 4 Pc Bath |
| Basement | Recreation | 12.67 x 5 | |
| Basement | Bedroom 5 | 3.94 x 3.28 | |
| Basement | Bathroom | 3.89 x 3.23 | 2 Pc Bath |
| Basement | Bedroom | 3.25 x 6.07 |