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 7 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 a 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 overlooking 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!