Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Yamaha mt 09 2019

Location Moto

Réserver

Ce voisin propose en location à Cerisy (80800)

85€/jour

Gregory B.

2 annonces

Prix

85€/jour

-1100kgqu'à l'achat

Description de l'annonce

Vous souhaitez partir en week-end ou en vacances, voici cette Suzuki bandit équipée de valises et top case. Les tarifs sont les suivants : 85€ la journée 150 kms inclus kms supplémentaires 0,15 cts
Week-end 140€ du samedi matin au dimanche soir 300 kms inclus kms suplementaires 0,15 cts
Semaine du lundi matin au dimanche soir 350€ avec 750 kms inclus kms supplémentaires 0,15 cts
Le mois soit 4 semaines du lundi au dimanche soir 1000 € avec 2500 kms inclus kms supplémentaires 0,15 cts #moto

Autres annonces du voisin

Tout voir

Il y a + de 30j

Service : Coach de boxe

35€

Cerisy

Annonces similaires

Tout voir

Il y a + de 30j

Bmw r1100rt

185€/weekend

Roye

Louer une moto entre particuliers ou proposer une moto en location.

Poster une annonce

Location entre voisins

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
0.0002
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
0.0003
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
0.0002
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0006
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
0.0001
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='447939'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'moto' LIMIT 1
0.0001
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='81'
0.0001
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='80'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='279612' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 279612
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 447939
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=864 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='447939'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='447939' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 279612 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=279612 LIMIT 1
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 279612 AND W.type_id = 1) OR (W.util_id <> 279612 AND W.type_id = 2)) AND (M.post_util_id = 279612 OR M.dest_util_id = 279612) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='279612' AND note_visu IN (1,3,4)
0.0001
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 = '447939'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='279612' AND wish_id<>'447939' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
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='1025' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=279612 AND note_visu IN (1,3,4)
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 279612
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='80800'
0.0165
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.8714*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.8714*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.59556- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.421739197041 AND ville_latitude_deg<50.321060802959 AND ville_longitude_deg>1.8978692756916 AND ville_longitude_deg<3.2932507243084 HAVING distance <= 50 ORDER BY distance ASC
0.009
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('80800','80800','80170','80170','80720','80170','80340','80720','80800','80800','80800','80110','80800','80131','80380','80800','80800','80340','80720','80800','80110','80170','80800','80121','80131','80110','80380','80800','80131','80800','80300','80300','80800','80113','80300','80340','80113','80110','80800','80110','80110','80340','80800','80170','80300','80380','80110','80800','80300','80110','80340','80340','80340','80340','80170','80110','80118','80800','80340','80110','80300','80115','80800','80300','80800','80170','80170','80340','80440','80110','80170','80810','80200','80134','80440','80320','80320','80110','80340','80300','80440','80110','80110','80110','80170','80300','80170','80300','80170','80115','80260','80200','80300','80260','80910','80340','80340','80450','80300','80440','80260','80110','80980','80170','80260','80910','80320','80200','80170','80260','80260','80300','80110','80560','80560','80320','80300','80300','80700','80300','80110','80440','80300','80360','80440','80700','80340','80250','80200','80500','80500','80500','80330','80330','80450','80320','80500','80700','80110','80300','80250','80320','80300','80200','80700','80200','80320','80300','80320','80320','80560','80260','80200','80300','80700','80110','80360','80500','80500','80250','80500','80700','80300','80700','80500','80500','80320','80300','80260','80260','80500','80300','80200','80560','80560','80300','80260','80360','80200','80360','80200','80300','80560','80320','80700','80680','80260','80136','80260','80200','80260','80250','80250','80560','80700','80260','80680','80500','80700','80320','80500','80360','80260','80700','80500','80250','80300','80250','80000','80080','80090','80700','80190','80560','80700','62450','80300','80200','80250','80500','80320','80260','80560','80250','80200','80250','80560','80260','80190','80360','80500','80700','80200','80700','80560','80700','80500','80200','80200','80360','80200','80560','80560','80500','80250','80250','80480','80680','80500','80560','80300','80190','80700','80700','80200','80300','80250','80300','80190','80680','80600','80190','80500','80260','80190','80480','80480','80360','80700','80700','80480','80500','80700','80300','80200','80250','80360','80500','80360','80260','80560','80560','62450','80250','80700','80200','80190','80190','80700','80250','80700','80190','80260','80680','80560','80200','80360','80500','80480','80160','80480','80560','80730','80730','80470','62450','80360','80700','80250','80300','80560','80200','80190','80160','80200','80190','80260','80700','80200','80500','80500','80360','80730','80500','80190','80190','80300','62111','80560','80250','80600','62111','80200','80560','80700','80500','80300','80700','60120','80700','80190','80160','80560','80700','80200','80560','80190','80470','60310','80560','80260','80160','62116','80500','62450','80500','60120','80260','60310','80260','80190','80700','80190','80470','80500','80400','80190','60120','80200','62450','80190','62450','80200','80160','62760','80360','62111','80760','62111','80250','80250','62121','60120','60420','80160','80160','80160','62760','80200','62760','80470','80400','62450','62450','60310','80310','62116','80400','62760','80400','60420','60420','80500','60310','80240','60120','60310','80470','60120','62450','62121','60420','60420','62760','80670','62450','80200','80400','80540','80160','80540','80930','80400','80160','62760','80200','80480','62111','80360','62450','62450','62760','60310','60490','62450','80670','80630','80400','62760','60490','60490','80400','60120','80600','60120','80240','60420','62121','60120','80400','60420','80160','80500','80160','62760','80400','60490','60310','62124','62116','80160','60420','62121','80650','80200','80200','62450','80400','60420','60640','62450','62111','62760','60490','62450','62111','80360','80310','80310','80540','80540','62124','80160','80240','80240','60120','80600','80400','60490','62760','62760','60310','60120','80670','80240','62121','62121','60310','62124','80200','60120','60420','80240','60420','60120','62116','62760','62124','60120','80670','62450','80240','80240','62116','60310','80400','80540','80240','60120','80670','80400','62111','62158','80310','60310','80400','62760','60420','62450','62760','60120','62111','60310','80240','80360','60310','60120','02590','62760','60120','80670','80750','80160','62116','62121','80540','80540','80240','80670','60120','80540','80600','80310','60490','60640','60120','60120','60420','80290','80310','60420','60420','62159','60640','80400','02490','02490','62124','80240','80160','60490','60640','60310','62124','80400','62124','60490','60310','80850','62158','60120','62123','80240','60120','02590','02590','80540','62124','62121','80600','60310','60640','80160','62121','80310','62159','60120','80400','80360','80240','62158','80710','60130','60490','62158','80600','60490','60310','02590','62124','60120','60120','60420','80750','80600','80240','60490','62175','80600','80610','80240','80310','60130','80160','80160','62124','60640','60400','62121','60310','62175','80112','62158','62124','62123','60400','60480','80122','62123','62158','62175','80780','62124','02480','60490','02590','02590','80610','80600','60640','60310','60640','02490','62124','62173','60400','62175','80600','60130','80600','60120','80240','62128','02590','80540','60360','60120','80160','80710','60130','62173','80310','60420','60420','80310','60310','62147','02490','62128','80620','80310','80310','60480','62159','80310','60130','80290','80420','80420','62128','62124','80400','60400','02590','02590','80160','62158','80540','02490','62123','60310','80600','80600','60640','62123','62123','02480','80620','02590','02480','80160','60360','62173','60640','60130','62810','60157','60640','60120','02490','80370','80740','80600','62175','60400','80240','60120','60480','80600','62810','60190','60490','80540','60420','80290','62173','60400','02480','02490','80290','62128','62147','60420','62128','62128','80600','60190','60400','60400','80620','60490','62810','60130','62810','62147','60310','62128','80370','80290','02640','60480','80160','60360','62147','62123','62810','62217','62810','59231','02480','80370','60360','60190','80160','60400','60130','02590','62810','60480','60480','80600','02420','80740','60162','62217','60480','80370','60480','62810','60640','02590','60130','80690','02420','60490','02300','02420','80290','02640','60190','60640','60640','60360','60400','80600','02480','80370','02490','60210','62270','80600','60162','60480','80620','59297','80620','60190','80290','62128','60130','62860','02480','62128','80620','60490','80160','60400','60400','60400','80540','80540','62123','62810','62810','80830','80600','62123','02480','60138','60480','62123','62147','80290','60210','59231','80830','62860','62182','02480','80890','60130','02760','60210','80620','02490','80690','62128','80270','60130','60130','80620','62128','60480','02300','60113','60640','80370','60130','80370','80370','60480','62217','02300','80290','80540','59159','59231','80290','60190','62810','60150','60150','02680','60190','60480','80290','60360','60150','02790','60190','62217','62217','60150','60400','62147','60360','02760','02490','62810','60130','60130','60130','62217','60400','60480','62182','62810','60400','62123','60480','02680','59267','02420','80370','62860','60400','60360','80370','62810','62128','62128','60113','60113','80640','02680','02680','02420','80270','60210','60170','80690','80690','62000','02520','80510','80270','62217','62810','59266','60170','80690','80620','60210','62128','60190','60190','62270','60190','02100','02300','02100','80270','80370','62810','60170','60360','60400','60480','02420','60480','62810','60190','80290','02420','62270','80290','80510','60130','80270','60400','60130','59266','80620','60210','60360','62123','62147','02420','62123','62123','62000','62123','60150','60150','62810','60150','80126','80370','62810','60190','80270','62161','60480','62810','62182','62161','62860','80290','62810','62270','02440','60360','80370','60130','59266','60150','60400','59400','62390','02430','62156','62270','80640','80690','62860','60510','02680','62270','60130','60360','60190','60190','02300','80640','60190','02300','02300','80270','02480','62182','02420','62118','62810','60150','80270','62156','80370','60170','62223','60400','62223','62270','60400','60400','62270','62223','02420','02100','60600','80290','80290','62270','62390','60360','60510','60190','62690','02420','80135','80510','80135','60600','60360','60400','62860','62690','60170','02420','62156','02440','80370','60510','80640','62223','62390','60200','60200','02300','62127','02300','80270','62270') AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='864' AND wish_id<>'447939' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
0.0001
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='864' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=99784 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 99784 AND W.type_id = 1) OR (W.util_id <> 99784 AND W.type_id = 2)) AND (M.post_util_id = 99784 OR M.dest_util_id = 99784) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 99784
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 864
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
0.0002
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
0.0003
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
0.0002
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
0.0001
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
0.0001
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
0.0001
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
0.0002
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
0.0002
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
0.0001
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
0.0001
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
0.0002
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
0.0002
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0001
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
0.0002
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
0.0009
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0265
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
0.018
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

56 requetes sql en 0.0777

Taille variable Globale : 76.6 KB