Discuter
Description de l'annonce
Terrain de 5500 m2 sÉcurisÉ et amÉnagÉ pour ÉvÉnements sanitaire et piscine
#jardin
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Terrain de 5500 m2 sÉcurisÉ et amÉnagÉ pour ÉvÉnements sanitaire et piscine
#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é
15€
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='578747'
INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (578747, 0, '/img/wiiz/439685-240610-0420-location-jardin.jpg', 0)
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='71'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='439685' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 439685
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 = 578747
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=928 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='578747'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='578747' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 439685 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 439685 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 = 439685 AND W.type_id = 1) OR (W.util_id != 439685 AND W.type_id = 2)) AND (`post_util_id` = 439685 OR `dest_util_id` = 439685) 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='439685' 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 = '578747'
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='439685' AND wish_id<>'578747' 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='71290'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((5.01667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.117039197041 AND ville_latitude_deg<47.016360802959 AND ville_longitude_deg>4.3626204139637 AND ville_longitude_deg<5.6707195860363 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 (71290,71290,71290,71290,71290,71290,71290,71290,71290,71470,71290,71700,71290,71700,71290,71440,01190,71470,71470,71290,71500,71440,71700,71700,71470,71700,71440,71370,01560,01190,71440,01560,71700,01560,71700,71240,01560,71240,71500,71240,71700,71700,71240,71240,71240,71500,71500,71260,01190,71370,71440,01560,71370,01190,01560,71700,71240,71240,71240,01190,71700,71260,01560,71240,71440,71240,01190,71500,71700,71500,71440,71440,71240,71370,01190,01560,71240,71470,71260,71700,71260,71260,01190,71260,01560,71260,71440,71240,71500,01560,71240,71480,71260,01190,71460,71460,71240,71370,01190,71370,71330,01190,71260,01560,01560,71500,71260,71240,71460,71580,71580,71440,01190,71260,71500,71380,71460,01340,71940,71100,71260,01570,71480,71460,71580,71480,71260,71100,71380,01340,71500,71330,71100,71118,71250,71620,71390,71260,71250,71260,71250,71260,71460,71480,71870,71330,01380,71380,71380,71460,71460,01340,71380,01570,71460,71620,71250,71460,71500,01340,71100,71250,71580,01270,01570,71620,71460,71330,71940,71100,01270,71390,01340,01340,71960,01570,71620,71620,71380,01380,71940,71250,71390,71310,71460,71310,39190,71310,01340,71940,71480,71250,71880,71870,71460,71000,39160,71460,71580,71480,39190,71460,71530,01340,71390,71580,71620,39160,01270,01340,71580,71390,39190,71480,71330,39190,71530,01380,71390,71330,39160,71390,71460,39160,01380,71460,39190,71460,39190,39160,71250,71330,71960,71530,71310,39160,01750,71460,71460,71580,71390,71620,01380,01851,39160,71390,71390,71960,71250,71640,01340,39190,71620,71250,71960,71640,39190,71250,39190,01310,71460,71390,01270,71460,01750,71530,71310,71530,71530,71390,01750,71000,71330,71640,39160,71960,01370,39570,39190,39190,71250,39140,01270,71960,71460,01380,71310,01340,71460,01310,71330,39190,39160,71390,71460,71250,39160,01310,71250,01270,39190,71150,39140,71590,71330,71960,71350,71460,39320,39160,71250,39320,71460,71960,71250,71390,71850,71250,01290,39570,71960,71640,71960,01270,71250,71640,71310,71310,71350,71590,71640,39570,71460,39140,39160,39190,39270,39190,39190,71310,71640,01290,71460,39270,71530,39320,71250,71390,39320,01310,71960,01290,71350,71960,39140,71390,71250,71250,39320,71640,71150,71630,39570,39320,71460,71460,71350,01660,39190,71220,01540,39140,71000,01370,71350,01290,71960,71960,01370,71350,39570,39570,71460,71640,71220,71390,71350,71640,71250,71460,71460,39570,71510,39140,71270,01370,71960,39320,39570,01440,71220,71570,71680,39320,39570,39140,39320,71350,01540,39320,39270,39320,71570,39140,71150,71250,71960,01660,71390,71270,01290,71680,39270,01290,01290,39570,71220,39140,71250,39320,71690,71510,71270,71220,39270,71270,71520,71630,39570,01290,39570,39320,71220,71510,71570,39570,39570,71270,71570,71570,71350,39270,39270,71570,39140,39570,01290,71520,39320,71510,39270,71350,01540,39570,01250,39270,71350,71270,71150,71270,39320,71690,01310,39240,01310,71510,71270,39140,71220,39270,71270,39140,71210,71520,39570,39000,39570,71510,39320,39320,71210,39270,01370,71520,71350,01400,39570,71150,39570,71570,71150,71350,71270,01660,39570,39240,71220,71510,39230,71210,71150,71270,71520,01000,01140,39240,71270,01250,01310,39270,71220,39270,39240,71220,39570,01370,71510,39270,71150,71133,01000,39570,71520,69840,69840,39570,39240,71270,01140,71150,71270,39570,71690,71690,39270,39230,71270,01310,71510,71510,71220,71490,21190,71270,01400,71520,39210,21200,39270,01400,39570,39210,39230,01400,21190,01960,39120,69840,71570,71510,39230,71210,39570,69840,39240,39140,01250,39240,71520,39570,21190,71570,71150,21190,71270,71520,39570,39240,71220,01250,21820,39230,21190,39230,39270,39240,71520,39230,39240,21250,39210,71150,39120,39240,21590,01250,01240,39240,21200,39240,39240,39570,39230,01400,39210,21190,39240,01140,39270,39570,21200,39270,39120,21190,39270,39570,39570,01250,69840,39270,39230,39230,39120,71490,21250,21250,71520,39240,71230,01140,39270,39210,39230,69860,39210,39240,39240,01140,71490,71210,71570,71150,69860,71510,21200,01250,39230,39210,71670,39230,71490,21200,71220,21200,39240,69860,21820,39230,71210,71520,21190,71150,39230,69860,39570,01250,21200,71220,01400,69820,21250,71670,39230,39240,39120,71490,39230,21200,69820,01250,01240,21340,39570,39120,69860,39130,39210,71230,71220,39270,39240,39570) AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='928' AND wish_id<>'578747' 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