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

3280 3rd Avenue
Mims, FL 32754

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $9,900
Beds: 1
Baths: 1
Status: Active
SqFt: 432
Agency: Sunset Home Sales

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1971
Notes: HUGE PRICE DROP ! GREAT DEAL ON THIS HOME . NORTHGATE IS A 55+ ACTIVE ADULT POOL COMMUNITY IN MIMS FL. Call to view this cozy 1 bedroom 1 bath home with an enclosed porch for added additional space, home price reduced. This unit is furnished with kitchen appliances, home essentials. ** Make an offer on the brand new washer/dryer set with warranty** The roof has been resealed and coated in 2023, along with plumbing and electrical updates. 1 Window AC unit or space heater keeps this little unit cool/warm. Carport, shed and back yard patio too ! *CASH PURCHASE ONLY PLUS CLOSING COSTS ON OLDER UNITS. Northgate is a 55+ adult community, NO exceptions. All new owners must apply with office and go through park's background check. $50 per person. Minimum income required ( 3k monthly ) The land lease monthly is $530. This fee includes trash/recycle/yard waste and use of park's amenities. Park has a clubhouse offering miscellaneous events during each month. Swimming pool on site. Non aggressive breeds (2) permitted with park approval. NO RENTING permitted. Storage available for trailer/boats.(inquire with office ) All listing information is deemed reliable but not guaranteed and should be independently verified through personal inspection by appropriate professionals. We do not and 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. We are not responsible for quoting of said fees or policies.
MlsNumber: 11234352


Listing Provided By: Sunset Home Sales, original listing
Name: Sunset Home Sales
Office Name: Sunset Home Sales
Office Phone: (813) 215-0080
Agent Name: Melissa Stegmeier
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App