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 = 'SBBRMLS') or (MLS_FEED = 'SEFlorida')) OR (MLS_FEED = 'FSBO')) AND ((MLS_COUNTYID = '12011') or (MLS_COUNTYID = '12086') or (MLS_COUNTYID = '12099')) AND (`SUBDIVISION` Like '%Westwood%Lake%1st%Addn%')ORDER BY MLS_PRICE DESC LIMIT 0,10 Rental Search Results
Erin Marvasti Real estate serving Hollywood Fl
  1. Reaction Realty Group,Inc.
  2. Reaction Realty Group
  3. If Customer Service is a thing of the past, then we're just Old Fashioned
  4. Office: 954.967.6767
  5. Cell: 954.709.0192
  6. 954.553.8711
  7. reactionrealtygroup@gmail.com
Searching on:
  1. Subdivision Like Westwood Lake 1st Addn
No Results found