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

Toutes les occasions d'AXXESS MACHINE sont contrôlées et garanties, nous sommes à votre service depuis plus de 27 ans, concessionnaire DUCATI & TRIUMPH depuis plus de 20 ans, KAWASAKI depuis plus de 14 ans. Un choix permanent d'une centaine de motos neuves et d'occasions.

nous vous proposons les services suivants:

REPRISE, ACHAT IMMÉDIAT, CRÉDIT, ENTRETIEN par des techniciens formés par nos marques.

Rechercher un véhicule d'occasion

Pages : 123
04/2013
DAYTONA R

TRIUMPH DAYTONA R 675

Plaquettes avant neuves.Pneus avant et arrière neufs (s21).Révision à jour (huile, filtres, liquide de frein et de refroidissement).La moto est ...
675 cm3   8669 Km
Prix: 12 900 €
03/2016
T 120

TRIUMPH BONNEVILLE T 120

SILENCIEUX VANCE & HINES EN OPTION
1200 cm3   3374 Km
Prix: 10 990 €
11/2016
VERSYS 650 ABS GRAND TOURER

KAWASAKI VERSYS 650 ABS GRAND TOURER

ABSPACK GRAND TOURER.
650 cm3   1869 Km
Prix: 8 600 €
06/2017
DIAVEL CARBON

DUCATI DIAVEL FL CARBON

BELLE DUCATI DIAVEL CARBON 2017 ETAT IRRÉPROCHABLE PRIX NEUF 22890€ CÉDÉ 19900€ SOIT 2990€ DE MOINS QUE LE NEUF..
1200 cm3   844 Km
Prix: 19 900 €
01/2017
Z 1000 SX

KAWASAKI Z 1000 SX

1000 cm3   2133 Km
Prix: 11 990 €
04/2016
Z1000SX ABS

KAWASAKI Z1000SX ABS

ABS FULL
1000 cm3   2438 Km
Prix: 10 590 €
02/2017
STREET SCRAMBLE

TRIUMPH STREET SCRAMBLER

KIT AMORTISSEURS TRIUMPHBEQUILLE CENTRALEBOCAL DE FREIN AVANT ALUBARRES DE PROTECTION MOTEURCLIGNOTANTS LED AVANT ET ARRIEREKIT PLAQUE NUMEROPROTEC...
900 cm3   3478 Km
Prix: 10 790 €
01/2017
ICON

DUCATI SCRAMBLER FULL THROTTLE

ELIGIBLE PERMIS A2. GARANTIE CONSTRUCTEUR JANVIER 2020.Un concentré de fun dans un écrin typiquement Ducati : Un Moteur vivant, un Châssis rigou...
803 cm3   895 Km
Prix: 9 990 €
07/2016
MONSTER 1200

DUCATI MONSTER 1200 R

GARANTIE CONSTRUCTEUR 07/2018. Le plus ultime des Monsters ! Etat neuf. Aucun frais à prévoir. Garantie constructeur jusqu'en Mars 2018. 160 che...
1200 cm3   2484 Km
Prix: 15 290 €
07/2017
STREET SCRAMBLE

TRIUMPH STREET SCRAMBLER A2

900 cm3   1913 Km
Prix: 9 590 €
09/2009
TDM 900

YAMAHA TDM 900

SELLE CONFORTBULLE HPBEQUILLE CENTRALEKIT DE SURBAISSEMENTPORTE PAQUETPARE MAINBARRES DE PROTECTION MOTEUR
900 cm3   28500 Km
Prix: 4 590 €
01/2017
T 120

BONNEVILLE T 120

X-PIPEPORTE PAQUET GIVISELLE CONFORT
1200 cm3   7614 Km
Prix: 10 990 €
01/2014
Z1000 SX ABS

KAWASAKI Z1000 SX ABS

ECHAPPEMENT LEOVINCEVALISESSELLES CONFORT
1000 cm3   36550 Km
Prix: 6 900 €
10/2016
TROPHY 1200

TRIUMPH BONNEVILLE T100

PROTECTION DE CARTERPARE BRISEPOIGNEE PASSAGERCLIGNOTANTS LEDSILENCIEUX CHROMES VANCE & HINES
900 cm3   4200 Km
Prix: 10 590 €
09/2016
TROPHY 1200

TRIUMPH 1200 EXPLORER XCX

1200 cm3   3686 Km
Prix: 15 990 €

Pages :123