Exceptional architectural details & resort-style outdoor living define this custom-built Colonial, privately set at the end of a dead-end road. A gracious foyer introduces an impressive interior appointed with beautiful millwork & unexpected upgrades. The showstopper chef's kitchen with upscale marble counters & backsplash, copper sink, stainless appliances, large island & doors opening to an expansive deck overlooking the breathtaking backyard oasis. Entertain with ease in the spacious dining room, sun-drenched fireplaced family room or striking sunken living room featuring oak paneling, a coffered ceiling & striking sconce lighting. Unwind in the spacious primary suite offering a walk-in closet & luxurious bath with double vanity and oversized shower. Imagine the possibilities in the finished lower level with a generous living area, exercise room & bath with shower, while a walk-up attic offers exciting expansion potential and is already plumbed for a bath. Outside, your private retreat truly shines with an inground pool & spa surrounded by an enormous travertine patio, expansive deck, and 2 story pool house - all embraced by the privacy of the tranquil surrounding landscape. Hobbyists will appreciate the oversized attached garages with epoxy floors easily accommodating 5 vehicles PLUS additional space for storage & workspace. Certainteed fiber cement siding and PVC trim provide ease of maintenance and lasting exterior appeal. Coveted location offering easy access to nearby picturesque Sterling town center, Davis Farmland fun, Rota farm's famous ice cream, apple picking & more at Meadowbrook orchard, and commuting ease via nearby I-190 & Route 2 puts convenience within easy reach. A truly distinctive home designed for impressive entertaining and comfortable everyday living indoors and out.