Discuter
Description de l'annonce
Loue 1200 m² de jardin pour réunion familiale, anniversaire
#jardin
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Loue 1200 m² de jardin pour réunion familiale, anniversaire
#jardin
Annonces similaires
Tout voirLouer jardin entre particuliers ou proposer jardin en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
350€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='511002'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jardin' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='928'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jardin' LIMIT 1
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'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='70'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='351627' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 351627
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = 511002
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=928 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='511002'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='511002' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 351627 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 351627 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 351627 AND W.type_id = 1) OR (W.util_id != 351627 AND W.type_id = 2)) AND (`post_util_id` = 351627 OR `dest_util_id` = 351627) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='351627' AND note_visu IN (1,3,4)
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 = '511002'
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='351627' AND wish_id<>'511002' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='70230'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.4333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.4333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.25- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.983639197041 AND ville_latitude_deg<47.882960802959 AND ville_longitude_deg>5.5852550489953 AND ville_longitude_deg<6.9147449510047 HAVING distance <= 50 ORDER BY distance ASC
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 (70230,25680,25640,70230,25640,25640,70230,25680,70230,25640,70230,25680,25640,70230,70230,70230,25680,25680,25640,25640,25680,70190,70230,25640,25640,70230,70230,70190,25680,25640,70230,25680,70190,70190,25110,25640,25640,25680,25680,25680,25110,25680,25640,70230,25110,25640,25680,25640,70190,25110,70230,25680,70190,70190,25680,25110,70230,70230,25680,25680,25640,25640,70230,25640,25640,25110,70190,25110,25870,25110,70190,25640,25110,70190,25110,25870,25870,25680,70190,70190,70190,25340,25110,25640,25640,25640,70190,25640,70000,25110,70110,25870,25680,70190,25110,25340,70190,70110,25640,25340,25110,25680,25680,25870,70190,25820,70000,25340,25960,70000,70190,25340,25110,70000,25110,25110,25640,25110,70110,70000,70110,70190,25220,70000,25360,25340,70190,25110,25340,25870,70190,25110,70000,25340,25360,25870,25110,70000,70110,25110,25220,25640,25220,25360,25360,25360,70110,70000,70000,25870,70190,25220,25360,25250,70190,70110,25110,70190,70110,25340,25340,70000,70110,25360,25360,70000,70190,70110,25340,70110,70000,70000,70190,25340,25250,25220,70190,70190,25340,70000,70000,70000,25870,25340,70110,70190,70110,25220,70190,25360,25360,70000,70000,70190,70110,25360,25250,25360,70110,70110,70110,70110,25870,70000,25870,25430,70110,70110,70000,70000,25360,25220,25220,70000,25250,25360,70190,25530,25660,25430,25340,70110,70190,25870,70000,70000,70110,70190,70110,70190,25340,70200,70110,70240,25360,70130,25250,25250,70000,70110,70700,25430,25530,70000,25530,70000,70000,70240,25530,70700,70000,25660,25250,25340,25620,70000,70000,25360,70000,70110,70110,70000,25530,25870,25250,70130,25430,25430,25530,70000,70200,25250,25530,70110,25660,70150,70000,70240,25580,25870,70130,70000,70240,25000,25530,70000,70700,25660,25870,25250,25250,70240,70700,70700,25530,70110,25620,25480,25510,25530,70200,70130,70240,70000,25870,25480,70400,70130,25250,70130,70360,25250,25250,70360,25660,70240,25250,70700,25430,70400,70400,70240,25250,70240,25430,25480,70000,70170,70200,70400,70000,25250,70360,70150,70700,25170,70240,70170,70700,25250,25250,25510,70400,25430,25430,25620,70240,70240,70700,25250,25430,70150,25170,25530,70360,70200,25620,25260,70130,70240,70360,70200,25510,25530,70000,70700,25260,25170,70700,25430,70130,25250,25510,70200,70240,70360,25620,25250,70170,25510,70130,25170,70170,70200,70360,25660,25530,25770,25115,70130,25580,70150,70240,25150,70700,70170,70130,25620,25170,70360,70200,25530,70240,70240,25620,70240,25720,25720,70200,25260,25380,70200,25800,25170,70400,70130,70360,25170,25770,25750,70200,25190,70170,25690,70400,25260,25430,70700,70200,25510,70700,25620,25150,25750,25170,25170,70240,70700,25580,25720,70200,70360,70400,70200,70360,25260,70170,25150,70150,25620,25620,25190,70150,70700,70160,70200,70120,25510,25720,70200,25660,70120,25380,25800,25113,25170,70200,70200,25190,25550,25720,70700,25190,70700,70300,25580,70400,25260,25170,25580,70160,70170,70130,25150,25770,25380,70300,70200,70200,25320,70300,25750,25390,70150,25320,70700,70700,25800,70300,70200,70170,25690,25750,25750,25550,70160,25150,70130,70130,25170,25380,25170,70200,25420,70170,70400,25580,25660,70300,25320,25390,25550,70700,25550,70400,25190,25320,25580,25580,25550,70300,70200,25150,70300,25690,70150,25580,25320,70400,70120,70160,25620,70200,70300,70160,25380,25380,25170,70200,25170,25190,25580,25380,70130,70400,70200,25420,25170,70700,25290,70200,70120,70160,25550,70360,70200,70700,70400,25380,25580,70300,70170,70100,25550,25390,25410,25170,25380,70120,25550,25550,70200,70160,25290,70130,25410,25190,70100,70300,25580,25420,70700,25111,70300,25690,70130,25210,70400,25420,25580,25580,70300,25290,25150,70200,70120,25390,25320,25630,25380,25390,25440,70300,25320,25170,70130,70130,25410,70200,70160,70160,25580,70400,25190,25190,25190,70150,25380,25410,25700,25150,25290,70200,25440,25410,70130,25380,25190,25190,70400,25290,25320,25380,70120,70400,70700,25840,70160,25420,70400,70200,25210,70150,25210,25290,70300,70180,70400,25390,25320,70150,25840,70300,70800,70100,25330,70100,25210,25350,70120,70120,25120,25170,70400,70150,25190,25120,25390,70120,25170,70300,70300,70250,70150,25690,70180,25210,70160,25410,25200,25190,70270,70400,70120,70800,25930,70800,70160,25410,25210,25200,25150,25190,25390,70150,25580,25410,70800,25400,70500,70100,70180,25150,70160,25210,70120,70270,70270,70160,25330,70180,25320,70400,70300,70400,70150,70120,70160,70400,70120,70270,25410,25440,25170,25520,70300,70180,25410,70100,25330,25170,25700,70500,70120,25400,25120,70100,70290,25440,70300,25400,25330,25920,70800,70180,70100,70140,25190,70180,70120,70150,25440,25440,25310,25330,25600,25600,25210,70300,25190,25520,70400,90800,70180,25210,25320,25440,25170,39700,70270,25230,25310,25200,90800,70120,70100,25330,25310,25440,25500,25320,25330,70400,25440,25400,70120,39350,25210,25440,25410,25140,70400,39700,25210,70160,25330,70180,70500,25650,70270,39350,25120,25330,25440,25520,70800,70140,25190,70100,70800,70800,70100,90800,90800,25310,25600,25330,70100,25230,25120,70160,70800,25330,25500,70100,25520,70800,39350,90400,25330,70500,25460,70100,25210,25310,25190,70100,70270,70500,25440,70500,70270,25410,70140,39350,70280,70160,25330,70180,90700,70310,25210,25310,25600,25310,70120,70300,25120,39700,70400,70140,25440,70280,25310,39350,25140,39350,90850,25500,70290,90400,25600,25470,39700,25520,70800,70310,70280,70500,25440,90850,25520,70270,25650,70120,70500,90400,70800,25500,70140,25440,25440,25500,90400,70140,70500,70310,25520,70120,25230,39350,25140,39700,90350,25230,70210,90400,25310,70180,39350,25440,25500,70310,25470,25440,70140,70600,70280,70140,25440,25490,25210,25190,70180,90400,90300,39350) AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='928' AND wish_id<>'511002' AND wish_url='' ORDER BY rand() LIMIT 0,10
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 928
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
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
Contactez-nous