












































404 Mountain Brow Boulevard
Sherwood, Hamilton
$2,750,000
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 extensively rebuilt in 2012. 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 façade, 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 basement provides a shared access in-law suite. 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, comfort,**INTERBOARD LISTING: CORNERSTONE ASSOCIATION OF REALTORS**
No extras listed.
Visit this home
Pick a time that works for you.
No upcoming open houses.
| Type | Detached |
| Style | 2-Storey |
| Approx. Age | 51-99 |
| Size | 3500-5000 sq. ft. |
| Property Tax | $18,422 |
| Lot Size | 82.17 ft x 185.47 ft |
| mls© Number | X13437012 |
| Listed By | KELLER WILLIAMS COMPLETE REALTY |
Listing History
- No recent sale history for this listing.
- No recent lease history for this listing.
Could you afford this home?
What the bank counts
This home's actual carrying costs, payment stress-tested at 6%
- Mortgage, tested at 6%
- $14,076
- Property tax
- $1,535
- Heat allowance
- $150
- Housing costs
- $15,761 / mo
Lenders cap these at 39% of gross income — that sets the number.
Income needed
$485,000
gross annual household income
- Payment at 4%
- $11,572 / mo
- Cash down
- $550,000
Assumes no other monthly debts · 25-yr amortization
Full affordability checkInvestment Analysis
Estimated rent, cap rate and monthly cash flow for this property
Values and trends
Nearby listings
Comparable sales
- No similar listings found.













































































































































































































































































































































































































































































































