#ERROR RECU:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT Error number: HY000 Error message SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT Error SQL SELECT DISTINCT bdd_country.cny_idt, bdd_country.cny_lib_fr as cny_nam, bdd_country.cny_lib_fr as loc_name, bdd_country.cny_lib_simple FROM bdd_country INNER JOIN flatshare ON flatshare.cny_idt = bdd_country.cny_idt ORDER BY cny_lib_seo ASC Error URL /immobilier/collocation-renovated-furnished-2-5pc-apart-in-geneva-centre-refH13082463233962.html 0:HY000 1:3065 2:Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT
Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409

Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380

Warning: Cannot use a scalar value as an array in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380

Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409

Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380
Renovated, furnished 2.5pc apart in Geneva centre € - Contact now!
Print this page

Colocation: Renovated, furnished 2.5pc apart in Geneva centre

Renovated, furnished 2.5pc apart in Geneva centre

Property ID: H13082463233962

Price: 1700 €

Adress : Grottes - Saint-Gervais, Genève Centre, Genève / Genf, Suisse

Available from : 1-Oct-2013

Full Description

Hello! Being out of town for a while we would like to sublease our flat in Geneva from 1st October 2013 to 31st January 2014. The apartment is located in ?Rue de Vermont? and offers the following: - 65 square meters with two bedrooms. While being away we would like to sublease the flat with one of the two bedrooms. - fully furnished. No need to bring anything yourself. - newly refurbished in 2012 - kitchen is integrated in the living room - separated toilet and bath room - bath room with shower tub - washing machine and dryer in the bathroom - non-smoking flat - Denner supermarket: 3 min walking, Coop and Migros supermarket: 10 min walking - stop of bus No 8 close by (4 min to the central train station ?gare cornavin?, 4 min to the United Nations buildings) - stop of bus No 5 close by (12 min to the airport of Geneva) - base rent of 1700 CHF/month including heating. Plus electricity: 15 CHF/month (our average consumption), Plus internet flat rate: 35 CHF/month. In total: 1750 CHF/month - deposit of 3400 CHF We are looking for an open and friendly person in need of accommodation in this time frame. German and English speaking would be perfect. Pictures on request. Feel free to contact us at: ApartmentVermont(at)gmx.de Jub&Kolja Hallo! Aufgrund einer 4-monatigen Absenz suchen wir eine/-n Zwischenmieter/-in für unsere Wohnung in Genf vom 01. Oktober 2013 bis zum 31. Januar 2014. Die Wohnung liegt in der ?Rue de Vermont? und bietet das Folgende: - 65 Quadratmeter mit 2 Schlafzimmern. Die Wohnung mit einem der Schlafzimmer steht zur Verfügung. - Möbiliert. Es braucht nichts mitgebracht werden. - Die Wohnung wurde 2012 frisch renoviert. - Offene Küche integriert ins Wohnzimmer. - Toilette und Badezimmer sind getrennt. - Das Badezimmer hat eine Duschwanne. - Waschmaschine und Trockner befinden sich im Badezimmer. - Wohnung für Nichtraucher. - Denner Supermarkt: 3 min zu Fuss, Coop und Migros Supermarkt: 10 min zu Fuss. - Haltestelle des BusNr 8 (per Bus in 4 min zum Hauptbahnhof ?gare cornavin? und in 4 min zu den Gebäuden der Vereinten Nationen) - Haltestelle des BusNr 5 (per Bus in 12 min zum Genfer Flughafen) - Kaltmiete von 1700 CHF/Monat inklusive Heizkosten. Plus Strom: 15 CHF/Monat (basierend auf unserem Durchschnittsverbrauch). Plus Internet Flat Rate: 35 CHF/Monat. Total: 1750 CHF/Monat. - Kaution von 3400 CHF. Wir suchen eine offene und freundliche Person mit Bedarf für eine Unterkunft in diesem Zeitraum. Deutsch- und Englischsprachig wäre perfekt. Fotos auf Anfrage. Wir freuen uns über Eure Anfragen. Jub&Kolja

Rooms information

Rooms information
Bedrooms available 1
Bathrooms 1

Flatmate information :

Flatmate information Flatmate preferences information
Gender DoesntMatter Gender DoesntMatter
Age N/A Age N/A - N/A
Smoker DoesntMatter Smoker DoesntMatter
Occupation N/A Occupation DoesntMatter
Pets N/A Couples NotDisclosed
Make Contact
. .
Une Assurance Santé sur Mesure
Une Assurance Santé sur Mesure

ACS, spécialiste de la protection sociale pour expatriés avec plus de 20 ans d'expérience. Demandez un devis dès maintenant!

BUPA GLOBAL
BUPA GLOBAL

Pour aider les individus et les familles à vivre une vie plus longue, plus saine et plus heureuse.

Contactez l'équipe SuperExpat
Contactez l'équipe SuperExpat

Sélection de prestataires, produits et services relatifs à votre déménagement et votre vie à l’étranger... Logement, Finance, Assurance…

Assurance Vie Pour Expatriés!
Assurance Vie Pour Expatriés!

Comparez les offres. En tant qu'expatrié bénéficiez de l’exonération de droit de succession meme apres retour en France!

Transfert Au Meilleur Taux!
Transfert Au Meilleur Taux!

Transferez et changez votre argent au meilleur taux. Paiements Internationaux Importants, Transfert réguliers, Couverture Taux. Devis & Conseils Gratuits!

Vous avez entre 58 et 65 ans?
Vous avez entre 58 et 65 ans?

Faites appel à des experts spécialisés en audit et bilan retraite: Calcul, Rachats de trimestres, Age de départ, interventions auprès des caisses de retraite...

. .

Articles & Guides

Articles & Guides

Immobilier

Déménagement

Assurances

Finance

Articles & Guides

Categories

Categories

Copyright SuperExpat.fr - Designed by Expatfinder.com