Réserver
Description de l'annonce
Bonjour, Je recherche un frigo pour le week-end du 9 et 10 septembre 2023 pour réfrigérer des boissons pour le mariage de ma fille.
#refrigerateur
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Bonjour, Je recherche un frigo pour le week-end du 9 et 10 septembre 2023 pour réfrigérer des boissons pour le mariage de ma fille.
#refrigerateur
Annonces similaires
Tout voirLouer un refrigerateur entre particuliers ou proposer un refrigerateur en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
30€
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='524135'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='refrigerateur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='702'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'refrigerateur' 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='207'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='62'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='370199' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 370199
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 = 524135
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=702 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='524135'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='524135' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 370199 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 370199 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 = 370199 AND W.type_id = 1) OR (W.util_id != 370199 AND W.type_id = 2)) AND (`post_util_id` = 370199 OR `dest_util_id` = 370199) 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='370199' 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 = '524135'
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='370199' AND wish_id<>'524135' 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='62117'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.01667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.883639197041 AND ville_latitude_deg<50.782960802959 AND ville_longitude_deg>2.3122191924404 AND ville_longitude_deg<3.7211208075596 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 (62117,62490,62112,62490,62112,59552,59169,59553,59552,62490,62490,59151,62118,59500,62490,62490,62118,62490,59553,59553,62490,59169,59151,59187,62580,59259,62156,62156,59128,59169,62118,59450,59151,62156,59119,62320,62320,62118,62156,62970,62860,62118,59169,62580,62860,62860,59950,62950,59287,62580,62860,62156,62860,62320,59151,62580,62118,62156,59286,59169,59182,59287,62320,62156,62110,59151,62118,62141,62580,62119,62860,62790,62580,62580,59167,59194,59283,62182,59234,59194,62420,62640,62860,59182,59265,62680,62182,59162,62223,59176,62580,62860,62740,62128,62860,62128,62223,62860,62182,59283,62430,59265,62128,59234,62710,59176,59234,62580,62128,62860,62210,62590,62860,59146,59165,62221,62218,62440,62128,62860,62580,62182,59148,62223,59247,59247,62217,62880,59580,59580,62223,62820,59261,62128,59265,59239,62860,62300,62217,59490,59310,62220,59870,62300,62128,59246,59252,62000,62223,62128,62880,62880,62223,62580,59247,59265,62128,62128,62223,62217,62880,59554,59310,59265,62860,59870,62580,59252,62860,59239,59554,62217,62223,59554,59551,59235,59268,62128,59252,62217,62217,59490,62860,62153,62128,59710,59870,62800,59215,59554,62175,59111,59133,59179,62410,59172,62128,59133,59551,62128,59870,62147,59112,62410,62159,62750,62143,59295,59295,59554,59310,62410,59310,59400,59400,59710,59185,59171,62410,62121,62147,59141,59400,62153,59111,62000,62147,59161,62175,59147,59221,59870,62144,59111,62161,62161,59267,62121,59554,59251,59710,62124,59171,59172,59242,62138,59267,62173,59112,62217,59161,62175,62144,62159,62159,59124,59710,59156,59310,62160,59141,62161,59870,62160,59141,62175,59400,62147,62147,59113,62138,62124,59147,59293,59870,62160,62124,59147,62121,62147,59159,59242,59496,62124,59111,59310,62121,62173,59161,62175,59178,59267,59171,62144,59272,62161,59310,62450,62123,59184,59273,62138,59496,62121,62121,62450,59230,62123,59263,59220,59175,62144,59310,62980,59178,59161,62173,62124,59175,62138,59400,59282,59274,59242,59281,62172,59282,59159,62450,59159,62670,59136,59230,62114,62173,62980,59480,62121,62123,62530,62144,59255,62690,62149,59400,62116,59830,59135,62690,62123,59178,62530,62450,59296,62138,62121,62124,59310,62149,59139,59400,62124,59139,59277,59310,59690,59241,62450,62116,59155,59273,59134,62147,62149,62116,62123,62123,59220,62124,62149,62690,59134,62450,59830,62123,62123,62116,59810,62450,62690,59226,59231,59480,62450,62530,62113,62113,62121,62690,62123,59178,59134,62450,62123,62124,59830,59220,62450,59121,59195,62690,62124,59320,59320,59262,59135,62123,62124,59198,62290,59830,59400,62111,59129,59400,59211,59217,59188,62123,59830,62124,59790,62690,59134,62121,62450,59830,62840,59258,59195,59121,62690,59226,62113,62150,59224,62123,62620,62660,62450,59188,62123,62690,62810,62149,59830,59320,59258,62450,59120,59230,62124,59320,59400,59217,62116,62450,62124,59494,59258,59249,59320,59320,62150,80300,62690,62123,59217,59231,62450,59320,59260,59780,62840,59152,59152,59249,59266,59224,59292,59227,59227,62131,62150,62810,80300,59152,62131,62131,62620,59134,59231,59188,62111,62116,80300,59217,62690,59174,62690,59125,62810,59494,59233,62810,62620,80360,59157,80360,80360,59000,59320,59800,59160,59350,59777,59590,62690,59127,62136,80360,59320,62158,59214,62111,59780,59227,62450,62111,59266,80360,80360,59158,62620,62940,62158,59157,62111,62690,62690,62150,62810,59410,62690,80240,59152,80360,62400,59297,62150,59192,62810,59158,62196,62232,59370,62136,62450,80360,62158,80300,62400,59213,59191,62111,80300,59130,59266,59510,59110,59160,59230,80122,59840,59300,59294,62158,62810,62136,80360,59158,62232,62400,59269,59230,62232,62232,59540,62127,59213,62111,59350,59300,59280,59191,62150,59300,59780,62127,80360,62199,62810,62760,59540,80240,62158,59860,62700,59840,62810,59730,80240,59127,59840,59158,59191,80300,59199,80240,59700,62127,80360,59510,62840,80360,80360,62150,62840,02420,62450,80300,59390,62122,59213,59213,62127,59770,62127,59271,62111,02420,80740,59730,59880,62127,59269,59127,62920,80300,59730,62760,59170,59290,59520,62150,62810,62232,59199,59225,59127,80300,62920,59237,59730,62150,59225,59142,59118,62810,80760,59990,62127,59540,62111,80560,62136,80112,80560,62840,59269,62810,59213,59213,62460,59940,80200,59730,62158,80300,59390,59930,80560,62122,59491,59493,59650,59655,62760,59970,62460,62540,59280,59540,59278,59390,59390,59127,59253,59990,62127,62127,80560,02420,80740,62127,59990,80300,80300,02420,02420,80300,62810,62810,59193,62158,80240,80240,80240,80300,59530,62810,62760,80560,80360,62350,62920,62760,62760,59910,59980,62470,59116,59990,02420,80360,59990,62127,59980,62810,59420,80300,80300,59970,62460,59264,59530,62810,80600,80240,62540,80560,59360,62760,62127,59100,02110,59730,59163,59115,62350,80560,59970,62130,62470,59238,59144,62127,80240,59890,80200,62270,80300,59980,59980,59850,80360,62157,02420,80200,62810,59218,59218,59243,62127,80560,59530,59660,80240,59236,59940,02110,80300,62260,59150,80360,80300,62760,80300,59980,80560,62350,59218,62810,59200,80200,62127,80560,59181,80360,59218,59530,62810,62260,02420,80200,59940,62130,59530,62550,80200,80240,80200,80240,59223,59250,59890,59126,59530,62350,62151,80200,59222,80560,80560,59360,02420,59990,62130,80560,62760,59144,62130,62350,80240,62550,59990,62130,59360,62270,80600,59222,59530,62810,80240,80300,62550,02420,02110,80300,80560,62760,02490,62130,59163,80300,62350,62550,02490,02420,62190,59154,62760,62130,62130,59144,80340,62270,80810,59137,80300,59560,59144,80200,59360,80560,59920,80200,62270,62760,80560,80560,80340,62130,59163,62270,62550,59530,80600,80200,59530,62760,02490,59530,62260,02420,02110,59530,59222,59960,59144,62130,62550,80340,80200,59144,02110,62350,62190,80200,62190,62130,62550,59530,62270,59360,62810,62760,59530,80600,80560,59560,62550,02110,80300,59117,80240,59550,02420,80240,02110,02110,59360,59166,62130,62130,59530,59288,80560,62190,59270,62130,62190,62190,59360,80560,59232,80300,62760,62260,80300,62330,62760,02420,62550,59270,02420,80340,80340,59550,62550,02110,80300,80980,62270,80240,59570,62190,62120,59270,62130,62270,62270,80200,62130) AND fami_id='5' AND cate_id='207' AND type_id='1' AND ssrubr_id='702' AND wish_id<>'524135' 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='702' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271400 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 = 271400 AND W.type_id = 1) OR (W.util_id != 271400 AND W.type_id = 2)) AND (`post_util_id` = 271400 OR `dest_util_id` = 271400) 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 = 271400
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 702
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