Waterfront estate offers great value for renovation or development. Located on a private oversized lot at the end of an exclusive cul-de-sac with luxurious homes, this nearly 5,500 sq ft under air and over 8,200 sq ft under roof, custom Bayfront residence offers incredible bones. Boasting over 200 feet of water frontage with breathtaking views in every direction. With mature landscaping for privacy, the tranquil property offers a private dock and boat lift on a protected cove - the perfect starting point for your boating adventures. Direct access to the Intracoastal Waterway and very close to Longboat Pass for entry to the Gulf. The one-of-a-kind two-story home is teeming with possibilities for the new owner, with high ceilings throughout and generous spaces. The first floor includes a large open living room with a soaring ceiling and fireplace, opening to a spacious kitchen and dining room with spectacular water views. Multiple sliding glass doors open to a wrap-around screened porch and lanai with a pool and spa for relaxing and savoring the picturesque panorama. A fourth bedroom, a full bath which leads to the pool area, laundry room and a yoga/workout room complete the first floor. The second floor offers an expansive master suite plus two additional guest suites - all with their own balconies. The home also has an oversized 3-garage with a lift for additional space. Don't miss this incredible opportunity to use your vision to transform this well-built home sited high on a peninsula in Hideaway Bay into the waterfront estate of your dreams.