3512 Celeste Avenue WATERFRONT LUXURY WITH MILLION-DOLLAR VIEWS--WITHOUT THE PRICE TAG Built in 2018 and strategically positioned on nearly 2 acres of pristine waterfront, this property delivers a rare combination of privacy, functionality, and unforgettable scenery. With approximately 297 feet of bulkheaded shoreline, two boat lifts, and extensive docking, this is a turnkey setup for serious water enthusiasts. From the moment you arrive, the setting separates itself--mature oak and magnolia trees draped in moss create a true Southern backdrop, while the home is perfectly placed to capture sweeping water views from nearly every angle. Inside, the home continues to outperform expectations. Featuring 3 bedrooms, 2.5 baths, and a versatile bonus room that can easily convert into a 4th bedroom, office, or private study, the layout is both functional and flexible. Custom cabinetry, hardwood flooring, and a thoughtfully designed floor plan elevate the overall finish, while large windows pull the outside in. Operational efficiency meets convenience with a spacious laundry room offering ample storage, plus a 2-car garage with an additional bay ideal for a golf cart or lawn equipment. On the rear elevation, custom hurricane shutters provide peace of mind without compromising the view--because the view is the asset. And it's a showstopper. The kind of waterfront exposure typically reserved for multi-million-dollar properties. Adding even more upside, the detached structure opens the door to multiple revenue or lifestyle plays--use it as a workshop, storage, guest quarters, or transform it into a full mother-in-law suite or income-producing apartment. With an existing enclosed room, loft space, sink, and additional features already in place, the framework is there. Bottom line: properties with this level of privacy, acreage, water frontage, and infrastructure rarely hit the market--especially at this price point. If you've been waiting for a waterfront opportunity that actually delivers on value, this is it.