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

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

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

    [3] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT IDConcession FROM AnnonceVehicule
WHERE
IDAnnonceVehicule = "1800441"
 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 = "159601"
OR INSTR(Dupliquee,159601) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-22"
)
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 = "159601"
OR INSTR(Dupliquee,159601) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule > "2017-09-22"
)
OR (DateDebutAnnonceVehicule <= "2017-09-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-22"
)
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 9002 990 €

 Nos coordonnées

TRIUMPH NIMES (S-Team Moto)
328, route d'Avignon
30000 NIMES
Personne à contacter : NicolasNicolas

 Nous contacter


* champ obligatoire

 Caractéristiques

Prix
2 990 €
Marque YAMAHA
Modèle TDM 900
Cylindrée 900 CM ³
Kilométres 45600 Km
1ere immat. 17/01/2002
Année modèle 2002
Motorisation 4T
Chassis 2 roues
Catégorie Trail
Couleur grise
Garantie 6 mois
Annonce mise à jour le 01/09/2017 à 16:49

 Description

Triumph Nimes
Concessionnaire exclusif Triumph

Vous propose cette :

Yamaha 900 TDM

Mise en circulation : 17/01/2002
Kilométrage : 45200 KMS

º Top case

Garantie 6 mois
_________________

Possibilité de :

REPRISE

LIVRAISON France entière

Contact Sébastien 04 66 68 70 96
sebastien@triumph-nimes.com

Equipements de série
Top case 2 casques