ON THE WATERFRONT! TIMELESS STYLE AND ELEGANCE IN THE HEART OF OLD NORTHEAST! A rare opportunity to own the largest and most distinguished residence in the Historic Old Northeast, a truly picturesque waterfront estate, this classic Hamptons-inspired home blends traditional sophistication with modern luxury in one of the most coveted locations in St. Petersburg. Situated on Coffee Pot Bayou behind a stately brick wall, the property is surrounded by lush, manicured grounds, an expansive courtyard, pool, pool bar, basketball court, and two water lots, creating a refined coastal retreat. Originally built with meticulous craftsmanship, the home was significantly reimagined and expanded in 2005 and updated again in 2021-2024. Beyond the striking masonry and stonework, step into a grand foyer that opens to the awe-inspiring Great Hall, where soaring wood-beamed ceilings, intricate millwork, and custom stained glass set a tone of timeless luxury. Gleaming hardwood floors complement elegant wall finishes and rich architectural details throughout the home. The living room, anchored by an exquisite gas fireplace is spacious and grand, while both the formal and casual dining areas provide a seamless transition to the kitchen with view of the courtyard and water. This is a new kitchen design and space, a large pantry, a Wolf gas cooking center, and two refrigerators?perfect for both everyday living and grand entertaining. Adjacent to the kitchen, the inviting waterfront family room with fireplace connects to a light-filled library or office offering a peaceful retreat. The stadium-style theater provides a great way to unwind at the end of the day. Upstairs, the wrap-around balcony of the Great Hall showcases architectural details rarely found in Florida homes. The primary suite is a retreat within the house with a living space area featuring a sitting area with morning bar, vaulted wood-beam ceilings, a gas fireplace, and access to a covered balcony overlooking the grounds. The spa-like owner's bath has recently been updated and boasts custom finishes, dual vanities, a spa tub, a spacious walk-in shower, and dual custom closets. This exceptional home also offers a 1,300+ sq. ft. luxury guest apartment (in law quarters) with two bedrooms and two baths which can be sectioned off completely with exterior access and a dedicated garage space and laundry. This property also has a spacious executive office, a second primary suite and three additional waterfront bedrooms, all ensuite, and a host of premium amenities, 4-car garage, two upper and one lower-level laundry rooms, tankless hot water, an oversized luxury elevator, and two water lots, one with a dock and lift. Designed with ease of accessibility in mind, this waterfront estate delivers an unmatched blend of classic elegance and modern comfort.