There is an error on the SQL command.

SQL:
select sql_cache COUNT(CODIGO) as n FROM fbz_imoveis imo WHERE VER_WEB='Sim' AND (STATUS = 'VENDA' OR STATUS = 'ALUGUEL' OR STATUS = 'VENDA E ALUGUEL') AND INSTR(STATUS,'ALUGUEL')>0 AND ( ( VLR_ALUGUEL >= 0 AND VLR_ALUGUEL <= 1000 ) ) AND ( DORMITORIO>=4 ) AND AREA_PRIVATIVA>0 AND ( )

Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1