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;

1516 Windy Pass
St. George Island, FL 32328

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,227,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2889 Square Feet
Agency: Century 21 Collins Realty, Inc
Agency Phone: (850) 927-3100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Located on the South side of Leisure Lane within the gated SGI Plantation, The Bluffs stands as a pinnacle of coastal luxury. Just a strone's throw from the air strip, this custom 4 bedroom, 3 bath home exudes elegance & sophistication. As you enter, the first living level welcomes you with a sense of serenity, boasting a master bedroom with chic furnishings & a spa-like ensuite bathroom. Two additional guest bedrooms, tastefully appointed & sharing a common bath, provide ample space for friends & family. Ascending to the second floor, you're greeted by a great room with elevated ceilings & beautiful Satillo Mexican tile floors, providing a warm & inviting ambiance. The remodeled kitchen, featuring granite countertops and stone rolled tile backsplash, is a chef's delight, offering both functionality & style. A versatile 4th bedroom, which doubles as an office space has it's own bathroom. This living space offers sweeping views of both Gulf and Bay. Nestled among the pines, this home offers a sense of privacy & seclusion, allowing you to escape the hustle & bustle of everyday life. Outdoor shower, fish cleaning area & extra ground level storage provides a space for beach gear. The Bluff Community offers a common swimming pool and beach boardwalks just steps away, every day feels like a vacation in this charming coastal retreat! Baths & Kitchen remodeled 2007, Hardiboard siding(Kevin Queen); Roof 2018 Furnished with few exceptions.
MlsNumber: --
ListingId: 317355


Listing Provided By: Century 21 Collins Realty, Inc, original listing
Phone: (850) 653-6733
Office Phone: (850) 927-3100
Agent Name: Marilyn Bean
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