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!