Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Collins-Maury
Property view
Listing view 2
Listing view 3

3512 Celeste Avenue, 
Moss Point, MS 39563

$800,000


3

Beds


3

Baths


2,167

Sq Ft


Single Family


Virtual Tour

Pending

Listed by

Patrick Merrill

Coldwell Banker Smith Home Rltrs-Gautier

228-497-1800

Last updated:

March 20, 2026, 07:19 AM

MLS#

4142796

Source:

MS UNITED

About This Home

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.

Home Facts

Single Family

3 Baths

3 Bedrooms

Built in 2018

Price Summary

800,000

$369 per Sq. Ft.

MLS #:

4142796

Last Updated:

March 20, 2026, 07:19 AM

Added:

2 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

2,167 Sq. Ft.


Structure

Structure

Architectural Style:

Traditional

Building Area:

2,167 Sq. Ft.

Year Built:

2018


Lot

Lot Size (Sq. Ft):

81,457


Finances & Disclosures

Finances

Price:

$800,000

Price per Sq. Ft:

$369 per Sq. Ft.

Source:MS UNITED
The information being provided by MLS United is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 MLS United All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.