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!
Data was last updated December 10, 2025 at 03:15 AM (UTC)
Area Statistics
Listings on market:
14
Avg list price:
$599,900
Min list price:
$355,000
Max list price:
$799,900
Avg days on market:
34
Min days on market:
6
Max days on market:
418
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.
This website may only be used by consumers that have a bona fide interest in the purchase, sale, or lease of real estate of the type being offered via the website.
The data relating to real estate on this website comes in part from the MLS® Reciprocity program of the PropTx MLS®. The data is deemed reliable but is not guaranteed to be accurate.