This stunning lakeview property offers exceptional flexibility with three fully self-contained living spaces - each featuring its own kitchen, living room, bathroom, laundry, and private entrance. With approximately 6,000 sq. ft. of finished interior space (~2,450 sqft main level, ~1,250 sqft second level, and ~2,300 sqft lower level), there is room for extended family, multi-generational living, guests, or potential income possibilities. The impressive main level has been extensively renovated with quality finishes throughout, featuring a custom kitchen with oversized island, granite and quartz countertops, engineered flooring, fully updated bathrooms, custom staircase detailing, professional paintwork, upgraded trim, enhanced insulation, and modern lighting. Three generous bedrooms are located on the main floor, including a beautifully redesigned primary retreat with a luxurious 4-piece ensuite. A bright, spacious, and inviting living room is warmed by a natural gas fireplace, while the dining area captures peaceful views of mature trees and open waters of Lake Lisgar. Outside, the paved driveway offers abundant parking, and the oversized double garage provides excellent additional space for vehicles, storage, hobbies, or workshop use. Special R-1 zoning permits in-home care clients, adding even more versatility to this unique property. This is an exceptional opportunity that must be seen to be fully appreciated.