Welcome to this exquisite French provincial mansion, a true gem nestled on a 2.8-acre waterfront property overlooking the picturesque Northport Bay. This 8000 square foot masterpiece has undergone continuous renovations over the years, ensuring its timeless elegance and modern comforts. This magnificent estate holds a rich history as the former summer residence of Raymond V. Ingersoll, the esteemed Brooklyn borough president. It also holds the distinction of being a favored retreat for Mayor Fiorello LaGuardia, who frequently found solace within its walls. As you enter through the gated entrance and cross over the private causeway, you will be greeted by the sheer beauty of this property. The gated access not only enhances privacy but also provides a sense of security, making this estate a truly exclusive oasis. With 350 feet of bulkhead and a quarter mile of private beach, the serenity of waterfront living is at your fingertips. The mansion itself offers ample space and luxury with 8 bedrooms and 3 and a half functioning bathrooms. Additionally, there is a fourth full bathroom that's in need of renovation, adding further value to this already remarkable home. Elegance and warmth permeate throughout the interior, with 4 fireplaces creating a cozy ambiance. The sunroom and screened porch provide serene spaces to relax and soak in the breathtaking views. The patio offers a perfect spot for outdoor gatherings and entertaining. One of the highlights of this estate is the spectacular study, complete with a fireplace. This space is ideal for those seeking a private sanctuary to work, read, or simply unwind. With its gated beach access to the serene Long Island Sound, this property offers the ultimate in waterfront living. Whether you seek tranquility, privacy, or a place to entertain, this French provincial mansion is a true masterpiece that seamlessly combines history, luxury, and natural beauty.