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 = 3349 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 = 3349 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 = 3349 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;

9053 Bayou Dr
Tampa, FL 33635

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $119,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1488
Agency: Central Florida Mobile Home Sales, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1992
Notes: FINANCING AVAILABLE Charming 3-Bedroom, 2-Bathroom Manufactured Home in Meadowbrook Village Community, Tampa, FL The payment for base monthly rent is $687.00 This includes amenities and community maintenance. Home Features: Modern Appliances: Enjoy a fully-equipped galley kitchen and the convenience of an in-home washer and dryer. Screen Room with Doggie Door: Perfect for entertaining or relaxing, this large screened room offers a seamless indoor-outdoor living experience, complete with a doggie door for your pets. Outdoor Metal Shed: Elevated on a wooden platform, this large shed provides ample storage space for your outdoor equipment and belongings. Spacious Floor Plan: The home boasts a flowing floor plan with a dining room, and wrap-around master bedroom/bathroom suite, providing an amazing living experience. Versatile Bedrooms: Originally a 4-bedroom home, the two smallest rooms were combined into one large room, perfect for siblings or an older child to share. The third bedroom features a spacious walk-in closet, ideal for guests or a home office. Utility Room/Pantry: This home includes a generously sized utility room that can double as additional storage or pantry space. Vaulted Ceilings: Enjoy the open and airy feel provided by the home's vaulted ceilings, complete with a ceiling fan to keep the living area fresh and comfortable. Durable Vinyl Flooring: The updated flooring throughout the home offers modern style and easy maintenance. New Guest Bathroom: The guest bathroom has been recently renovated and features a brand-new shower and vanity. Community Amenities: Heated Outdoor Pool: Take a refreshing dip and relax in the warm Florida sun. Tennis Courts: Stay active and challenge your neighbors to a friendly match. Clubhouse: Meet your new neighbors and participate in a variety of fun activities and events. Playground: Let your kids play and make lasting memories in the community playground. Dog Park: Your furry friends will love the fenced dog park, where they can run, play, and socialize. Additional Amenities: Enjoy access to basketball, BBQ area, pond, shuffleboard, billiards, common area free Wi-Fi, and more. Location: Situated in one of Tampa Bay's finest neighborhoods, Meadowbrook Village offers an exceptional quality of life and a strong sense of community. The home is conveniently located near shopping, dining, entertainment, and local schools.
MlsNumber: 11270389


Listing Provided By: Central Florida Mobile Home Sales, Inc, original listing
Name: Central Florida Mobile Home Sales, Inc
Phone: (813) 404-6776
Office Name: Central Florida Mobile Home Sales, Inc
Office Phone: (813) 404-6776
Agent Name: Allen Regal
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

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 = 3349 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;
Real Estate Expert Photo for Stacy Wolfson
Stacy Wolfson
ASCIIeXp Realty - The Wolfson Luxury Group
Call Today!: (813) 240-8888

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App