Array
(
    [0] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT 
				IDAnnonceVehicule,
				IDListePhotos,
				ReferenceAnnonce,
				TitreAnnonce,
				NomModele AS Modele,
				Cylindree,
				NomMarque AS Marque,
				Marques.Logo AS MarqueLogo,
				Categorie,
				Location,
				NeufOuOccasionOuAccidenteOuDestocke,
				NombrefoisClique,
				DateMiseEnCirculation,
				DateCreationAnnonce,
				DateMiseAJourAnnonce,
				DateDebutAnnonceVehicule,
				DateFinAnnonceVehicule,
				DemandeEssai,
				Garantie,
				FinGarantie,
				Kilometrage,
				KilometrageOuHeure,
				TypeMotorisation,
				PrixVente,
				AncienPrix,
				AnnonceVehicule.Puissance,
				CouleurVehicule,
				Commentaire,
				AnnonceVehicule.Chassis,
				Retrocession,
				AnnonceVehicule.Motorisation,
				AnneeModele,
				PiaggoPrivilege,
				Approved,
				Collection,
				PremiereMain,
				DepotVente,
				FinSerie,
				ComformeReglementation,
				Homologue,
				LargeurChenille,
				LongueurChenille,
				PuissanceSelect,
				Caracteristiques,
				FinancementDuree,
				FinancementInterets,
				FinancenementApport,
				FinancementTotal,
				FinancementMontant,
				FinancementCGV,
				Token,
				PartagesVN,
				PartagesVA,
				PartagesVO,
				PartagesVD,
				PartagesVNActive,
				PartagesVAActive,
				PartagesVOActive,
				PartagesVDActive
				 FROM 
			AnnonceVehicule
			LEFT JOIN Marques ON (Marques.IDMarque = AnnonceVehicule.IDMarque)
			LEFT JOIN ModeleMarque ON (ModeleMarque.IDModeleMarque = AnnonceVehicule.IDModeleMarque)
			LEFT JOIN Categorie ON (Categorie.IDCategorie = AnnonceVehicule.IDCategorie)
			LEFT JOIN Cylindree ON (Cylindree.IDCylindree = AnnonceVehicule.IDCylindree)
		
WHERE
((AnnonceVehicule.IDConcession = "159670"
OR INSTR(Dupliquee,159670) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-23"
AND DateFinAnnonceVehicule > "2017-09-23"
)
OR (DateDebutAnnonceVehicule <= "2017-09-23"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-23"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","1","14","16","18","19","27","33","31","32","97","777248","176","180","94","42","105","95","159","81","116","2","141","134","3","91","137","230","43","4","166","5","6","84","7","80","216","107","220","112","37","248","8","9","155","44","167","109","119","108","165","45","131","191","36","126","211","46","47","48","110","103","145","206","10","217","49","11","202","244","12","38","121","212","13","154","140","179","104","148","214","226","15","130","207","139","219","133","50","175","51","143","52","41","53","99","96","243","237","54","17","146","172","89","93","186","120","215","249","161","204","142","164","229","193","147","231","55","40","20","56","150","151","152","106","168","129","250","21","57","58","136","209","111","239","247","22","23","236","192","170","218","60","124","24","198","25","61","26","213","85","62","100","63","28","208","182","102","251","234","132","29","30","195","78","65","200","174","201","122","118","210","233","173","153","228","196","242","128","252","227","92","235","115","39","156","76","86","77","171","69","205","101","135","88","68","160","253","70","113","187","71","72","127","87","169","138","73","194","158","245","67","199","232","144","181","66","34","185","75","190","114","162","149","225","189","224","197","177","98","117")
)
 ORDER BY DateMiseAJourAnnonce DESC LIMIT 0,15
            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2537
        )

    [1] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT COUNT(IDAnnonceVehicule) AS Total FROM 
			AnnonceVehicule
			LEFT JOIN Marques ON (Marques.IDMarque = AnnonceVehicule.IDMarque)
			LEFT JOIN ModeleMarque ON (ModeleMarque.IDModeleMarque = AnnonceVehicule.IDModeleMarque)
			LEFT JOIN Categorie ON (Categorie.IDCategorie = AnnonceVehicule.IDCategorie)
			LEFT JOIN Cylindree ON (Cylindree.IDCylindree = AnnonceVehicule.IDCylindree)
		
