Los alquileres Malidri, casa de campo, chalet, Xaramela casa cerca de Dax, en las Landas (40).

Xaramela albergue, situado cerca de Dax, en las Landas (40), y está completamente renovado .

Esta casa de campo incluye una cocina equipada con un comedor, una sala de estar, un dormitorio con una cama de 140 y otra habitación con 3 camas de 90, cuarto de baño, WC independiente.

Situado en el primer piso de una casa tradicional, que ofrece una superficie de 70 metros cuadrados con una capacidad de hasta 5 personas. Posibilidad se ofrecerá al grupo para familias numerosas o vacaciones con amigos, la casa Gorria Etxea se encuentra en la planta baja y el beneficio de una superficie de 160 m² para 13 personas.
El acceso seguro al interior de la propiedad de su vehículo.

Ofrecemos una zona común de estar con cabañas contiguas, situado fuera en la forma de una terraza cubierta en un lado y un espacio completamente abierto por el otro, ideal para la "perezosa" en la muebles de jardín, sino también para sus noches de barbacoa.
También estará disponible, una bolera y varios juegos al aire libre (raquetas, columpio,  ...)

Situado en las afueras de la localidad de Pontonx sur l'Adour en las Landas (40), esta casa muy tranquila seducirá a que disfrute de su estancia.

Se realiza un spa, nuestra casa está muy bien situado cerca de Préchacq les Bains, Saint Paul les Dax y Dax.
Sólo se necesita para sus vacaciones, estamos a 30 minutos del Océano, Bayona, Biarritz, la costa vasca ya 45 minutos de España.

LOS EQUIPOS :

  • Frigorífico-congelador, encimera de gas, horno eléctrico, tostadora, cafetera, microondas, licuadora, batidora, lavavajillas, lavadora, plancha y tabla de planchar.
  • Casa de niño disponible: cuna, trona, cambiador, parque, baño.
  • TV con TDT, acceso a Internet (libre de la caja) y WiFi segura, libre e ilimitado. reversible de calefacción / aire acondicionado central.
Casas Xaramela
  • Mémoire utilisée par PHP : 4.06 MB
  • Pic mémoire allouée par PHP : 5.22 MB
  • Temps d'execution du script : 0.852 s
  • Lang : es
  • Path : gite-xaramela
  • Route : pagesItem
  • $okt->page->module : pages
  • $okt->page->action : item
ID Query Time
1
SET NAMES utf8mb4
0.00037
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
modules_sitti_core_users AS u INNER JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id LEFT JOIN
modules_sitti_core_users_online AS o ON
o.ident='54.91.62.236' WHERE u.id=1
0.00072
3
UPDATE modules_sitti_core_users_online SET
logged=1642358542,
prev_url='http://www.location-gites-landes.com/es/gite-xaramela'
WHERE ident='54.91.62.236'
0.00061
4
SELECT id_selection FROM modules_sitti_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
0.00073
5
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00046
6
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC 
0.00090
7
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC 
0.00051
8
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00042
9
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC 
0.00087
10
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC 
0.00048
11
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00045
12
 SELECT * 
                        FROM
modules_sitti_mod_resa_reservation_detail
						WHERE id_reservation = '108'  ORDER BY
index_selection, libelle 
0.00051
13
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00109
14
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC 
0.00089
15
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC 
0.00049
16
UPDATE modules_sitti_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00060
17
UPDATE modules_sitti_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
0.00052
18
SELECT id, title, code, img, active, ord FROM
modules_sitti_core_languages WHERE 1  AND code='es' ORDER BY
ord ASC 
0.00045
19
SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM modules_sitti_mod_pages AS p  INNER JOIN
modules_sitti_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='es'  LEFT OUTER JOIN
modules_sitti_mod_pages_categories AS r ON
r.id=p.category_id  LEFT OUTER JOIN
modules_sitti_mod_pages_categories_locales AS rl ON
r.id=rl.category_id AND rl.language='es' WHERE 1  AND
pl.language='es'  AND pl.slug='gite-xaramela' AND p.active=1
ORDER BY p.created_at DESC 
0.00310
20
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM modules_sitti_mod_map AS m
 LEFT JOIN modules_sitti_mod_map_locales AS ml ON
