Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Location château gonflable

Location Chateau gonflable

Réserver

Ce voisin propose en location à Vertaizon (63910)

100€/jour

Pierre M.

7 annonces

Prix

100€/jour

-33kgqu'à l'achat

Description de l'annonce

Bonjour,
Nous louons notre château gonflable pouvant accueillir jusqu'à 6 enfants en même temps.
Trampoline, toboggan, piscine à balles, et bien d'autres encore !
Dimensions : 350x350 - hauteur 245
Pompe de gonflage en continu, besoin d'être branché donc.
Location : 100€ à la journée - 160€ le week-end complet - 50% à la réservation
Chèque de caution exigée, qualité professionnelle
Montage et démontage par nos soins, gratuit dans un rayon de 15 km autour de Vertaizon puis 10€ par tranche de 10 km supplémentaires aller. #chateau gonflable

Autres annonces du voisin

Tout voir

Il y a + de 30j

Service : Papier peint

25€/heure

Vertaizon

Il y a + de 30j

Meuble a monter ou à créer

25€/heure

Vertaizon

Il y a + de 30j

Service : Meubles à rénover

30€/heure

Vertaizon

Il y a + de 30j

Pose parquet stratifié ou pvc

25€/heure

Vertaizon

Il y a + de 30j

Petit travaux de peinture

25€/heure

Vertaizon

Il y a + de 30j

Service : Poseur cuisine

35€/heure

Vertaizon

Louer de pose de cuisine entre particuliers ou proposer de pose de cuisine en location.

Poster une annonce

Location entre voisins

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
0.0001
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
0.0002
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
0.0001
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0004
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='432835'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chateau-gonflable' LIMIT 1
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='176'
0
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='63'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='258623' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 258623
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 432835
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=850 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='432835'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='432835' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 258623 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=258623 LIMIT 1
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 258623 AND W.type_id = 1) OR (W.util_id <> 258623 AND W.type_id = 2)) AND (M.post_util_id = 258623 OR M.dest_util_id = 258623) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='258623' AND note_visu IN (1,3,4)
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 = '432835'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='258623' AND wish_id<>'432835' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='594' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=258623 AND note_visu IN (1,3,4)
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
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='600' LIMIT 0,1
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
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='593' LIMIT 0,1
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
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='596' LIMIT 0,1
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
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='587' LIMIT 0,1
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
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='604' LIMIT 0,1
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 258623
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='63910'
0.0059
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.317039197041 AND ville_latitude_deg<46.216360802959 AND ville_longitude_deg>2.6553938535912 AND ville_longitude_deg<3.9446061464088 HAVING distance <= 50 ORDER BY distance ASC
0.0032
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('63910','63910','63160','63910','63117','63160','63190','63800','63190','63160','63111','63430','63800','63115','63116','63370','63800','63160','63160','63190','63190','63160','63430','63800','63670','63360','63800','63730','63510','63160','63720','63190','63270','63190','63160','63160','63510','63160','63350','63350','63270','63670','63170','63270','63720','63730','63160','63190','63360','63160','63270','63720','63270','63730','63360','63960','63170','63520','63350','63670','63270','63190','63520','63270','63270','63110','63450','63540','63350','63720','63730','63120','63720','63350','63000','63100','63200','63450','63270','63270','63118','63730','63520','63920','63350','63114','63114','63119','63450','63450','63520','63400','63112','63520','63120','63122','63500','63830','63720','63720','63300','63350','63130','63120','63530','63350','63720','63830','63120','63200','63450','63290','63730','63200','63450','63720','63490','63500','63200','63520','63500','63200','63520','63200','63320','63870','63500','63500','63310','63500','63320','63530','63260','63310','63490','63300','63300','63122','63290','63320','63490','63260','63530','63120','63450','63200','63200','63500','63200','63290','63320','63530','63500','63290','63490','63140','63590','63120','63590','63500','63290','63200','63500','63200','63880','63930','63200','63120','63490','63450','63260','63320','63650','63310','63500','63500','63320','63320','63490','63200','63260','63590','63550','63310','63320','63320','63970','63460','63200','63460','63320','63320','63250','63310','63310','63500','63290','63500','63310','63320','63410','63880','63310','63490','63490','63410','63880','63260','63460','63320','63500','63460','63320','63460','63550','63550','63710','63120','63260','63500','63250','63500','63590','63290','63260','63580','63980','63320','63340','63580','63210','63890','63580','63210','63840','63260','63310','63210','63340','63570','63570','63480','63320','03270','63500','63340','63310','63260','63230','63210','63230','63320','63340','63260','63340','63880','63710','63980','63970','63340','63460','63340','03800','63570','63250','63340','63480','63230','63930','63460','63320','63290','63260','63340','63890','63790','63610','63320','63480','63890','63210','63580','63340','63250','63230','63210','63410','03800','63340','42440','63230','63340','63570','63570','03800','63340','63980','03700','63570','63440','03270','63580','03800','63230','63410','63210','63890','03250','42440','63210','42440','63480','63580','63790','63230','63440','03110','03270','63600','63570','03270','03110','63340','63340','03800','63340','03250','63580','63410','03250','63580','63790','03200','63420','63980','42440','63210','63990','42440','63340','42440','63440','03800','03250','63340','63580','42440','63570','63230','03700','63340','63410','03200','03200','42111','63610','63440','63420','63440','42430','63340','42440','63780','63600','63610','03110','03110','43250','63570','63630','43390','63580','63440','03800','42830','63780','63740','63600','42920','63600','03800','63210','63420','63770','03250','42430','03450','03800','03300','63600','43410','63420','43250','63230','42111','42111','03300','63230','03110','63390','43410','03300','43390','42430','42920','42830','63630','03450','63240','43440','63630','03250','63600','63420','63440','63390','63420','43390','42111','63210','03110','63630','03800','43360','63440','63440','03800','43410','43390','03250','03250','03110','03800','63440','63610','03250','42136','63390','03300','42430','63820','63220','63940','03110','42430','63740','43450','63600','03140','03450','03450','03110','63420','42430','63150','03300','63380','63220','63390','03140','63150','63640','42130','63470','42890','42990','03450','43100','43360','43360','43360','63560','63560','42260','03450','43440','43100','03330','03300','43440','03250','63380','63390','42130','03120','63820','03260','03120','63380','42130','03330','63820','03300','42990','03140','03260','43450','63600') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='850' AND wish_id<>'432835' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 850
0
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
0.0001
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
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 (87) ORDER BY ssrubr_order ASC
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 (88) ORDER BY ssrubr_order ASC
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
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
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
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
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
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
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
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 (207) ORDER BY ssrubr_order ASC
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
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
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
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
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
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
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
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
0.0011
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0244
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
0.0177
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

62 requetes sql en 0.0592

Taille variable Globale : 75.7 KB