SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID FROM wp_2_posts LEFT JOIN wp_2_term_relationships ON (wp_2_posts.ID = wp_2_term_relationships.object_id) INNER JOIN wp_2_postmeta ON ( wp_2_posts.ID = wp_2_postmeta.post_id ) WHERE 1=1 AND ( wp_2_term_relationships.term_taxonomy_id IN (477) ) AND ( ( wp_2_postmeta.meta_key = 'price-public' AND CAST(wp_2_postmeta.meta_value AS SIGNED) <= '999999' ) ) AND wp_2_posts.post_type = 'veicoli' AND ((wp_2_posts.post_status = 'publish')) GROUP BY wp_2_posts.ID ORDER BY wp_2_posts.post_date DESC LIMIT 0, 24
784 auto usate
Filtra Auto
Renault Megane
Sporter 1.5 Dci 85kw Blue Business Edc Wagon
132.944 km
2019
diesel
automatico
Garanzia 12 mesi
Volkswagen Golf
Vii 1.6 Tdi Executive Bmt Dsg 5 Porte Berlina
158.578 km
2018
diesel
automatico
Garanzia 12 mesi
Volkswagen Polo
1.6 Tdi Scr 59kw Businesscomfortline Bmt 5 Porte
142.260 km
2018
diesel
manuale
Garanzia 12 mesi
Volkswagen Tiguan
2.0 Tdi Scr 110kw Business Bmt Dsg
111.115 km
2019
diesel
automatico
Garanzia 12 mesi
Volvo V40
D2 Geartronic Business 5 Porte Berlina
118.062 km
2018
diesel
automatico
Garanzia 12 mesi
Volvo Xc40
T5 Plug-in Hybrid Auto Recharge Inscription
81.976 km
2021
ibrida
automatico
Garanzia 12 mesi
Volvo Xc60
D4 Awd Geartronic Business
93.820 km
2018
diesel
automatico
Garanzia 12 mesi
Peugeot 3008
Bluehdi 130 Eat8 S&s Business
89.530 km
2018
diesel
automatico
Garanzia 12 mesi
Nissan Qashqai
1.5 Dci 115 Business
98.975 km
2019
diesel
manuale
Garanzia 12 mesi
Nissan X-trail
1.7 Dci 150 4wd N-connecta Xtronic
157.878 km
2019
diesel
automatico
Garanzia 12 mesi
Nissan X-trail
2.0 Dci 177 4wd N-connecta Autom.
93.299 km
2018
diesel
automatico
Garanzia 12 mesi
Opel Mokka X
1.6 Cdti Business 110cv S&s 4x2 Mt6
144.552 km
2019
diesel
manuale
Garanzia 12 mesi
Peugeot 208
Active Bluehdi 75cv 5 Porte
140.488 km
2016
diesel
manuale
Garanzia 12 mesi
Renault Clio
1.5 Dci 90cv Business 5 Porte Berlina
137.480 km
2019
diesel
manuale
Garanzia 12 mesi
Volkswagen Crafter
35 L4h3 2.0 Bitdi 130kw Furgone 4porte
112.912 km
2019
diesel
manuale
Garanzia 12 mesi
Nissan Qashqai
1.3 Dig-t 140 Business
79.314 km
2019
benzina
manuale
Garanzia 12 mesi
Nissan Qashqai
1.5 Dci 110 Business
102.352 km
2018
diesel
manuale
Garanzia 12 mesi
Kia Sportage
1.6 Crdi Mhb 100kw Black Edition Dct 2wd
53.308 km
2021
ibrida
automatico
Garanzia 12 mesi
Land Rover Range Rover Sport
3.0 Tdv6 Hse Dynamic Aut.
94.698 km
2018
diesel
automatico
Garanzia 12 mesi
Mercedes-benz Classe A
A 180 D Automatic Business 5 Porte Berlina
74.531 km
2018
diesel
automatico
Garanzia 12 mesi
Mercedes-benz Classe Gla
Gla 200 D Automatic Business
80.304 km
2018
diesel
automatico
Garanzia 12 mesi
Mitsubishi Asx
1.6 Inform Plus 2wd
87.911 km
2018
benzina
manuale
Garanzia 12 mesi
Nissan Qashqai
1.6 Dci 130 4wd N-connecta
118.774 km
2017
diesel
manuale
Garanzia 12 mesi
Citroen C3
Bluehdi 75 Shine 5 Porte
104.525 km
2017
diesel
manuale
Garanzia 12 mesi