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

517 Suwanee Circle
Tampa, FL 33606

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,895,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4026
Agency: Palermo Real Estate Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1949
Notes: Davis Island living at its best! Own a private oasis on approximately 138 feet of waterfront with this 0.36 acre ranch, renovated in 2020-2021. This must see one story home offers 5 bedrooms (5th bedroom is huge and can be used as a bonus room) and 4 full bathrooms with an amazing family-friendly floor plan featuring formal living, waterfront dining, separate office, walk-in pantry, and laundry/mud room. The large kitchen is a chef’s delight featuring 2 islands, natural stone quartzite counters, gas cooktop, French door double convection ovens, advantium speed oven, and a dedicated tap for instant hot water and RO filtered water. The original portion of the home offers charming built-ins, large bedrooms, original hardwood floors which beautifully transitions into an addition to create a separate primary bedroom with waterfront views. <br /> The house sits on an oversized, fenced in lot with custom playground, swimming pool and large open back porch, quaint brick paved courtyard off of the kitchen, 6,000 lb boat lift and floating dock for kayak and paddle boarding. The 2.5 car attached garage has storage in attic space with easy access. <br /> The community offers a charming downtown strip with dining, shopping and local RX, which lead to the end of the island and the beautiful DI Yacht Club with dog park and white sandy beach overlooking sail boats and DI airport. The island is golf cart friendly. With convenient access to downtown and the riverfront, this location is a win!<br /> Roof 2023, HVAC 2018, 2021 and 2022, brand new irrigation system and sod.<br /> MUST SEE VIRTUAL TOUR to appreciate the floor plan and views. https://realestate.febreframeworks.com/videos/018ea9e0-4929-72bc-8a86-d40a7acd7295
MlsNumber: T3512325


Listing Provided By: Palermo Real Estate Professionals, original listing
Name: Palermo Real Estate Professionals
Phone: (813) 637-0117
Office Name: PALERMO REAL ESTATE PROF.INC.
Office Phone: (813) 637-0117
Agent Name: Lara Champ Mays LLC
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