(11) 3198-2889
Filtros
Filtros
string(468) "SELECT SQL_CALC_FOUND_ROWS * FROM websites.tb_imovel_consolidado WHERE 1 AND universo IN ('we') AND tipo_oferta IN ('alugar', 'alugar_vender') AND tipo_imovel IN ('Andar Corporativo') AND cidade IN ('São Paulo') AND uf IN ('sp')AND ( ( busca_regiao LIKE ('Santo Amaro%') OR busca_bairro LIKE ('Santo Amaro%')) OR (regiao LIKE ('%Santo Amaro%') OR bairro LIKE ('%Santo Amaro%') ) ) ORDER BY destaque DESC, ranking DESC, CHAR_LENGTH(URL) DESC "