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

222 Dunes Dr
Mexico Beach, FL 32456
Ashley Phathanak with Scenic Sotheby's International Realty, original listing - (850) 231-6052

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,250,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6517 Square Feet
Agency: Scenic Sotheby's International Realty
Agency Phone: (850) 231-6052

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Nestled in the exclusive Sugar Sand community, this luxury gulf-front residence offers an idyllic coastal lifestyle right on Mexico Beach. Light and space are the first things to notice in this 5,200-sq.-ft. Craftsman-built home, which occupies an oversized lot. Built in 2023, the home boasts five bedrooms, five-and-a-half lavishly appointed bathrooms and multiple living areas, both inside and out. In short, this custom-built home combines contemporary design, smart infrastructure and an awe-inspiring location to deliver an unparalleled living experience. Paved parking at the front of the home can accommodate several vehicles. A neat tier of steps leads up to the canopied front door. Once inside, premium LVP flooring emphasizes the spacious open family room with a dedicated dining area and sitting room. The gourmet kitchen is the heart of the home with a 60-in. professional range and side-by-side ovens, a Sub-Zero refrigerator and premium custom cabinetry. A huge center island with seating encourages social interaction while enjoying signature cocktails and chef-inspired canapes. A pantry, ice maker and a wet bar facilitate effortless entertaining while two laundry rooms help you stay on top of pool towels and beach gear. The master bedroom deserves a special mention, with multi-aspect windows and French doors leading onto a private balcony. The private bathroom has gorgeous azul tile flooring and a fully tiled shower. Four additional bedrooms all have private baths showcasing the same high-end finish. Enjoy fresh gulf breezes in your outdoor oasis, including an elevated pool and hot tub on the generous ipe deck. It's the perfect place to cool off and entertain while enjoying panoramic views of the shimmering Gulf of Mexico. Private balconies complement this expansive outdoor living area. Located in flood zone X, this well-designed home has accommodation on two elevated floors, eliminating the need for specialist flood insurance.
MlsNumber: --
ListingId: 321133


Listing Provided By: Scenic Sotheby's International Realty, original listing
Phone: (615) 624-1879
Office Phone: (850) 231-6052
Agent Name: Ashley Phathanak
Disclaimer: Copyright © 2025 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