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;

1839 Harbor Light Ln
St. George Island, FL 32328

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,195,000
Beds: 4
Baths: 5
Status: Active
SqFt: 4426
Agency: Berkshire Hathaway Home Services - SGI

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1983
Notes: Premier bayfront home sited on a rare point with uninterrupted panoramic views of the Apalachicola Bay. Experience the thrill of world-class fishing in your own backyard with prime redfish habitats right off your private canal-front boat dock. Exquisitely renovated in 2023 with contemporary design highlighting the bay and marsh views from every room. Spectacular chef's kitchen features Blue Star gas 6 burner range, Thermador wall ovens, Thermador refrigerator, expansive kitchen island and a phenomenal butler's pantry w/sink, small appliance storage and organized storage. The kitchen features a full wall of windows overlooking the bay with stunning sunsets and birdwatching; eagles, roseate spoonbills, kingfishers, there is new wildlife to enjoy every day! Two bedrooms on the main level have private doors to the side deck and beautiful canal views. Top floor primary suite has a vaulted ceiling and custom windows highlighting the waterfront vistas, luxurious en-suite bath w/ steam shower, soaking tub, and custom designed closet space. An additional bedroom with en suite bath on the top floor opens to a joint screened porch with the primary bedroom and is the epitome of sanctuary. Ground level bonus room for ping-pong and recreation offers a full bath for coming right in off the boats, plenty of beach/boat gear storage, and covered parking with EV charging. The ultimate private bayfront retreat!
MlsNumber: 317024


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