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;

140 Pogy Rd
Apalachicola, FL 32320

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,899,000
Beds: 4
Baths: 5
Status: Active
SqFt: 5744
Agency: ROBINSON REAL ESTATE COMPANY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1999
Notes: Magnificent Handcrafted Cypress Home with Deep Water Dockage on the Apalachicola River Experience unparalleled luxury in this stunning cypress home, offering deep water dockage on the Apalachicola River Intracoastal Waterway. As you enter, you're greeted by custom-etched glass depicting a serene river scene, visible as you ascend to the second and third floors via the glass-front elevator. The entry-level features two spacious garage bays, a versatile room that can serve as an office or a fourth bedroom, and a full three-piece bathroom. On the second floor, you'll find an entertainment paradise with a custom pool table, a full wet bar, and a comfortable sitting area. This level also includes two spacious bedrooms, each with its en suite bathroom. The third level boasts an open-concept living and kitchen space with 22-foot ceilings and breathtaking river views. The stunning Brazilian cherry floors add to the elegance of this home. The main bedroom, also located on this level, includes an en suite five-piece bathroom. Outdoor features are equally impressive, with a deepwater dock, boatlift, boat ramp, RV pavilion, and a private boat basin with a renewable dredge license up to nine feet. The pavilion area, equipped with a built-in barbecue, is perfect for large gatherings. Situated on a 1.47-acre site, this property boasts approximately 300 feet of shoreline, including 143 feet directly on the river. This unique home offers deepwater access and unmatched views, making it a must-see for discerning buyers. Shown by appointment only. Call today for your private tour!
MlsNumber: 316718


Listing Provided By: ROBINSON REAL ESTATE COMPANY, original listing
Name: ROBINSON REAL ESTATE COMPANY
Phone: (850) 653-1653
Office Name: Robinson Real Estate Company
Office Phone: (850) 653-1653
Agent Name: LaDonna Ingram
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