Image de CUSTOMS & CLASSICS
CUSTOMS & CLASSICS
Image de ENDURO
ENDURO
Image de MOTOCROSS
MOTOCROSS
Image de ROADSTERS
ROADSTERS
Image de ROUTIERES
ROUTIERES
Image de SCOOTERS
SCOOTERS
Image de SPORTIVES
SPORTIVES
Image de TRAILS
TRAILS
Vulcan 1700 Nomad 2016
Vulcan 1700 Voyager
Vulcan 900 Classic 2016
Vulcan 900 Classic Specia...
Vulcan 900 Light Tourer 2016
Vulcan S 2017
Vulcan S Cafe 2017
Vulcan S Special Edition ...
W800 Final Edition 2016
W800 Special Edition 2016
KLX110 2017
KLX110 2018
KX450F 2018 2018
KX250F 2016
KX250F 2017
KX250F 2018
KX450F 2016
KX450F 2017
KX65 2017
KX65 2018
KX85 Grandes roues 2016
KX85 Grandes roues 2017
KX85 Grandes Roues 2018
KX85 Petites roues 2016
KX85 Petites roues 2017
KX85 Petites Roues 2018
Z1000 2017
Z1000 Performance 2017
Z1000 R Edition
Z1000 R Edition Performan...
Z300 2016
Z300 Performance 2016
Z650 2017
Z650 Performance 2017
Z800 2016
Z800 e version 2016
Z800 e version Performanc...
Z800 e version SE 2016
Z800 e version SE Perform...
Z800 Performance 2016
Z800 Sugomi Edition 2016
Z900 2017
Z900 Performance & Perfor...
1400GTR 2016
1400GTR Grand Tourer 2016
Z1000SX 2016
Z1000SX 2017
Z1000SX Performance 2017
Z1000SX Tourer 2016
Z1000SX Tourer 2017
ZZR1400 2017
ZZR1400 Performance 2017
ZZR1400 Performance Sport
ZZR1400 Performance Sport...
J125 2016
J125 Special Edition 2016
J300 Special Edition 2017
Ninja ZX-10R KRT Replica...
Ninja 650 2017
Ninja 650 KRT Edition 2017
Ninja 650 Performance 2017
Ninja 650 Tourer 2017
Ninja H2 2016
Ninja H2 2017
Ninja H2 Carbon
Ninja H2R
Ninja ZX-10R 2017
Ninja ZX-10R Performance ...
Ninja ZX-10RR 2017
Ninja ZX-10RR Performance...
Ninja ZX-6R 636 KRT Editi...
Ninja ZX-6R 636 KRT Editi...
Versys 1000 2016
Versys 1000 2017
Versys 1000 Grand Tourer ...
Versys 1000 Grand Tourer ...
Versys 1000 Tourer 2016
Versys 1000 Tourer 2017
Versys 1000 Tourer Plus 2016
Versys 1000 Tourer Plus 2017
Versys 650 2017
Versys 650 Grand Tourer 2017
Versys 650 Special Editio...
Versys 650 Special Editio...
Versys 650 Special Editio...
Versys 650 Special Editio...
Versys 650 Tourer 2017
Versys 650 Tourer Plus 2017
Versys-X 300 2017
Versys-X 300 Adventure 2017
Versys-X 300 Urban 2017
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 = "147220"
OR INSTR(Dupliquee,147220) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
)
 ORDER BY DateMiseAJourAnnonce DESC LIMIT 0,12
            [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 = "147220"
OR INSTR(Dupliquee,147220) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
)

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

)

Véhicules d'occasion

Rechercher un véhicule d'occasion

Pages : 12
600 FAZER S
04/2003
YAMAHA 600 FAZER S
2 490 €
Z 650
02/2017
KAWASAKI Z 650
6 190 €
KXF 450
01/2014
KAWASAKI KXF 450
6 490 €
W 800
11/2014
KAWASAKI W800 "BLACK EDITION"
8 490 €
VULCAN 650S ABS
01/2017
KAWASAKI VULCAN 650 ABS CAFE RACER
7 249 €
Au lieu de 8 049 €
Z 900
03/2017
KAWASAKI Z900 ABS
7 990 €
J300 ABS-SE
09/2015
KAWASAKI J300 ABS-SE
4 390 €
J125 ABS
05/2015
KAWASAKI J125 ABS
4 190 €
GSF 1250 SA BANDIT
11/2013
SUZUKI GSF 1250 SA BANDIT
6 490 €
Au lieu de 6 990 €
KXF 450
01/2016
KAWASAKI KXF 450
6 790 €
KXF 450
01/2015
KAWASAKI KXF 450
6 490 €
Z 750 R
01/2011
KAWASAKI Z 750 R
5 200 €
Pages : 12