Situated in South Burlington's "Little Ireland" neighbourhood, this exceptional property features three distinct living areas, each with its own kitchen, offering outstanding flexibility for multi-generational living or work-from-home versatility. Extensive upgrades have been completed throughout the home, including the newly renovated main floor. All levels showcase updated lighting, flooring, doors, baseboards, and trim, while every bathroom has been beautifully renovated. Custom closet built-ins in the bedrooms and basement provide exceptional storage and organization. The main floor kitchen offers custom cabinetry, matte porcelain countertops, coffee bar, numerous deep drawers and an open-concept layout flowing seamlessly into the family room with fireplace. The ceilings in the kitchen, family room, living room, and dining room have all been replaced, with pot lighting added throughout the main floor. The upper-level living space can be accessed through a separate entry via the garage or through lockable interior doors, allowing the area to function independently or remain connected to the main home. Complete with its own kitchen, living room, bedroom, full bathroom, and laundry area, the space is ideal for a home office, studio, or independent living arrangement.The fully finished basement includes a living area, bedroom, 3-piece bath, kitchen, 2nd laundry room, and heated floors in both the kitchen and bathroom for added comfort. Significant capital improvements include the furnace, 200-amp electrical service with buried hydro lines, high-capacity water tank, basement waterproofing, high-capacity sump pump with backup battery and backflow valve, as well as updated siding, roof, stone patio, stone front porch, and professionally stained brick exterior. This truly unique, move-in-ready property offers exceptional functionality, quality upgrades, and long-term value. Homes with this level of versatility rarely come to market.