Escape the ordinary at 518 Lakeview Avenue — a one-of-a-kind home nestled on over 3 acres of land with both MU-2 and residential zoning, offering endless potential for extended family living, rental income, or home-based businesses. This spacious and updated 5-bedroom, 2-bathroom home features soaring vaulted ceilings, a bright and open-concept layout, and an in-law suite with a walkout on the lower level. The main floor welcomes you with a stunning great room featuring a cozy new WETT-certified woodstove, a sun-drenched sunroom, and a large kitchen with center island — perfect for entertaining. The primary bedroom is conveniently located on the main floor as well as a spa-inspired 4pc bathroom with a whirlpool tub and separate tile shower. A curved staircase leads to the upper level where you'll find two additional bedrooms and extra space for growing families or guests. Downstairs, the walkout lower level includes a second kitchen, two more bedrooms, a full bathroom, laundry/mudroom, and abundant storage — ideal for multi-generational living or income potential. Outdoors, enjoy the privacy and beauty of your own natural oasis: mature trees, a large pond perfect for winter skating and a detached garage. Upgrades include a new propane boiler and tankless hot water heater, water treatment, new washer/dryer, new fridge/cooktop and more. Just minutes from Springfield Lake Beach Park, local recreation facilities, and the full range of amenities in Sackville — this property combines space, flexibility, and location in one incredible package.