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

7979 Sailboat Key Boulevard S
South Pasadena, FL 33707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1300
Agency: Future Home Realty, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1989
Notes: Welcome to Harbourside, a Luxurious Waterfront condominium community. This unit is located in Sunrise association, Bldg 11, featuring North /South views. Enjoy your favorite beverage as you look out over the panoramic open waters of Boca Ciega Bay with the active Seabirds, Dolphins and natural nautical wildlife. There are 2 balconies, one off front in kitchen and den, the 2nd off Living room and master bedroom. If you are a Tennis/Pickle ball player this Condo Lobby is just steps away from the courts. This corner unit is light and bright with 2 bedrooms, 2 baths with a den or 3rd bedroom which comes turnkey furnished, ready to move in. Upgrades include newer hi-impact sliders and windows, AC new in 2017, hot water heater 2009, porcelain and ceramic flooring. There are 2 storage units, one on the balcony and larger one in a locked room by the elevators, assigned parking space in 103 under the bldg. Harbourside condo's have an integrated fire sprinkler system as well.When Constructing Harbourside, JMC the contractor used Solid Steel reinforced concrete construction rather than hollow concrete blocks. Amenities include 6 swimming pools, 5 tennis courts with a Pickle ball court, 2 fitness centers, Men and Women's Gyms, Jacuzzi, saunas, shuffleboard, outdoor grilling, 3 car wash station with vacuum & air, Car Charging station, Marina with 3 docks and 87 deeded slips. There is no deeded slip to this unit but there are slips available to rent or purchase from other owners. Harbourside’s Clubhouse has a full social agenda, card room, billiard room, library Grand room with kitchen and a 1.5 mile walking trail around the island to exercise or walk your pet. Sunrise allows owners one pet under 20 pounds. Come see and experience Resort style living at it's best.
MlsNumber: U8223144


Listing Provided By: Future Home Realty, Inc, original listing
Name: Future Home Realty, Inc
Phone: (727) 409-3368
Office Name: FUTURE HOME REALTY INC
Office Phone: (813) 855-4982
Agent Name: Denise Hobbs
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