Welcome to 990 HAIST Street, this exceptional 5 bedrooms, 2-storey executive home, thoughtfully renovated to combine timeless architectural charm with modern sophistication. Perfectly positioned on a pristine 100' x 200' lot backing onto a serene wooded backdrop, this distinguished property offers unmatched privacy and tranquility in one of Niagara's most coveted communities. From the moment you enter, a dramatic vaulted ceiling and open second-storey gallery create a striking first impression. The formal living room is a showcase of elegance, featuring engineered hardwood flooring, custom wainscoting, and exquisite trim, bathed in natural light from oversized windows. At the heart of the home lies a chef-inspired kitchen, adorned with quartz countertops and full-height backsplash, premium stainless steel appliances and a charming breakfast bar. The adjacent family room is designed for comfort and connection, boasting a floor-to-ceiling stone feature wall, gas fireplace, and expansive windows with stunning views of the manicured rear yard. A sliding walkout leads to a brand-new stone and concrete patio-ideal for outdoor living and entertaining. The formal dining area offers custom serving cabinetry, quartz counters, and a wine fridge, creating a seamless space for gatherings both intimate and grand. A versatile main-floor office or fifth bedroom, along with a beautifully updated powder room, completes the main level. Upstairs, the loft-style bedroom with dual closets and skylights joins two additional well-sized bedrooms and a beautifully appointed 4-piece bath. The primary suite is a luxurious escape, complete with a private balcony overlooking the wooded yard, and a spa-worthy 5-piece ensuite with freestanding soaker tub, walk-in tiled shower, dual vanities, and heated floors. The finished lower level offers added living space with luxury H-wood flooring, a fireplace, and a sleek 3-piecebathideal for a home theatre or guest suite. Step inside and see!