#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-large-double-room-in-newly-renovated-property-refH130819122146702.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
Large Double Room in Newly Renovated Property £ - Contact now!

Colocation: Large Double Room in Newly Renovated Property

Large Double Room in Newly Renovated Property

Property ID: H130819122146702

Price: 500 £

Adress : Kenton, Newcastle upon Tyne, Royaume-Uni

Available from : 1-Oct-2013

Full Description

Having renovated our larger 3 bedroom semi, my partner and I are looking for someone to rent our spare double room. The area: Kenton is a few miles from the city centre, which can be reached via a number of bus services. The journey time is a little over 10 minutes as there aren't many stops. We are located on the periphery of Gosforth, with the high street within easy reach. Our street is very quiet and tidy, consisting of 3 and 4 bedroom semi detached and detached property. The property has been renovated to a very high standard, with no expense spared. The room itself consists of a king size bed with memory foam mattress, 2 wardrobes, a large chest of drawers and two bedside tables. The furniture was all purchased at Barker and Stonehouse. The property consists of a front lounge, a large kitchen diner with breakfast bar and dining table (with range oven, american style fridge freezer, dishwasher and bottle cooler), a utility room with separate washer/dryer, 3 bedrooms and a large luxury bathroom with a bath and walk in shower. To the rear of the property is a decent size garden, with a large deck, accessed from either the utility room, or the kitchen diner. There is high speed broadband access with wifi capability. The room on offer also has a wall hung 32" LCD TV which has access to it's own Virgin HD recordable TV service. We are looking for someone that will treat our property and possessions with utmost respect. This generally isn't a party house, but we don't mind a drink and a bit of banter. The property will be available around the end of September, beginning of October, as we are in the the middle of working on our utility room. About us: I am a 29 year old lad, qualified electrician with experience renovating houses but currently studying Architectural Engineering at Northumbria University. I am a Newcastle United season ticket holder and I go to all home games and try to watch the majority away games. I like a pint or 8 in town or on Gosforth High Street. There is also a pub local to the house, called the Duke of Wellington, which isn't bad for the odd drink. My partner is 27, and a Primary School Teacher. She is quite partial to a glass of red and doesn't mind the occasional night out. She likes to keep the house clean and tidy. We also have 2 puppies, a Bedlington Terrier and Welsh Terrier. They're no bother, and will be sleeping in the Utility room once this is completed. They are crate trained and currently sleep in their crate in the bay window of the kitchen diner. All bills are included in the price of the rent, including Virgin TV. The photos shown were taken prior to furnishing the property, but we will upload photos of the finished rooms once we've taken some. If you have any questions, please contact me 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
. .
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