1504 Upper Sherman Avenue
Hamilton, ON
- 7 bed
- 5 bath
- approx. 2500-3000 sqft
- Detached
- 102 days on market
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.
Virtual Tour
Virtual Tour Available
Listing Details
- Taxes (2026)
- $11,400
- Originally Listed
- $1,749,900
- Listed
- June 4, 2026
Price History
Listing history
Sign in to view
Property
- Style
- Bungalow-Raised
- Age
- 16-30
- Construction
- Brick
- Roof
- Asphalt Shingle
- Foundation
- Poured Concrete
- Interior
- Auto Garage Door Remote, Brick & Beam, Built-In Oven, Carpet Free, In-Law Suite, Primary Bedroom - Main Floor
- Lot Size
- 66 x 152 Feet
Parking
- Garage
- Attached
- Covered Spaces
- 3
- Total Parking
- 8
Utilities
- Sewer
- Sewer
- Heat Source
- Gas
Location & Legal
- Cross Street
- Upper Sherman & Stone Church Rd E
- Parcel Number
- 169200758
- Possession
- Flexible
- Occupancy
- Owner
Included
- Inclusions
- Dishwasher, Dryer x2, Refrigerator x2, Stove x2, Washer x2, All electrical light fixtures, all window coverings.
- Exclusions
- Sellers personal belongings.
Schools
Secondary
- St. Jean de Brebeuf Catholic Secondary School0.2 km
Catholic · Hamilton-Wentworth CDSB · 1615 students
Grade 10 literacy: 78% met the provincial standard
- Nora Frances Henderson0.8 km
Public · Hamilton-Wentworth DSB · 1270 students
Grade 10 literacy: 67% met the provincial standard
- ÉSAC Mère-Teresa3.1 km
French Catholic · CS catholique MonAvenir · 300 students
Grade 10 literacy: 90% met the provincial standard
Elementary
- St. John Paul II Catholic Elementary School0.6 km
Catholic · Hamilton-Wentworth CDSB · 365 students
Grade 3 reading: 83% met the provincial standard · Grade 6 math: 50% met the provincial standard
- Lincoln Alexander Public School1 km
Public · Hamilton-Wentworth DSB · 210 students
Grade 3 reading: 84% met the provincial standard · Grade 6 math: 24% met the provincial standard
- St. Teresa of Calcutta Catholic Elementary School1 km
Catholic · Hamilton-Wentworth CDSB · 285 students
Grade 3 reading: 55% met the provincial standard · Grade 6 math: 71% met the provincial standard
Straight-line distance. Nearby schools are not necessarily the assigned schools — confirm catchment with the school board. Scores are EQAO provincial test results for 2024-2025.
Community
Postal area L8W
- Population
- 26,077
- Private dwellings
- 8,612
- Median age
- 38.8
- Average household size
- 3
- Median household income
- $101,000
Source: Statistics Canada, 2021 Census of Population, catalogue 98-401-X2021013. Adapted from Statistics Canada. This does not constitute an endorsement by Statistics Canada of this product.
Local market
Residential Freehold in Hamilton · last 12 months
- Median sold price
- $680,000
- Homes sold
- 4,942
- Median days on market
- 27
- Sale-to-list price
- 97.1%
Based on 4,942 recorded sales of residential freehold properties in Hamilton over the last 12 months.
Rooms
4-piece on Main, 5-piece on Main, 2-piece on Main, 5-piece on Basement, 4-piece on Basement
Main
- Bathroom5'5" x 4'10"
- Bathroom13'9" x 11'
- Bathroom9'9" x 10'1"
- Bedroom13'5" x 12'
- Bedroom9'9" x 11'11"
- Bedroom13'5" x 12'3"
- Dining Room13'11" x 13'1"
- Foyer7'7" x 17'
- Kitchen11'10" x 14'5"
- Kitchen11'10" x 14'5"
- Laundry12'9" x 9'1"
- Living Room13' x 30'
- Office8' x 8'6"
- Pantry7'11" x 5'4"
- Primary Bedroom13'9" x 25'3"
Basement
- Bathroom13'5" x 8'
- Bathroom7'7" x 4'9"
- Bedroom19'1" x 11'4"
- Bedroom13'1" x 26'
- Bedroom19'5" x 10'7"
- Family Room21'4" x 14'5"
- Recreation
- Utility Room15'7" x 16'8"
Listed by
BOLDT REALTY INC., BROKERAGE
Walk Score
Walk Score is unavailable for this address right now.
Location
Street View
Mortgage Calculator
$339,980
Estimated Monthly Payment
$8,351
Land transfer tax
Ontario land transfer tax only. An estimate — not legal or financial advice. Municipal land transfer tax applies in Toronto and is not included.
Investment Analysis
No recent nearby lease data. Enter a rent to see the numbers.
Mortgage: $8,351/mo (20% down, 5.5%)
Taxes: $950/mo · Insurance: $425/mo
Estimates only. Consult a financial advisor.
Reita | Assistant
Online
Reita is an automated assistant, not a licensed real estate agent. This listing mentions Perfect for extended family, guests, or in-law potential, this level offers privacy without sacrificing openness and comfort.. I can help you explore neighbourhoods, understand the market, and find our free tools. What are you looking for?