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

)
Véhicules Occasions
Toutes nos occasions sont contrôlées en détail et expertisée 

Rechercher un véhicule d'occasion

Pages : 1
  • MONSTER 696
    DUCATI
    5 500 CHF
    696 cc
    25000 Km
    Immat.:03/2013
    Détails
  • MYROAD 700i ABS
    KYMCO
    3 500 CHF
    700 cc
    24000 Km
    Immat.:04/2014
    Détails
  • STREET TRIPLE 675 R ABS
    TRIUMPH
    9 800 CHF
    675 cc
    650 Km
    Immat.:11/2013
    Détails
  • CB 900 F HORNET
    HONDA
    3 000 CHF
    900 cc
    51000 Km
    Immat.:04/1994
    Détails
  • STREET TRIPLE 675
    TRIUMPH
    4 700 CHF
    675 cc
    20500 Km
    Immat.:03/2009
    Détails
  • THUNDERBIRD 900 SPORT
    TRIUMPH
    9 500 CHF
    900 cc
    25000 Km
    Immat.:04/1998
    Détails
  • TROPHY 1200
    TRIUMPH
    2 500 CHF
    1200 cc
    69000 Km
    Immat.:05/1997
    Détails

Pages :1