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

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

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

    [3] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT IDConcession FROM AnnonceVehicule
WHERE
IDAnnonceVehicule = "1862783"
 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 = "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 Categorie = "Roadster"
)
 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 = "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 Categorie = "Roadster"
)

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

)
TRIUMPH STREET TRIPLE 6754 700 CHF

 Nos coordonnées

SUPERMOTORAMA
Avenue de France 82
1950 SION
Personne à contacter : Joël TschoppJoël

 Nous contacter


* champ obligatoire

 Caractéristiques

Prix
4 700 CHF
Marque TRIUMPH
Modèle STREET TRIPLE 675
Puissance 78 CV
Kilométres 20500 Km
1ere immat. 27/03/2009
Année modèle 2009
Chassis 2 roues
Catégorie Roadster
Couleur Roulet Green
Garantie 3 mois
Mise à jour le 02/08/2017 à 09:28

 Description

Moto en super état, grand service et expertise du jour