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 ( ( VLR_VENDA >= 100000 AND VLR_VENDA <= 300000 ) ) AND ( DORMITORIO=1 ) 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