Array
(
    [0] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT * FROM AnnonceVehicule
WHERE
IDAnnonceVehicule = "1866751"
 LIMIT 1
            [4] => /ModelV2.php l.758
        )

    [1] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT IDAnnonceVehicule, TitreAnnonce FROM AnnonceVehicule
WHERE
((IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule <= "2017-09-20"
AND DateFinAnnonceVehicule > "2017-09-20"
AND IDAnnonceVehicule > "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule <= "2017-09-20"
AND DateFinAnnonceVehicule = "0000-00-00"
AND IDAnnonceVehicule > "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-20"
AND IDAnnonceVehicule > "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
AND IDAnnonceVehicule > "1866751"
)
)
 ORDER BY IDAnnonceVehicule LIMIT 1
            [4] => /ModelV2.php l.758
        )

    [2] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT IDAnnonceVehicule, TitreAnnonce FROM AnnonceVehicule
WHERE
((IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule <= "2017-09-20"
AND DateFinAnnonceVehicule > "2017-09-20"
AND IDAnnonceVehicule < "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule <= "2017-09-20"
AND DateFinAnnonceVehicule = "0000-00-00"
AND IDAnnonceVehicule < "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-20"
AND IDAnnonceVehicule < "1866751"
)
OR (IDConcession = "147076"
AND NeufOuOccasionOuAccidenteOuDestocke = "0"
AND Active = 1
AND DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
AND IDAnnonceVehicule < "1866751"
)
)
 ORDER BY IDAnnonceVehicule DESC LIMIT 1
            [4] => /ModelV2.php l.758
        )

    [3] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT IDConcession FROM AnnonceVehicule
WHERE
IDAnnonceVehicule = "1866751"
 LIMIT 1
            [4] => /ModelV2.php l.758
        )

    [4] => 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 Categorie = "Trail"
)
 ORDER BY DateMiseAJourAnnonce DESC LIMIT 0,12
            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2537
        )

    [5] => 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 Categorie = "Trail"
)

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

)
YAMAHA TDM 9004 590 €

 Nos coordonnées

TRIUMPH LANESTER
Avenue François Mitterrand
56600 LANESTER
Personne à contacter : DanielDaniel

 Nous contacter


* champ obligatoire

 Caractéristiques

Prix
4 590 €
Marque YAMAHA
Modèle TDM 900
Puissance 86 CV
Kilométres 28500 Km
1ere immat. 04/09/2009
Année modèle 2009
Motorisation 4T
Chassis 2 roues
Catégorie Trail
Couleur NOIR
Garantie 3 mois
Annonce mise à jour le 10/09/2017 à 17:01

 Description

SELLE CONFORT
BULLE HP
BEQUILLE CENTRALE
KIT DE SURBAISSEMENT
PORTE PAQUET
PARE MAIN
BARRES DE PROTECTION MOTEUR
Toutes les occasions d’AXXESS MACHINE sont révisées et garanties.
Concessionnaire : KAWASAKI DUCATI TRIUMPH
AXXESS MACHINE 25 ans d’expérience à votre service.
Un stock permanent d’une centaine de motos, et un interlocuteur par marque pour réaliser votre projet.
Toutes les gammes de nos marques sont en stock, ainsi que les collections de vêtements.
Un grand choix de modèles préparés.
Dans nos ateliers la possibilité de : réviser, réparer, préparer ou accessoiriser votre moto.
Centre d’essai permanent pour déterminer votre choix.
Nous vous proposons également un large choix d’équipement pour le ou la pilote.
Crédit/reprise/livraison partout en France/dépôt vente/achat immédiat.
www.axxessmachine.com
0297816868 commercial@axxessmachine.com

Services concession
Démarches administratives sur place, Extension de garantie possible, Financement & Assurance possibles , Gravage possible, Livraison possible, Plus de photos sur demande, Prix hors frais d'immatriculation, Reprise possible, Transport possible