Renault

Afficher les filtres de recherche


Chercher parmi tous nos vehicules


Il y a 15 véhicules affichés sur 2 pages.

Renault Renault Ponticelli Fast Scoler 2

Détails

Tarifs sur demande
CH
243200Km
Manuelle 6
Diesel
Renault Ares

Détails

Tarifs sur demande
CH
617900Km
Manuelle 6
Diesel
Renault Master 2.5 DCI 120 Autocar Renault  Master 2.5 DCI 120

Détails

Tarifs sur demande
Autocar Renault Master 2.5 DCI 120 CH
2008
270300Km
Manuelle 6
Diesel
Renault Ponticelli Fast Scoler 2 Autocar Renault Ponticelli Fast Scoler 2

Détails

Tarifs sur demande
Autocar Renault Ponticelli Fast Scoler 2 CH
2003
270400Km
Manuelle 6
Diesel
Renault Ponticelli Fast Scoler 2 Autocar Renault Ponticelli Fast Scoler 2 euro 3

Détails

Tarifs sur demande
Autocar Renault Ponticelli Fast Scoler 2 euro 3 CH
2003
295400Km
Manuelle 6
Diesel
Renault Ponticelli Fast Scoler 2 Autocar Renault Ponticelli Fast Scoler 2

Détails

Tarifs sur demande
Autocar Renault Ponticelli Fast Scoler 2 CH
2001
461600Km
Manuelle 6
Diesel
Renault Ponticelli Fast Scoler 2 Autocar Renault Ponticelli Fast Scoler 2

Détails

Tarifs sur demande
Autocar Renault Ponticelli Fast Scoler 2 CH
2001
444500Km
Manuelle 6
Diesel
Renault Ponticelli Fast Scoler 2 Jumbo Autocar Renault Ponticelli Fast Scoler Jumbo

Détails

Tarifs sur demande
Autocar Renault Ponticelli Fast Scoler Jumbo CH
2004
424500Km
Manuelle 6
Diesel
  • 1
  • 2

Acheter ou vendre?


Contactez-nous !

Une question ?


02 37 46 89 57

MONDIAL NEGOCE BUS


  • 13 Rue Ethe Virton
  • 28100 DREUX

Horaires

Lundi au vendredi de 9h à 12h30 et de 13h30 à 17h30.

Samedi de 9h à 12h30.

Fermé le dimanche.

Plan d'accès

  • Mémoire utilisée par PHP : 12,48 Mo
  • Pic mémoire allouée par PHP : 13,36 Mo
  • Temps d'execution du script : 0.642 s
  • Lang :
  • Path : vehicules/marque/url-7
  • Route : vehiclesBrand
  • $okt->page->module : vehicles
  • $okt->page->action : brand
