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','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 = 367 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 = 367 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;

201 W Seaview Drive
Duck Key, FL 33050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $14,500,000
Beds: 3
Baths: 4
Status: Active
SqFt: 4065
Agency: Coldwell Banker Schmitt Lower Keys (KW)

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2019
Notes: Nestled within the confines of exclusive Plantation Island, at the end of a quiet cul-de-sac, lies a monumental Oceanfront estate of unparalleled proportion. Enveloped in lush tropical landscaping, and sprawling across an oversized 17,900 Sq. Ft. Point Lot, boasting stunning Open Water Views, every detail has been masterfully considered at this coastal retreat in coveted Hawks Cay! Enjoy Direct Ocean Access with approximately 200' of concrete seawall, with additional dock featuring jetski and boat lifts, this exceptional property allows for frequent boating with ease. Cool off in the resort-style, saltwater infinity pool, or sink into a luxurious hot tub at days' end while taking in stunning Sunset Views. Venture inside this colossal masterpiece through a sleek, glass elevator. The show-stopping Great Room features soaring ceilings, well-appointed wet bar, and walls of impact-resistant glass which open to unobstructed Ocean Views. Ideal for entertaining, the open-concept main living space flows seamlessly into an expertly-equipped Chef's Kitchen, complete with premium JennAir appliances, ample prep- and storage space, and generous peninsula with counter seating. Guests will enjoy elevated accommodations in a separate wing, with elegant en suite bathrooms, and access to a spacious veranda overlooking the well-manicured yard and Open Ocean beyond. The primary suite epitomizes luxury boasting an expansive walk-in closet with custom built-in storage, opulent en suite bathroom, with Ocean Views, deep soaking tub, walk-in shower adorned with onyx, and veranda access. The primary bedroom features impact, pocket sliding glass along two walls, which open entirely for enjoying sublime sunsets and ocean breezes; relax and unwind in this exceptional retreat. The property offers a plethora of parking and storage with a detached garage, open- and street parking. Peace and tranquility abound at this extraordinary property, call to schedule a tour today!
MlsNumber: 608507


Listing Provided By: Coldwell Banker Schmitt Lower Keys (KW), original listing
Name: Coldwell Banker Schmitt Lower Keys (KW)
Phone: (305) 872-3050
Office Name: Coldwell Banker Schmitt Lower Keys (KW)
Office Phone: (305) 872-3050
Agent Name: Lisa H Ferringo
Disclaimer: Copyright © 2024 Key West Association 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