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.
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
- 91 days
- 26
- 2
Zillow last checked:
Listing updated:
Listed by:
BOLDT REALTY INC., BROKERAGE
Source: TRREB,MLS®#: X13240042
Originating 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
Price history
Price history is unavailable.
Public tax history
Tax history is unavailable.
Climate risks
Neighborhood: Butler
Nearby schools
GreatSchools rating
No schools nearby
We couldn't find any schools near this home.





