404 MOUNTAIN BROW Boulevard E
251 - Sherwood Hamilton L8T 1A7

$2,750,000
Single Family beds: 5 baths: 4.0 6,281 sq. ft. built: 1957

View of front of house featuring driveway, a shingled roof, an attached garage, a porch, and board and batten siding
Photo 1: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 2: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 3: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 4: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 5: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 6: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 7: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 8: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 9: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 10: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 11: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 12: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 13: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 14: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 15: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 16: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 17: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 18: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 19: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 20: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 21: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 22: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 23: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 24: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 25: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 26: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 27: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 28: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 29: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 30: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 31: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 32: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 33: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 34: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 35: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 36: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 37: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 38: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 39: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 40: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 41: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 42: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 43: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 44: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 45: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 46: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 47: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 48: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 49: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Photo 50: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40762304
Bedrooms:
5
Bathrooms:
4
Year Built:
1957
Welcome to this custom-built luxury residence on prestigious Mountain Brow Blvd with breathtaking views of the Niagara Escarpment and Lake Ontario. Originally built in 1957, the home was completely rebuilt in 2012, retaining only portions of the original foundation. Nearly every component — including framing, mechanical systems, roofing, and interior finishes — was replaced or upgraded, offering the comfort and efficiency of a modern build with the charm of its origins. The craftsman-inspired façade, clad in Georgian Bay limestone and board-and-batten, makes a striking first impression. A limestone-paved circular driveway enhances the curb appeal, along with an EV charging station, path lighting, and mature perennial gardens with irrigation. Inside, a cathedral ceiling and floating staircase set the tone in the grand foyer. The gourmet kitchen features granite counters, high-end appliances, cherry wood cabinetry, and a spacious walk-in pantry. It flows into an expansive dining room with a built-in fireplace and escarpment views — ideal for intimate dinners or large gatherings. Off the dining room, a bright study with heated floors and an indoor/outdoor gas fireplace leads to a four-season sunroom with serene backyard views. The backyard oasis includes a heated saltwater pool, retractable awnings, a 14’ x 20’ covered outdoor kitchen with gas fireplace, and a private annex. A double-sized family room with radiant heat and gas fireplace sits just off the kitchen, perfect for entertaining. Upstairs offers four spacious bedrooms, three bathrooms, and a central laundry room. The primary suite is a true retreat with a five-piece ensuite, walk-in closet, gas fireplace, and balcony with panoramic views. The 37’ x 20’ backyard annex provides additional privacy and includes a guest suite with fireplace, in-floor heating, 3-piece bath, and gym. Every inch of this residence reflects luxury, comfort, and functionality — a truly exceptional home. (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Total Living Area:
6,281 sq. ft.
Finished Area Above Grade:
4,863 sq. ft.
Zoning:
B
Taxes:
$17,711.12 / -
Community:
251 - Sherwood
Exterior Features:
Wood, Brick, Stone
Pool Features:
Inground pool
Community Features:
School Bus, Community Centre
Security Features:
Alarm system, Security system, Smoke Detectors, Monitored Alarm
Structure Type:
House
Appliances Included:
Washer, Refrigerator, Central Vacuum, Gas stove(s), Range - Gas, Dishwasher, Dryer, Microwave, Oven - Built-In, Wet Bar, Window Coverings, Garage door opener
Home Style:
2 Level
Bedrooms:
5
Bedrooms Above Grade:
4
Bedrooms Below Grade:
1
Bathrooms:
4.0
Half Bathrooms:
1
Construction Material:
Wood frame
Cooling:
Central air conditioning
Fireplace:
Yes
Fireplaces:
6
Heating:
Hot water radiator heat, Radiant heat, Forced air, In Floor Heating
# Storeys:
2.0
Sewer:
Municipal sewage system
Basement:
Finished, Full
Lot Frontage:
82'
Lot Features:
Wet bar, Skylight, Automatic Garage Door Opener, In-Law Suite
Parking:
Attached Garage
Total Parking Spaces:
10
Floor
Type
Size
Other
Main level
Family room
17'4" × 15'8"
-
Main level
Foyer
29' × 25'
-
Main level
Sunroom
20'4" × 15'8"
-
Main level
Living room
17'4" × 15'8"
-
Main level
Dining room
23'5" × 13'1"
-
Main level
Kitchen
10'11" × 10'9"
-
Second level
Laundry room
12'6" × 7'5"
-
Second level
Bedroom
13'7" × 12'1"
-
Second level
Bedroom
12'8" × 11'9"
-
Second level
Bedroom
16'6" × 12'1"
-
Second level
Primary Bedroom
21'1" × 17'3"
-
Basement
Bedroom
12'8" × 10'8"
-
Basement
Other
10'9" × 5'8"
-
Basement
Wine Cellar
7'9" × 6'8"
-
Basement
Utility room
11'4" × 8'10"
-
Basement
Storage
11'9" × 11'9"
-
Basement
Den
15'9" × 14'
-
Basement
Living room
28'4" × 11'5"
-
Basement
Kitchen/Dining room
10'11" × 10'9"
-
Floor
Ensuite
Pieces
Other
Main level
No
2
Second level
No
4
10'1" x 8'2"
Second level
No
3
10'2" x 13'4"
Basement
No
3
7'4" x 6'3"
  • Photo 1: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of front of house featuring driveway, a shingled roof, an attached garage, a porch, and board and batten siding
  • Photo 2: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Craftsman-style house featuring driveway, stone siding, a garage, and covered porch
  • Photo 3: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Entrance to property featuring a porch and board and batten siding
  • Photo 4: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Photo 4 of 50
  • Photo 5: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Entryway featuring light tile patterned flooring and recessed lighting
  • Photo 6: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Hall with light tile patterned floors, recessed lighting, a chandelier, and a raised ceiling
  • Photo 7: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Dining space featuring light tile patterned flooring and baseboards
  • Photo 8: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Dining area featuring light tile patterned flooring, recessed lighting, and wine cooler
  • Photo 9: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bar with light tile patterned flooring, light stone countertops, dark brown cabinets, a fireplace, and recessed lighting
  • Photo 10: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Kitchen featuring a breakfast bar, built in fridge, light stone countertops, recessed lighting, and a large island
  • Photo 11: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Kitchen featuring exhaust hood, light stone countertops, premium appliances, dark brown cabinetry, and recessed lighting
  • Photo 12: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of storage
  • Photo 13: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Living room with a glass covered fireplace, light tile patterned flooring, billiards, and recessed lighting
  • Photo 14: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Playroom with billiards, light tile patterned floors, a ceiling fan, an AC wall unit, and vaulted ceiling
  • Photo 15: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Foyer entrance featuring light tile patterned floors and recessed lighting
  • Photo 16: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Living area with tile patterned floors, plenty of natural light, and a chandelier
  • Photo 17: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Living area with light tile patterned flooring, a chandelier, healthy amount of natural light, and recessed lighting
  • Photo 18: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Sunroom with a skylight
  • Photo 19: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Hall featuring light tile patterned floors, recessed lighting, and a chandelier
  • Photo 20: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bedroom with a ceiling fan and light tile patterned floors
  • Photo 21: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Full bathroom featuring vanity, a shower stall, and light tile patterned flooring
  • Photo 22: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bedroom featuring light tile patterned floors and ceiling fan
  • Photo 23: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Tiled bedroom featuring a ceiling fan and baseboards
  • Photo 24: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Hallway featuring light tile patterned floors and recessed lighting
  • Photo 25: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bedroom featuring vaulted ceiling, access to exterior, a wall mounted air conditioner, light tile patterned flooring, and a skylight
  • Photo 26: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bedroom featuring ceiling fan, vaulted ceiling, a skylight, light tile patterned flooring, and recessed lighting
  • Photo 27: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bathroom featuring tile walls, double vanity, a soaking tub, walk in shower, and light tile patterned floors
  • Photo 28: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bathroom with a tile shower, ceiling fan, light tile patterned floors, and a freestanding tub
  • Photo 29: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of patio / terrace
  • Photo 30: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of patio / terrace
  • Photo 31: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Photo 31 of 50
  • Photo 32: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Entryway with light wood-style flooring and recessed lighting
  • Photo 33: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Playroom with light wood-style floors, recessed lighting, and decorative columns
  • Photo 34: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Detailed view of wood ceiling, wood finished floors, recessed lighting, and wooden walls
  • Photo 35: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Playroom with wood finished floors and recessed lighting
  • Photo 36: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Living room featuring light wood-style flooring and recessed lighting
  • Photo 37: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Indoor wet bar featuring recessed lighting, light wood-type flooring, dark countertops, and stainless steel fridge with ice dispenser
  • Photo 38: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Kitchen featuring backsplash, appliances with stainless steel finishes, a kitchen bar, light wood-type flooring, and a peninsula
  • Photo 39: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Full bathroom featuring vanity, a stall shower, dark wood-style floors, and recessed lighting
  • Photo 40: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Bedroom with a spacious closet, light wood-style floors, and recessed lighting
  • Photo 41: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Swimming pool with a patio and an outdoor structure
  • Photo 42: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Swimming pool with a patio
  • Photo 43: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of patio / terrace with an outdoor pool and grilling area
  • Photo 44: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of patio featuring a storage shed and exterior kitchen
  • Photo 45: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    View of yard
  • Photo 46: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Tiled bedroom with vaulted ceiling, recessed lighting, fridge, and access to exterior
  • Photo 47: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Full bath featuring dark tile patterned flooring, vanity, and a shower stall
  • Photo 48: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Exercise room with a barn door
  • Photo 49: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Aerial view of residential area with a pool
  • Photo 50: 404 MOUNTAIN BROW Boulevard E in Hamilton: Single Family for sale : MLS®# 40762304
    Aerial perspective of suburban area with a pool

Video Tour Website

Listed by Keller Williams Complete Realty
Data was last updated September 7, 2025 at 05:15 AM (UTC)
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.