valor:

SELECT distinct imovel_dormitorios FROM imovel WHERE imovel_dormitorios >= 1 and imovel_id_imobiliaria = '343' AND rec = '0' AND imovel_excluido = '0' ORDER BY imovel_dormitorios DESC LIMIT 0, 1;imovel_dormitorios: 6Quartos1+2+3+4+5+6+