404 Mountain Brow Boulevard E, Hamilton, ON, L8T 1A7

$2,750,000

MLS® # 40795619

House For Sale In Sherwood, Hamilton, Ontario

$2,750,000

  • 5

    Bedrooms

  • 4

    Baths

  • 10

    Parking Spaces

Property Information:

elcome 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.

Inclusions: Carbon Monoxide Detector,Central Vac,Dishwasher,Dryer,Garage Door Opener,Gas Oven/Range,Gas Stove,Microwave,Pool Equipment,Refrigerator,Smoke Detector,Washer,Window Coverings,Central Vac, Dishwasher X 2, Refrigerator X 2, Microwave X 2, Oven/Stove X 2, Radon Mitigation System, Generator

Building Features:

  • Floor Space: 6281 Square Feet

Property Features:

  • Bedrooms: 5
  • Bathrooms: 3+1
  • Accessibility Features: Accessible Public Transit Nearby, Neighborhood with Curb Ramps
  • Acres Range: < 0.5
  • Architectural Style: Two Story
  • Basement: Full, Finished
  • Built in: 1957
  • Construction Materials: Brick, Stone, Wood Siding
  • Cooling: Central Air, Energy Efficient
  • Driveway Parking: Private Drive Triple+ Wide
  • Fireplace Features: Family Room, Living Room, Recreation Room
  • Floor Space (approx): 6281 Square Feet
  • Heating: Fireplace-Gas, Forced Air, Gas Hot Water, Radiant Floor, Radiant
  • Interior Features: Central Vacuum, Atrium, Auto Garage Door Remote(s), Brick & Beam, Built-In Appliances, Ceiling Fan(s), Floor Drains, In-Law Floorplan, Separate Heating Controls, Suspended Ceilings, Upgraded Insulation, Wet Bar, Work Bench
  • Laundry Features: Gas Dryer Hookup, Laundry Room, Upper Level
  • Lot Depth: 185.47 Feet
  • Lot Features: Urban, Rectangular, Library, Open Spaces, Park, Playground Nearby, Public Transit, Rec./Community Centre, School Bus Route, Schools, Shopping Nearby, View from Escarpment
  • Lot Frontage: 82.17 Feet
  • Parking Features: Attached Garage, Garage Door Opener, Electric Vehicle Charging Station(s)
  • Pool Features: In Ground, Salt Water, In Ground, Salt Water
  • Road Frontage Type: Public Road
  • Roof: Shingle
  • Security Features: Carbon Monoxide Detector, Smoke Detector, Alarm System, Carbon Monoxide Detector(s), Monitored, Security System, Smoke Detector(s)
  • Water Source:
  • Window Features: Window Coverings, Skylight(s)
  • Zoning: B
  • Sewer: Sewer (Municipal)
  • No. of Parking Spaces: 10

Rooms:

  • Kitchen Main Level 3.33 X 3.28
  • Dining Main Level 7.14 X 3.99
  • Living Main Level 5.28 X 4.78
  • Sun Room Main Level 6.20 X 4.78
  • Foyer Main Level 8.84 X 7.62
  • Bathroom Main Level
  • Family Main Level 5.28 X 4.78
  • Primary Bedroom 2nd Level 6.43 X 5.26
  • Bedroom 2nd Level 5.03 X 3.68
  • Bedroom 2nd Level 4.14 X 3.68
  • Bedroom 2nd Level 3.86 X 3.58
  • Bathroom 2nd Level 2.49 X 3.07
  • Bathroom 2nd Level 4.06 X 3.10
  • Bathroom Basement Level 1.91 X 2.24
  • Laundry 2nd Level 3.81 X 2.26
  • Living Basement Level 8.64 X 3.48
  • Other Basement Level 3.28 X 3.33 Note: Kitchen/Dining Room
  • Den Basement Level 4.80 X 4.27
  • Storage Basement Level 3.58 X 3.58
  • Utility Basement Level 2.69 X 3.45
  • Other Basement Level 2.03 X 2.36 Note: Wine Cellar
  • Other Basement Level 1.73 X 3.28
  • Bedroom Basement Level 3.86 X 3.25

Courtesy of: Keller Williams Complete Realty

This listing content provided by REALTOR.ca has been licensed by REALTOR® members of The Canadian Real Estate Association.

Additional Photos