Appartement
4.5 Pièces
131 m²
CHF 647'000.-
CHF 4'939.-/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 4'939.-/m²
Appartement
CHF 4'893.-/m²

Projet
Appartement
CHF 4'206.-/m²
Appartement
CHF 5'472.-/m²
Appartement
CHF 6'222.-/m²
Duplex
CHF 5'410.-/m²
Attique
CHF 14'906.-/m²
Appartement
CHF 16'556.-/m²
Attique
CHF 14'127.-/m²
Appartement
CHF 9'027.-/m²