SELECT distinct id_imovel, imovel_id_negocio FROM imovel WHERE imovel_excluido = 0 and rec = 0 and imovel_ativo = 1 and imovel_id_imobiliaria = '343'<br>sql: 2<option value="">Negócio</option><option value="1">Venda</option><option value="2">Locação</option>