Amazing rare find waterfront condo location that is truly a diamond in the rough with a million dollar view! Although this condo needs some TLC and updating it's located on the water with an open-air patio overlooking Lake Pontchartrain for breathtaking views! New roof May 2025 and new A/C condensor unit May 2026; excellent location for commuters situated at the foot of the Causeway Bridge, there aren't many places where you can live on the water and not be mandated to carry flood insurance with a mortgage but here it is! Located in preferred flood zone X and has never flooded; 9-ft ceilings throughout and no carpet; two fireplaces: one with gas starter in the living room and one that's wood-burning in the primary bedroom; both large bedrooms are upstairs each with a full bath, walk-in closet, and balcony; the primary bedroom balcony overlooks the lake for that million dollar view! Much of the interior has been newly painted but the condo still needs some love and updating plus some windows are fogged but the potential is tremendous and a definite choice waterfront location! Seller is motivated... condo dues are $475/month which include structure insurance, exterior and common area maintenance, lawn care, water/sewer/garbage services, and termite contract; the buyer would need an H-06 condo insurance policy for interior and contents coverage; the property is being sold in its as-is condition, refrigerator stays with the property