m.id=ml.id_map AND ml.language='es' WHERE 1  AND
ml.language='es' AND m.active=1 ORDER BY m.created_at DESC 
0.00062
21
SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM modules_sitti_mod_pages AS p  INNER JOIN
modules_sitti_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='es'  LEFT OUTER JOIN
modules_sitti_mod_pages_categories AS r ON
r.id=p.category_id  LEFT OUTER JOIN
modules_sitti_mod_pages_categories_locales AS rl ON
r.id=rl.category_id AND rl.language='es' WHERE 1  AND
pl.language='es' AND p.active=1 ORDER BY p.created_at DESC 
0.00262
22
SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id,
f.bloc, f.colonne, f.picto, f.options, f.info_personnelle,
fl.language, fl.title, fl.description, fl.value, fl.legend
FROM modules_sitti_mod_pages_forms_fields AS f  LEFT JOIN
modules_sitti_mod_pages_forms_fields_locales AS fl ON
fl.field_id=f.id WHERE 1  AND active>0  AND page_id=3 AND
fl.language='es' ORDER BY ord ASC 
0.00092
23
SELECT p.id, p.user_id, p.category_id, p.active, p.selected,
p.created_at, p.updated_at, p.end_at, p.images, p.files,
p.tpl, p.visit, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.content_short, pl.meta_description, pl.meta_keywords,
pl.words, u.username, u.lastname, u.firstname, rl.title AS
category_title, rl.slug AS category_slug, r.items_tpl AS
category_items_tpl FROM modules_sitti_mod_news AS p  LEFT
OUTER JOIN modules_sitti_core_users AS u ON u.id=p.user_id 
INNER JOIN modules_sitti_mod_news_locales AS pl ON
p.id=pl.post_id AND pl.language='es'  LEFT OUTER JOIN
modules_sitti_mod_news_categories AS r ON r.id=p.category_id
 LEFT OUTER JOIN modules_sitti_mod_news_categories_locales
AS rl ON r.id=rl.category_id AND rl.language='es' WHERE 1 
AND pl.language='es' AND p.active=1 ORDER BY p.selected
DESC, p.created_at DESC LIMIT 10 
0.00102
24
SELECT id, language, message, nom, email, url, note, ip,
visible_home, date_sign, visible, spam_status, spam_filter,
date_reponse, reponse,type,element,id_user,
DATE_FORMAT(date_sign, "%d/%m/%Y %Hh%i") AS date_sign_fr,
DATE_FORMAT(date_reponse, "%d/%m/%Y %Hh%i") AS
date_reponse_fr FROM modules_sitti_mod_guestbook WHERE 1 AND
language='es' ORDER BY date_sign DESC LIMIT 3 
0.00044
25
SELECT t.*, 
                        DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                        DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr 
                     FROM modules_sitti_mod_slideshow_type t
                     WHERE t.id_type = '2'
0.00045
26
SELECT f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
modules_sitti_mod_contact_fields f LEFT JOIN
modules_sitti_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1  AND
f.active>0  AND f.category = "insert" AND fl.language='es'
ORDER BY ord ASC 
0.00043
# type fichier ligne classe fonction message
# 1  Warning /www/2011/01/iza129/www/oktModules/cookie/module_handler.php 33 oktDebug errorHandler Undefined index: es

#0 module_cookie->prepend( called at [/oktInc/classes/modules/class.module.php:150]


#1 oktModule->init( called at [/oktInc/classes/modules/class.modules.php:138]


#2 oktModules->loadModules( called at [/oktInc/public/prepend.php:32]


#3 require_once( called at [/oktPrepend.php:17]


#4 require_once( called at [/oktopus.php:17]

# 2  Warning /www/2011/01/iza129/www/oktModules/slideshow/module_handler.php 268 oktDebug errorHandler in_array() expects parameter 2 to be array, string given

#0 in_array( called at [/oktModules/slideshow/module_handler.php:268]


#1 module_slideshow->isH1Display( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:65]


#2 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#3 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#4 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#5 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]


#6 sfTemplateRenderer->__call( called at [/oktThemes/ra141-s/templates/layout.php:438]


#7 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#8 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#9 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#10 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]


#11 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#12 oktTemplating->render( called at [/oktModules/pages/inc/class.pages.controller.php:368]


#13 pagesController->pagesItem( called at [/oktInc/classes/router/class.oktRouter.php:317]


#14 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

# 3  Warning /www/2011/01/iza129/www/oktModules/slideshow/module_handler.php 268 oktDebug errorHandler in_array() expects parameter 2 to be array, string given

#0 in_array( called at [/oktModules/slideshow/module_handler.php:268]


#1 module_slideshow->isH1Display( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:115]


#2 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#3 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#4 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#5 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]


#6 sfTemplateRenderer->__call( called at [/oktThemes/ra141-s/templates/layout.php:438]


#7 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#8 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#9 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#10 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]


#11 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#12 oktTemplating->render( called at [/oktModules/pages/inc/class.pages.controller.php:368]


#13 pagesController->pagesItem( called at [/oktInc/classes/router/class.oktRouter.php:317]


#14 oktRouter->callRouteHanlder( called at [/oktopus.php:58]