404 MOUNTAIN BROW Boulevard E Hamilton

404 MOUNTAIN BROW Boulevard E, Hamilton, Ontario

$2,750,000

  • 5 Beds
  • 4 Bath
  • 4,863 Square Feet
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. (id:50004)
  • Listing ID: 40832110
  • Property Type: Single Family
  • Year Built: 1957

Mortgage Calculator

A mortgage is often necessary when buying a home, but determining what you can afford can be tricky. Use our calculator to estimate your mortgage payments based on the purchase price.

Contact a mortgage specialist to apply for a mortgage or to obtain pre-approval.

Talk to a Home Lifestyle Matchmaker

Use our neighbourhood guide to score the perfect match between your lifestyle and home. When ready to buy, we will put you in touch with an agent who specializes in Hamilton.

Rooms

LevelTypeDimensions
Second LevelLaundry Room12'6'' x 7'5''
Second Level4pc Bathroom8'2'' x 10'1''
Second Level3pc Bathroom13'4'' x 10'2''
Second LevelBedroom13'7'' x 12'1''
Second LevelBedroom12'8'' x 11'9''
Second LevelBedroom16'6'' x 12'1''
Second LevelPrimary Bedroom21'1'' x 17'3''
BasementBedroom12'8'' x 10'8''
BasementOther5'8'' x 10'9''
BasementWine Cellar6'8'' x 7'9''
BasementUtility Room8'10'' x 11'4''
BasementStorage11'9'' x 11'9''
BasementDen15'9'' x 14'0''
BasementLiving Room28'4'' x 11'5''
BasementKitchen/Dining Room10'9'' x 10'11''
Basement3pc Bathroom6'3'' x 7'4''
Main LevelFamily Room17'4'' x 15'8''
Main Level2pc BathroomMeasurements not available
Main LevelFoyer28'11'' x 24'11''
Main LevelSunroom20'4'' x 15'8''
Main LevelLiving Room17'4'' x 15'8''
Main LevelDining Room23'5'' x 13'1''
Main LevelKitchen10'11'' x 10'9''

Details

  • Amenities Nearby: Park, Playground, Public Transit, Schools, Shopping
  • Community Features: Community Centre, School Bus
  • Features: Wet bar, Skylight, Automatic Garage Door Opener, In-Law Suite
  • Ownership: Freehold
  • Parking Spaces: 10
  • Pool: Inground pool
  • Transaction: For sale
  • Zoning Description: R1

Building

  • Appliances: Central Vacuum, Dishwasher, Dryer, Microwave, Oven - Built-In, Refrigerator, Wet Bar, Washer, Range - Gas, Gas stove(s), Window Coverings, Garage door opener
  • BasementType: Full (Finished)
  • Basement Development: Finished
  • Bedrooms Main Level: 4
  • Bedrooms Lower Level: 1
  • Constructed Date: 1957
  • Constructed Material: Wood frame
  • Construction Style Attachment: Detached
  • Cooling: Central air conditioning
  • Exterior Finish: Brick, Stone, Wood
  • Fireplace Present: True
  • Fireplace Total: 6
  • Fire Protection: Monitored Alarm, Smoke Detectors, Alarm system, Security system
  • Fixture: Ceiling fans
  • Bathrooms (Half): 1
  • Bathrooms (Total): 4
  • Heating: In Floor Heating, Forced air, Radiant heat, Hot water radiator heat
  • Size Interior: 4863 sqft
  • Stories Total: 2
  • Type: House

Land

  • Access Type: Road access
  • Amenities: Park, Playground, Public Transit, Schools, Shopping
  • Sewer: Municipal sewage system
  • Size Frontage: 82 ft

REALTOR® MLS®

Listing provided courtesy of Keller Williams Complete Realty

MLS®, REALTOR®, and the associated logos are trademarks of the Canadian Real Estate Association. Information deemed reliable but not guaranteed. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Request More Information

Want more information or schedule a showing? Let us put you in touch with one of our agents who specializes in Hamilton.

    Are you under contract with a real estate agent or REALTOR®?
    YesNo

    You've indicated that you are currently working with a REALTOR®. Please be advised that TRESA 2002 and supporting Rules and Regulations, restricts the amount of information that we are able to provide to you as a client of another Brokerage or REALTOR®. Therefore, any further information must be sought directly from your current REALTOR®.

    This property for sale is located at 404 MOUNTAIN BROW Boulevard E in Hamilton. It was last modified on June 3rd 2026.
    Connect with one of our real estate agents to schedule a viewing or to discover other Hamilton homes for sale.

    Terms of Use Agreement

    Terms of Use
    This website is operated by Royal LePage® Burloak, a brokerage who is a member of The Canadian Real Estate Association (CREA). The content on this website is owned or controlled by CREA. By accessing this website, the user agrees to be bound by these terms of use as amended from time to time, and agrees that these terms of use constitute a binding contract between the user, Royal LePage® Burloak, and CREA.

    Copyright
    The content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically prohibited. Prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate the content of this website.

    Trademarks
    REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the professional real estate services provided by members of CREA.

    Liability and Warranty Disclaimer
    The information contained on this website is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members, and assumes no responsibility for its completeness or accuracy.

    Amendments
    Royal LePage® Burloak may at any time amend these Terms of Use by updating this posting. All users of this site are bound by these amendments should they wish to continue accessing the website, and should therefore periodically visit this page to review any and all such amendments.

    AgreeDecline

    Request an In-house Showing

      Your Preferences

      Are you under contract with a real estate agent or REALTOR®?YesNo

      You've indicated that you are currently working with a REALTOR®. Please be advised that TRESA 2002 and supporting Rules and Regulations, restricts the amount of information that we are able to provide to you as a client of another Brokerage or REALTOR®. Therefore, any further information must be sought directly from your current REALTOR®.

      Are you a real estate agent or REALTOR®?YesNo

      When are you available?

      Request More Information

        Are you under contract with a real estate agent or REALTOR®?
        YesNo

        You've indicated that you are currently working with a REALTOR®. Please be advised that TRESA 2002 and supporting Rules and Regulations, restricts the amount of information that we are able to provide to you as a client of another Brokerage or REALTOR®. Therefore, any further information must be sought directly from your current REALTOR®.

        Let us find a Property to Match your Lifestyle

          Your Lifestyle Characteristics

          Are you under contract with a real estate agent or REALTOR®?

          YesNo

          You've indicated that you are currently working with a REALTOR®. Please be advised that TRESA 2002 and supporting Rules and Regulations, restricts the amount of information that we are able to provide to you as a client of another Brokerage or REALTOR®. Therefore, any further information must be sought directly from your current REALTOR®.

          Schedule Booking

            Not already working with a REALTOR®? If you are not working with a real estate agent, you can schedule a private viewing to tour this property with one of our professionals.

            Are you under contract with a real estate agent or REALTOR®?YesNo

            You've indicated that you are currently working with a REALTOR®. Please be advised that TRESA 2002 and supporting Rules and Regulations, restricts the amount of information that we are able to provide to you as a client of another Brokerage or REALTOR®. Therefore, any further information must be sought directly from your current REALTOR®.

            Are you a real estate agent or REALTOR®?YesNo

            You've indicated that you are a REALTOR® looking to schedule an appointment. This is not a Royal LePage® Burloak property and we cannot schedule showing requests. Please contact the listing agent.