El campo para Malidri, alquiler de habitaciones, alquiler de casa, apartamento amueblado, casa Ongi Etorri cerca de Dax (40).

Para sus vacaciones o los tratamientos de spa en Dax (40), esta disponible para alquiler.

Esta casa de campo  tiene una cocina equipada con un comedor, un bar y un salón, un dormitorio con una cama de 140 y otra habitación con 3 camas de 90, cuarto de baño, WC separado.

Situado en la planta baja de una casa tradicional, que ofrece una superficie de 70 metros cuadrados con una capacidad de hasta 5 personas.

Ofrecemos el espacio en el que viven fuera en forma de una terraza cubierta en un lado y un espacio completamente abierto por el otro, ideal para el "perezoso" en el mobiliario de jardín, sino también para sus noches de barbacoa.

El acceso seguro al interior de la propiedad de su vehículo.

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.

Las fotos de la nueva casa estarán disponibles en marzo.

Descubre nuestra casa de campo en el vídeo

Casas Ongi Etorri
  • Mémoire utilisée par PHP : 4.08 MB
  • Pic mémoire allouée par PHP : 5.23 MB
  • Temps d'execution du script : 0.753 s
  • Lang : es
  • Path : gite-ongi-etorri
  • 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='54.91.62.236' WHERE u.id=1
0.00065
3
UPDATE modules_sitti_core_users_online SET
logged=1642360543,
prev_url='http://www.location-gites-landes.com/es/gite-ongi-etorri'
WHERE ident='54.91.62.236'
0.00067
4
SELECT id_selection FROM modules_sitti_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
0.00056
5
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00037
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.00042
8
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00036
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.00082
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.00042
11
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00038
12
 SELECT * 
                        FROM
modules_sitti_mod_resa_reservation_detail
						WHERE id_reservation = '108'  ORDER BY
index_selection, libelle 
0.00040
13
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00038
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.00076
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.00041
16
UPDATE modules_sitti_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00055
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.00054
18
SELECT id, title, code, img, active, ord FROM
modules_sitti_core_languages WHERE 1  AND code='es' ORDER BY
ord ASC 
0.00079
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-ongi-etorri' AND
p.active=1 ORDER BY p.created_at DESC 
0.00347
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.00147
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.00511
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=7 AND
fl.language='es' ORDER BY ord ASC 
0.00056
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.00087
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.00054
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.00041
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.00071
# 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]