Welcome to 417 Union Street, an exceptional modern home nestled in the heart of prestigious Old Oakville. Completed in 2023, this one-of-a-kind residence blends modern farmhouse inspiration with refined contemporary and traditional design elements, creating a home that is both striking and timeless. The modern farmhouse exterior showcases clean lines, black-framed windows, and a harmonious mix of materials, complemented by a covered porch, professionally landscaped front and back yards, and a stone six-car driveway. The backyard offers a private retreat with a deck, stone patio, and custom garden shed. Inside, the home is filled with natural light and defined by a modern, sleek interior. Wide-plank engineered hardwood flooring, custom ceilings with integrated LED lighting, and large-format matte tiles elevate the main living areas. The chef-inspired kitchen features quartz countertops and backsplash, an oversized centre island, built-in Bosch appliances, and a convenient adjoining servery. A tiered maple staircase with glass railings leads to the upper level, where skylights continue the home's bright and airy feel. The expansive primary suite spans over 700 square feet and offers two walk-in closets and a luxurious five-piece ensuite with double vanity, freestanding tub, and glass-enclosed rainfall shower. Three additional bedrooms each include their own custom three-piece ensuite with modern walk-in showers. The fully finished lower level adds outstanding versatility with a second kitchen, large recreation room, two additional bedrooms with ensuites, and a powder room. Additional highlights include an elevator servicing all three levels, 10-ft ceilings on the main and lower levels, pot lights, blackout blinds, built-in speakers, and a security system. Ideally located minutes from Lake Ontario, parks, trails, Oakville GO, the QEW, and top-ranked schools including Appleby College, this home delivers modern luxury, thoughtful design, and an exceptional lifestyle.