K21 MOTO CHENOVE
10 rue des Frères Montgolfier
21300 - CHENOVE

Tél.: 03 80 54 34 72

Du mardi au vendredi:
de 9h15 à 12h00 et de 14h00 à 19h00

Le samedi:
de 9h15 à 18h00 (non stop)

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 = "134825"
OR INSTR(Dupliquee,134825) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
)
 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 = "134825"
OR INSTR(Dupliquee,134825) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
)

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

)
Nos occasions
Page(s) : 12
KTM 1190 ADVENTURE 2016
KTM 1190 ADVENTURE 2016
11 490 €
2901 Km
07/2016
1190 cm3
KAWASAKI ZX6R 2017 KRT EDITION
KAWASAKI ZX6R 2017 KRT EDITION
10 990 €
980 Km
03/2017
636 cm3
KAWASAKI ZZR 1400 PERFORMANCE SPORT 2017
KAWASAKI ZZR 1400 PERFORMANCE SPORT 2017
17 490 €
865 Km
03/2017
1400 cm3
KTM 125 EXC 2016
KTM 125 EXC 2016
5 990 €
2562 Km
02/2016
125 cm3
QUAD TGB BLADE 425
QUAD TGB BLADE 425
3 290 €
3230 Km
07/2009
425 cm3
BMW R 1200 GS 2005
BMW R 1200 GS 2005
5 990 €
52518 Km
04/2005
1200 cm3
KTM EXC-F350 2017
KTM EXC-F350 2017
7 490 €
85 Km
01/2017
350 cm3
KTM 450 EXC-F 2016
KTM 450 EXC-F 2016
6 490 €
4000 Km
01/2016
450 cm3
KTM 300 EXC 2017
KTM 300 EXC 2017
6 690 €
3511 Km
01/2017
300 cm3
KTM 250 EXC-F 2017
KTM 250 EXC-F 2017
6 990 €
4303 Km
01/2017
250 cm3
KAWASAKI KX450F CROSS 2016
KAWASAKI KX450F CROSS 2016
4 990 €
3 Km
03/2016
450 cm3
YCF 150 SP 3 2016
YCF 150 SP 3 2016
2 490 €
2 Km
12/2016
150 cm3
KAWASAKI KX250F CROSS 2016
KAWASAKI KX250F CROSS 2016
4 990 €
0 Km
03/2016
250 cm3
KAWASAKI 750 Z 2008
KAWASAKI 750 Z 2008
3 990 €
28306 Km
06/2008
750 cm3
KTM 350 EXCF 2013
KTM 350 EXCF 2013
4 800 €
7093 Km
02/2013
350 cm3
Page(s) : 12