#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-2-student-rooms-in-a-3bedroom-house-not-portobello-refH13082282834525.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
2 student rooms in a 3bedroom house NOT portobello £ - Contact now!
Print this page

Colocation: 2 student rooms in a 3bedroom house NOT portobello

2 student rooms in a 3bedroom house NOT portobello

Property ID: H13082282834525

Price: 335 £

Adress : Portobello, Edinburgh, Royaume-Uni

Available from : 26-Aug-2013

Full Description

Two upstairs bedroom( one now let ) in refurbished house with garden in Prestonpans East Lothian( you would need a car if going to Napier or Heriot watt uni .or a very long bus journey) shared living room, bathroom and kitchen, all mod cons power shower, dish washer, full TV package in living room with 5 speaker surround sound. Car parking on street, 10 minutes walk to rail way station. 15 minute journey time to Queen Margret university by car. 5 minute by Train. Bus stop 2 minute walk away. looking for students or professionals. Male or Female I have full references and a check able background. It's worth adding if travelling to QMU by car the entrance and exit are on the by-pass, so it may be easier and quicker to travel to and from here rather than Musselburgh.. update both rooms now have brand new double beds, desk with chair and hardwired broadband & wireless as well. pictures of rooms now on web site, all work should be finished end of April. £100 deposit secures your room for the start of uni this summer.. more pictures via email..

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