Deprecated: Creation of dynamic property kvCORE\Actions::$agentPageId is deprecated in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/class-actions.php on line 228

Warning: Undefined variable $includeSoldData in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/class-listing.php on line 94
Listing Detail - Nashville Home and Farms

Warning: Undefined variable $use_cell in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Warning: Undefined variable $use_work in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Warning: Undefined variable $use_direct in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Warning: Undefined array key "soldFields" in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 898

Warning: Trying to access array offset on value of type null in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 898

Warning: Trying to access array offset on value of type null in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 898

Warning: Undefined variable $use_cell in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Warning: Undefined variable $use_work in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Warning: Undefined variable $use_direct in /home/u972523473/domains/nashvillehomeandfarms.com/public_html/wp-content/plugins/insiderealestate-kvcore-wordpress-plugin-de6a09df3454/includes/kvcore/shortcode/class-listing-detail.php on line 251

Moss Point, MS 39563 3512 Celeste Avenue

Pending
3512 Celeste Avenue Moss Point, MS - Image 13512 Celeste Avenue Moss Point, MS - Image 23512 Celeste Avenue Moss Point, MS - Image 3
49 more
3512 Celeste Avenue Moss Point, MS - Image 43512 Celeste Avenue Moss Point, MS - Image 53512 Celeste Avenue Moss Point, MS - Image 63512 Celeste Avenue Moss Point, MS - Image 73512 Celeste Avenue Moss Point, MS - Image 83512 Celeste Avenue Moss Point, MS - Image 93512 Celeste Avenue Moss Point, MS - Image 103512 Celeste Avenue Moss Point, MS - Image 113512 Celeste Avenue Moss Point, MS - Image 123512 Celeste Avenue Moss Point, MS - Image 133512 Celeste Avenue Moss Point, MS - Image 143512 Celeste Avenue Moss Point, MS - Image 153512 Celeste Avenue Moss Point, MS - Image 163512 Celeste Avenue Moss Point, MS - Image 173512 Celeste Avenue Moss Point, MS - Image 183512 Celeste Avenue Moss Point, MS - Image 193512 Celeste Avenue Moss Point, MS - Image 203512 Celeste Avenue Moss Point, MS - Image 213512 Celeste Avenue Moss Point, MS - Image 223512 Celeste Avenue Moss Point, MS - Image 233512 Celeste Avenue Moss Point, MS - Image 243512 Celeste Avenue Moss Point, MS - Image 253512 Celeste Avenue Moss Point, MS - Image 263512 Celeste Avenue Moss Point, MS - Image 273512 Celeste Avenue Moss Point, MS - Image 283512 Celeste Avenue Moss Point, MS - Image 293512 Celeste Avenue Moss Point, MS - Image 303512 Celeste Avenue Moss Point, MS - Image 313512 Celeste Avenue Moss Point, MS - Image 323512 Celeste Avenue Moss Point, MS - Image 333512 Celeste Avenue Moss Point, MS - Image 343512 Celeste Avenue Moss Point, MS - Image 353512 Celeste Avenue Moss Point, MS - Image 363512 Celeste Avenue Moss Point, MS - Image 373512 Celeste Avenue Moss Point, MS - Image 383512 Celeste Avenue Moss Point, MS - Image 393512 Celeste Avenue Moss Point, MS - Image 403512 Celeste Avenue Moss Point, MS - Image 413512 Celeste Avenue Moss Point, MS - Image 423512 Celeste Avenue Moss Point, MS - Image 433512 Celeste Avenue Moss Point, MS - Image 443512 Celeste Avenue Moss Point, MS - Image 453512 Celeste Avenue Moss Point, MS - Image 463512 Celeste Avenue Moss Point, MS - Image 473512 Celeste Avenue Moss Point, MS - Image 483512 Celeste Avenue Moss Point, MS - Image 493512 Celeste Avenue Moss Point, MS - Image 503512 Celeste Avenue Moss Point, MS - Image 513512 Celeste Avenue Moss Point, MS - Image 523512 Celeste Avenue Moss Point, MS - Image 53
Presented By: Coldwell Banker Smith Home Rltrs-Gautier
  • MLS# 4142796
  • 03/18/2026
  • Request Tour
  • Request Info
  • Beds • 3
  • Full/Half Baths • 2 / 1
  • SQFT • 2,167
  • Garage • 3

Home Details

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.
Presented By: Coldwell Banker Smith Home Rltrs-Gautier

Interior Features for 3512 Celeste Avenue

Bathrooms

Total Baths3

Other Interior Features

Air Conditioning Y/NYes
Fireplace Y/NNo
FlooringCarpet, Ceramic Tile, Hardwood, Tile, Other, See Remarks
Heating Y/NYes
Interior AmenitiesBookcases, Breakfast Bar, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), Crown Molding, Eat-in Kitchen, Entrance Foyer, Granite Counters, High Ceilings, His and Hers Closets, Open Floorplan, Soaking Tub, Stone Counters, Storage, Walk-In Closet(s), Double Vanity
Laundry FeaturesInside, Laundry Room, Sink
Window FeaturesBlinds, Double Pane Windows, Plantation Shutters, Shutters

General for 3512 Celeste Avenue

Architectural StyleTraditional
Attached Garage Yes
CityMoss Point
Community FeaturesBoating, Fishing, Marina, Near Entertainment, Park
Construction MaterialsBrick, HardiPlank Type, Wood Siding, Other, See Remarks
CoolingCentral Air, Electric
CountyJackson
Garage Spaces3
HeatingCentral, Natural Gas
High SchoolMoss Point
LevelsOne
Lot Size Square Feet81457.2
Lot Size UnitsAcres
New ConstructionNo
Other StructuresBoat House, Storage
Patio/Porch FeaturesBrick, Deck, Front Porch, Patio, Porch, Rear Porch, Side Porch
Property SubtypeSingle Family Residence
Property TypeResidential
RoofArchitectural Shingles
Security FeaturesCarbon Monoxide Detector(s), Smoke Detector(s)
SewerPublic Sewer
Standard StatusPending
StatusPending
Structure TypeHouse
Subdivision NameMetes And Bounds
Tax Year2025
Total Rooms0
UtilitiesCable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected, Back Up Generator Ready
Virtual TourClick here
Waterfront FeaturesBayou, Boat Dock, Bulkhead, Partial Wetlands, River Front, View, Waterfront, See Remarks
Year Built2018

Exterior for 3512 Celeste Avenue

Building Area Total2167
Exterior AmenitiesBoat Slip, Dock, Landscaping Lights, Lighting, Private Yard, Other, See Remarks
FencingNone
Lot Dimensions257.0 X 255.0
Lot FeaturesCity Lot, Few Trees, Landscaped, Sloped, Views, Wetlands
Lot Size Acres1.87
Lot Size Area1.87
Parking FeaturesAttached, Driveway, Garage Faces Side, Golf Cart Garage, Storage, Concrete, Paved
Water SourcePublic
Waterfront Y/NYes

Additional Details

Price History

Anthony Martin

Agent | Owner
Price $800,000
MLS#4142796
List Date 03/18/2026
Property Type Single Family
Request Tour
Request Info
Visit My Website

Similar Properties to 3512 Celeste Avenue