A rare water-to-water estate in Crane Road Estates, set on approximately 1.7 manicured acres. This John Hall custom masonry residence with five bedrooms and seven baths pairs a signature Aquascapes pond at the front approach with panoramic exposure to the neighborhood's four-acre community pond at the rear, one of only six interior lots with frontage on the community pond. A two-story foyer with sweeping staircase opens to luminous formal rooms and a vaulted great room, each oriented to the water. The kitchen integrates a Viking professional range, Sub-Zero refrigeration, expansive island, and floor-to-ceiling pantry cabinetry, flowing to a window-wrapped dining room with trussed ceiling, masonry fireplace, and terrace access. The main-floor primary suite forms a private wing, featuring a refined tray ceiling and glass-lined sitting area with uninterrupted views across the pool to the rear pond, continuing to a spa bath with soaking tub, oversized shower, dual vanities, and a custom walk-in closet. Also on the main level, a richly detailed library and stately family room anchor the north wing and offer architectural separation, flexibility, and private exterior access, while a spacious mudroom and laundry complete the floor. Upstairs, three en-suite bedrooms all enjoy pond views, including one with a Juliet balcony, and are joined by an approximately 700 square foot fifth bedroom or additional suite. A finished third floor adds more than 600 square feet of flexible studio, guest, or play space. The sun-filled lower level offers large windows, a generous recreation area, pub-style wet bar, fireside lounge, dedicated gym, ample storage and workshop space, plus a full bath and a powder room. Outdoors, limestone balustrade terraces and stairs descend to a heated pool and raised spa within a broad, fenced court, framed by sweeping lawn and mature landscaping leading to the fountain beyond. Recent updates include a premium roof completed in 2023 and exterior paint and seal completed in 2025. Four-car side-load garage. Part of St. Charles CUSD303 and zoned for Wild Rose Elementary, Thompson Middle, and St. Charles North High School, and minutes to downtown St. Charles dining, shops, and the riverwalk.