Stunning custom-built home with remarkable curb appeal, offering over 5,000 sq ft of beautifully finished living space and a rare combination of size, style, and location. This exceptional 7-bedroom, 5-bathroom residence includes a spacious 3-car epoxied floor garage and is perfectly situated near top-rated schools, highways, trails, and essential amenities. Step inside to a sunlit main level featuring soaring ceilings, a large formal living and dining room with abundant natural light, and a generously sized kitchen ideal for hosting and everyday living. The upper floor boasts 4 spacious bedrooms and 3 bathrooms, providing ample space for families of all sizes. Enjoy walkouts to a private balcony and elegant architectural details throughout. The fully finished walk-out basement expands your living space with 3 additional large bedrooms, 2 full bathrooms, a full kitchen, and a sprawling family/rec room — all beneath tall ceilings that create an open, airy feel. The lower level also opens to a covered porch, offering seamless indoor-outdoor living. Outside, the backyard is a true retreat featuring a luxurious saltwater pool, ideal for summer gatherings and family relaxation. This rare offering is the complete package — space, comfort, and prime location all in one. Don’t miss your chance to make this extraordinary home your own! LUXURY CERTIFIED.
For sale
C$2,099,900
1504 Upper Sherman Ave, Hamilton, ON L8W 1C5
7beds
2,863sqft
Single Family Residence, Residential
Built in 2004
10,032 Square Feet Lot
$-- Zestimate®
C$733/sqft
C$-- HOA
What's special
Remarkable curb appealSoaring ceilingsAbundant natural lightGenerously sized kitchenPrivate balconyElegant architectural detailsFully finished walk-out basement
- 9 days
- on Zillow |
- 27 |
- 0 |
Zillow last checked: 7 hours ago
Listing updated: April 24, 2025 at 01:30pm
Listed by:
Rob Golfi, Salesperson,
RE/MAX Escarpment Golfi Realty Inc.
Source: ITSO,MLS®#: 40719198Originating MLS®#: REALTORS® Association of Hamilton-Burlington
Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 3
- Main level bedrooms: 4
Bedroom
- Level: Main
Other
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Basement
Bedroom
- Level: Basement
Bedroom
- Level: Basement
Bathroom
- Features: 2-Piece
- Level: Main
Bathroom
- Features: 5+ Piece
- Level: Basement
Bathroom
- Features: 4-Piece
- Level: Main
Bathroom
- Features: 4-Piece
- Level: Basement
Bathroom
- Description: Primary Bathroom
- Features: 5+ Piece
- Level: Main
Dining room
- Level: Main
Eat in kitchen
- Level: Main
Family room
- Level: Basement
Foyer
- Level: Main
Kitchen
- Level: Main
Kitchen
- Level: Basement
Laundry
- Level: Main
Living room
- Level: Main
Office
- Level: Main
Other
- Description: Walk-in Closet
- Level: Basement
Pantry
- Level: Main
Recreation room
- Level: Basement
Utility room
- Level: Basement
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Water Heater, Dishwasher, Dryer, Refrigerator, Stove, Washer
- Laundry: Main Level
Features
- Auto Garage Door Remote(s), In-Law Floorplan
- Basement: Walk-Out Access,Full,Finished
- Has fireplace: No
Interior area
- Total structure area: 5,253
- Total interior livable area: 2,863 sqft
- Finished area above ground: 2,863
- Finished area below ground: 2,390
Video & virtual tour
Property
Parking
- Total spaces: 8
- Parking features: Attached Garage, Private Drive Triple+ Wide
- Attached garage spaces: 3
- Uncovered spaces: 5
Features
- Patio & porch: Deck, Porch, Enclosed
- Exterior features: Awning(s), Privacy
- Frontage type: West
- Frontage length: 66.00
Lot
- Size: 10,032 Square Feet
- Dimensions: 152 x 66
- Features: Urban, Ample Parking, Business Centre, High Traffic Area, Library, Major Highway, Park, Place of Worship, Public Transit, Rec./Community Centre, Schools, Shopping Nearby
Details
- Parcel number: 169200758
- Zoning: C
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Bungalow Raised
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Foundation: Poured Concrete
- Roof: Asphalt Shing
Condition
- 16-30 Years
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Sewer (Municipal)
- Water: Municipal
Community & HOA
Location
- Region: Hamilton
Financial & listing details
- Price per square foot: C$733/sqft
- Annual tax amount: C$10,907
- Date on market: 4/17/2025
- Inclusions: Dishwasher, Dryer, Refrigerator, Stove, Washer, All Electrical Light Fixtures, All Window Coverings.
- Loading