Title Page Background
DEBUG FN args: Array ( [0] => 342 [1] => [2] => [3] => agent ) BEFORE: Site: 342 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 342 Igate: njhud LocID: 342 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 342 [1] => [2] => [3] => lender ) BEFORE: Site: 342 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 342 Igate: njhud LocID: 342 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 342 [1] => [2] => [3] => other ) BEFORE: Site: 342 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 342 Igate: njhud LocID: 342 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1840 Sea Oat Dr
St. George Island, FL 32328
Shelley Shepard with Berkshire Hathaway HomeServices - SGI, original listing - (850) 990-0020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,675,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 9000 Square Feet
Agency: Berkshire Hathaway HomeServices - SGI
Agency Phone: (850) 990-0020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Completely renovated inside and out, you must see this premier beachfront offering in the St George Plantation! Ideal floorplan to gather the entire family at the beach with multiple living areas, 6 bedrooms, most with ensuite baths, and the most outstanding game room you can imagine on the ground floor opening to the beachside shaded deck! Spectacular views of the beach from nearly every room, this home was custom built to be a full time residence, evident by the tremendous spaces. The main floor living space has been renovated with shiplap accent walls and architectural gas fireplace while a cozy beachfront sitting area and two dining areas surround a central kitchen, the literal heart of the house! Primary bedroom on the main has a spacious sitting area overlooking the beach along with a expansive en-suite bath with garden tub, walk in shower and separate walk in closets. A front office is a quiet space to work from home and the extra large laundry/pantry room provides plenty of storage. Second floor has a central living area opening to a screened beachfront deck with 4 bedrooms on each corner, three with en-suite baths and one hall bath. Charming custom built in bunks on the top floor bedroom are sure to be a hit with the younger generation! Every member of the family will find something to entertain in the ground level game room; basketball, ping pong, TV, wet bar, hot tub and more, just open the garage doors and enjoy the beach breezes. Two car – or golf cart - enclosed garage and an elevator to the second floor. New hardiboard siding, impact doors/windows and standing seam metal roof make for low maintenance living and being offered fully furnished, ready to move in. Just one street to the community pool and tennis/pickleball courts, this is truly a beach house the whole family will love!
MlsNumber: --
ListingId: 321247


Listing Provided By: Berkshire Hathaway HomeServices - SGI, original listing
Phone: (850) 653-6621
Office Phone: (850) 990-0020
Agent Name: Shelley Shepard
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