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 = 367 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 367 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 367 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

170 Sapodilla Drive
Lower Matecumbe, FL 33036

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,500,000
Beds: 4
Baths: 4
Status: Active
SqFt: 4512
Agency: Berkshire Hathaway HomeServices Freewheeler Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Unravel your dreams through this gated Estate Residence encompassing entire peninsula with over 500feet of bayfront and protected crystal clear waters. This pristine private luxury resort style property and residence includes designs by D'Asign Source and provides ultimate privacy while exposing the surrounding majestic waters. Avid boaters will appreciate this dockage for multiple large boats, plus onsite boat ramp Y private boat lift. Marked features of this Estate include professionally designed infinity pool & waterfalls, jacuzzi, and salt water pond overlooking the bay, manicured lawns with 28 zone irrigation, extensive tropical landscaping, paver brick driveway, detached 2 car garage plus additional undercover parking, separate multipurpose CBS building, expansive outdoor porches and entertainment areas, German inspired indoor & outdoor fireplace, stand alone carport with car washing facilities, full home generator, home security system, advanced stereo system for interior & exterior of home. This custom designed concrete Residence consists of two buildings attached by large open covered breezeway. Enter into the foyer leading to a grand interior living and entertaining area offering views in every direction, all of which lead out to expansive wrap around porches. Custom gourmet kitchen with dual refrigerator, dual dishwashers, dual ranges, all Viking appliances, wet bar with wine cooler, & multiple sinks. Private office, walkin pantry, & guest bath. The sleeping quarters located in separate building offers private third floor master suite & bath with steam shower, jacuzzi tub, dual sinks, & a dream walkin closet. Two additional guests rooms, bathroom & living area on main level. Additional ground level cabana bar, plus private guest suite. This grand Estate home was completely rebuilt in 2006 and 2009 with two separate buildings attached by exceptional breezeway and all overlooking the beautiful gulf front waters. So much more...call for full details.
MlsNumber: 608173


Listing Provided By: Berkshire Hathaway HomeServices Freewheeler Realty, original listing
Name: Berkshire Hathaway HomeServices Freewheeler Realty
Phone: (305) 664-4444
Office Name: Berkshire Hathaway HomeServices Keys Real Est
Office Phone: (305) 664-4444
Agent Name: The Lindback Team
Disclaimer: Copyright © 2024 Florida Keys Board of REALTORS ®. 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