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

895 S Gulfview Boulevard
Clearwater Beach, FL 33767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1007
Agency: Smith & Associates Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Rental
Year Built: 1970
Notes: SHORT TERM ( 3 mth. min. ) Rent includes W/S/T/basic cable/basic internet. Condo is fully furnished with breathtaking views of the community private beach. Unit has been remodeled with walk-in showers, new paint, new plank flooring, and new guest room furnishings. Master BR has a king bed, flat Screen TV, dresser, lots of closet space and nice water view. Guest room with large bunk beds, flat screen TV and large closet. Large kitchen with range, microwave, dishwasher, refrigerator, beautiful white cabinetry, and a small breakfast bar/prep or computer area. Living room has a flat screen TV, beautiful leather furniture, new flooring, new paint and a gorgeous water view. The sunroom is the perfect spot to relax and read, have your morning coffee or have an evening beverage watching the sun go down. Always a special something cool to see on the waterside...lots of sea life activity to enjoy. Basic cable, and WIFI are included. Tenants pay electricity on all long term annual leases over 6 months. Private beach and community has 2 waterside heated pools, spa, tennis area, shuffleboard, a BBQ area and more. This is truly living your vacation here at the Island House on Clearwater Point. It's a short distance to the famous Shephards and all the great Clearwater beach hot spots. Lots of shopping in the area so take the Jolly trolley and go explore all the area has to offer. Association approval is required for tenants $150. No Pets! Tenants responsible for cleaning fee and tax will apply on any ST lease.
MlsNumber: U7700896


Listing Provided By: Smith & Associates Real Estate, original listing
Name: Smith & Associates Real Estate
Phone: (813) 839-3800
Office Name: SMITH & ASSOCIATES REAL ESTATE
Office Phone: (727) 282-1788
Agent Name: Jo Overin
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