WordPress database error: [Table 'testidxmap_bk.listings_rets_active' doesn't exist]
SELECT ( select COUNT(id) FROM listings_rets_active where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental = 1 ) as total_rent, ( select AVG(list_price) FROM listings_rets_active where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental = 1 ) as prom_price_rent, ( select AVG(list_price) FROM listings_rets_sold where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental IS NULL AND list_date >= "2017-10-20" ) as prom_price_sold, COUNT(id) AS total_sale, min(square_feet) AS min_sf, max(square_feet) AS max_sf, min(list_price) AS price_min, max(list_price) AS price_max, AVG(square_feet) AS pro_sf, AVG(list_price) AS prom_price, min( list_date ) AS min_date , max( list_date ) AS max_date FROM listings_rets_active where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental IS NULL /* From [www.euadoromiami.com.br/condo-building/loft-downtown-2/] in [/nas/content/live/euadoromiami/wp-content/plugins/idx-real-estate-post-type/admin/generate_information.php:85] */

WordPress database error: [Table 'testidxmap_bk.listings_rets_sold' doesn't exist]
select (select count(id) FROM listings_rets_sold where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental IS NULL AND list_date >= "2017-10-20" ) as tot_12, (select count(id) FROM listings_rets_sold where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental IS NULL AND list_date >= "2016-10-20" ) as tot_24, (select count(id) FROM listings_rets_sold where ( (street_number IN (133) and street_name regexp "2") ) and zip regexp "33132" AND rental IS NULL AND list_date >= "2015-10-20" ) as tot_36 /* From [www.euadoromiami.com.br/condo-building/loft-downtown-2/] in [/nas/content/live/euadoromiami/wp-content/plugins/idx-real-estate-post-type/admin/generate_information.php:116] */

Loft Downtown 2 | I ADORE MIAMI
Miami 786.440.8404
Brasil 021.3958.0507
Condos By Area Search Contact Us

Localização

idr_city

As melhores coisas para fazer em Miami

As melhores atividades de Miami

idr_map

Mapa interativo de Miami

imóveis em Destaque

idr_tablet

panfleto

veja / baixe nosso panfleto

idr_moove

video de propriedades

video tour de propriedades

I adore miami blog

detalhes

ver todos os apartamentos

Loft Downtown 2

- 133 2nd Avenue Miami FL 33132

  • Faixa de preço
    $ 0.00 to $ 0.00
  • Ano construído
    2007
  • Unidades
    496
  • Andares
    36
  • Quartos
    1-2 bedrooms
  • Área
    n/a to n/a
  • Média preço por m²
    $ 0.00
  • Média de dias no mercado
    0 day(s)

PLANTAS

STATISTICAS DE APARTAMENTOS

INVENTARIO

HISTORICO DE VENDAS(ULTIMOS MESES)

  • ULTIMO 12 0 496
  • 12-24 0 496
  • 24-36 0 496
  • VENDIDO
  • 0 Vendas
  • 0 PARA ALUGAR
  • 0% do predio

  • MEDIA DE PRECO DE VENDAS*
    $ 0.00
  • MEDIA DE PRECO DE LISTA*
    $ 0.00
  • MEDIA DE PRECO DE ALUGUEL*
    $ 0.00

 

casas / vilas / mansões

Condominio em destaque

Aventura
Bal Harbour
Brickell / Downtown
brickell Key
Coconut Grove
Hallandale
Hollywood
Israel
Key Biscayne
Miami Beach
Midtown
South Beach
Sunny Isles