WordPress database error: [Table 'testidxmap_bk.listings_rets_active' doesn't exist]
SELECT ( select COUNT(id) FROM listings_rets_active where ( (street_number IN (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental = 1 ) as total_rent, ( select AVG(list_price) FROM listings_rets_active where ( (street_number IN (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental = 1 ) as prom_price_rent, ( select AVG(list_price) FROM listings_rets_sold where ( (street_number IN (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental IS NULL AND list_date >= "2017-09-22" ) 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 (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental IS NULL /* From [www.euadoromiami.com.br/condo-building/st-regis-bal-harbour/] 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 (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental IS NULL AND list_date >= "2017-09-22" ) as tot_12, (select count(id) FROM listings_rets_sold where ( (street_number IN (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental IS NULL AND list_date >= "2016-09-22" ) as tot_24, (select count(id) FROM listings_rets_sold where ( (street_number IN (9703) and street_name regexp "Collins") ) and zip regexp "33154" AND rental IS NULL AND list_date >= "2015-09-22" ) as tot_36 /* From [www.euadoromiami.com.br/condo-building/st-regis-bal-harbour/] in [/nas/content/live/euadoromiami/wp-content/plugins/idx-real-estate-post-type/admin/generate_information.php:116] */

St. Regis Bal Harbour | 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

St. Regis Bal Harbour

- 9703 Collins Avenue Bal Harbour FL 33154

  • Faixa de preço
    $ 0.00 to $ 0.00
  • Ano construído
    2012
  • Unidades
    270
  • Andares
    26
  • Quartos
    1-4 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 270
  • 12-24 0 270
  • 24-36 0 270
  • 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