$2,750,000
 $14,763 est/mo Sourced by Back At You

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

Hamilton, ON L8T 1A7

Share:

Description

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.

Details

MLS #40832110
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year1957
Days On Site103
Listing Provided ByRE/MAX Escarpment Golfi Realty Inc. | Emily Zablocki

Features

Bed(s)5
Bath(s) 4 Total
SQ Feet4,863
Garage2
BasementY
PoolYes
Story(s)2
Units2
Building(s)2
ZoningR1
Acreage0.35
Property ViewYes

Interior

AppliancesBar Fridge, Range, Instant Hot Water, Oven, Water Heater Owned, Dishwasher, Dryer, Gas Oven/Range, Gas Stove, Microwave, Refrigerator, Washer
Rooms Total23
Interior FeaturesCentral 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
CoolingCentral Air, Energy Efficient
Cooling Yes / NoNo
HeatingFireplace-Gas, Forced Air, Gas Hot Water, Radiant Floor, Radiant
Heating Yes / NoYes
Fireplaces Total6
Fireplace FeaturesFamily Room, Living Room, Recreation Room
Window FeaturesWindow Coverings, Skylight(s)
Laundry FeaturesGas Dryer Hookup, Laundry Room, Upper Level

Exterior

Accessibility FeaturesAccessible Public Transit Nearby, Neighborhood with Curb Ramps
Lot FeaturesUrban, Rectangular, Library, Open Spaces, Park, Playground Nearby, Public Transit, Rec./Community Centre, School Bus Route, Schools, Shopping Nearby, View from Escarpment
Construction MaterialsBrick, Stone, Wood Siding
RoofShingle
Security FeaturesCarbon Monoxide Detector, Smoke Detector, Alarm System, Carbon Monoxide Detector(s), Monitored, Security System, Smoke Detector(s)

Parking

Garage Spaces2
Parking FeaturesAttached Garage, Garage Door Opener, Electric Vehicle Charging Station(s)
Open Parking Yes / NoYes
Attached Garage Yes / NoYes

Utilities

SewerSewer (Municipal)

Taxes

Tax Annual Amount18422.08

Area Information

ProvinceON
CountyHamilton
CityHamilton
Postal CodeL8T 1A7
Area25 Hamilton Mountain
Subarea251 Sherwood
Community Name251 Sherwood
School DistrictSherwood
Elementary SchoolSaint Margaret Mary, Huntington
High SchoolSherwood
Listing VS Median (in 251 Sherwood)
Price:
$2,750,000
low | high
Med:
$1,624,394
90.931127272727% of Average
sqft:
4,863
low | high
Med:
2,760
93.244910549044% of Average
$ / sqft:
$565
low | high
Med:
$563
50.475184646465% of Average
On site:
103
low | high
Med:
33.5
100% of Average
Sourced by Back At You

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from Coldwell Banker the Real Estate Centre at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the Information Technology of Southern Ontario MLS.

Contact

Learn More About This Property

ProvinceON
CountyHamilton
CityHamilton
Postal CodeL8T 1A7
Area25 Hamilton Mountain
Subarea251 Sherwood
Community Name251 Sherwood
School DistrictSherwood
Elementary SchoolSaint Margaret Mary, Huntington
High SchoolSherwood
Listing VS Median (in 251 Sherwood)
Price:
$2,750,000
low | high
Med:
$1,624,394
90.931127272727% of Average
sqft:
4,863
low | high
Med:
2,760
93.244910549044% of Average
$ / sqft:
$565
low | high
Med:
$563
50.475184646465% of Average
On site:
103
low | high
Med:
33.5
100% of Average
Sourced by Back At You
Listing Updated: July 9, 2026 at 8:07:20 PM PDT