Come see luxury at its finest! The waterway mansion you have been waiting for!! Beautiful and upgraded, Gated Estate sits directly on the Intracoastal Waterway! With over 230 ft of Water Frontage, this home is on three combined lots for a total of approximately 1.46 acres has 8 Bedrooms, 8 Full Bathrooms, and 2 Half Baths. This estate is the largest home in CCAR MLS History with approximately 15,000 Heated Square Feet plus an additional 2500 Heated Square Footage from Detached Garage. Perfect for keeping your luxury vehicles enclosed, entertainment space or extra storage area. All Newer HVAC Units, Double Masters Upstairs with Large Walk in Custom Closets, Tiled showers, Elevator and a true full Mother in Law suite downstairs. Mother in Law Suite Features two bedrooms, full living room, full kitchen and has Intracoastal Waterway Views as well. There is Parking and a Door Entry for easy access to the MIL Suite. Not only is there a game room for entertainment, but a full area for a gym, a Movie Theatre/Media Room recently upgraded, and a gorgeous Sunroom with Waterway Views. Outside there is black iron fencing, with beautifully landscaped yard, three gates and 3 car garage controlled via an App from your phone! The indoor heated pool with hot tub is a great feature for Summer or Winter time! The outdoor hot tub overlooks the waterway where the large covered deck with two jet ski lifts and boat lift sits. Come enjoy the Waterway Lifestyle! Once in a lifetime opportunity that can never be replicated. Check out the virtual tour! Listing agent must be present at all showings. Contact Agent for more information! Buyer to verify all square footage. Voluntary HOA!