Imóveis

SELECT * FROM list_avaliable_property WHERE cidade='Porto Belo' and tipoNegocio='venda' and dormitorios=3 and tipoImovel='apartamento' and idEmpresa=39 and idImovel!=42839 and showOnline=1 and status=4 and(preco>=1251652.432 and preco<=1877478.648) group by idImovel order by RAND() LIMIT 3