Appartement
4.5 Pièces
205 m²
CHF 2'225'000.-
CHF 10'854.-/m²
SELECT `_profiles_0`.`societe`, `_profiles_0`.`societe_2` AS `societe2`, `_profiles_0`.`responsable` AS `responsible`, `_profiles_0`.`street` AS `address`, `_profiles_0`.`npa` AS `zipcode`, `_profiles_0`.`city`, `_profiles_0`.`cp` AS `postalbox`, `_cantons_3`.`symbole` AS `canton`, `_profiles_0`.`tel` AS `phone_main`, `_profiles_0`.`renting_dep_tel` AS `phone_rent`, `_profiles_0`.`selling_dep_tel` AS `phone_sale`, `_profiles_0`.`mobile`, `_profiles_0`.`fax`, `_profiles_0`.`email` AS `email_main`, `_profiles_0`.`email_rent` AS `email_rent`, `_profiles_0`.`email_sale` AS `email_sale`, `_profiles_0`.`url`, `_profiles_0`.`info_fr` AS `info`, `_profiles_0`.`pictname` AS `picture_name` FROM `profiles` AS `_profiles_0` LEFT JOIN (`websites_configs_to_profiles` AS `_websites_configs_to_profiles_1`) ON (`_profiles_0`.`id` = `_websites_configs_to_profiles_1`.`profile_id`) LEFT JOIN (`postes` AS `_postes_2`) ON (`_profiles_0`.`npa` = `_postes_2`.`npa`) LEFT JOIN (`cantons` AS `_cantons_3`) ON (`_postes_2`.`canton_id` = `_cantons_3`.`id`) WHERE (`_websites_configs_to_profiles_1`.`website_config_id` IN ('0', '1337') OR `_websites_configs_to_profiles_1`.`website_config_id` IS NULL ) AND (`_profiles_0`.`account_id` = '10000') AND `_profiles_0`.`profile_type` IN ('main', 'main') /* no groups */ ORDER BY (`_profiles_0`.`profile_type` = 'main') DESC, `_profiles_0`.`lastedit_date` DESC /* no limits */ SELECT `_profiles_0`.`societe`, `_profiles_0`.`societe_2` AS `societe2`, `_profiles_0`.`responsable` AS `responsible`, `_profiles_0`.`street` AS `address`, `_profiles_0`.`npa` AS `zipcode`, `_profiles_0`.`city`, `_profiles_0`.`cp` AS `postalbox`, `_cantons_3`.`symbole` AS `canton`, `_profiles_0`.`tel` AS `phone_main`, `_profiles_0`.`renting_dep_tel` AS `phone_rent`, `_profiles_0`.`selling_dep_tel` AS `phone_sale`, `_profiles_0`.`mobile`, `_profiles_0`.`fax`, `_profiles_0`.`email` AS `email_main`, `_profiles_0`.`email_rent` AS `email_rent`, `_profiles_0`.`email_sale` AS `email_sale`, `_profiles_0`.`url`, `_profiles_0`.`info_fr` AS `info`, `_profiles_0`.`pictname` AS `picture_name` FROM `profiles` AS `_profiles_0` LEFT JOIN (`websites_configs_to_profiles` AS `_websites_configs_to_profiles_1`) ON (`_profiles_0`.`id` = `_websites_configs_to_profiles_1`.`profile_id`) LEFT JOIN (`postes` AS `_postes_2`) ON (`_profiles_0`.`npa` = `_postes_2`.`npa`) LEFT JOIN (`cantons` AS `_cantons_3`) ON (`_postes_2`.`canton_id` = `_cantons_3`.`id`) WHERE (`_websites_configs_to_profiles_1`.`website_config_id` IN ('0', '1337') OR `_websites_configs_to_profiles_1`.`website_config_id` IS NULL ) AND (`_profiles_0`.`account_id` = '10000') AND `_profiles_0`.`profile_type` IN ('main', 'main') /* no groups */ ORDER BY (`_profiles_0`.`profile_type` = 'main') DESC, `_profiles_0`.`lastedit_date` DESC /* no limits */ SELECT `_profiles_0`.`societe`, `_profiles_0`.`societe_2` AS `societe2`, `_profiles_0`.`responsable` AS `responsible`, `_profiles_0`.`street` AS `address`, `_profiles_0`.`npa` AS `zipcode`, `_profiles_0`.`city`, `_profiles_0`.`cp` AS `postalbox`, `_cantons_3`.`symbole` AS `canton`, `_profiles_0`.`tel` AS `phone_main`, `_profiles_0`.`renting_dep_tel` AS `phone_rent`, `_profiles_0`.`selling_dep_tel` AS `phone_sale`, `_profiles_0`.`mobile`, `_profiles_0`.`fax`, `_profiles_0`.`email` AS `email_main`, `_profiles_0`.`email_rent` AS `email_rent`, `_profiles_0`.`email_sale` AS `email_sale`, `_profiles_0`.`url`, `_profiles_0`.`info_fr` AS `info`, `_profiles_0`.`pictname` AS `picture_name` FROM `profiles` AS `_profiles_0` LEFT JOIN (`websites_configs_to_profiles` AS `_websites_configs_to_profiles_1`) ON (`_profiles_0`.`id` = `_websites_configs_to_profiles_1`.`profile_id`) LEFT JOIN (`postes` AS `_postes_2`) ON (`_profiles_0`.`npa` = `_postes_2`.`npa`) LEFT JOIN (`cantons` AS `_cantons_3`) ON (`_postes_2`.`canton_id` = `_cantons_3`.`id`) WHERE (`_websites_configs_to_profiles_1`.`website_config_id` IN ('0', '1337') OR `_websites_configs_to_profiles_1`.`website_config_id` IS NULL ) AND (`_profiles_0`.`account_id` = '10000') AND `_profiles_0`.`profile_type` IN ('main', 'main') /* no groups */ ORDER BY (`_profiles_0`.`profile_type` = 'main') DESC, `_profiles_0`.`lastedit_date` DESC /* no limits */
Appartement
CHF 10'854.-/m²
Appartement
CHF 12'714.-/m²
Appartement
CHF 14'117.-/m²
Appartement
CHF 15'455.-/m²
Appartement
CHF 19'329.-/m²
Appartement
CHF 19'471.-/m²
Appartement
CHF 11'244.-/m²
Appartement
CHF 15'558.-/m²
Appartement
CHF 14'589.-/m²
Appartement
CHF 13'097.-/m²
Appartement
CHF 15'558.-/m²