Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/xtremese/public_html/alexpcastro/wp-content/themes/nofeeapartments/template-rent.php on line 261
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20, 20' at line 20 Whole query: SELECT units.*, units.id as unit_id, neighborhoods.slug as neighborhood_slug, buildings.id as building_id, buildings.slug as building_slug, buildings.street_short as building_street_short, neighborhoods.title as building_neighborhood, buildings.lat as building_lat, buildings.lng as building_lng, bedrooms.abbreviation as bedroom_abbreviation, bedrooms.numeric_value as bedroom_numeric_value, boroughs.title as borough_title, buildings.doorman as doorman, buildings.elevator as elevator, buildings.gym as gym, buildings.laundry as laundry, buildings.outdoor as outdoor, buildings.lounge as lounge, buildings.storage as storage, buildings.lat as building_lat, buildings.lng as building_lng, buildings.garage as garage, IF( units.net_rent IS NULL OR units.net_rent = 0, units.gross_rent, units.net_rent ) AS rent, IF( units.net_rent IS NULL OR units.net_rent = 0, 'GROSS', 'NET' ) AS price_type, brokerages_agents.first_name AS listagent_first_name, brokerages_agents.last_name AS listagent_last_name FROM units INNER JOIN buildings ON buildings.id = units.building_id INNER JOIN boroughs ON boroughs.id = buildings.borough INNER JOIN neighborhoods ON neighborhoods.id = buildings.neighborhood_id INNER JOIN bedrooms ON bedrooms.id = units.bedrooms_id LEFT JOIN brokerages_agents ON brokerages_agents.id = units.brokerages_agents_id LEFT JOIN brokerages ON brokerages.id = brokerages_agents.brokerages_id WHERE units.site_search_status = 'Live' AND units.market_status = 'active' AND units.market_type = 'Open' AND (buildings.neighborhood_id = '17') AND (bedrooms.id = '4') ORDER BY units.id ASC LIMIT -20, 20