ID Query Time
1
SET NAMES utf8mb4
0.00036
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='3.230.144.31' WHERE u.id=1
0.00144
3
UPDATE oktopusV1_core_users_online SET logged=1632287059,
prev_url='https://www.negocebus.com/vehicules/marque/url-7'
WHERE ident='3.230.144.31'
0.00046
4
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00074
5
UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
0.00046
6
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1 
AND b.slug='url-7' AND b.active=1 AND m.active=1  GROUP BY
b.id ORDER BY b.title ASC 
0.00320
7
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND b.active=1 AND m.active=1 GROUP BY b.id ORDER BY b.title
ASC 
0.00255
8
SELECT m.id, m.brand_id, m.active, m.title, m.slug,
m.description, b.title AS brand_title, b.slug AS brand_slug,
COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_model AS m LEFT JOIN
oktopusV1_mod_vehicles_brand AS b ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND m.active=1 AND b.active=1  GROUP BY m.id ORDER BY
brand_title ASC, m.title ASC 
0.00264
9
SELECT COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles AS v LEFT JOIN
oktopusV1_mod_vehicles_category AS c ON v.category_id=c.id
LEFT JOIN oktopusV1_mod_vehicles_agencies AS a ON
v.agency_id=a.id LEFT JOIN oktopusV1_mod_vehicles_type AS t
ON v.type_id=t.id LEFT JOIN oktopusV1_mod_vehicles_energy AS
e ON v.energy_id=e.id LEFT JOIN
oktopusV1_mod_vehicles_gearboxes AS g ON v.gearbox_id=g.id
LEFT JOIN oktopusV1_mod_vehicles_model AS m ON
v.model_id=m.id LEFT JOIN oktopusV1_mod_vehicles_brand AS b
ON b.id=m.brand_id WHERE 1  AND m.brand_id=7  AND
v.disponibility<=3 AND v.visibility=1 
0.00139
10
SELECT v.id, v.title, v.slug, v.title_tag, v.title_seo,
v.model_id, v.type_id, v.category_id, v.agency_id,
v.energy_id, v.gearbox_id, hybrid_engine, v.created_at,
v.updated_at, v.desc_short, v.desc_long, v.ref,
v.meta_description, v.meta_keywords, v.gateway, v.annee,
v.date, v.roadworthiness, v.km, v.hours, v.environmental,
v.cv, v.kw, v.engine_size, v.engine_size_liter,
v.wheel_drive, v.air_conditioning, v.cylinder_number,
v.valves_number, v.front_brakes, v.rear_brakes, v.asr,
v.abs_system, v.registration, v.procedure, v.back_theft,
v.company_car, v.driving_school, v.rear_view_camera,
v.rear_view_warning, v.length, v.width, v.height,
v.wheelbase, v.turning_circle, v.weight,
v.carrying_capacity, v.ptra, v.axle, v.capacity, 
v.type_mine, v.norme_euro, v.carrosserie, v.ptac,
v.poids_utile, v.num_serie, v.usure_pneu, v.crit_air, 
v.seating, v.disability, v.disability_pmr_elec,
v.disability_pmr_manual, v.standing, v.toilet,
v.video_screen, v.number_vehicles, v.alcolocks, v.webasto,
v.kneeling, v.belts, v.convertible, v.retarder,
v.retarder_txt,  v.vane, v.vane_brand, v.lateral_vane,
v.frontal_vane, v.back_vane,  v.portes, v.garantie,
v.garantie_name, v.color_ext, v.color_family, v.color_int,
v.saddlery, v.rims, v.tires, v.maximum_speed,
v.maximum_torque, v.zero_to_one_hundred,
v.thousand_meters_ss, v.consumption, v.prix,
v.prix_marchand, v.prix_promo, v.disponibility,
v.tank_capacity, v.tank_capacity_adblue,
v.tank_position_adblue, v.images, v.files, v.promo,
v.promo_start, v.promo_end, v.nouvo, v.nouvo_start,
v.nouvo_end, v.favo, v.favo_start, v.favo_end, v.first_hand,
(v.first_hand = 1) AS is_first_hand, v.exclu, (v.exclu = 1)
AS is_exclu, v.visibility, (v.visibility = 1) AS is_visible,
v.filing_sale, (v.filing_sale = 1) AS is_filing_sale,
c.title AS category, c.description AS category_description,
e.title AS energy, g.title AS gearbox, t.title AS type,
b.title AS brand, b.slug AS brand_slug, m.title AS model,
m.brand_id, a.title AS agency_title, a.active AS
agency_active, a.adress AS agency_adress, a.adress2 AS
agency_adress2, a.code AS agency_code, a.city AS
agency_city, a.tel AS agency_tel, a.tel2 AS agency_tel2,
a.email AS agency_email, a.contact AS agency_contact,
(v.promo = 1) AS is_promo, (v.nouvo = 1) AS is_nouvo,
(v.favo = 1) AS is_favo, CONCAT_WS('
',b.title,m.title,v.title) AS intitle FROM
oktopusV1_mod_vehicles AS v LEFT JOIN
oktopusV1_mod_vehicles_category AS c ON v.category_id=c.id
LEFT JOIN oktopusV1_mod_vehicles_agencies AS a ON
v.agency_id=a.id LEFT JOIN oktopusV1_mod_vehicles_type AS t
ON v.type_id=t.id LEFT JOIN oktopusV1_mod_vehicles_energy AS
e ON v.energy_id=e.id LEFT JOIN
oktopusV1_mod_vehicles_gearboxes AS g ON v.gearbox_id=g.id
LEFT JOIN oktopusV1_mod_vehicles_model AS m ON
v.model_id=m.id LEFT JOIN oktopusV1_mod_vehicles_brand AS b
ON b.id=m.brand_id WHERE 1  AND m.brand_id=7  AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.id DESC
LIMIT 0,8 
0.02493
11
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND b.active=1 AND m.active=1 GROUP BY b.id ORDER BY b.title
ASC 
0.00037
12
SELECT m.id, m.brand_id, m.active, m.title, m.slug,
m.description, b.title AS brand_title, b.slug AS brand_slug,
COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_model AS m LEFT JOIN
oktopusV1_mod_vehicles_brand AS b ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1 
AND m.brand_id=7 AND m.active=1 AND b.active=1  GROUP BY
m.id ORDER BY brand_title ASC, m.title ASC 
0.00234
13
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV1_mod_map AS m 
LEFT JOIN oktopusV1_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='fr' WHERE 1  AND m.id = 2  AND
ml.language='fr' AND m.active=1 ORDER BY m.created_at DESC 
0.00077
# type fichier ligne classe fonction message