Welcome to this exceptional 6-bed, 5-bath residence offering stunning waterfront views, ideally located on a quiet street in highly sought-after South Aldershot. Designed for multi-generational living, this versatile home features a fully self-contained main-floor in-law suite with its own private entrance, backyard, kitchen, laundry, vaulted ceilings, & cozy gas fireplace.The main residence impresses with outstanding curb appeal, beautifully landscaped gardens, an interlock & stone walkway & breathtaking bay waterfront views right from your front seating area. Inside, the main floor showcases tile flooring, a thoughtful layout, & an updated custom kitchen complete with stainless steel appliances, quartz countertops, & a bright, sitting area. The formal living & dining features hardwood floors, a wood fireplace, & a wall of windows that perfectly frame the spectacular water views. Updates include new downstairs furnace (2025), upstairs furnace (2023), kitchen remodel (2024), all bathrooms updated (2024), New roof, soffit/ fascia (2020), fresh paint, updated light fixtures & more. The second level features four spacious beds all with water views, including a large primary suite with a spa-style ensuite bath. The lower level features an additional bed, expansive rec room, dedicated gym space, bonus den, & generous laundry with built-in cabinetry, offering flexibility for future use, including the potential for a 3rd kitchen. Outdoor living is impressive, with a spacious fully fenced main backyard offering a deck, pergola with shade, & a beautifully landscaped, expansive patio ideal for entertaining or relaxing. The garage has an unfinished loft space above, offering potential for additional living area to complement the in-law suite. Enjoy city living with lake views, just an 8-min drive to GO Station. 5 min drive to LaSalle Marina & Park, 11 min drive to Spencer Smith Park. A truly one-of-a-kind opportunity to live by the water while enjoying all modern amenities.