#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-located-10-mins-bus-journey-from-city-centre-70pw-refH130225114431288.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
Located 10 mins bus journey from city centre £70pw £ - Contact now!
Print this page

Colocation: Located 10 mins bus journey from city centre £70pw

Located 10 mins bus journey from city centre £70pw

Property ID: H130225114431288

Price: 303 £

Adress : Edinburgh Centre, Edinburgh, Royaume-Uni

Available from : 26-Aug-2013

Full Description

2 Large double rooms for rent in modern flat, for male occupancy, the flat has two bedrooms, where one is occupied by a student from Hungry,(now returned home) it is situated two floors up in a block of 8 flats all of which are owned by the residents, thus great care is taken of the stairwell and the green to the rear of the building, the area where the flat is situated is in a very quiet cul-de-sac, as is like the building where most of the residents are retired The flat has a modern kitchen with all facillites, freezer, fridge, cooker,microwave,washing machine and leads on to a balcony, which is a great sun trap in the summer months. The room is a large room with a large double bed, two bed side cabinets, a wordrope, chest of drawers and a T.V with freeveiw and DVD player. The bathroom is completely new with a new bath,toilet, sink and power shower. There is a 10 mins bus journey to/ from city centre, and the bus stops are a few minutes walk from the flat.There is also parking bays to the front of the building. It is a few minutes walk from the local library and 10 mins from the local sports centre and few mins walk from local shops.It is also a 15 mins walk from Edinburgh Telford College. My self I work mostly during the summer as a customer services assistant at Edinburgh Airport. The flat is available now for immediate entry.

Rooms information

Rooms information
Bedrooms available 2
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