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 = 133 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 133 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 133 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

4700 Cove Circle
St Petersburg, FL 33708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1055 Square Feet
Agency: WIREGRASS REALTY LLC
Agency Phone: (813) 727-9344

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator
Architectural Style: Other
Flooring: Tile
Interior Features: Window Treatments, Eat-in Kitchen, CEILING FANS(S), LIVING ROOM/DINING ROOM COMBO, PRIMARY BEDROOM MAIN FLOOR
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Dining Room, Kitchen, Living Room

Window Features

Exterior Features: Lighting, Irrigation System, Tennis Court(s), Sidewalk
Other Features: Tennis Court(s)

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: JEFFERSON HOUSE THE CONDO

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential Lease-Condominium
Year Built: 1969
Notes: Looking for long term renter. Beautiful 2 bed/2 bath condo in the vibrant 55+ community of Sea Towers. Easy to keep clean, new ceramic tile throughout. Fully furnished ready for your added personal touch. Eat-in kitchen with lots of cabinet space. Updated guest bathroom with tiled sit-in shower. The master bedroom is roomy and furnished with a king sized bed with ensuite bath. The guest room is generously-sized with a walk-in closet and access to a semi private back yard. <br /> <br /> The safe Sea Towers staffed 24/7 gated community boasting stunning water views, beautiful sunsets, creating a tranquil and picturesque setting. Whether you're strolling along the waterfront paths living in this waterfront community offers a truly idyllic lifestyle. The Sea Towers community is bustling with tennis, pickle ball, 2 heated gunite pools, billiards, putting green, fishing piers, and so much more. A stunning clubhouse and social director ensures your enjoyment. <br /> <br /> Location, Location, Location<br /> <br /> 10 min walking distance to newly rebuilt Publix with public transportation available. Take a 5 min drive to the Maderia Beach public access with parking. While there, hop on the beach trolley to all of St Pete's beaches, John's Pass and many watering holes and restaurants. Easy 35 minute commute to Tampa International Airport and downtown. <br /> <br /> Other than the bountiful amenities of Sea Towers one of the biggies is Free internet includes basic cable which is all hooked up, live and ready to go.<br /> <br /> Sorry NO pets allowed in community.
MlsNumber: --
ListingId: T3509516


Listing Provided By: WIREGRASS REALTY LLC, original listing
Phone: (813) 727-9344
Office Phone: (813) 727-9344
Agent Name: Timothy Fallon
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.


Local Real Estate Expert

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 = 133 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Fay Garner
ASCIIHot Springs Realty
Call Today!: (501) 318-7392

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App