Código do Imóvel:

{"isset_fin":true,"is_venda":"S","accepts_sell":null,"total_sell":null}

Proximidades Em até 1,5km

{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"restaurant","type_search":"imovel","id":"4908"}
{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"supermarket","type_search":"imovel","id":"4908"}
{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"park","type_search":"imovel","id":"4908"}
{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"university","type_search":"imovel","id":"4908"}
{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"cafe","type_search":"imovel","id":"4908"}
{"places":{"return":false,"imovel":{"error":"N\u00e3o Encontrado","retorno":false,"sql":"SELECT DISTINCT \n i.id,\n COALESCE(i.code, emp.code) AS code,\n \"www.margiotta.com.br\" AS domain_web,\n i.id_empreendimento,\n COALESCE(emp.is_exclusividade, i.is_exclusividade) AS is_exclusividade,\n i.id_imovel_situacao,\n i.total_area,\n i.private_area,\n i.furniture, \n i.public_transportation, \n i.pets_allowed, \n COALESCE(iv.description, i.description) AS description, \n i.bedrooms, \n i.bathrooms, \n i.floor, \n COALESCE(i.ano_construcao, emp.ano_construcao) AS ano_construcao,\n COALESCE(i.updated_at, i.created_at) AS created_at, \n COALESCE(iv.dwelling_description, i.dwelling_description) AS dwelling_description, \n COALESCE(iv.add_code, \"\") AS add_code,\n i.district_description, \n i.mobility_description, \n i.ideal_tenant_profile, \n i.moving_house_available, \n i.moving_house_date, \n i.condominium_name, \n i.developer, \n i.suites, \n i.property_type, \n COALESCE(i.garages, 0) AS garages, \n i.doorkeeper, \n COALESCE(iv.video, i.video, emp.video) AS video, \n COALESCE(i.tour_virtual, emp.tour_virtual) AS tour_virtual, \n i.tower, \n i.voltage, \n i.furniture_description, \n i.value, \n i.condominium, \n i.iptu, \n i.iptu_included, \n i.total_value, \n i.minimum_income, \n i.fire_insurance, \n i.tipos_garantias,\n i.percent_first, \n i.percent_monthly, \n i.total_sell,\n i.html_code,\n i.html_code_visita_lead,\n COALESCE(i.show_valores, emp.show_valores) AS show_valores,\n i.accepts_sell,\n i.accepts_rent,\n i.id_tipo_imovel,\n COALESCE(i.street, emp.street) AS street, \n COALESCE(i.number, emp.number) AS number, \n COALESCE(i.zip_code, emp.zip_code) AS zip_code, \n COALESCE(i.latitude, emp.latitude) AS lat, \n COALESCE(i.longitude, emp.longitude) AS lng, \n IF(i.tried_maps = \"N\" OR emp.tried_maps = \"N\", \"N\", \"S\") AS tried_maps,\n COALESCE(b.nome, b2.nome, i.district) AS nome_bairro, \n COALESCE(c.uf, c2.uf) AS uf, \n COALESCE(b.slug, b2.slug) AS slug_bairro, \n COALESCE(c.slug, c2.slug) AS slug_cidade,\n COALESCE(b.id, b2.id) AS id_bairro, \n COALESCE(c.id, c2.id) AS id_cidade, \n COALESCE(c.nome, c2.nome) AS nome_cidade, \n COALESCE(emp_sit2.nome, emp_sit.nome, \"\") AS nome_empreendimento_situacao,\n COALESCE(emp.show_ocupacao_unidades, \"N\") AS show_ocupacao_unidades,\n i.id_exibir_localizacao,\n i.complement,\n i.extra_imovel,\n COALESCE(emp.extra_condominio, i.extra_condominio) AS extra_condominio,\n tpi.nome AS nome_tipo_imovel,\n tpi.shortname_plural,\n tpi.pronome,\n tpi.shortname,\n tpi.value_financiei,\n COALESCE(iv.id_portal_destaque, i.id_portal_destaque) AS id_portal_destaque,\n COALESCE(emp.nearby, i.nearby) AS nearby,\n COALESCE(emp.nearby_last_update, i.nearby_last_update) AS nearby_last_update,\n i.setted_to\n FROM imovel AS i LEFT JOIN empreendimento AS emp ON\n i.id_empreendimento IS NOT NULL AND\n emp.id = i.id_empreendimento\n LEFT JOIN empreendimento_situacao AS emp_sit ON\n emp_sit.id = emp.id_empreendimento_situacao\n LEFT JOIN empreendimento_situacao AS emp_sit2 ON\n emp_sit2.id = i.id_empreendimento_situacao\n LEFT JOIN tipo_imovel AS tpi ON\n i.id_tipo_imovel = tpi.id\n LEFT JOIN area AS b ON b.id = i.id_area \n LEFT JOIN cidade AS c ON c.id = i.id_cidade \n LEFT JOIN area AS b2 ON b2.id = emp.id_area \n LEFT JOIN cidade AS c2 ON c2.id = emp.id_cidade \n \n LEFT JOIN imovel_vitrine AS iv\n FORCE INDEX FOR JOIN (ativo) ON\n iv.id_imovel = i.id AND\n iv.id_empresa = :id_empresa2 AND\n iv.ativo = \"S\"\n LEFT JOIN vitrine_espelho AS ve\n FORCE INDEX FOR JOIN (id_empresa_source) ON\n ve.id_empresa = :id_empresa3 AND\n ve.id_empresa_source = i.id_empresa AND\n ve.ativo = \"S\"\n WHERE \n i.id = :id_imovel AND (\n i.id_empresa = :id_empresa OR\n ve.id IS NOT NULL OR\n iv.id IS NOT NULL\n )\n GROUP BY i.id\n LIMIT 1"}},"nearby_key":"primary_school","type_search":"imovel","id":"4908"}
Quero saber mais:
Tendencia
Alta procura
8 pessoas viram esse imóvel recentemente, não perca tempo!