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 >= 1000 AND VLR_ALUGUEL <= 2000 ) ) AND ( SUITE=3 ) 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