FEATURED LISTINGS

342 MOUNTAIN BROW Road
460 - Waterdown West Hamilton L7P 5A3

$2,495,000
Single Family beds: 6 baths: 5.0 4,392 sq. ft. built: 1978

Main Photo: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 1: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 2: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 3: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 4: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 5: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 6: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 7: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 8: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 9: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 10: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 11: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 12: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 13: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 14: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 15: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 16: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 17: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 18: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 19: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 20: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 21: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 22: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 23: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 24: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 25: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 26: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 27: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 28: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 29: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 30: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 31: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 32: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 33: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 34: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 35: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 36: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 37: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 38: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 39: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 40: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 41: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 42: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 43: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 44: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 45: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 46: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 47: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 48: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 49: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Photo 50: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40832001
Bedrooms:
6
Bathrooms:
5
Year Built:
1978
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. (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Total Living Area:
4,392 sq. ft.
Finished Area Above Grade:
3,108 sq. ft.
Zoning:
P6
Taxes:
$13,006.98 / -
Community:
460 - Waterdown West
Exterior Features:
Stone
Pool Features:
Inground pool
Community Features:
School Bus
View:
City view
Structure Type:
House
Appliances Included:
Washer, Refrigerator, Sauna, Dishwasher, Stove, Dryer, Hood Fan, Window Coverings, Garage door opener
Home Style:
2 Level
Bedrooms:
6
Bedrooms Above Grade:
4
Bedrooms Below Grade:
2
Bathrooms:
5.0
Half Bathrooms:
2
Cooling:
Central air conditioning
Fireplace:
Yes
Fireplaces:
2
Fireplace Type:
Wood, Other - See remarks
Foundation:
Poured Concrete
Heating:
Forced air, Natural gas
# Storeys:
2.0
Water:
Municipal water
Sewer:
Municipal sewage system
Basement:
Finished, Full
Lot Frontage:
420'
Lot Size:
1.675 acre(s)
Lot Details:
1.675
Lot Features:
Cul-de-sac, Visual exposure, Automatic Garage Door Opener
Parking:
Attached Garage
Total Parking Spaces:
18
Floor
Type
Size
Other
Main level
Laundry room
9'10" × 9'5"
-
Main level
Office
14'2" × 12'9"
-
Main level
Office
14'2" × 12'9"
-
Main level
Dinette
12'9" × 8'5"
-
Main level
Kitchen
12'9" × 10'10"
-
Main level
Family room
16'4" × 16'2"
-
Main level
Dining room
12'11" × 10'9"
-
Main level
Living room
19'11" × 12'7"
-
Main level
Foyer
16'6" × 13'9"
-
Second level
Bedroom
13'7" × 12'9"
-
Second level
Bedroom
12'9" × 10'7"
-
Second level
Bedroom
13'8" × 10'9"
-
Second level
Primary Bedroom
19'3" × 12'7"
-
Basement
Bedroom
19'11" × 10'8"
-
Basement
Bedroom
12'11" × 10'9"
-
Basement
Recreation room
41'7" × 16'5"
-
Floor
Ensuite
Pieces
Other
Main level
No
2
7'9" x 4'5"
Main level
No
3
8'7" x 5'3"
Second level
No
4
7'8" x 7'4"
Second level
No
-
7'8" x 10'5"
Basement
No
2
10'7" x 12'9"
  • Photo 1: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 1 of 50
  • Photo 2: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 2 of 50
  • Photo 3: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 3 of 50
  • Photo 4: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 4 of 50
  • Photo 5: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 5 of 50
  • Photo 6: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 6 of 50
  • Photo 7: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 7 of 50
  • Photo 8: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 8 of 50
  • Photo 9: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 9 of 50
  • Photo 10: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 10 of 50
  • Photo 11: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 11 of 50
  • Photo 12: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 12 of 50
  • Photo 13: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 13 of 50
  • Photo 14: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 14 of 50
  • Photo 15: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 15 of 50
  • Photo 16: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 16 of 50
  • Photo 17: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 17 of 50
  • Photo 18: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 18 of 50
  • Photo 19: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 19 of 50
  • Photo 20: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 20 of 50
  • Photo 21: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 21 of 50
  • Photo 22: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 22 of 50
  • Photo 23: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 23 of 50
  • Photo 24: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 24 of 50
  • Photo 25: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 25 of 50
  • Photo 26: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 26 of 50
  • Photo 27: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 27 of 50
  • Photo 28: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 28 of 50
  • Photo 29: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 29 of 50
  • Photo 30: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 30 of 50
  • Photo 31: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 31 of 50
  • Photo 32: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 32 of 50
  • Photo 33: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 33 of 50
  • Photo 34: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 34 of 50
  • Photo 35: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 35 of 50
  • Photo 36: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 36 of 50
  • Photo 37: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 37 of 50
  • Photo 38: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 38 of 50
  • Photo 39: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 39 of 50
  • Photo 40: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 40 of 50
  • Photo 41: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 41 of 50
  • Photo 42: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 42 of 50
  • Photo 43: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 43 of 50
  • Photo 44: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 44 of 50
  • Photo 45: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 45 of 50
  • Photo 46: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 46 of 50
  • Photo 47: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 47 of 50
  • Photo 48: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 48 of 50
  • Photo 49: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 49 of 50
  • Photo 50: 342 MOUNTAIN BROW Road in Hamilton: Single Family for sale : MLS®# 40832001
    Photo 50 of 50

Video Tour Website

Listed by Royal LePage State Realty Inc.
Data was last updated June 6, 2026 at 05:15 PM (UTC)
Area Statistics
Listings on market:
38
Avg list price:
$754,900
Min list price:
$449,000
Max list price:
$3,249,000
Avg days on market:
17
Min days on market:
1
Max days on market:
121
Avg price per sq.ft.:
$450.08
These statistics are generated based on the current listing's property type and located in 460 - Waterdown West. Average values are derived using median calculations. This data is not produced by the MLS® system.
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are member’s of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.