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.
For sale
C$2,495,000
342 Mountain Brow Rd, Hamilton, ON L7P 5A3
6beds
3,108sqft
Single Family Residence, Residential
Built in 1978
1.68 Acres Lot
$-- Zestimate®
C$803/sqft
C$-- HOA
What's special
Incredible panoramic viewsStately all-brick homeMature treesBreathtaking natural sceneryProfessionally landscaped groundsElegant fountain featureOversized triple garage
- 19 hours |
- 6 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Kevin Roger Girard, Salesperson,
Royal LePage State Realty Inc.,
Tina Girard, Salesperson,
Royal LePage State Realty Inc.
Source: ITSO,MLS®#: 40832001Originating MLS®#: Cornerstone Association of REALTORS®
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 3
- 1/2 bathrooms: 2
- Main level bathrooms: 2
Kitchen
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Water Heater Owned, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
- Laundry: Main Level, Sink
Features
- Auto Garage Door Remote(s), Floor Drains, Sauna
- Windows: Window Coverings
- Basement: Separate Entrance,Walk-Up Access,Full,Finished
- Number of fireplaces: 2
- Fireplace features: Family Room, Living Room, Gas, Wood Burning
Interior area
- Total structure area: 4,392
- Total interior livable area: 3,108 sqft
- Finished area above ground: 3,108
- Finished area below ground: 1,284
Video & virtual tour
Property
Parking
- Total spaces: 18
- Parking features: Attached Garage, Garage Door Opener, Private Drive Triple+ Wide
- Attached garage spaces: 3
- Uncovered spaces: 15
Features
- Patio & porch: Patio, Porch
- Exterior features: Awning(s), Landscape Lighting, Landscaped, Lawn Sprinkler System, Lighting, Privacy, Private Entrance
- Has private pool: Yes
- Pool features: In Ground
- Has view: Yes
- View description: City, Forest, Downtown, Lake, Pool, Skyline, Trees/Woods
- Has water view: Yes
- Water view: Lake
- Frontage type: South
- Frontage length: 420.45
Lot
- Size: 1.68 Acres
- Dimensions: 420.45 x 387.2
- Features: Urban, Cul-De-Sac, Highway Access, Hospital, Landscaped, Library, Major Highway, Playground Nearby, Public Transit, School Bus Route, Schools, Shopping Nearby, Trails, View from Escarpment, Visual Exposure, Other
Details
- Additional structures: Sauna, Shed(s), Storage
- Parcel number: 175010801
- Zoning: P6
- Other equipment: Pool Equipment
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Two Story
- Property subtype: Single Family Residence, Residential
Materials
- Stone
- Foundation: Poured Concrete
- Roof: Asphalt Shing, Flat
Condition
- 31-50 Years
- New construction: No
- Year built: 1978
Utilities & green energy
- Sewer: Sewer (Municipal)
- Water: Municipal
Community & HOA
Community
- Security: Carbon Monoxide Detector, Smoke Detector
Location
- Region: Hamilton
Financial & listing details
- Price per square foot: C$803/sqft
- Annual tax amount: C$13,006
- Date on market: 5/20/2026
- Inclusions: Carbon Monoxide Detector, Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, Sauna
- Exclusions: Garage Cabinets, Workbench, Attachments.
Kevin Roger Girard, Salesperson
Kevin Roger Girard, Salesperson
By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.
Price history
| Date | Event | Price |
|---|---|---|
| 5/20/2026 | Listed for sale | C$2,495,000C$803/sqft |
Source: ITSO #40832001 Report a problem | ||
Public tax history
Tax history is unavailable.
Climate risks
Neighborhood: L7P
Nearby schools
GreatSchools rating
No schools nearby
We couldn't find any schools near this home.
- Ontario
- Hamilton Division
- Hamilton
- L7P 5A3
- 342 Mountain Brow Rd
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Hamilton Topics
