SELECT ACRES, BATHS_FULL, BATHS_HALF, BATHS_THREEQ, BATHS_TOTAL, BEDROOMS, BIDX_VIDEO_URL, BUILDING_SQUARE_FOOTAGE, CITY, COMMUNITY_NAME, COUNTY, FIREPLACE_NUMBER, FORECLOSURE, GEO_LAT, GEO_LON, LEGAL, MLS_ADULT,MLS_AGENT_ID, MLS_AGENT2_ID, MLS_AREA_NAME, MLS_AREA, MLS_BOARD_IMG, MLS_BOARD_NAME, MLS_CONDO, MLS_COUNTYID, MLS_DISPLAY_TYPE, MLS_FEED, MLS_GREEN, MLS_LAST_PRICE_TIMESTAMP, MLS_LAST_PRICE, MLS_LIST_NUM, MLS_LISTDATE, MLS_OFFICE_ID, MLS_OFFICE_NAME, MLS_AGENT_NAME, MLS_PARKING_SPACES, MLS_PHOTODATE, MLS_PRICE, MLS_PROP_TYPE, MLS_REMARKS, MLS_RENT_MONTH, MLS_SPA, MLS_TABLE, MLS_TRANSDATE, MLS_VIDEO_URL, MLS_WATERACCESS, MLS_ZONING, PHOTO_QUANTITY, PHOTO_URL, POOL, PROPERTY_STYLE, SCHOOL_DISTRICT, SCHOOL_ELEMENTARY, SCHOOL_HIGH, SCHOOL_JUNIOR_HIGH, SCHOOL_MIDDLE, SHORTSALE, SHOW_ADDRESS, STATE, STREET_DIRECTION, STREET_NAME, STREET_NUMBER, STREET_TYPE, SUBDIVISION, sysid, UNIT_NUMBER, VIRTUAL_TOUR_URL, VIRTUALTOUR, WATERFRONT_TYPE, WATERFRONT, YEAR_BUILT, ZIP_CODE from far_properties_rental WHERE (((MLS_FEED = 'GFLMLS')) OR (MLS_FEED = 'FSBO')) AND ((MLS_COUNTYID = '12009') or (MLS_COUNTYID = '12011') or (MLS_COUNTYID = '12021') or (MLS_COUNTYID = '12057') or (MLS_COUNTYID = '12061') or (MLS_COUNTYID = '12083') or (MLS_COUNTYID = '12086')) AND (`MLS_COUNTYID`='0') AND (`MLS_PRICE` >= 936) AND (`MLS_PRICE` <= 1248) AND (`ZIP_CODE`='33304')ORDER BY MLS_PRICE DESC LIMIT 0,10 Rental Search Results
  1. Elite Real Estate Solutions
  2. 954.794.7474
Searching on:
  1. County =
  2. Min Rent is at least $936
  3. Max Rent is less than $1248
  4. Zipcode = 33304
No Results found