WHERE
((AnnonceVehicule.IDConcession = "159670"
OR INSTR(Dupliquee,159670) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-23"
AND DateFinAnnonceVehicule > "2017-09-23"
)
OR (DateDebutAnnonceVehicule <= "2017-09-23"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-23"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","1","14","16","18","19","27","33","31","32","97","777248","176","180","94","42","105","95","159","81","116","2","141","134","3","91","137","230","43","4","166","5","6","84","7","80","216","107","220","112","37","248","8","9","155","44","167","109","119","108","165","45","131","191","36","126","211","46","47","48","110","103","145","206","10","217","49","11","202","244","12","38","121","212","13","154","140","179","104","148","214","226","15","130","207","139","219","133","50","175","51","143","52","41","53","99","96","243","237","54","17","146","172","89","93","186","120","215","249","161","204","142","164","229","193","147","231","55","40","20","56","150","151","152","106","168","129","250","21","57","58","136","209","111","239","247","22","23","236","192","170","218","60","124","24","198","25","61","26","213","85","62","100","63","28","208","182","102","251","234","132","29","30","195","78","65","200","174","201","122","118","210","233","173","153","228","196","242","128","252","227","92","235","115","39","156","76","86","77","171","69","205","101","135","88","68","160","253","70","113","187","71","72","127","87","169","138","73","194","158","245","67","199","232","144","181","66","34","185","75","190","114","162","149","225","189","224","197","177","98","117")
)

            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2539
        )

)
Occasions

Découvrez notre sélection de motos d'occasions garanties et contrôlées

Financement, reprise et essai possibles

Nous vous proposons des accessoires et équipements adaptés à votre future machine, grâce aux catalogues fournisseurs tels que Bihr, Top Block, Rizoma, France Equipement, Givi, et tant d'autres !

Les annonces figurant dans cette rubrique sont mises à jour quotidiennement, afin de vous présenter des modèles disponibles en temps réel dans notre showroom

Demandez Maxime au 0388182474 qui vous accueillera et vous accompagnera dans votre projet !

Rechercher un véhicule d'occasion

Pages : 12
  • THUNDERB.COMMAN
    TRIUMPH
    14 990 €
    0 cc
    9100 Km
    Immat.:05/2016
    Détails
  • TIGER SPORT
    TRIUMPH
    11 990 €
    1050 cc
    6500 Km
    Immat.:03/2017
    Détails
  • SPEED TRIPLE R
    TRIUMPH
    13 490 €
    1050 cc
    2250 Km
    Immat.:02/2017
    Détails
  • BONNEVILLE T120 ABS
    TRIUMPH
    11 490 €
    1200 cc
    3100 Km
    Immat.:01/2017
    Détails
  • 690 DUKE
    KTM
    5 690 €
    690 cc
    8150 Km
    Immat.:09/2014
    Détails
  • BONNEVILLE T120 ABS
    TRIUMPH
    11 390 €
    1200 cc
    4000 Km
    Immat.:02/2017
    Détails
  • R 1200 CL
    BMW
    5 490 €
    1200 cc
    67250 Km
    Immat.:02/2005
    Détails
  • NC 750 X
    HONDA
    6 790 €
    750 cc
    4420 Km
    Immat.:09/2016
    Détails
  • CBF 1000 F
    HONDA
    4 490 €
    1000 cc
    44650 Km
    Immat.:03/2007
    Détails
  • STREET SCRAMBLE
    TRIUMPH
    9 990 €
    900 cc
    3500 Km
    Immat.:03/2017
    Détails
  • TIGER XCX
    TRIUMPH
    13 990 €
    1200 cc
    12250 Km
    Immat.:03/2016
    Détails
  • ROCKET X
    TRIUMPH
    16 490 €
    2300 cc
    0 Km
    Immat.:05/2015
    Détails
  • THRUXTON R
    TRIUMPH
    13 990 €
    1200 cc
    4200 Km
    Immat.:03/2017
    Détails
  • R1150R ROCKSTER
    BMW
    5 490 €
    1150 cc
    23650 Km
    Immat.:03/2003
    Détails
  • STREET TWIN
    TRIUMPH
    8 390 €
    900 cc
    3100 Km
    Immat.:03/2017
    Détails

Pages :12