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

Chateau Beach Residences | 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

Chateau Beach Residences

- 17475 Collins Ave Sunny Isles Beach FL 33160

property details



Building Amenities:

Entire 2ND Level of Amenities (9,500 SF)
Oceanfront Property with uninterrupted ocean and park views
Magnificent 25 ft. high glass Boutique Lobby Overlooking the Ocean, the Samson Park, and Collins Avenue.
Personal concierge Services
24-hour Security
24-hour Valet parking service
Pool deck with infinity edge pool
Residents Moon Bar with spectacular ocean views
Spa services
Signature her and his Spa with therapies suites
Relaxation terrace with aromatherapy Jacuzzi
Fitness center overlooking the ocean
Wine lounge with private lockers
Cigar bar with humidor boxes
Home theatre
Kids Club
Ballroom
Shabbat Elevator

Residences features:
11 foot ceilings Penthouses
10 foot ceilings
Floor to ceiling impact glass
Staff rooms
Private elevators
Semi private elevators for 2 bedrooms residences
Italian cabinetry
Top of the line appliances

Deposit:
- 30% at the Contract
- 20% 3 Month Later
- 20% April, 2014
- 30% at the Closing (December, 2014)

Maintenance: $ 0,95/SF

PLANTAS

STATISTICAS DE APARTAMENTOS

INVENTARIO

HISTORICO DE VENDAS(ULTIMOS MESES)

  • ULTIMO 12 0 84
  • 12-24 0 84
  • 24-36 0 84
  • 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