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

20000 Us Highway 19 Highway N
Clearwater, FL 33764

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $117,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 948 Square Feet
Agency: FUTURE HOME REALTY INC
Agency Phone: (813) 855-4982

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Range, Refrigerator, Dryer
Architectural Style: Other
Construction Materials: Vinyl Siding
Flooring: Tile, Laminate, Tile - Ceramic
Interior Features: 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: Corner Lot, Storage, Awning(s)
Parking Features: Carport
Other Features: Storage

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: SOUTH GATE MOBILE HOME PARK UNREC

Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Mobile Home
Year Built: 1970
Notes: Located within the highly sought-after 55+ community of South Gate Mobile Home Park, this charming 2 bed, 2 FULL bath home has a little bit of everything. An open concept living area providing a perfect setting for entertainment with family and friends. An adjacent dining room area joining the spacious living room creating a perfect spot for gathering. The bedrooms offer a generous amount of space and the primary has a connecting bathroom with a walk in shower. There are plenty of windows (some updated) throughout the home offering an abundance of natural light and sunshine. An enclosed screened in patio for when you want to relax and just gaze at the pedestrian traffic passing by on the Pinellas trail. Located on a corner lot offering the convenience of easy entry and exit and only a short distance from the pool and shuffleboard courts. Whether you want to be super active, outgoing or prefer to lay back and rest, South Gate has something for you. If you are only looking to be a seasonal resident, then it's the perfect place for a rental when you are not in there. The application process is hassle-free, allowing you to enjoy the benefits of the community's offerings. A current monthly HOA fee of $225 includes water, trash, lawn care, and also grants access to an array of fantastic amenities. This community is golf cart and motorcycle friendly. A short drive to the Tampa International Airport, the beautiful beaches of Clearwater, and downtown St. Petersburg. An abundance of shopping centers and restaurants in the area.
MlsNumber: --
ListingId: U8234204


Listing Provided By: FUTURE HOME REALTY INC, original listing
Phone: (727) 710-1526
Office Phone: (813) 855-4982
Agent Name: JB Brown
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS®, Inc. 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 = 405 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Real Estate Expert Photo for Amber Nicole Holt
Amber Nicole Holt
UTF-8Engle & Völkers Savannah
Call Today!: (478) 636-3588

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App