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 = "159490"
OR INSTR(Dupliquee,159490) > 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 = "159490"
OR INSTR(Dupliquee,159490) > 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
        )

)
Nos occasions

Rechercher un véhicule d'occasion

Pages : 12
07/2007
YP 400 MAJESTY ABS

YAMAHA YP 400 MAJESTY ABS

Yamaha YP400 Majesty ABSMise en circulation : 07/2007Kilométrage : 28 537 Kmº Grosse révision des 24 000 Kms effectuéeº Rien à prévoir______...
400 cm3   28537 Km
Prix: 2 590 €
10/2016
STREET CUP 900 ABS

TRIUMPH STREET CUP 900 ABS

Triumph Street Cup 900 ABSMise en circulation : 10/2016Kilométrage : 2 833 Kmº Véhicule de démonstration / courtoisieº Complète (carnet, manu...
900 cm3   2833 Km
Prix: 8 790 €
03/2000
THUNDERBIRD

TRIUMPH THUNDERBIRD 900

Triumph Thunderbird 900Mise en circulation : 03/2000Kilométrage : 29 845º Entretien à jourº Rien à prévoir• Échappement accessoire• Baga...
900 cm3   29845 Km
Prix: 6 290 €
07/2016
MT-09 TRACER

YAMAHA MT-09 TRACER

Yamaha MT09 Tracer ABSMise en circulation : 07/2016Kilométrage : 19 410 Kmº Première mainº Entretien 20 000 Kms effectué(entretien complet en ...
847 cm3   19410 Km
Prix: 7 990 €
10/2016
TIGER EXPLORER

TRIUMPH TIGER EXPLORER 1200 XRX LOW / LRH (Surbaissé)

Triumph Tiger 1200 Explorer XRX LowModèle surbaissé d'origine (LRH)MY2017Mise en circulation : 10/2016Kilométrage : 13 972º Première mainº Co...
1200 cm3   13972 Km
Prix: 14 690 €
02/2017
TIGER XRX

TRIUMPH TIGER 800 XRX

800 cm3   2507 Km
Prix: 10 990 €
05/2017
BONNEVILLE

TRIUMPH BONNEVILLE T120 BLACK 2017

Triumph Bonneville T 120 Black ABSMise en circulation : 05/2017Kilométrage : 2 616 Kmº Véhicule de courtoisieº Complète (carnet, manuel, factu...
1200 cm3   2616 Km
Prix: 11 490 €
05/2017
THRUXTON R

TRIUMPH THRUXTON R

Triumph GB Motors 94Concessionnaire exclusif Triumph Val de MarneVend :Triumph Thruxton 1200R ABSMise en circulation : 05/2017Kilométrage : 2 834 ...
1200 cm3   2834 Km
Prix: 14 490 €
08/2016
TIGER 1050 SPORT ABS

TRIUMPH TIGER 1050 SPORT ABS

Triumph Tiger Sport ABS MY2017Mise en circulation : 08/2016Kilométrage : 2 667 Kmº Véhicule de démonstration/courtoisieº Complète (carnet tam...
1050 cm3   2667 Km
Prix: 12 990 €
06/2016
TIGER 1200 EXPLORER XCx

TRIUMPH TIGER 1200 EXPLORER XCX | Première main

Triumph Tiger Explorer 1200 XC XMise en circulation : 08/2016Kilométrage : 2 077 Kmº Première mainº Complète (carnet tamponné, manuel, factur...
1200 cm3   2077 Km
Prix: 14 990 €
03/2014
CB 1000 R

HONDA CB 1000 R EXTREME

Honda CB 1000 R ExtremeMise en circulation : 03/2014Kilométrage : 5 068 Kmº État proche du neufº Rien à prévoir• Entièrement d'origineGara...
1000 cm3   5068 Km
Prix: 8 190 €
10/2014
TMAX 530 ABS

YAMAHA TMAX 530 ABS

Yamaha T MAX 530 ABSMise en circulation : 10/2014Kilométrage : 12 305 Kmº Manuel, carnet d'entretien, 3 clésº Entretien 10 000 Kms effectuéº ...
530 cm3   12305 Km
Prix: 8 190 €
01/1980
KZ

KAWASAKI KZ 750

Kawasaki KZ750 1980Mise en circulation : 01/01/1980Kilométrage : 833 Km~8000 € de préparationFactures jointesDossier complet photo de la prépa...
750 cm3   833 Km
Prix: 7 990 €
10/2016
BONNEVILLE

TRIUMPH BONNEVILLE T100 900 ABS BICOLORE

Triumph Bonneville T 100 ABS MY2017Mise en circulation : 10/2016Kilométrage : 1 999 Kmº Première mainº Complète (carnet, manuel, factures, dou...
900 cm3   1999 Km
Prix: 9 790 €
10/2013
SFV 650 GLADIUS

SUZUKI SFV 650 GLADIUS

Suzuki SFV650 Gladius(Bridable pour permis A2)Mise en circulation : 10/2013Kilométrage : 4 805º Première mainº Entretien à jourº Rien à pré...
650 cm3   4805 Km
Prix: 4 890 €

Pages :12