Absolutely stunning custom-built waterfront home on an exceptional 75 x 314 ft lot in Pickering's prestigious Rosebank community, featuring 23 feet of frontage on the Rouge River. This impressive 2-storey detached residence offers approximately 5,000 sq ft of beautifully designed living space, including a fully finished walkout basement with home theatre, gym, and steam room. The main floor showcases a bright open-concept layout with dramatic floor-to-ceiling bi-fold glass doors throughout, seamlessly connecting the interior to the resort-style backyard with luxury pool setting, mature treetops, and breathtaking Rouge River views. Designer AYA kitchen features a massive centre island, premium Miele stainless steel appliances, custom cabinetry, and a spacious walk-in pantry with additional prep area, sink, and built-ins. Elegant family room with stunning brick fireplace, oversized dining area, and rare indoor barbecue lounge with soaring 20-ft cathedral ceilings, exposed wood beam, wood-burning stove, and walkout to the pool area. Main floor also includes a private home office with AYA custom built-in desk and cabinetry. Upper-level features 3 spacious bedrooms, including a luxurious primary retreat overlooking the Rouge River with spa-inspired 5-piece ensuite, glass shower, freestanding tub, two-way fireplace, sitting area, oversized walk-in closet with custom built-ins, and ample space for king-size furnishings. Over $250,000 spent on professional landscaping and interlocking throughout the front, side, and rear grounds. Resort-inspired backyard features an $200,000 custom pool and hot tub built with insulated ICF construction and concrete finish. Located in one of Pickering's most exclusive waterfront communities, close to Rouge National Urban Park, top-rated schools, waterfront trails, GO Transit, and Highway 401.