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
05/2016
THUNDERB.COMMAN

TRIUMPH THUNDERBIRD COMMANDER

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette superbe:*Triumph Thunderbird Commander 1700 ABS*Coloris Jet Black*Mise en ci...
0 cm3   9100 Km
Prix: 14 990 €
03/2017
TIGER SPORT

TRIUMPH TIGER SPORT

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle:*Triumph Tiger Sport 1050 ABS*Coloris Aluminium Silver*Mise en circula...
1050 cm3   6500 Km
Prix: 11 990 €
02/2017
SPEED TRIPLE R

TRIUMPH SPEED TRIPLE R

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette superbe:*Triumph Speed Triple R ABS*Coloris Matt Graphite*Mise en circulatio...
1050 cm3   2250 Km
Prix: 13 490 €
01/2017
BONNEVILLE T120 ABS

TRIUMPH BONNEVILLE T120 ABS

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle:*Triumph Bonneville T120 ABS*Coloris Cranberry Red / Aluminium Silver*...
1200 cm3   3100 Km
Prix: 11 490 €
09/2014
690 DUKE

KTM 690 DUKE

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette:*KTM Duke 690 ABS*Coloris blanc*Mise en circulation: 05/09/2014*Kilométrage...
690 cm3   8150 Km
Prix: 5 690 €
02/2017
BONNEVILLE T120 ABS

TRIUMPH BONNEVILLE T120 ABS

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle:*Triumph Bonneville T120 ABS*Coloris Cranberry Red / Aluminium Silver*...
1200 cm3   4000 Km
Prix: 11 390 €
02/2005
R 1200 CL

BMW R 1200 CL

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette:*BMW R1200 CL R 1200 CL*Coloris gris*Mise en circulation: 08/02/2005*Kilomé...
1200 cm3   67250 Km
Prix: 5 490 €
09/2016
NC 750 X

HONDA NC 750 X ABS

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette:*Honda NC750 NC 750X *Coloris noir / gris mat*Mise en circulation: 22/09/201...
750 cm3   4420 Km
Prix: 6 790 €
03/2007
CBF 1000 F

HONDA CBF 1000 F ABS

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette:*Honda CBF1000 CBF 1000 CB1000 F *Coloris noir métallisé *Mise en circulat...
1000 cm3   44650 Km
Prix: 4 490 €
03/2017
STREET SCRAMBLE

TRIUMPH STREET SCRAMBLER ABS

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette superbe:*Triumph Street Scrambler ABS*Coloris Korosi Red*Mise en circulation...
900 cm3   3500 Km
Prix: 9 990 €
03/2016
TIGER XCX

TRIUMPH TIGER XCX

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle:*Triumph Tiger Explorer 1200 XCX*Coloris Lucerne Blue*Mise en circulat...
1200 cm3   12250 Km
Prix: 13 990 €
05/2015
ROCKET X

TRIUMPH ROCKET X

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle et rare:*Triumph Rocket X*Numéro 309 sur 500 exemplaires produits au ...
2300 cm3   0 Km
Prix: 16 490 €
03/2017
THRUXTON R

TRIUMPH THRUXTON R

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette magnifique:*Triumph Thruxton R 1200 ABS*Coloris Silver Ice *Mise en circulat...
1200 cm3   4200 Km
Prix: 13 990 €
03/2003
R1150R ROCKSTER

BMW R1150R ROCKSTER

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette:*BMW R1150 R R1150R Rockster*Coloris noir mat / vert métallisé*Mise en cir...
1150 cm3   23650 Km
Prix: 5 490 €
03/2017
STREET TWIN

TRIUMPH STREET TWIN

*TRIUMPH STRASBOURG, Votre Concessionnaire Exclusif vous propose cette belle:*Triumph Street Twin ABS*Coloris Cranberry Red*Mise en circulation: 01...
900 cm3   3100 Km
Prix: 8 390 €

Pages :12