404 Mountain Brow Boulevard, Hamilton, ON L8T 1A7, Hamilton, ON
Bed 6
Bath 6
This custom-built luxury residence on prestigious Mountain Brow Blvd with breathtaking views of the Niagara Escarpment and Lark Ontario. Originally built in 1957, the home was extensively 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 an established neighbourhood. The craftsman-inspired facade, clad in Georgian Bay limestone and board-and-batten, makes a striking first impression. A paved limestone-framed 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, forced air, 3-piece bath, and gym. Every inch of this residence reflects luxury **INTERBOARD LISTING: CORNERSTONE ASSOCIATION OF REALTORS**
Property Highlights
For Sale
MLS NO.
X12384877
Type
Residential Freehold
Sub Type
Detached
Bedrooms
6
Bathrooms
6
Parking
8.0
Garage
Yes
Complete Property Details
Property Type
Residential Freehold
Sub Type
Detached
Transaction Type
For Sale
Status
Expired
Contract Status
Unavailable
MLS® Number
X12384877
Living Area Range
3500-5000
Total Bedrooms
6
Bedrooms Above Grade
5
Bedrooms Below Grade
1
Total Bathrooms
6
Total Kitchens
2
Kitchens Above Grade
1
Kitchens Below Grade
1
Rooms Above Grade
17
Rooms Below Grade
8
Interior Features
Atrium, Auto Garage Door Remote, Bar Fridge, Carpet Free, Central Vacuum, Countertop Range, Floor Drain, Generator - Full, Guest Accommodations, In-Law Suite, Separate Heating Controls, Storage, Water Heater Owned, Water Meter
LT 177, PL 1025 ; PT LT 176, PL 1025 , AS IN NS299752 ; S/T NS290252 HAMILTON
Possession Type
Flexible
Possession Details
flexible
Listing Office
KELLER WILLIAMS COMPLETE REALTY
Board
Toronto Regional Real Estate Board
Original Entry
2025-09-05T18:38:55Z
Media Updated
2025-09-05T18:38:55Z
Photos Updated
2025-09-05T18:38:55Z
Last Modified
2025-12-02T05:15:40Z
System Modified
2025-12-02T05:15:40.068201Z
MLS Status
Expired
Architectural Style
2-Storey
Basement
Apartment, Finished
Ddfyn
No
Expiration Date
2025-12-01
Foundation Details
Concrete Block, Poured Concrete, Stone
Heat Source Multi
Gas
Heat Type Multi
Forced Air
Hstapplication
Included In
Link Yn
No
Occupant Type
Owner
Originating System Id
A00001796
Parcel Number
170730150
Parking Spaces
6
Property Features
Electric Car Charger, Fenced Yard, Greenbelt/Conservation, Hospital, Park, School
Public Remarks
This custom-built luxury residence on prestigious Mountain Brow Blvd with breathtaking views of the Niagara Escarpment and Lark Ontario. Originally built in 1957, the home was extensively 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 an established neighbourhood. The craftsman-inspired facade, clad in Georgian Bay limestone and board-and-batten, makes a striking first impression. A paved limestone-framed 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, forced air, 3-piece bath, and gym. Every inch of this residence reflects luxury **INTERBOARD LISTING: CORNERSTONE ASSOCIATION OF REALTORS**
