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 = 342 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 = 342 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 = 342 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;

2474 Hwy 98 E
Carrabelle, FL 32322
Greg Eldridge with Sea Crest Real Estate, Inc., original listing - (850) 697-9604

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,149,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2346 Square Feet
Agency: Sea Crest Real Estate, Inc.
Agency Phone: (850) 697-9604

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Experience breathtaking views of the Gulf of Mexico and the pristine Dog Island Sound from this stunning, newly built waterfront home. Completed in 2019, this custom-designed 3-bedroom, 3.5-bath residence seamlessly blends luxury, comfort, and entertainment. The thoughtfully designed layout features expansive open spaces with multiple sets of French doors and oversized windows, offering panoramic water views from every room. The first-level bonus den boasts a wet bar, fridge, and icemaker—perfect for hosting guests. Also on the first floor are two bedrooms, each with private bathrooms and French doors opening to a balcony. The second level hosts a spacious great room with a gorgeous view of the water, top-of-the-line furnishings, and an elegant fireplace. Just steps away, a gourmet kitchen awaits, equipped with premium appliances and thoughtful design details. The master suite, located on the top level, provides unparalleled views and ultimate privacy. French doors open to your private balcony, creating a serene retreat. Accessibility is ensured with a four-stop elevator serving every floor, making every corner of this home effortlessly reachable. Outdoor amenities include a private dock, boat lift, double Seadoo lift, and a fish cleaning station complete with water and electricity. Evenings by the bay become unforgettable as you relax by the water and take in the stunning sunsets. Move-in ready, this remarkable home offers an exceptional lifestyle and invites you to discover its many extraordinary features firsthand.
MlsNumber: --
ListingId: 320510


Listing Provided By: Sea Crest Real Estate, Inc., original listing
Phone: (850) 889-1137
Office Phone: (850) 697-9604
Agent Name: Greg Eldridge
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