Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1434 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1434 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1434 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5333 E Belle Fontaine Road
Ocean Springs, MS 39564
Nicole S Sanchez with Keller Williams, original listing - (228) 275-7500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,999
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1708 Square Feet
Agency: Keller Williams
Agency Phone: (228) 275-7500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: This stunning resort-style property is located on the Gulf of Mexico, offering breathtaking views of Horn Island. Set on over an acre of land with 135' of waterfront, this one-of-a-kind property provides an unparalleled living experience. With over 2,000 sq ft of outdoor space, you can unwind and enjoy the mesmerizing water views while lounging by the custom saltwater pool or sipping your morning coffee on one of the multi-level decks. The main house, elevated on 10' concrete pilings, boasts a two-story design with just over 1700 square feet of living space , three bedrooms and three bathrooms. Additionally, there is a fully independent 900 square feet guest house with two bedrooms and two bathrooms FULLY FURNISHED currently operating as an Active Airbnb. For all your storage needs, there is a spacious 20 x 30 garage with 14' sidewalls and oversized doors to accommodate your water toys. Built by Deltec Homes, renowned for their coastal builds, this property exceeds Miami-Dade standards and is designed to withstand hurricane force winds up to 190 mph. You can live on the water with peace of mind, as the property is located in the X flood zone. The interior of the main house features a Chef's kitchen equipped with top-of-the-line Cafe appliances, induction cooking, multiple sinks, and a stunning Quartz island that will leave you in awe. The master bathroom offers a luxurious soaking tub and a custom spa shower with multiple shower heads. Each shower is equipped with a comprehensive Schluter waterproofing system and built-in niches. Enjoy the convenience of Google Smart Home automation, featuring a complete ADT security system with Nest Doorbells and connected Yale locks. The property is also designed with energy efficiency in mind, boasting 15 400-watt solar panels, spray foam insulation throughout, and insulated storm-grade windows. Each home is equipped with a fully independent, self-cleaning whole house water filtration system. This property truly needs to be seen to be believed. Its unique combination of luxury, style, and exceptional features make it a dream retreat for those seeking a coastal lifestyle.
MlsNumber: --
ListingId: 4092047


Listing Provided By: Keller Williams, original listing
Phone: (228) 243-1222
Office Phone: (228) 275-7500
Agent Name: Nicole S Sanchez
Disclaimer: Copyright © 2024 MLS United. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1434 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Carol L Howell
Carol L Howell
ASCIIR Evans Realty, LLC
Call Today!: (601) 791-8500

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App