Skip main navigation
For sale
  • C$1,749,900

    1504 Upper Sherman Ave, Hamilton, ON L8W 1C5

    7beds
    5baths
    Single Family Residence
    Built in ----
    10,032 Square Feet Lot
    $-- Zestimate®
    C$--/sqft
    C$-- HOA

    What's special

    Striking exteriorImpressive curb appealSoaring ceilingsThoughtfully designed kitchenCovered lower patioMultiple outdoor living spaces
    Welcome to this exceptional custom-built residence offering over 5,200 sq. ft. of beautifully finished living space in one of Hamilton Mountain's most desirable neighbourhoods. Combining luxury, versatility, and outstanding functionality, this impressive 7-bedroom, 5-bathroom home is ideal for large families, multi-generational living, or those who love to entertain. A striking exterior, triple-car garage with epoxy flooring, and impressive curb appeal create a memorable first impression. Inside, soaring ceilings and expansive windows fill the home with natural light, highlighting the spacious principal rooms designed for both everyday living and elegant gatherings. The thoughtfully designed kitchen serves as the heart of the home, offering ample space for family meals and entertaining alike. The upper level features four generously sized bedrooms and three bathrooms, including a spacious primary retreat designed for comfort and privacy. Elegant architectural details and quality craftsmanship can be found throughout. The fully finished walk-out lower level provides exceptional flexibility with three additional bedrooms, two full bathrooms, a second kitchen, and expansive living and recreation spaces. Perfect for extended family, guests, or in-law potential, this level offers privacy without sacrificing openness and comfort. Step outside to your private backyard oasis featuring a stunning saltwater inground pool, creating the perfect setting for summer entertaining, family gatherings, or peaceful relaxation. The covered lower patio and multiple outdoor living spaces enhance the home's resort-like atmosphere. Ideally located close to top-rated schools, parks, golf courses, hospitals, shopping, public transit, and major highway access, this remarkable property delivers the perfect balance of luxury, convenience, and lifestyle. A rare opportunity to own a home of this size and calibre in an exceptional location.
    44 days
    |
    11
    |
    0
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    BOLDT REALTY INC., BROKERAGE

    Source: TRREB,MLS®#: X13240042MLS LogoOriginating MLS®#: Niagara Association of REALTORS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 7
      • Bathrooms: 5
      Primary bedroom
      • Level: Main
      • Dimensions: 4.19 x 7.7
      Bedroom
      • Level: Basement
      • Dimensions: 5.82 x 3.45
      Bedroom
      • Level: Basement
      • Dimensions: 3.99 x 7.92
      Bedroom
      • Level: Main
      • Dimensions: 4.09 x 3.66
      Bedroom
      • Level: Main
      • Dimensions: 2.97 x 3.63
      Bedroom
      • Level: Main
      • Dimensions: 4.09 x 3.73
      Bedroom
      • Level: Basement
      • Dimensions: 5.92 x 3.23
      Bathroom
      • Level: Main
      • Dimensions: 1.65 x 1.47
      Bathroom
      • Level: Basement
      • Dimensions: 4.09 x 2.44
      Bathroom
      • Level: Main
      • Dimensions: 4.19 x 3.35
      Bathroom
      • Level: Main
      • Dimensions: 2.97 x 3.07
      Bathroom
      • Level: Basement
      • Dimensions: 2.31 x 1.45
      Dining room
      • Level: Main
      • Dimensions: 4.24 x 3.99
      Family room
      • Level: Basement
      • Dimensions: 6.5 x 4.39
      Foyer
      • Level: Main
      • Dimensions: 2.31 x 5.18
      Kitchen
      • Level: Main
      • Dimensions: 3.61 x 4.39
      Kitchen
      • Level: Main
      • Dimensions: 3.61 x 4.39
      Laundry
      • Level: Main
      • Dimensions: 3.89 x 2.77
      Living room
      • Level: Main
      • Dimensions: 3.96 x 9.14
      Office
      • Level: Main
      • Dimensions: 2.44 x 2.59
      Pantry
      • Level: Main
      • Dimensions: 2.41 x 1.63
      Recreation
      • Level: Basement
      • Dimensions: 5.89 x 13.28
      Utility room
      • Level: Basement
      • Dimensions: 4.75 x 5.08
      Heating
      • Forced Air, Gas
      Cooling
      • Central Air
      Appliances
      • Included: Built-In Oven
      Features
      • In-Law Suite, Primary Bedroom - Main Floor
      • Flooring: Brick & Beam, Carpet Free
      • Basement: Finished with Walk-Out,Full
      • Has fireplace: Yes
      • Fireplace features: Natural Gas
      Interior area
      • Living area range: 2500-3000 null
      Video & virtual tour

      Property

      Parking
      • Total spaces: 8
      • Parking features: Private Triple, Garage Door Opener
      • Has garage: Yes
      Features
      • Has private pool: Yes
      • Pool features: Salt Water, In Ground
      Lot
      • Size: 10,032 Square Feet
      • Features: Arts Centre, Golf, Hospital, Library, Place Of Worship, Public Transit
      Details
      • Additional structures: Fence - Full
      • Parcel number: 169200758

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Bungalow-Raised
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Poured Concrete
      • Roof: Asphalt Shingle

      Utilities & green energy

      • Sewer: Sewer

      Community & HOA

      Community
      • Security: Smoke Detector(s)
      Location
      • Region: Hamilton

      Financial & listing details

      • Annual tax amount: C$11,400
      • Date on market: 6/4/2026
      BOLDT REALTY INC., BROKERAGE

      BOLDT REALTY INC., BROKERAGE

      By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

        Price history

        Price history is unavailable.

        Public tax history

        Tax history is unavailable.

        Climate risks

        Neighborhood: Butler

        Getting around

        55 / 100
        Somewhat Walkable
        50 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        No schools nearby

        We couldn't find any schools near this home.

        Similar homes