#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-double-room-in-family-home-to-rent-refH13082213587922.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
We are a professional family ( a married couple and 2 children) living in Chartham Hatch and have a room to rent out. We would like to rent the room to a post graduate on a professional programme e. g. an MA, PGCE, nursing etc. We are looking for a student that needs accommodation but is working at this level as we also work and have children so need to maintain a fairly peaceful household! The rental includes use of the house and large garden, bills (other than use of the phone), access to the Internet (broadband), driveway parking and breakfast and evening meal (if eating with/the same as the family). Also included will be basics such as loo roll, washing up liquid, polish etc We would only charge the weekly rental in term time when you are living in the house - therefore there would be no charge for the holidays if you return home! Though the room would of course be held for you and you would be able to leave your belongings at the house. The start and end date would be flexible upon you needs and we would only charge rental from the date you move in until the date you move out - we will not insist that this is an end or beginning of a month or even week. Rental would be payable one month in advance and a deposit paid - which is refundable upon departure. We live in a large 4 bedroom house which does have an office/study space you can use as well as a lounge, dining room, kitchen and shared bathroom (family bathroom). The property is a short walk from Chartham station which is one stop from Canterbury West. There is also a cycle path from Chartham village into the city. There is very easy access onto the A2 We do have a dog (labrador) so you must like dogs! We have tried to work this as an ideal property for post graduate/professional students e. g. PGCE - if you are keen please do come and have a look at the house or make contact with us. Also do feel free to discuss rental costing too.
Rooms information | |
---|---|
Bedrooms available | 1 |
Bathrooms | 2 |
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 |
ACS, spécialiste de la protection sociale pour expatriés avec plus de 20 ans d'expérience. Demandez un devis dès maintenant!
Pour aider les individus et les familles à vivre une vie plus longue, plus saine et plus heureuse.
Sélection de prestataires, produits et services relatifs à votre déménagement et votre vie à l’étranger... Logement, Finance, Assurance…
Comparez les offres. En tant qu'expatrié bénéficiez de l’exonération de droit de succession meme apres retour en France!
Transferez et changez votre argent au meilleur taux. Paiements Internationaux Importants, Transfert réguliers, Couverture Taux. Devis & Conseils Gratuits!
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...