#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-casita-con-vistas-a-pie-de-playa-refH1308216149974.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
CASITA CON VISTAS a pie de playa!! € - Contact now!

Colocation: CASITA CON VISTAS a pie de playa!!

CASITA CON VISTAS a pie de playa!!

Property ID: H1308216149974

Price: 290 €

Adress : Otras Áreas, Lanzarote, Espagne

Available from : 28-Aug-2013

Full Description

Hola! Soy Ana busco un compañero/a de piso. Es un pisito con mucho encanto, esta a pie de playa (Pocillos) y la urbanización en la que se encuentra es muy tranquila con piscina incluida. El piso es totalmente exterior y esta compuesto de: hall, cocina (amueblada con vitroceramica, horno y extractor, microondas), baño, habitación con cama de matrimonio y armario empotrado, salón grande y muy soleado y lo mejor es la terraza y sus vistas!! (entre la terraza y el mar solo esta la arena y el jardín...) Esta a 5 min de parada de bus y taxi, supermercado y de la avenida. Facilidad de aparcamiento. 15 min del centro del pueblo de Puerto del Carmen. En el precio esta incluido facturas luz, agua y piscina. Hi there! Im Ana, 34, tidy, respectful and above all fun and sociable. Looking for a roommate (English speaking person), in a ground floor gorgeus apartment just into the beach (Pocillos). Enjoy sunny breakfasts seated at the terrace. All the modern facilities. Treat yourself! Better come and see!!!. 290 euros per month including bills. I give you more details about the flat: comprises of hall, kitchen (furnished with ceramic cooking surface, oven and extractor hood, microwave), family sized bathroom, bedroom with a big built in wardrobe, matrimonial bed, bright and big living room and the best is the sunny terrace and its views (between the terrace ant the sea is the sand...). Its better to have a look than my explanations... In the Price, 290? (paid the first day) is included water and electricity bills, and also communal swimming pool. Its really quiet, sunny and fresh flat. And also, bus and taxi stop, supermarket is 5 min and 15 minutes walking to the centre of Puerto del Carmen.

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