Réserver
Prix
50€/j
-20kgqu'à l'achat
Description de l'annonce
Nous mettons à votre disposition notre enceinte 2200w avec ou sans base
Avec lumières
#enceinte
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Prix
50€/j
-20kgqu'à l'achat
Nous mettons à votre disposition notre enceinte 2200w avec ou sans base
Avec lumières
#enceinte
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer des enceintes entre particuliers ou proposer des enceintes en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
50€
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='523640'
INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (523640, 0, '/img/wiiz/369513-230827-2314-location-enceinte.jpeg', 0)
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'enceinte' 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='80'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='369513' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 369513
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 = 523640
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=663 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='523640'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='523640' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 369513 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 369513 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 = 369513 AND W.type_id = 1) OR (W.util_id != 369513 AND W.type_id = 2)) AND (`post_util_id` = 369513 OR `dest_util_id` = 369513) 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='369513' 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 = '523640'
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='369513' AND wish_id<>'523640' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='844' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369513 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 = 369513 AND W.type_id = 1) OR (W.util_id != 369513 AND W.type_id = 2)) AND (`post_util_id` = 369513 OR `dest_util_id` = 369513) 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 = 369513
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='667' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 369513
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='858' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 369513
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='80640'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.86667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.433639197041 AND ville_latitude_deg<50.332960802959 AND ville_longitude_deg>1.168807310737 AND ville_longitude_deg<2.564532689263 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 (80640,80140,80140,80140,80140,80640,80270,80140,80140,80430,80640,80430,80140,80430,80140,80270,80270,80270,80140,80640,80140,80430,80270,80640,80270,80140,80430,80270,80540,80270,80430,80430,80540,80430,80126,80140,80140,80540,80430,80140,80590,80590,80490,80590,80270,80270,80140,80140,80140,80140,80430,80140,80140,80140,76340,80140,80540,80270,80140,80430,80270,80490,80490,80590,80590,80140,80540,80140,80290,76390,80290,80140,80590,80590,80590,80590,80290,80590,80270,80140,80540,80490,80310,80290,80140,76390,80310,80710,76340,76340,80290,80290,80140,76340,80140,80140,80290,80140,80310,80140,80140,80290,80490,80490,76340,76390,76390,80290,80290,60220,80540,80310,80140,80290,80140,80290,76390,80140,60220,80490,80540,80310,80540,80580,60220,80510,76390,80540,76340,80290,80710,80510,80220,76340,80140,80510,60220,80290,80290,76390,80310,80310,80540,80890,80290,80310,80580,80580,80510,76340,80580,80540,80220,60220,80132,80540,80290,80290,80290,80140,60220,76390,80310,80870,80580,60210,80580,80830,76340,80830,76390,80132,80220,80140,80160,60210,80690,76340,80220,76390,80310,80210,80690,80160,80210,80420,80420,76390,76340,80540,76340,80310,80310,76340,60220,76340,80540,60220,80160,80480,76340,60210,80160,80160,60210,60210,76340,60210,80132,80620,80132,76340,80470,80870,80132,80690,80870,80220,80610,80160,80470,76270,76390,80132,60210,80470,80160,80690,60220,60210,80100,80132,80160,80690,80210,60220,80210,80610,76340,60210,60210,80160,80620,80160,76390,80730,60220,80135,76660,80690,80690,80220,76390,76270,80210,80160,80160,80160,80470,80135,60960,60210,80220,80310,80160,76270,60210,80160,76260,80132,60210,60210,80470,76660,80730,80730,80480,80780,60220,76340,76390,80480,80132,80620,80620,80160,76270,80160,76270,60220,60210,80480,80480,80480,60220,60210,60210,80132,60220,60120,76260,80132,80210,60220,60210,76660,80132,80135,80650,80570,76270,76270,80850,60220,60210,80132,80135,80210,76270,80210,80620,76660,60360,60210,80480,80260,60360,80680,80132,80620,80770,80670,76270,80135,76260,80390,80160,80132,80160,76270,60220,80135,80230,80132,80160,80210,76660,76117,80570,80670,60360,80260,76260,80135,60120,80620,80132,60220,80620,76870,76660,80220,80670,80090,80000,80080,80670,76260,80260,80160,80210,80680,76660,76440,80520,80390,80160,60380,60360,80132,60360,76870,60380,60380,60210,80132,80150,80130,80620,60690,80680,76270,60210,80670,80520,80160,76270,80370,80620,80520,76440,80160,80230,76660,80370,76440,80136,76260,80260,80680,76660,60120,60690,60360,80370,76440,80820,80370,80370,76260,80260,80680,76270,76270,80160,60220,76260,60380,80150,60220,76630,80150,80530,60690,76660,76630,80960,80370,80132,60380,76440,80150,60860,80130,76660,60360,60360,76260,80970,60380,60360,80260,80460,76270,80260,76270,80150,80530,80530,60380,80670,76260,80230,60120,80230,80450,76440,80330,80330,80150,60690,60690,76440,80860,80260,76260,80370,80370,60360,60360,80260,80250,60380,80670,80940,76440,60120,60120,80150,80150,80260,80370,80370,60690,80260,76440,60380,76660,80250,80150,80250,60360,76440,76440,76270,80880,76220,80750,76260,76660,76270,80370,60360,76440,80460,80750,60120,76270,80450,60380,80860,76260,80260,76630,80440,80230,80260,60120,76440,60380,80230,80250,80230,76260,60380,80250,80150,80250,80150,60360,76440,76220,80370,76440,80440,80600,80440,60380,60120,80460,76260,80370,80370,80860,76630,60860,76220,80260,76260,80250,60120,80230,80250,60120,76630,60380,60112,60380,60112,60380,60480,60480,80260,80150,80150,76440,80150,60860,80440,76630,76260,80370,80370,76270,80600,60860,80370,80115,76660,80440,76660,80440,80260,80600,76270,80150,80260,76630,60860,80350,76440,76270,76270,80250,60120,80260,76660,76630,80800,60860,60380,60650,80150,80150,76630,60112,60112,60480,76440,80550,80630,76470,60360,80260,76440,80110,60112,60380,76910,80120,80250,76630,80120,80260,60380,76220,80110,76440,60120,80600,80250,60480,80800,80800,76220,60120,80370,76510,80380,76910,80260,76630,76660,80115,76630,80250,76680,60480,80600,76510,76220,80370,60480,80600,76440,60650,60650,80150,80260,60650,62390,62390,76680,60480,76780,60650,80150,60120,76630,80410,76510,80150,80260,80260,60480,60120,80250,80250,60480,80150,80120,80560,76630,62390,62390,60112,80110,76510,60112,76910,80600,76630,80150,60112,80110,80600,80600,80600,80800,76680,80250,62390,76680,80250,80380,76630,80110,60120,60650,76780,80150,76630,60650,60112,80600,80150,80250,76440,60650,80800,76680,60480,80110,60112,80560,80120,62390,80120,76750,62140,76220,80600,80600,80600,80800,60112,76780,76680,76220,80800,80600,76680,60480,76680,60480,76780,76510,62390,80120,62390,76370,80560,80560,60120,62140,80110,80110,60112,60480,80110,62390,76220,80800,60650,76780,76680,60650,60112,80150,76510,76630,80380,76630,62140,76510,60480,76950,80800,76370,60650,60480,76750,60480,62760,76220,80560,62760,62390,80110,62390,76220,60120,80250,60120,80600,62390,60510,80800,76510,80120,60480,60480,80110,76630,62760,60120,60000,80150,80300,80113,60120,62140,76680,62390,62270,62390,76220,62270,76220,60850,80560,76750,60120,76680,80300,80120,80120,60650,60510,76680,76370,76510,76750,76750,80800,80800,80110,80110,62270,62760,60650,76750,62390,60120,76590,80110,62140,80560,62270,60510,76780,80110,80250,76590,80110,80560,62140,80120,76780,60000,80600,76370,76680,80600,76590,60480,76780,60510) AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='663' AND wish_id<>'523640' 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='663' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=501980 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 = 501980 AND W.type_id = 1) OR (W.util_id != 501980 AND W.type_id = 2)) AND (`post_util_id` = 501980 OR `dest_util_id` = 501980) 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 = 501980
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='663' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74152 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 = 74152 AND W.type_id = 1) OR (W.util_id != 74152 AND W.type_id = 2)) AND (`post_util_id` = 74152 OR `dest_util_id` = 74152) 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 = 74152
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 663
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