Les Gîtes Malidri, self-catering cottage, cottage Xaramela near Dax in the Landes (40).

Xaramela cottage rental, located very close to Dax in the Landes (40),

This  gîte ( includes an equipped open plan kitchen with a dining area, a sitting area, a bedroom with a double bed and another bedroom with 3 single beds, bathroom, toilet independent.

Located on the floor of a traditional house, it offers a surface of 70 m² for a capacity of up to 5 people. Possibility of grouping, for the big families or stays with friends, with the lodging Gorria Etxea located on the ground floor and thus benefit from a surface of 160 m ² for 13 people maximum.
Secured access to the interior of the property for your vehicle.

We propose you a shared living space with adjoining gîtes, located outside in the form of a covered terrace on one hand and a completely open space on the other hand, ideal for "farniente" on the Garden furniture, but also for your barbecue evenings.
There will also be a boules court and various outdoor games (snowshoes, swing...)

Located on the outskirts of the village of Pontonx sur l'Adour in the Landes (40), this very quiet cottage will seduce you to enjoy your stay.

You are in a thermal cure, our lodging is ideally located near Préchacq les Bains, Dax or Saint Paul lès Dax.
You are just 30 minutes from the ocean, Bayonne, Biarritz, the Basque coast and 45 minutes from Spain.

THE EQUIPMENT :

  • Refrigerator-freezer, gas cooker, electric oven, toaster, coffee maker, microwave, blender, blender, dishwasher, washing machine, iron with table.
  • Baby cot on request: bed umbrella, high chair, changing table, park, bath.
  • Television with TNT, Internet access (Free Box) and Wifi secure, unlimited and free. Central heating reversible / Air conditioning.
Self catering Xaramela
  • Mémoire utilisée par PHP : 4.14 MB
  • Pic mémoire allouée par PHP : 5.30 MB
  • Temps d'execution du script : 0.819 s
  • Lang : en
  • Path : gite-xaramela
  • Route : pagesItem
  • $okt->page->module : pages
  • $okt->page->action : item
ID Query Time
1
SET NAMES utf8mb4
0.00034
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='34.207.230.188' WHERE u.id=1
0.00082
3
UPDATE modules_sitti_core_users_online SET
logged=1638237742,
prev_url='https://www.location-gites-landes.com/en/gite-xaramela'
WHERE ident='34.207.230.188'
0.00045
4
SELECT id_selection FROM modules_sitti_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
0.00050
5
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00040
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.00078
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.00041
8
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00034
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.00069
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.00041
11
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00039
12
 SELECT * 
                        FROM
modules_sitti_mod_resa_reservation_detail
						WHERE id_reservation = '108'  ORDER BY
index_selection, libelle 
0.00073
13
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00080
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.00098
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.00104
16
UPDATE modules_sitti_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00056
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.00051
18
SELECT id, title, code, img, active, ord FROM
modules_sitti_core_languages WHERE 1  AND code='en' ORDER BY
ord ASC 
0.00048
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='en'  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='en' WHERE 1  AND
pl.language='en'  AND pl.slug='gite-xaramela' AND p.active=1
ORDER BY p.created_at DESC 
0.01919
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='en' WHERE 1  AND
ml.language='en' AND m.active=1 ORDER BY m.created_at DESC 
0.00308
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='en'  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='en' WHERE 1  AND
pl.language='en' AND p.active=1 ORDER BY p.created_at DESC 
0.00798
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='en' ORDER BY ord ASC 
0.00566
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='en'  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='en' WHERE 1 
AND pl.language='en' AND p.active=1 ORDER BY p.selected
DESC, p.created_at DESC LIMIT 10 
0.00047
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='en' ORDER BY date_sign DESC LIMIT 3 
0.00058
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.00043
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='en'
ORDER BY ord ASC 
0.00071
# type fichier ligne classe fonction message
# 1  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]

# 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: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]