select i.*, t.*
from tb_unsoft_imoveis i
LEFT JOIN tb_unsoft_tipos t on t.tip_id=i.imo_tipo
WHERE i.imo_mostrar='1' and i.imo_finalidade like '%V%' and i.imo_datadelete='0000-00-00 00:00:00' and i.imo_datalixeira='0000-00-00 00:00:00'
ORDER by i.imo_valor_venda desc, imo_id desc LIMIT 36,12