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 = 'HERN') or (MLS_FEED = 'MFRMLS')) OR (MLS_FEED = 'FSBO')) AND ((MLS_COUNTYID = '12017') or (MLS_COUNTYID = '12053') or (MLS_COUNTYID = '12057') or (MLS_COUNTYID = '12081') or (MLS_COUNTYID = '12083') or (MLS_COUNTYID = '12097') or (MLS_COUNTYID = '12101') or (MLS_COUNTYID = '12103') or (MLS_COUNTYID = '12115') or (MLS_COUNTYID = '12117')) AND (`MLS_COUNTYID`='0') AND (`MLS_PRICE` >= 1620) AND (`MLS_PRICE` <= 2160) AND (`ZIP_CODE`='34606')ORDER BY MLS_PRICE DESC LIMIT 0,10 Rental Search Results
Robin Winchester-Heugel Real estate serving Spring Hill FL
  1. Heugel Properties of Floridas Gulf Coast
  2. Tropic Shores Realty
  3. Cell: 920.737.9148
  4. heugels@yahoo.com
Searching on:
  1. County =
  2. Min Rent is at least $1620
  3. Max Rent is less than $2160
  4. Zipcode = 34606
No Results found