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;

145 White Pelican Way
Carrabelle, FL 32322

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $45,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Berkshire Hathaway HomeServices - SGI
Agency Phone: (850) 990-0020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Welcome to the last bit of Florida paradise! 145 White Pelican Way offers an incredible opportunity to build your dream home in the sought-after St. James Bay Golf and Pickleball Resort. Since 2003, this resort has been a destination for golfers, pickleball players, nature enthusiasts, fishermen and leisure seekers. Golf enthusiasts delight in the area's only Designated Audubon Signature Sanctuary Course. Designed by Robert Walker, this 18-hole championship golf course features meticulously manicured fairways, challenging bunkers, and smooth, undulating greens. St. James Bay also offers 8 brand new, state-of-the-art pickleball courts where you can enjoy friendly matches or competitive tournament play. Beyond golf and pickleball, the resort features a gulf-front park with day-dock, boat storage, meeting spaces, and two community pools. St. James Bay is surrounded by the 212,000-acre Tate's Hell State Forest where lush nature trails wind through pristine pine forests. Sightings of native birds, deer, bears, alligators, and even the elusive Florida panther are commonplace. After a day on the Gulf, the greens or the courts, unwind at the on-site Crooked River Grill with a cocktail and a meal. Just a few miles west is the charming coastal town of Carrabelle, known as the “Gateway to the Forgotten Coast.” You're just a short drive away from Carrabelle Beach, with its sugar-white sand and unspoiled waters teeming with inshore fish species. Just 40 minutes west, St. George Island awaits. This 22-mile-long barrier island, accessible by bridge, offers pristine beaches, charming shops, and a laid-back vibe. St. George Island beaches were ranked the #1 beach in America in 2023 by “Dr. Beach.” Don't miss out on this incredible opportunity! One day soon, people will ask “You only paid how much for a lot in St. James Bay with its generous amenities, close proximity to the Gulf of Mexico, and world-renowned beaches?” This may be the last great coastal bargain in Florida!
MlsNumber: --
ListingId: 317477


Listing Provided By: Berkshire Hathaway HomeServices - SGI, original listing
Phone: (850) 591-9444
Office Phone: (850) 990-0020
Agent Name: Brenda Brown
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