Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Tente 5 a 6 personnes (location 5 jours)

Retour Location Tente Location tente entre particuliers (80) Location tente entre particuliers (80)

Discuter

Ce voisin demande à louer à Pont-Remy (80580)

65€/Faire offre

Prix

65€/Faire offre

-10kgqu'à l'achat

Description de l'annonce

Je suis à  la cherche d'une tente pour nouvel an.
Location pour le 30/12/20 au 02/01/21, pour environ 6 personnes, qui seras bien sur rendu en très bon état.
Cordialement.
#tente

Annonces similaires

Tout voir
Location tente
Location tente

Demande il y a + de 30j

Il y a + de 30j

TENTE DE TOIT COQUE RIGIDE 2 PERSONNES
Profil du voisin
Le rolland de beauvillé S

Tilloy-les-Conty 80160

120€/sem

Louer ma tente

Louer une tente entre particuliers ou proposer une tente en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='327236'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tente' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='912'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tente' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='93'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='80'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='128745' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 128745

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  11. 0.0004

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC

  12. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC

  13. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC

  14. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC

  15. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC

  16. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC

  17. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC

  18. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC

  19. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC

  20. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC

  21. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC

  22. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC

  23. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC

  24. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC

  25. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC

  26. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC

  27. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC

  28. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC

  29. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 327236

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=912 LIMIT 1

  31. 0

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='327236'

  32. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='327236' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  33. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 128745 AND util_tel != ''

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 128745 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  35. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128745 AND W.type_id = 1) OR (W.util_id != 128745 AND W.type_id = 2)) AND (`post_util_id` = 128745 OR `dest_util_id` = 128745) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='128745' AND note_visu IN (1,3,4)

  37. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '327236'

  38. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='128745' AND wish_id<>'327236' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='80580'

  40. 0.0052

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.88333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.600339197041 AND ville_latitude_deg<50.499660802959 AND ville_longitude_deg>1.183046231012 AND ville_longitude_deg<2.583613768988 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0024

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (80580,80580,80580,80580,80580,80580,80490,80510,80132,80690,80132,80490,80510,80132,80132,80132,80490,80100,80132,80490,80510,80490,80510,80132,80135,80490,80690,80140,80132,80270,80132,80270,80870,80490,80690,80870,80270,80135,80140,80890,80140,80135,80140,80270,80830,80830,80140,80140,80132,80140,80132,80135,80690,80690,80132,80210,80620,80870,80690,80690,80140,80135,80140,80132,80135,80135,80140,80132,80140,80132,80270,80270,80150,80270,80620,80270,80270,80132,80140,80132,80620,80270,80140,80210,80210,80132,80620,80420,80420,80150,80140,80270,80140,80310,80310,80230,80150,80620,80140,80150,80140,80270,80270,80140,80140,80132,80140,80140,80132,80370,80310,80150,80140,80140,80620,80210,80610,80140,80150,80150,80970,80620,80140,80140,80610,80310,80620,80140,80150,80640,80210,80140,80310,80780,80220,80210,80230,80140,80150,80140,80540,80140,80140,80640,80640,80620,80140,80860,80310,80370,80370,80310,80210,80370,80370,80210,80220,80150,80370,80860,80210,80140,80220,80310,80370,80850,80210,80430,80370,80220,80150,80540,80370,80310,80150,80150,80140,80430,80540,80620,80820,80140,80430,80140,80540,80670,80140,76340,80370,80430,80370,80150,80860,80150,80230,80140,80310,80310,80220,76340,80390,80370,80150,80150,80430,80670,80390,80430,80640,80310,76340,80220,80650,80540,80230,80370,80540,80370,76340,80140,80960,80670,80570,80370,80130,76340,80540,80120,80430,80640,80150,80310,80150,80540,80230,80220,80570,80230,80520,80370,80670,80470,80670,76340,80150,80430,76340,80120,80130,80540,76340,80540,80150,80120,80150,80150,80370,80750,76260,80126,80520,80670,62390,62390,80150,80430,62390,62390,80670,80530,80770,80550,80600,80430,80750,80260,80710,76390,62140,80470,80230,80540,80540,80370,80470,80470,80120,80290,80430,62390,80600,80520,80220,80530,80530,62390,76117,80290,80230,80260,76340,80590,80540,80590,80590,80150,62140,80370,62140,80460,80120,76340,62390,80120,80260,76340,80290,80540,80940,80600,76260,80600,80730,80730,80470,76340,80600,76340,62390,80710,80150,80590,62140,80590,80290,80260,80540,80260,80730,76390,80600,80460,76340,80590,80290,62390,62390,80120,76340,80880,76260,80260,80600,80120,62140,76660,76260,62390,80290,80460,62390,76260,62390,80480,62870,80590,62140,80590,80290,80120,80590,62390,80590,76340,76260,62390,80290,76390,76390,80600,80290,80480,80410,80260,76260,80120,80600,76390,76390,62140,62140,80630,80290,80600,76390,76340,80260,76340,76660,80480,80480,76260,62270,62870,80290,62140,80290,80290,80120,80260,76260,80120,62140,62144,76340,62270,60220,80260,80480,80090,80000,80080,76260,62270,80136,60220,76390,62180,80120,80260,80120,62140,80290,76260,80480,62180,62390,76660,80600,80600,76260,80260,62870,80160,62870,80600,80480,62270,80290,60220,62870,80290,80600,80350,80290,76260,62270,80260,62180,80160,80290,80160,62770,80160,80160,80260,80160,80160,62870,60220,62270,76260,80260,62770,62770,80290,76390,62770,62140,80260,62270,80160,80160,62140,62270,76470,76260,80600,80600,76660,62140,62140,80160,62870,76270,76390,80160,80260,62270,76660,60220,60220,76390,76630,62140,76260,62140,62760,80560,76270,76390,76660,80450,80680,80260,62770,62770,62180,62140,80160,80600,62270,62760,76260,62170,62870,60210,60210,80330,80330,62810,76630,80680,62140,80600,62990,80790,62770,62270,62140,80160,80560,80160,80260,80160,62270,62270,60220,60210,80680,62760,80160,60220,62770,80600,62990,62760,76270,62270,80115,80450,62140,80260,76270,80680,62170,80560,62180,76910,76270,62990,60210,60210,60210,60210,76630,80260,76910,76630,76270,76270,62270,80160,62760,80260,80260,76390,76660,76270,80680,62760,76630,62760,80600,62270,62270,80260,62770,62140,60210,62130,62770,62600,76660,76270,80160,62770,60210,76630,80800,62270,80160,62810,80440,76660,62170,62270,62770,80440,62180,76630,62130,62130,80160,80440,80160,62130,80115,80560,76660,76270,62760,62990,62990,76630,60210,60220,62770,60210,76390,80560,60220,76270,62270,62130,76660,80560,80560,76910,62130,62130,76390,62130,60220,76660,62760,60120,62140,76630,80250,80800,80160,80160,62770,62180,62810,62810,62170,80800,80560,62770,60120,60210,62990,62130,60210,62130,60960,80800,60210,62170,80560,62170,60210,62130,76630,62990,62990,80600,76630,62170,62600,76630,60360,62770,62810,76630,80800,60220,60210,80440,76660,62270,62170,62270,80560,80560,62180,62180,80440,76630,62760,80300,76630,60210,62770,60220,80250,62130,80300,80160,62170,62770,60220,80560,62760,62760,62158,60360,62140,80800,60220,76270,80380,62130,60120,62810,80160,62130,62990,60210,80560,80560,62170,80250,80800,62990,60210,60220,62130,62130,76870,60360,60210,62130,62170,62990,60220,76270,62810,62810,62158,76630,62170,62990,62270,80800,76630,76630,80110,80800,76660,80250,62310,62760,62130,80560,80440,60360,62130,62170,60360,76270,76270,76270,62760,76270,80560,80250,62130,80113,76370,62170,62310,60120,62170,62810,62810,80250,76270,80560,62127,62170,62810,80110,62130,62170,60220,76440,80250,80250,62155,80380,76510,62134,76870,62127,62810,62310,62990,76270,62760,62134,62130,80560,80560,62170,80300,76440,62130,62130,62810,62170,62310,60220,80300,80110,76660,76660,80800,80300,76370,76440,76510,80250,62158,62170,62170,62310,62310,62130,80380,62130,80800,60360,62134,80800,80800,60120,60120,62111) AND fami_id='5' AND cate_id='93' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='912' AND wish_id<>'327236' AND wish_url='' ORDER BY rand() LIMIT 0,10

  42. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='912' LIMIT 0,1

  43. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326328 AND note_visu IN (1,3,4)

  44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326328 AND W.type_id = 1) OR (W.util_id != 326328 AND W.type_id = 2)) AND (`post_util_id` = 326328 OR `dest_util_id` = 326328) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 326328

  46. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 912

  47. 0.0009

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  48. 0

    SELECT count(*) as nbwish FROM wish

  49. 0.0567

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

49 requetes sql en 0.0707

Taille variable Globale : 74.7 KB