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 = 106 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 = 106 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 = 106 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;

257 Jamaica Drive
Palmetto, FL 34221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $240,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1100
Agency: Keller Williams On the Water

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: PRICE REDUCED! Live the Florida Gulf Coast lifestyle in the hidden gem community of TROPIC ISLES Co-Op, a 55+ Resident Owned WATERFRONT COMMUNITY on TERRA CEIA BAY. This 2017 Jacobsen Home offers 2 bedrooms and 2 baths with picturesque curb appeal. All the upgrades were strategically planned and methodically integrated into this well-appointed home for catering to a casual way of life. Step inside this bright and spacious interior featuring an open-concept arrangement making the common areas feel even larger than its square footage! Upgrades include double pane windows, 9 foot ceilings with 5" crown molding throughout and transom windows. Kitchen has 42" cabinetry, stone counter island, stainless steel farm sink, fridge, smooth-top range, microwave and dishwasher. An expansive master suite provides a nice place to retreat at the end of the day with a large walk-in closet, dual sinks, and walk-in shower. If you appreciate little details, you will absolutely love the outdoor space that perfectly captures the casual vibe of this home. An indoor laundry room provides convenience in addition to an attached shed ideally configured as a workshop for storing all your fishing gear and sports equipment. Tropic Isles offers an array of amenities and endless activities for your enjoyment. Recreational facilities include a full service MARINA and BAIT SHOP, social rooms, shuffleboards, fitness center, controlled temperature pool and spa, a library, and so much more! Keep your social calendars busy with aerobics, movie nights, book club, and there's even bingo nights and line dancing! Boat slips rental available to residents, check with administration’s office for details. Act now to make this your forever home and schedule your private tour today!
MlsNumber: A4603335


Listing Provided By: Keller Williams On the Water, original listing
Name: Keller Williams On the Water
Phone: (941) 729-7400
Office Name: KELLER WILLIAMS ON THE WATER
Office Phone: (941) 729-7400
Agent Name: Cusie Garcia Urgelles
Disclaimer: Copyright © 2024 Stellar MLS. 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