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!
Single-familyProperty Type
2 spacesParking
Listed by MIGUEL LIMA• CENTURY 21 HERITAGE GROUP LTD.
Source:TREB #X12614468
Market trends in North End East, ON
Last updated October 2026
Sale-to-list price
--
Median sale price
--
Avg. days on market
--
Recently sold homes
--
Provided by Redfin
Sale history for 575 Mary St
Date
Event
Price
TREB #X12614468
Jun 6, 2026
Delisted
—
Dec 9, 2025
Listed
$799,999
+45
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!
TREB #X12204873
Dec 2, 2025
Delisted
—
Jun 6, 2025
Listed
$849,900
+45
Welcome to 575 Mary Street, a stunningly unique property steps from the waters 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, and 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!
As the MLS and public records start to fill up, we'll list the details here.
Property details
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
Region: —
Home facts updated by public records on Aug 9, 2023
Around this home
Schools
0.3km
St. Lawrence Catholic Elementary School
Public, JK-8 • Assigned
1.9km
Sir John A MacDonald Secondary School
Public, 9-12 • Assigned
Provided by Local Logic
Lifestyle
Provided by Walk Score and Local Logic
Sell confidently with a local market expert in Hamilton. 3 minutes to get started.
Nearby similar homes
Sorry, we don't have any nearby similar homes to display. See all homes for sale in North End East