Exquisite Waterfront Colonial in Lake St. Clair's Premier Lottivue Community! Welcome to this stunning open-concept colonial offering 6,195 sqft of beautifully finished living space, including a fully finished lower level, perfectly situated in the finest waterfront community on Lake St. Clair. Step inside to find a gorgeous updated kitchen with a vaulted ceiling, functional island workspace, and high-end appliance package, seamlessly flowing into the formal dining room and great room-ideal for entertaining and everyday living. Hardwood floors run throughout the home, enhancing its timeless elegance. Two beautifully appointed his-and-her offices provide exceptional work-from-home flexibility, while two interior balconies flood the home with natural light and offer stunning architectural detail. Retreat to the luxurious master suite, complete with a spa-like updated bath and an impressive 18-foot walk-in closet. Nearly all-new windows (90%), new furnace and A/C, and a tankless hot water heater ensure modern comfort and efficiency. Enjoy outdoor living on brand-new, maintenance-free TREX decks, surrounded by fresh new landscaping. A small hand davit at the canal adds convenience for boating enthusiasts. The finished basement, completed just four years ago, is an entertainer's dream-featuring a media area with projection TV, custom bar, full bathroom, and dedicated workout space. This home has been thoughtfully updated and meticulously maintained-offering luxury, functionality, and an unparalleled lifestyle on the lake. Sale subject to seller obtaining home of choice.