Indulge in the rare opportunity to call this stunning waterfront home in Heron Bay your own. As you enter, the soaring ceilings and luxurious spiral staircase will surely captivate both you and your esteemed guests. The yard is a serene oasis, featuring a tranquil koi pond, a relaxing hot tub, and ample space for entertaining. The kitchen and butler's pantry offer abundant storage, a convenient island, and a charming breakfast nook. The adjacent dining room opens up to an exterior alcove adorned with a soothing water feature. The downstairs bedroom is perfect for accommodating in-laws or creating a home gym. Upstairs, an open loft provides a versatile space in an intimate living area, home office, or possible 5th bedroom. The expansive and opulent primary suite encompasses the entire width of the home, offering a cozy fireplace and breathtaking views of the bay. The remodeled spa-like primary bath exudes sophistication, featuring a standalone tub, a frameless shower door, and separate vanities. Continuing down the hall, you'll discover another ensuite with a tastefully remodeled shower, as well as two additional secondary bedrooms and a spacious hall bath. This tranquil retreat is perfectly situated, with easy access to I-880 and I-92, the San Leandro Marina, dining and shopping!