Forgot password Extend Verify Contact

575 MARY STREET
North End Hamilton (North End) L8L 4X8

$799,999
Single Family beds: 3 baths: 2.0

Main Photo: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 1: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 2: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 3: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 4: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 5: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 6: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 7: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 8: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 9: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 10: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 11: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 12: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 13: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 14: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 15: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 16: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 17: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 18: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 19: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 20: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 21: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 22: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 23: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 24: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 25: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 26: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 27: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 28: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 29: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 30: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 31: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 32: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 33: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 34: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 35: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 36: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 37: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 38: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 39: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 40: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 41: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 42: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 43: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 44: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 45: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 46: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 47: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 48: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 49: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Photo 50: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
Status:
Active
Prop. Type:
Single Family
MLS® Num:
X12614468
Bedrooms:
3
Bathrooms:
2
Welcome to 575 Mary Street, a stunningly unique property steps from the water's edge in the north end of Hamilton, where a tight-knit family transformed a house into a home during the quiet of Covid lockdowns. Step inside this fully renovated gem, seamlessly blending modern comforts with warm, inviting spaces, all crafted by a talented Hamilton native and international artist. The artistic flair captivates, merging the natural light of the outdoors with glass, cement, and crisp whites throughout. At the heart of the home is a stunning kitchen featuring floor-to-ceiling cabinetry, a four-seater waterfall quartz island, and very likely the most interesting matching Italian porcelain flooring and backsplash combo you have ever seen. The front porch, drenched in light from two skylights, is perfect for sipping morning coffee while enjoying the sunrise. On the opposite side of the house, cozy evenings come alive by the newly installed wood-burning fireplace, which warms the all-season backyard patio designed for both entertaining and relaxing after a long day. This home also features an innovative and massive office space seamlessly integrated into the main bedroom, ideal for remote work or midnight inspiration. With HUE smart lights throughout, you can easily set the perfect mood for any occasion. In the last four years, recent upgrades include Neal installed roof coverings, a high-efficiency furnace, all new flooring, windows, all siding, main floor powder room, brand-new kitchen and laundry appliances. This means you can move in and enjoy modern living! With three spacious bedrooms plus an office, this home provides ample space for families, guests, or your creative pursuits. Plus, convenience is key with two included parking spaces and an upgraded fast-charging EV connection port already installed. Come fall in love with this art piece of a home. A space ready for some new dreamers and creative spirits! (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Living Area (Min):
1,500 sq. ft.
Living Area (Max):
2,000 sq. ft.
Zoning:
D
Taxes:
$3,390 / -
Community:
North End
Features:
Fireplace(s)
Exterior Features:
Steel, Brick
Structure Type:
House
Utilities:
Sewer, Electricity, Cable
Appliances Included:
Washer, Refrigerator, Dishwasher, Stove, Dryer, Water Heater
Bedrooms:
3
Bedrooms Above Grade:
3
Bedrooms Below Grade:
0
Bathrooms:
2.0
Half Bathrooms:
1
Cooling:
Central air conditioning
Fireplace:
Yes
Fireplaces:
1
Foundation:
Stone
Heating:
Forced air, Natural gas
# Storeys:
2.0
Water:
Municipal water
Sewer:
Sanitary sewer
Basement:
Unfinished, Full
Lot Frontage:
20'
Lot Details:
20 x 120 FT
Parking:
No Garage
Total Parking Spaces:
2
Floor
Type
Size
Other
Main level
Other
15'5" × 5'1"
-
Main level
Living room
15'9" × 15'5"
-
Main level
Dining room
12'3" × 7'10⅞"
-
Main level
Kitchen
15'5" × 11'3"
-
Main level
Family room
13'2" × 13'
-
Main level
Laundry room
8'3" × 7'9"
-
Second level
Bedroom
11'8" × 8'10"
-
Second level
Primary Bedroom
13'2" × 12'3"
-
Second level
Sitting room
12'3" × 8'10"
-
Second level
Bedroom
15'5" × 10'3"
-
Floor
Ensuite
Pieces
Other
Main level
No
-
6'10" x 5'1"
Second level
No
-
6'7" x 6'2"
  • Photo 1: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 1 of 50
  • Photo 2: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 2 of 50
  • Photo 3: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 3 of 50
  • Photo 4: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 4 of 50
  • Photo 5: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 5 of 50
  • Photo 6: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 6 of 50
  • Photo 7: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 7 of 50
  • Photo 8: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 8 of 50
  • Photo 9: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 9 of 50
  • Photo 10: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 10 of 50
  • Photo 11: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 11 of 50
  • Photo 12: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 12 of 50
  • Photo 13: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 13 of 50
  • Photo 14: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 14 of 50
  • Photo 15: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 15 of 50
  • Photo 16: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 16 of 50
  • Photo 17: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 17 of 50
  • Photo 18: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 18 of 50
  • Photo 19: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 19 of 50
  • Photo 20: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 20 of 50
  • Photo 21: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 21 of 50
  • Photo 22: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 22 of 50
  • Photo 23: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 23 of 50
  • Photo 24: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 24 of 50
  • Photo 25: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 25 of 50
  • Photo 26: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 26 of 50
  • Photo 27: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 27 of 50
  • Photo 28: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 28 of 50
  • Photo 29: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 29 of 50
  • Photo 30: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 30 of 50
  • Photo 31: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 31 of 50
  • Photo 32: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 32 of 50
  • Photo 33: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 33 of 50
  • Photo 34: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 34 of 50
  • Photo 35: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 35 of 50
  • Photo 36: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 36 of 50
  • Photo 37: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 37 of 50
  • Photo 38: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 38 of 50
  • Photo 39: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 39 of 50
  • Photo 40: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 40 of 50
  • Photo 41: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 41 of 50
  • Photo 42: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 42 of 50
  • Photo 43: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 43 of 50
  • Photo 44: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 44 of 50
  • Photo 45: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 45 of 50
  • Photo 46: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 46 of 50
  • Photo 47: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 47 of 50
  • Photo 48: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 48 of 50
  • Photo 49: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 49 of 50
  • Photo 50: 575 MARY STREET in Hamilton (North End): Single Family for sale : MLS®# X12614468
    Photo 50 of 50

Video Tour Website

Listed by CENTURY 21 HERITAGE GROUP LTD.
Data was last updated December 10, 2025 at 03:45 AM (UTC)
Area Statistics
Listings on market:
92
Avg list price:
$544,950
Min list price:
$49,444
Max list price:
$799,900
Avg days on market:
35
Min days on market:
1
Max days on market:
370
Avg price per sq.ft.:
$290.96
These statistics are generated based on the current listing's property type and located in North End. Average values are derived using median calculations. This data is not produced by the MLS® system.
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are member’s of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.