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;

290 N Anglers Drive
Marathon, FL 33050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,750,000
Beds: 6
Baths: 5
Status: Active
SqFt: 3930
Agency: Florida Keys Real Estate Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1979
Notes: Located on the desirable ocean side of Marathon , Casa Del Sol is abeautiful waterfront estate situated on a large and very privatecorner lot. The interior includes a new gourmet kitchen with granitecounter tops and premium dual fuel appliances as well as twoworkstations. An old world charm is captured through the use of archesand stone columns. All rooms, including bedrooms and baths are large,airy, and sun drenched.On the second floor, at either end of the house, are two masterbedrooms with en suite bathrooms. Each master bedroom extends outonto beautiful covered balconies which overlook the waterfront. Thereis a third bedroom with a king size bed as well as a fourth bedroomwith two sets of bunk beds. These last two bedrooms share a fullbathroom.On the ground floor, in addition to the chef's kitchen and diningroom, there is an expansive living room with comfortable seating forat least a dozen people . Also on the ground floor there are privateliving quarters to include a bedroom with a king bed, a kitchenette ,a full bathroom , and a beautiful living room. This suite may beaccessed from within the house or by way of a private entrancelocated on the covered porch. The ''Fish Room '', built on the waterfront end of the garage , offersa 6th bedroom with a king size bed and a full bathroom . It isdetached from the main house and together with a private patiooverlooks the dock area . A large brick patio and pool area on the water sideoverlook 180' of dock space. A covered barbecue area with built-inappliances to include a DCS premium gas grill, power burner, Big GreenEgg smoker, and sink are surrounded by mature landscaping. Propane gasis piped directly to the grilling area. There are tables and chairson the porch providing lots of space for outdoor dining.There is ample room in our driveway to park four or five cars as wellas a boat trailer or RV . The dock is large enough for severa
MlsNumber: 609253


Listing Provided By: Florida Keys Real Estate Group, original listing
Name: Florida Keys Real Estate Group
Phone: (305) 664-1453
Office Name: Florida Keys Real Estate Group
Office Phone: (305) 664-1453
Agent Name: Kristen Brenner/Margie Casey Team
Disclaimer: Copyright © 2024 Marathon and Lower Keys 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