Title Page Background
DEBUG FN args: Array ( [0] => 376 [1] => [2] => [3] => agent ) BEFORE: Site: 376 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 376 Igate: njhud LocID: 376 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 376 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 376 [1] => [2] => [3] => lender ) BEFORE: Site: 376 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 376 Igate: njhud LocID: 376 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 376 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 376 [1] => [2] => [3] => other ) BEFORE: Site: 376 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 376 Igate: njhud LocID: 376 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 376 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

559 Goldenrod Circle N
Auburndale, FL 33823

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $89,900
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1708 Square Feet
Agency: American Mobile Home Sales of Tampa Bay, Inc.

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2

Window Features

Parking Features: Garage

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 1995
Notes: **This exclusive listing is on leased land with a monthly lot rent of 830.00** Please contact agent directly*** ..............................The home is huge (over 1600 sq ft) with beautiful laminate flooring throughout, fresh paint, and an open floor plan! ..............................................................The bedrooms are large as well, including a master suite with a walk-in closet and a large private bath!...................................................... The open floor plan includes a dining room, a big living room, and a bonus "great room"! ............................................................................The kitchen has lots of cabinets and countertops and updated appliances!!....................................................... Extras include a double-wide carport, screened patio, large shed, painted driveway, and most importantly LOW LOT RENT!! MUST SEE!!.......................................................... Big and Beautiful home in The Hamptons Golf and Country Club Resort of Auburndale! A gated, very active 55+ community with beautiful facilities and numerous activities!! Golf Course, restaurant, pool & spa, gym, library, pool room, and huge ballroom for shows, parties, games, cards, bingo, banquets and many dances with entertainment!! There are also plenty of outdoor activities as well, pickle ball, tennis, shuffleboard, bocce, corn-hole, horseshoes, 2 dog parks, and fishing ponds!!! You also have trips, cruises, poker runs, parades, and other group activities! "The Hamptons, where there is always something to do!" .................................................................................... All listing information is deemed reliable but not guaranteed and should be independently verified through personal inspection by appropriate professionals. American Mobile Home Sales of Tampa Bay Inc. cannot guarantee or warrant the accuracy of this information or condition of this property. Measurements are approximate.The buyer assumes full responsibility for obtaining all current rates of lot rent, fees, and pass-on costs. Additionally, the buyer is responsible for obtaining all rules, regulations, pet policies, etc., associated with the community, park, or home from the community/park manager. American Mobile Home Sales of Tampa Bay Inc is not responsible for quoting of said fees or policies.
MlsNumber: --


Listing Provided By: American Mobile Home Sales of Tampa Bay, Inc., original listing
Phone: (516) 524-7270
Office Phone: (727) 667-2400
Agent Name: Joseph Remkus
Disclaimer: Copyright © 2024 My State 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => polk-north [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: polk-north State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: polk-north State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 376 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jannette Rodriguez
ASCIIThe Landrua Group Real Estate Inc
Call Today!: (407) 690-1717

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App