Linda cobertura de 2 dormitórios

Vila Nova

Área Total
156m²
Área Privativa
111m²
Dormitórios
2
Garagem
1
Banheiros
2
Mobiliado
Não
Animais
Aceita
Ver todas fotos

O que te espera:

Vende belíssima Cobertura que no pavimento inferior estão os 02 dormitórios, living c/ sacada, cozinha, banheiro social e área de serviço. No pavimento superior amplo living c/ sacadão em "L", churrasqueira, banheiro social e terraço. Pertence também ao imóvel 01 vaga escriturada.

 
Condomínio: Village Center

Código do Imóvel: 8563

Imóvel

  • Cobertura
  • Churrasqueira
  • Acessibilidade
  • Área de Serviço
  • Banheiro Auxiliar
  • Piscina
  • Salão de Festas
  • Banheiro Social
  • Interfone
  • area-tecnica-para-ar-condicionado

Condomínio

  • Elevador
  • Piscina
  • Playground
  • Porteiro 24 horas
  • Estacionamento Rotativo
  • Chimarródromo
  • Fitness ao ar livre
  • Guarita
  • Piscina Infantil
  • Pista de Caminhada
  • vaga-para-visitante
Adicionar
R$ 330.000
Condomínio R$ 400
IPTU / anual R$ 900
array(4) { ["retorno"]=> bool(false) ["sql"]=> string(2275) "SELECT i.id, COALESCE(iv.description, i.description) AS description, b.nome AS nome_bairro, c.slug AS slug_cidade, i.`value`, i.total_sell, i.show_valores, i.bedrooms, i.accepts_rent, i.accepts_sell, COALESCE(i.garages, 0) AS garages, i.total_area, (SELECT IF(p.id_empreendimento IS NULL, CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/", p.property_id, "/", p.image), CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/empreendimento/", p.id_empreendimento, "/", p.image)) FROM pictures AS p WHERE (p.property_id = i.id OR p.id_empreendimento = i.id_empreendimento) AND p.active = "true" ORDER BY p.id_empreendimento DESC, p.seq ASC, p.id DESC LIMIT 1) AS image FROM imovel AS i LEFT JOIN area AS b ON b.id = i.id_area LEFT JOIN cidade AS c ON c.id = i.id_cidade LEFT JOIN imovel_vitrine AS iv FORCE INDEX FOR JOIN (ativo) ON iv.id_imovel = i.id AND iv.id_empresa = 520 AND iv.ativo = "S" WHERE i.id_imovel_situacao = 4 AND i.id NOT IN (8563) AND i.accepts_sell = "S" AND i.id_tipo_imovel = 1 AND i.id_cidade = 4314902 AND i.total_sell > 297000 AND i.total_sell < 363000 AND ( i.id_empresa = 520 OR i.id_empresa IN (SELECT ve.id_empresa_source FROM vitrine_espelho AS ve FORCE INDEX FOR JOIN (id_empresa) WHERE ve.id_empresa = 520 AND ve.ativo = "S") OR i.id IN (SELECT iv2.id_imovel FROM imovel_vitrine AS iv2 FORCE INDEX FOR JOIN (is_destaque) WHERE iv2.id_empresa = 520 AND iv2.ativo = "S") ) GROUP BY i.id ORDER BY RAND() LIMIT 4" ["data"]=> array(0) { } ["loop_1"]=> array(4) { ["retorno"]=> bool(false) ["sql"]=> string(2275) "SELECT i.id, COALESCE(iv.description, i.description) AS description, b.nome AS nome_bairro, c.slug AS slug_cidade, i.`value`, i.total_sell, i.show_valores, i.bedrooms, i.accepts_rent, i.accepts_sell, COALESCE(i.garages, 0) AS garages, i.total_area, (SELECT IF(p.id_empreendimento IS NULL, CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/", p.property_id, "/", p.image), CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/empreendimento/", p.id_empreendimento, "/", p.image)) FROM pictures AS p WHERE (p.property_id = i.id OR p.id_empreendimento = i.id_empreendimento) AND p.active = "true" ORDER BY p.id_empreendimento DESC, p.seq ASC, p.id DESC LIMIT 1) AS image FROM imovel AS i LEFT JOIN area AS b ON b.id = i.id_area LEFT JOIN cidade AS c ON c.id = i.id_cidade LEFT JOIN imovel_vitrine AS iv FORCE INDEX FOR JOIN (ativo) ON iv.id_imovel = i.id AND iv.id_empresa = 520 AND iv.ativo = "S" WHERE i.id_imovel_situacao = 4 AND i.id NOT IN (8563) AND i.accepts_sell = "S" AND i.id_tipo_imovel = 1 AND i.id_cidade = 4314902 AND i.total_sell > 264000 AND i.total_sell < 396000 AND ( i.id_empresa = 520 OR i.id_empresa IN (SELECT ve.id_empresa_source FROM vitrine_espelho AS ve FORCE INDEX FOR JOIN (id_empresa) WHERE ve.id_empresa = 520 AND ve.ativo = "S") OR i.id IN (SELECT iv2.id_imovel FROM imovel_vitrine AS iv2 FORCE INDEX FOR JOIN (is_destaque) WHERE iv2.id_empresa = 520 AND iv2.ativo = "S") ) GROUP BY i.id ORDER BY RAND() LIMIT 4" ["data"]=> array(0) { } ["loop_2"]=> array(4) { ["retorno"]=> bool(false) ["sql"]=> string(2223) "SELECT i.id, COALESCE(iv.description, i.description) AS description, b.nome AS nome_bairro, c.slug AS slug_cidade, i.`value`, i.total_sell, i.show_valores, i.bedrooms, i.accepts_rent, i.accepts_sell, COALESCE(i.garages, 0) AS garages, i.total_area, (SELECT IF(p.id_empreendimento IS NULL, CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/", p.property_id, "/", p.image), CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/empreendimento/", p.id_empreendimento, "/", p.image)) FROM pictures AS p WHERE (p.property_id = i.id OR p.id_empreendimento = i.id_empreendimento) AND p.active = "true" ORDER BY p.id_empreendimento DESC, p.seq ASC, p.id DESC LIMIT 1) AS image FROM imovel AS i LEFT JOIN area AS b ON b.id = i.id_area LEFT JOIN cidade AS c ON c.id = i.id_cidade LEFT JOIN imovel_vitrine AS iv FORCE INDEX FOR JOIN (ativo) ON iv.id_imovel = i.id AND iv.id_empresa = 520 AND iv.ativo = "S" WHERE i.id_imovel_situacao = 4 AND i.id NOT IN (8563) AND i.accepts_sell = "S" AND i.id_tipo_imovel = 1 AND i.id_cidade = 4314902 AND ( i.id_empresa = 520 OR i.id_empresa IN (SELECT ve.id_empresa_source FROM vitrine_espelho AS ve FORCE INDEX FOR JOIN (id_empresa) WHERE ve.id_empresa = 520 AND ve.ativo = "S") OR i.id IN (SELECT iv2.id_imovel FROM imovel_vitrine AS iv2 FORCE INDEX FOR JOIN (is_destaque) WHERE iv2.id_empresa = 520 AND iv2.ativo = "S") ) GROUP BY i.id ORDER BY RAND() LIMIT 4" ["data"]=> array(0) { } ["loop_3"]=> array(4) { ["retorno"]=> bool(false) ["sql"]=> string(2197) "SELECT i.id, COALESCE(iv.description, i.description) AS description, b.nome AS nome_bairro, c.slug AS slug_cidade, i.`value`, i.total_sell, i.show_valores, i.bedrooms, i.accepts_rent, i.accepts_sell, COALESCE(i.garages, 0) AS garages, i.total_area, (SELECT IF(p.id_empreendimento IS NULL, CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/", p.property_id, "/", p.image), CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/empreendimento/", p.id_empreendimento, "/", p.image)) FROM pictures AS p WHERE (p.property_id = i.id OR p.id_empreendimento = i.id_empreendimento) AND p.active = "true" ORDER BY p.id_empreendimento DESC, p.seq ASC, p.id DESC LIMIT 1) AS image FROM imovel AS i LEFT JOIN area AS b ON b.id = i.id_area LEFT JOIN cidade AS c ON c.id = i.id_cidade LEFT JOIN imovel_vitrine AS iv FORCE INDEX FOR JOIN (ativo) ON iv.id_imovel = i.id AND iv.id_empresa = 520 AND iv.ativo = "S" WHERE i.id_imovel_situacao = 4 AND i.id NOT IN (8563) AND i.accepts_sell = "S" AND i.id_tipo_imovel = 1 AND ( i.id_empresa = 520 OR i.id_empresa IN (SELECT ve.id_empresa_source FROM vitrine_espelho AS ve FORCE INDEX FOR JOIN (id_empresa) WHERE ve.id_empresa = 520 AND ve.ativo = "S") OR i.id IN (SELECT iv2.id_imovel FROM imovel_vitrine AS iv2 FORCE INDEX FOR JOIN (is_destaque) WHERE iv2.id_empresa = 520 AND iv2.ativo = "S") ) GROUP BY i.id ORDER BY RAND() LIMIT 4" ["data"]=> array(0) { } ["loop_4"]=> array(3) { ["retorno"]=> bool(false) ["sql"]=> string(2172) "SELECT i.id, COALESCE(iv.description, i.description) AS description, b.nome AS nome_bairro, c.slug AS slug_cidade, i.`value`, i.total_sell, i.show_valores, i.bedrooms, i.accepts_rent, i.accepts_sell, COALESCE(i.garages, 0) AS garages, i.total_area, (SELECT IF(p.id_empreendimento IS NULL, CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/", p.property_id, "/", p.image), CONCAT("https://14736y.ha.azioncdn.net/uploads/picture/image/empreendimento/", p.id_empreendimento, "/", p.image)) FROM pictures AS p WHERE (p.property_id = i.id OR p.id_empreendimento = i.id_empreendimento) AND p.active = "true" ORDER BY p.id_empreendimento DESC, p.seq ASC, p.id DESC LIMIT 1) AS image FROM imovel AS i LEFT JOIN area AS b ON b.id = i.id_area LEFT JOIN cidade AS c ON c.id = i.id_cidade LEFT JOIN imovel_vitrine AS iv FORCE INDEX FOR JOIN (ativo) ON iv.id_imovel = i.id AND iv.id_empresa = 520 AND iv.ativo = "S" WHERE i.id_imovel_situacao = 4 AND i.id NOT IN (8563) AND i.accepts_sell = "S" AND ( i.id_empresa = 520 OR i.id_empresa IN (SELECT ve.id_empresa_source FROM vitrine_espelho AS ve FORCE INDEX FOR JOIN (id_empresa) WHERE ve.id_empresa = 520 AND ve.ativo = "S") OR i.id IN (SELECT iv2.id_imovel FROM imovel_vitrine AS iv2 FORCE INDEX FOR JOIN (is_destaque) WHERE iv2.id_empresa = 520 AND iv2.ativo = "S") ) GROUP BY i.id ORDER BY RAND() LIMIT 4" ["data"]=> array(0) { } } } } } }
[]