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 with hois and a newly renovated dock" making it simple to launch, lift 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. Tremendous space and waterfront setting make this a standout value. Some updates are needed and the property is being sold As-Is.