Set on navigable waterfront in The Inlets (a gated community near a golf course), this exceptionally spacious brick home sits on two prime waterfront lots and is designed for big living and even bigger entertaining. Inside you'll find 5 bedrooms and 4 full baths, plus a large bonus room (approximately 16.4X19) and excellent storage throughout. The oversized kitchen is a true gathering hub with granite countertops, stainless appliances, a 5-burner gas range, multiple ovens and two dishwashers, opening to a formal dining area. The main living area features a vaulted ceiling, gas fireplace and wet bar, creating an easy flow for hosting. The downstairs primary suite offers wood floors, a huge built-out closet, double vanities, a jetted tub and a separate shower. Upstairs includes an additional study/loft area and flexible space for work, guests or hobbies. Outdoors is where this property truly shines: enjoy an enclosed sunroom, deck, a boathouse and store your boat and be minutes from fishing in Lake Pontchartrain. Conveniently located minutes from I-10, this home offers rare size, setting and upside. (Hoist system needs rebuild). Tremendous space and waterfront setting make this a standout value. Home needs some updates/repairs, including a new kitchen sink and a master-bath faucet replacement, plus other cosmetic improvements. Property is priced accordingly and sold As-Is.