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;

1244 Sandy Ln
St. George Island, FL 32328
Travis Stanley with Fickling & Company, original listing - (850) 653-6477

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,169,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 3320 Square Feet
Agency: Fickling & Company
Agency Phone: (850) 653-6477

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: The name says it all! "Front Row" is one of the most breath-taking gulf front homes on St. George Island. This home sits atop a high dune on a large one acre gulf-front lot, positioned in the "Front Row" closer to the beach than all the neighboring homes. The home's large panel windows offer an unprecedented and unobstructed 180 degree view of the gulf from the spacious 2nd floor living area. The entire 2nd floor is paneled in warm, rich cypress. The view of the beach and gulf continues into the well equipped gourmet kitchen. The first floor which opens to the large private swimming pool has a sitting area with television and three large bedrooms, all with luxurious bathrooms. The 2nd floor has two large master bedrooms with large panel windows that offer a spectacular view of the beach and gulf. The Pool-Side Cabana offers changing room/restroom, bar area with ice machine, refrigerator, bar sink, covered grill area and a speaker system for pool side music on the huge wraparound pool deck. Enter the property via a boardwalk through an oak canopy. Front Row is located inside The Plantation, which boasts over five miles of the most beautiful pristine white sand beaches. This gated community offers an ideal combination of seclusion and convenience including a new three-quarter Olympic size community swimming pool, shaded picnic area, fitness room, and a beautiful clubhouse. Community amenities include 3 tennis courts, a 3,200-foot paved, privately owned/public use landing strip, and privileged access to excellent fishing and magnificent sunsets at Bob Sikes Cut! Heavily wooded streets that criss-cross the area are ideal for bicyclists, jogging and walking enthusiasts.
MlsNumber: --
ListingId: 316975


Listing Provided By: Fickling & Company, original listing
Phone: (850) 653-6477
Office Phone: (850) 653-6477
Agent Name: Travis Stanley
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