Discuter
Description de l'annonce
Bonjour je recherche une salle pour un événement ( mariage )
Pour 20 personnes merci
#salle reception
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Bonjour je recherche une salle pour un événement ( mariage )
Pour 20 personnes merci
#salle reception
Annonces similaires
Tout voirLouer un lieu de reception entre particuliers ou proposer un lieu de reception en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
200€
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='571761'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='salle-reception' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1000'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'salle-reception' 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='431682' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 431682
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 = 571761
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1000 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='571761'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='571761' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 431682 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 431682 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 = 431682 AND W.type_id = 1) OR (W.util_id != 431682 AND W.type_id = 2)) AND (`post_util_id` = 431682 OR `dest_util_id` = 431682) 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='431682' 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 = '571761'
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='431682' AND wish_id<>'571761' 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='70400'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.100339197041 AND ville_latitude_deg<47.999660802959 AND ville_longitude_deg>5.9004462583633 AND ville_longitude_deg<7.2328937416367 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 (70400,70400,70400,25250,70400,70110,70110,70110,70400,70110,70110,25250,70110,70400,25250,70400,70110,70110,70110,25250,70400,70110,25250,25250,70110,70200,25750,70200,70200,25250,25750,70110,70110,70400,70110,25250,70110,25750,25260,70110,25250,70200,70400,70200,70110,70110,25750,25750,25550,70400,25340,70400,70400,25250,25250,70200,70200,70200,70110,70200,25250,70200,25250,25550,70400,25113,70200,25250,70110,25550,25250,70200,25250,25550,25680,25680,70400,70110,25550,70200,25260,25260,25250,70200,70400,25250,25260,25680,70200,25250,25340,70110,70400,25550,70110,70200,70200,70400,70110,70400,70110,25550,70200,70200,70400,25550,25680,25260,25550,70200,25260,70400,70110,25340,25420,25340,70200,25340,70400,25340,25630,70110,25340,70400,25420,25680,70400,70400,25340,25420,70200,25340,70110,25680,25420,25250,25340,25250,25200,25420,70250,90800,70400,70110,25680,25150,70230,25200,25150,25150,90800,25680,25340,70200,70200,70200,70240,70400,25680,70240,70200,25340,70400,70240,25340,70290,25110,25250,90800,70000,90800,70230,25680,25680,25340,25200,70200,25400,90400,25600,25600,25150,25350,25400,70240,25700,25680,90850,25680,70400,25110,70000,25340,90850,70000,90700,25600,25400,70230,90400,25110,70200,70200,25680,90400,25400,70240,25150,25680,25700,90350,70270,70270,70270,90400,25150,70290,25340,25430,25600,70230,25430,25600,70200,25110,25110,70200,70240,90400,25680,90300,25680,70200,25110,25340,90400,25460,70230,25110,25190,70270,70200,90400,25150,25680,70240,70300,25150,25680,70240,25230,90400,25430,25430,90000,70230,25230,70270,25190,25110,70240,70240,70240,90300,70200,25110,90300,25490,25150,70230,70230,25490,70000,90400,25190,25680,25310,25430,25680,90300,90200,25430,25110,70230,25230,70300,25430,90140,90120,70240,25150,25110,25430,70270,90160,25230,25430,70270,90200,90400,70000,25190,25190,25190,25110,25490,70240,90300,25640,25310,70300,25190,90300,25310,70230,90330,70240,70270,70000,90500,25190,70000,90120,70300,90140,70000,70290,70230,70270,25110,90340,25430,90500,25430,25310,25640,25640,25490,90300,25310,25310,70300,70300,25110,25190,70300,25190,90160,70230,25190,70290,25430,25110,90140,70230,25640,25310,70300,25190,25640,70230,70300,25360,25640,70000,90380,90100,25310,70230,90200,70240,25190,70000,90160,90340,70000,70000,70230,90140,25380,90200,25110,25190,25110,90600,90200,70000,90140,70310,25380,25530,70240,90150,90150,25310,25640,70230,90200,70300,70000,90340,25110,25380,70300,90200,70000,70000,90100,70440,70300,25190,70240,70240,25640,25310,25360,90140,90170,70000,25110,25110,70000,70190,90100,90150,70310,25360,70300,70310,70280,70310,70300,25190,70280,70300,90130,90170,90100,25110,70190,70440,25380,25190,70280,25640,25640,25380,70190,70000,90170,90100,90100,90100,90150,70300,25360,70300,25110,70300,90130,70000,90100,25640,70240,90150,25640,90110,70000,25360,70190,90130,70000,70310,25510,90150,70000,25190,70300,25640,25640,70310,25640,25190,90200,90150,90150,90100,90100,70000,70000,70190,25640,25640,70280,25380,25530,25640,25190,90110,70000,70190,90100,25190,25380,25530,25120,90150,70440,70300,25640,25380,90150,90150,70000,70000,70300,70000,70000,25530,25380,90100,90110,25640,70160,90110,70280,70160,25120,90170,70300,25380,68210,68210,70190,25360,25640,25530,70310,70000,68210,90110,70190,70310,25510,25530,90100,25470,70190,25640,25380,68210,25120,25470,25470,25120,70000,70190,25510,70310,70160,25470,25110,90110,90150,70000,25120,68290,25530,70170,25380,25820,70160,70170,90150,70800,90100,25120,25510,68210,70000,90100,70800,70190,90150,25360,25360,70190,25380,90360,68210,25530,25360,70310,90360,70170,25640,25640,70190,25870,70000,70800,90100,25470,90100,70000,25210,70000,90100,88160,88560,68290,70220,25530,70000,25960,70160,70000,25190,25190,25360,25870,25870,88160,70800,25530,68290,25510,25470,68210,70190,70800,68210,25510,88160,68290,68290,70190,25140,70000,90100,25210,25530,25470,25470,68210,68210,70170,25360,68290,88160,70190,70000,25870,25360,25640,68290,70170,68210,25390,70310,68290,70800,70800,25510,25210,25450,68780,25140,68210,68210,70360,25360,70310,88360,70190,25210,88340,25210,70800,25210,68780,70000,70170,68210,70160,68290,25140,70190,68210,25870,25470,70190,25640,90370,70190,25220,68210,68210,68210,70170,70190,68210,88540,70800,70160,70160,25360,68580,68290,70170,68780,70320,25530,68210,68580,25470,70360,25210,68780,25220,25210,70360,70190,25220,70800,70320,88360,25470,68780,70800,68210,68210,68780,25870,70170,25690,68580,70190,70360,70130,70160,25470,70800,70170,25220,25360,68210,25390,70800,70320,70360,25210,25530,68780,25390,88340,25580,25390,68116,25210,68290,70160,25870,25640,25390,70190,68210,68210,70190,68580,68580,25360,70190,68210,70360,70190,70190,68210,70800,68480,25530,70800,68290,70800,70360,25220,25870,70190,68210,70800,68470,70130,68580,70130,68210,25390,25390,68580,70190,68800,70160,68800,88370,25210,70360,68210,68470,68121,70800,88290,25220,25210,25690,70160,70170,70130,25140,70190,70360,68210,25690,25210,70190,25620,25800,25660,70190,68700,68470,25870,70160,88290,68720,25220,25220,88310,68520,70210,70360,68470,88200,25500,68520,68800,70160,25800,70210,25390,68800,70360,25870,68580,70130,68480,25660,70160,25870,25500,68118,68580,68210,70210,25620,70210,68130,25620,68720,25210,25210,68690,68550,70160,68700,25870,70700,68470,68620,25580,68700,88240) 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='1000' AND wish_id<>'571761' 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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=404364 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 = 404364 AND W.type_id = 1) OR (W.util_id != 404364 AND W.type_id = 2)) AND (`post_util_id` = 404364 OR `dest_util_id` = 404364) 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 = 404364
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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=539095 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 = 539095 AND W.type_id = 1) OR (W.util_id != 539095 AND W.type_id = 2)) AND (`post_util_id` = 539095 OR `dest_util_id` = 539095) 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 = 539095
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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=16344 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 = 16344 AND W.type_id = 1) OR (W.util_id != 16344 AND W.type_id = 2)) AND (`post_util_id` = 16344 OR `dest_util_id` = 16344) 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 = 16344
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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=428005 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 = 428005 AND W.type_id = 1) OR (W.util_id != 428005 AND W.type_id = 2)) AND (`post_util_id` = 428005 OR `dest_util_id` = 428005) 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 = 428005
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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=140023 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 = 140023 AND W.type_id = 1) OR (W.util_id != 140023 AND W.type_id = 2)) AND (`post_util_id` = 140023 OR `dest_util_id` = 140023) 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 = 140023
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='1000' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=438539 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 = 438539 AND W.type_id = 1) OR (W.util_id != 438539 AND W.type_id = 2)) AND (`post_util_id` = 438539 OR `dest_util_id` = 438539) 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 = 438539
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1000
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