Discuter
Description de l'annonce
Je souhaiterai louer un jacuzzi dans mon appartement
#jacuzzi
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Je souhaiterai louer un jacuzzi dans mon appartement
#jacuzzi
Annonces similaires
Tout voirLouer un jacuzzi entre particuliers ou proposer un jacuzzi en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
60€
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='524727'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jacuzzi' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='827'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jacuzzi' 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='92'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='336632' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 336632
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 = 524727
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=827 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='524727'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='524727' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 336632 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 336632 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 = 336632 AND W.type_id = 1) OR (W.util_id != 336632 AND W.type_id = 2)) AND (`post_util_id` = 336632 OR `dest_util_id` = 336632) 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='336632' 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 = '524727'
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='336632' AND wish_id<>'524727' 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='94600'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7344560125509 AND ville_longitude_deg<3.0988839874491 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 (94600,94400,94390,94310,94320,94140,94290,94700,94000,94460,94190,94550,94380,94800,94150,94220,94480,91200,94205,94200,91560,94450,94410,94233,94236,94234,94231,94237,94232,94238,94240,94235,94230,94239,94270,91550,94340,94340,94100,94110,94210,91320,92340,94160,91270,94260,94470,91230,94430,94250,91330,94370,94380,92160,94130,94500,92120,91210,92220,94300,91260,91800,91420,94880,92330,92260,94880,94490,94440,92240,94360,92320,91300,94440,94120,92290,94170,93170,92350,91370,93100,92170,91160,91380,91170,92140,75002,75012,75011,75010,75009,75008,75004,75007,75006,75000,75013,75003,75116,75020,75019,75018,75017,75016,75015,75014,75001,75005,91860,93110,91390,91600,94350,94520,94520,92130,94420,94440,94510,93330,91800,91360,91000,91130,93260,93230,93310,91350,91450,91160,93360,91360,91120,77170,93130,92360,92190,91480,77340,92100,91140,93250,93160,91160,91480,91570,91160,93500,93000,91090,91000,91430,77150,93140,91700,91450,93220,91700,93460,77380,77184,93400,91700,91250,92370,77150,91430,77420,91140,77185,93320,93340,91080,92310,92210,93300,91070,93120,92200,91620,92110,91240,77170,91250,92150,92800,77680,78140,92410,92300,91280,91310,77127,91220,91220,78350,77330,77186,93370,91310,91310,93350,91090,91400,77500,93700,93150,91620,78220,91400,92600,92400,92380,93200,93210,77173,91100,92430,92420,92250,93190,93390,77200,93450,92390,91250,77090,77183,91440,92270,91460,77166,93440,77360,93270,92230,77177,92500,93240,91940,91100,77166,92700,77181,93470,91310,78530,78350,78000,77135,77550,91940,91190,93410,78170,77600,93600,92000,93800,77164,93430,78117,77181,91180,95140,91540,91540,91540,95500,78150,77400,93380,91810,91190,77600,77600,91940,91190,95360,78800,91250,91830,77176,91290,78150,95880,91630,77400,78400,77111,91640,77220,78117,77400,78380,78290,77170,95870,77270,77550,95100,91290,93420,91630,77410,78420,95400,93290,91540,77600,95500,95218,95210,91710,91680,95410,78430,77400,91400,77550,91630,95170,77220,91520,91340,95110,91630,77176,78560,77400,77600,95230,78470,77111,77600,78280,78360,77550,91640,78210,77220,78114,91750,77240,77240,95200,95400,78870,77390,95500,95350,95500,91830,95120,78110,91630,77400,77400,78500,77240,95160,91770,77220,77144,78160,77220,91610,78960,95700,91680,78470,78590,95580,95580,78330,77950,78230,95130,77410,77310,91640,78750,91470,95600,95720,78590,78460,95440,91750,78620,91470,95530,95190,91650,78180,77290,77310,78600,91790,95350,77700,78600,91470,91760,78100,77390,91470,77174,78112,77144,77700,77390,91640,77410,95240,91650,77950,77410,91850,77950,95130,91730,95680,95370,78390,78470,77950,95720,77390,77410,95460,91470,95390,91510,77310,91510,91650,91530,91590,77700,78450,77610,95380,95330,91750,95320,77350,77410,77350,77610,77450,78190,77450,77390,78860,77610,78460,77990,77174,91730,91910,95380,77700,91730,78720,77350,91590,95720,77390,95190,77290,78240,77700,95220,77410,77000,77000,77950,95570,91590,95250,77990,95570,77190,78340,78720,91580,77410,78300,95570,95380,91530,78830,91470,77450,78240,95380,77930,77610,95550,95150,78450,78720,77450,77230,78320,95480,77230,95560,91890,95720,95850,78700,95190,77950,91590,77230,77580,91580,77390,77410,95380,91840,77930,77390,95840,77610,77410,78260,77450,77390,91530,77000,95560,91590,77930,78990,78320,77860,77190,91580,95560,78370,77450,77610,77450,78320,78955,77390,95740,77230,77450,77720,91590,78810,78830,78720,91580,77000,77115,95470,78570,95270,77930,95850,95270,95570,91490,77860,77230,77610,91580,77390,91580,77930,77115,91530,95670,91590,78630,91410,95840,95560,77230,77410,77230,77230,95610,77390,77230,77165,78780,95590,77930,91590,78310,78670,78670,77163,78310,77720,95470,91820,95540,78570,77230,77580,78810,77580,95270,95270,77860,91490,95270,91490,77165,77165,78720,77163,77580,91820,95470,95270,77720,78121,77630,77390,78850,77590,77100,77165,95000,78730,78730,77230,78760,95430,91880,78640,77163,78690,91410,77820,95470,95310,78640,95630,95430,91150,77630,77124,77100,77124,78540,77720,77580,78510,91720,95270,95270,95270,77720,60128,95300,78690,95000,91410,77590,77540,78640,95280,77540,78480,78610,95590,77230,77100,78630,78580,77280,95760,77515,78490,77230,95300,77580,77580,77515,78640,77590,77630,77124,95490,77165,77720,60330,91720,77820,91150,95270,91490,95270,78120,78125,60128,95290,95270,77540,95000,77122,77470,78650,91870,77540,60560,78490,78490,95620,95590,60520,77131,91410,77580,78580,77124,78130,60950,78920,78730,77580,95260,91150,95520,95180,78610,95260,91150,91410,78124,95300,95800,95660,60260,60580,60330,78490,91490,78730,78124,77720,77920,77515,95650,78740,78490,77470,91720,78650,95650,77820,77540,95650,77178,77470,77850,95300,60520,77540,77910,78410,77470,91720,77720,78490,95340,78490,78740,77910,77470,77580,77131,78120,95690,78580,77515,60520,91150,77178,77720,78770,78610,77580,77165,77165,78580,77470,91150,78120,60820,78130,77123,78730,60330,95820,77133,77870,91780,91780,77720,95690,95450,77120,77139,77515,91150,95340,91410,78770,78490,91410,78126,77120,78490,77540,91720,60950,77300,78770,77910,78250,78250,78660,78410,77370,77210,78770,77120,60230,77470,95810,60270,77210,95690,91720,95450,60330,77120,77370,91150,77123,78770,95650,95650,95810,77133,60950,95340,77910,95690,78250,77123,91150,78410,78250,91150,78410,78410,60530,95450,77370,77580,60440,91150,77760,78490,78770,77139,78940,78250,78610,77139,91410,60440,91150,60500,60460,77830,91720,77660,78680,60500,95810,78125,60300,60300,95450,91690,95830,91410,95810,77440,78820,77810,77120,60530,60300,60300,77760,77370,78890,77120,77370,91410,78580,78770,95830,60530,60440,77139,91780,95450,77430,91690,91410,60300,95810,78125,77141,60300,91150,95450,78125,95450) AND fami_id='5' AND cate_id='92' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='827' AND wish_id<>'524727' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121952 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121952 AND W.type_id = 1) OR (W.util_id != 121952 AND W.type_id = 2)) AND (`post_util_id` = 121952 OR `dest_util_id` = 121952) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 121952
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=402892 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 402892 AND W.type_id = 1) OR (W.util_id != 402892 AND W.type_id = 2)) AND (`post_util_id` = 402892 OR `dest_util_id` = 402892) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 402892
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=140854 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140854 AND W.type_id = 1) OR (W.util_id != 140854 AND W.type_id = 2)) AND (`post_util_id` = 140854 OR `dest_util_id` = 140854) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 140854
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=166095 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 166095 AND W.type_id = 1) OR (W.util_id != 166095 AND W.type_id = 2)) AND (`post_util_id` = 166095 OR `dest_util_id` = 166095) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 166095
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=463966 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 463966 AND W.type_id = 1) OR (W.util_id != 463966 AND W.type_id = 2)) AND (`post_util_id` = 463966 OR `dest_util_id` = 463966) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 463966
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=405287 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 405287 AND W.type_id = 1) OR (W.util_id != 405287 AND W.type_id = 2)) AND (`post_util_id` = 405287 OR `dest_util_id` = 405287) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 405287
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 827
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