A stunning and truly unique custom-built residence designed with exceptional flexibility, accommodating up to three families! With nearly 4,000 sqft of above-grade space plus a fully finished in-law basement, this impressive home features 5+2 bedrooms, 7 bathrooms and 3 kitchens. One wing showcases an updated 2-storey layout complete with 3 bedrooms, 2.5 bathrooms, and an oversized double garage. This section also offers 2nd-floor laundry, an office/flex room, a living room with built-ins & a gas FP, and a chef's kitchen equipped with a large island, new pendant lighting, quartz countertops, pot filler & wine fridge. The primary suite includes a w/i closet and a 5-piece spa-like ensuite with heated floor. The other wing is a well-appointed bungalow featuring 2 bedrooms, 1.5 bathrooms, a full kitchen, a living room, and its own laundry and access to a single-car garage. Perfect for extended family or in-law living, this space can function independently or seamlessly connect with the main home for larger households. Both living areas have their own front entrances and walkouts to the deck o/looking the fully fenced backyard oasis, complete with a new in-ground heated salt pool ('25) featuring colour-changing LED lighting and cover. The huge finished basement offers even more versatility, with a separate entrance and interior access from both sides of the home. It includes a third kitchen, 2 bedrooms, 2 full bathrooms, 2 bonus rooms, its own laundry, 4 storage rooms, and 2 cold rooms. Additional highlights include updated red oak engineered flooring, freshly painted (some areas), a detached single garage and a generous workshop, plus 2 furnaces and 2 air conditioners for added comfort. Set on a large 86 'x 175' lot in a sought-after Stoney Creek neighbourhood near the escarpment. Close to schools, parks, shopping, highway access, and just minutes from the upcoming Centennial GO Station. A rare opportunity to own a home of this scale and versatility—make it yours!