$2,750,000
Est. payment $12,176/moCalculate yours
404 Mountain Brow Boulevard, Hamilton, ON L8T 1A7
Sherwood, Hamilton, ON L8T 1A7
- 5 + 1 Beds
- 6 Baths
- 2 Garage
- 3,500 Sq Ft
Listing courtesy of KELLER WILLIAMS COMPLETE REALTY MLS® X13437012
About this home
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**
Property details
Overview
- Property Type
- Detached
- Style
- 2-Storey
- For
- For Sale
- Status
- New
- Approximate Age
- 51-99
- Size
- 3,500 sqft
Interior
- Bedrooms
- 5 + 1
- Bathrooms
- 6
- Kitchens
- 2
- Basement
- Finished
Building & Systems
- Heating
- Forced Air (Gas)
- Cooling
- Central Air
- Exterior
- Board & Batten , Stone
- Foundation
- Concrete Block, Poured Concrete
- Roof
- Asphalt Rolled, Shingles
- Water
- Municipal
- Sewer
- Sewer
Lot & Parking
- Lot Size
- 82.17 x 185.47 Feet
- Parking
- Attached garage · 8 total
- Zoning
- Residential
Financial
- Property Taxes
- $18,422 (2026)
Location
- Neighbourhood
- Sherwood
- Cross Street
- Mountain Brow Blvd and Fennell Avenue East
- Direction Faces
- East
Listing
- MLS® Number
- X13437012
- Days on Market
- 151
- Listed On
- 2026-05-20
- Possession
- flexible
- Listed By
- KELLER WILLIAMS COMPLETE REALTY
Rooms
Features
Interior
- 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
Property
- Electric Car Charger
- Fenced Yard
- Greenbelt/Conservation
- Hospital
- Park
- School
Pool
- Inground
- Salt
- Included
- Carbon Monoxide Detector, Central Vac, Dishwasher, Dryer, Garage Door Opener, Gas Oven/Range, Gas Stove, Microwave, Pool Equipment, Refrigerator, Smoke Detector, Washer, Window Coverings
- Excluded
- n/a
- Rental items
- n/a
Mortgage calculator
Estimated mortgage payment
$12,176 per month
- Principal and interest
- $12,176
- Property tax
- $1,535
- Condo fees
- $0
- Estimated monthly cost
- $13,712
Your mortgage
- Mortgage amount
- $2,200,000
- Mortgage insurance
- Not needed
- Interest over 25 years
- $1,452,921
Cash to close
- Down payment
- $550,000
- Land transfer tax
- $55,225
- First-time buyer refund
- $0
- Sales tax on insurance (8%)
- $0
- Total, before legal fees
- $605,225
With less than 20% down, a 30-year amortization is available to first-time buyers and buyers of newly built homes.
Talk to me about financingEstimates only, not a mortgage offer or financial advice. Uses the Canadian fixed-rate convention (interest compounded twice a year), 2026 mortgage insurance premiums and Ontario land transfer tax. Your lender will confirm your actual rate and payment.
Location
This photo could not be loaded.