An extraordinary waterfront estate at the tip of the peninsula, this iconic Mediterranean residence commands nearly 200 feet of direct open water frontage in Tierra Verdes coveted Sands Point community. Known as the Magic Mike House for its on screen cameo in the film, the property offers sweeping views of the bay and the dramatic silhouette of the Sunshine Skyway Bridge. Behind private gates, this walled compound features a rare separate guest casita. Showcasing timeless sophistication, meticulous craftsmanship, and rare amenitiesincluding two elevatorsthis residence blends refined architectural details with expansive entertaining spaces to deliver coastal luxury reimagined for modern living. Step into the dramatic great room featuring soaring two story ceilings, Saltillo tile flooring, breathtaking views, and a striking limestone fireplace that flows seamlessly to dining and lounge areas with an impressive concave window offering panoramic bay vistas. The expansive living level includes dual offices or flex space, a primary suite wing with a stunning custom dual closet and dressing area, an indulgent bath with a walk in shower, and a private waterfront terrace. A well appointed media room with surround sound, wet bar, and beverage station complements the main level. Private spaces on the upper level include a grand guest quarter (casita) with a separate elevator, two en suite guest bedrooms, a living room, dining space, a secondary bar and lounge, and a second laundryproviding exemplary accommodations for extended family or guests. There is an additional bonus room on the upper level, along with two additional guest bedrooms, each with access to the waterfront terrace and rooftop for 360 degree vistas. Outdoors, experience private resort level allure with a heated saltwater pool and spa, accessible via dual staircases. The ground level wet bar and covered lanai offer exceptional poolside dining and entertaining areas. Engage with abundant marine life while preparing for a glorious day on the open water from a full service dock. Additional appointments include impact rated doors and windows, dual elevators, an Elan Smart Home System, automated window treatments, a whole home generator, Lutron lighting, a water purification system, a 5+ car garage, a portico, and exterior video security. Close to the countrys top rated beaches, Tierra Verde Marina, Shell Key, and 15 minutes to Downtown St. Petersburg, with the very best of the areas sports venues, shopping, dining, and recreation mere minutes away. Boasting easy access to the Gulf in this revered coastal location, the ultimate Florida waterfront lifestyle awaits.