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 = 346 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 346 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 346 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

104 36th St
Mexico Beach, FL 32456

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3503
Agency: EXP Realty, LLC - Port St. Joe

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: WELCOME TO YOUR DREAM COASTAL OASIS! This stunning, brand new Gulf View home has everything you need for luxurious beachside living. With 5 spacious bedrooms and 5.5 bathrooms, there's plenty of room for the whole family and even some lucky friends. Step inside and be greeted by upgraded GE Cafe appliances in a sleek, modern kitchen that will make you feel like a gourmet chef. The kitchen opens up to an extraordinary dining/living experience with the Owner's bedroom/bathroom on the main floor. Don't worry about lugging your bags up flights of stairs to the large guest rooms – we've got you covered with an elevator conveniently located within the home. The wow-factor doesn't stop there. Imagine hosting unforgettable pool parties or simply lounging by the sparkling in-ground pool, soaking up the Florida sunshine. Complete with a wonderfully landscaped exterior sitting area, you'll have endless opportunities to create cherished memories with loved ones. From the moment you step foot in this extraordinary home, you'll notice the attention to detail and the pride the builder took in furnishing it with upgraded, stylish pieces. This fully furnished gem is ready for you to move right in, offering the perfect blend of comfort and sophistication. And when it's time to explore the beach, you'll hardly have to lift a finger. With a short walk to the Gulf of Mexico, you can easily enjoy breathtaking sunsets, long walks along the pristine shores, and the soothing soundtrack of crashing waves. It truly is a paradise for beach lovers! Don't miss out on this incredible opportunity to own a slice of heaven on the coast. Whether you're looking for a permanent residence, a vacation getaway, or an investment property, this home ticks all the boxes.
MlsNumber: 315861


Listing Provided By: EXP Realty, LLC - Port St. Joe, original listing
Name: EXP Realty, LLC - Port St. Joe
Phone: (850) 227-4455
Office Name: EXP Realty, LLC - Port St. Joe
Office Phone: (850) 227-4455
Agent Name: Nicole Majors
Disclaimer: Copyright © 2024 Realtor® Association of Franklin & Gulf Counties. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App