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','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 = 3335 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 = 3335 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;

2135 Mayfair Way
Titusville, FL 32796

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $19,999
Beds: 2
Baths: 1
Status: Active
SqFt: 621
Agency: Sunset Home Sales

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1994
Notes: **MISSILE VIEW MOBILE HOME PARK 55+ ADULT PARK** ONLY $19,999 AS IS ! This is a lovely 1994 2 bedroom 1 bath home with appliances, furnishings and home essentials. ( Newer stackable washer/dryer) The home sits on a quiet corner lot in the back of the park with screened porch. Two portable window units available. Come Take a look !! *CASH PURCHASE ONLY PLUS CLOSING COSTS ON OLDER UNITS. **MISSILE VIEW MOBILE HOME PARK is a 55+ adult park. Current lot fee on this home is $603 includes a real estate tax charge and water is metered and billed monthly- seems to average $30-$35. The park requires a $800 DEPOSIT. (Park Office will provide any info or changes) Minimum $1500 MONTHLY INCOME. Minimum credit score 620 2 SMALL PETS ARE ALLOWED WITH PARK APPROVAL. ALL NEW OWNERS MUST BE PARK APPROVED, FULL BACKGROUND CHECK. APP FEE $50 / Submit application through missileviewmobilehomepark. 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: 11236936


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