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
547 auto usate Filtra Auto
Volvo Xc40 D3 Geartronic Momentum
43.609 km 2019 diesel automatico Garanzia 12 mesi
33.850 iva inclusa
Mercedes-benz Classe Cla Cla 180 D Automatic Premium 4 Porte Berlina
132.978 km 2018 diesel automatico Garanzia 12 mesi
24.950 iva inclusa
Fiat 500 1.2 69cv Easypower Lounge
84.465 km 2018 gpl manuale Garanzia 12 mesi
11.700 iva inclusa
Volkswagen Polo 1.0 Mpi 48kw Business Trendline Bmt 5 Porte
58.377 km 2018 benzina manuale Garanzia 12 mesi
14.450 iva inclusa
Volkswagen Tiguan 1.6 Tdi Scr 85kw Business Bmt
92.766 km 2018 diesel manuale Garanzia 12 mesi
22.800 iva inclusa
Volkswagen Tiguan 2.0 Tdi Scr 110kw Advanced Bmt 4motion Dsg
122.967 km 2019 diesel automatico Garanzia 12 mesi
35.000 iva inclusa
Volvo Xc40 D3 Business
82.293 km 2019 diesel manuale Garanzia 12 mesi
29.900 iva inclusa
Peugeot 508 Wagon Bluehdi 150cv Business S/s
77.625 km 2016 diesel manuale Garanzia 12 mesi
13.700 iva inclusa
Renault Clio 0.9 Tce 90cv Gpl Business 5 Porte
47.628 km 2019 gpl manuale Garanzia 12 mesi
14.250 iva inclusa
Renault Clio 1.5 Dci 90cv Energy Intens 5 Porte
149.046 km 2017 diesel manuale Garanzia 12 mesi
9.750 iva inclusa
Smart Fortwo 70 1.0 52kw Youngster Twinamic
33.047 km 2018 benzina automatico Garanzia 12 mesi
14.150 iva inclusa
Toyota Auris Wagon Touring Sports Hybrid Business
85.468 km 2018 ibrida automatico Garanzia 12 mesi
17.450 iva inclusa
Opel Astra Wagon St 1.6 Cdti Business 136cv At6
108.264 km 2019 diesel automatico Garanzia 12 mesi
14.450 iva inclusa
Peugeot 208 Mix Bluehdi 75cv 5 Porte Autocarro
137.147 km 2017 diesel manuale Garanzia 12 mesi
9.400 iva inclusa
Peugeot 3008 Bluehdi 120 S&s Allure
129.838 km 2017 diesel manuale Garanzia 12 mesi
19.550 iva inclusa
Peugeot 3008 Bluehdi 130 S&s Allure
97.827 km 2018 diesel manuale Garanzia 12 mesi
22.800 iva inclusa
Mini Cooper Se Countryman All4 Automatica
52.920 km 2019 ibrida automatico Garanzia 12 mesi
31.250 iva inclusa
Nissan Qashqai 1.5 Dci 110 Business
80.261 km 2018 diesel manuale Garanzia 12 mesi
19.650 iva inclusa
Nissan Qashqai 1.5 Dci 110 Business
136.494 km 2018 diesel manuale Garanzia 12 mesi
18.350 iva inclusa
Nissan Qashqai 1.5 Dci 115 Business
135.250 km 2019 diesel manuale Garanzia 12 mesi
18.550 iva inclusa
Hyundai Tucson 2.0 Crdi 4wd A/t 136cv Comfort
123.199 km 2017 diesel automatico Garanzia 12 mesi
21.950 iva inclusa
Jeep Compass 2.0 Mjet 103kw Business 4wd Auto
61.158 km 2018 diesel automatico Garanzia 12 mesi
23.950 iva inclusa
Mercedes-benz Classe C C 220 D 4matic Sport Automatic 4 Porte Berlina
157.969 km 2018 diesel automatico Garanzia 12 mesi
28.450 iva inclusa
Mercedes-benz Classe Cla Cla 180 D Automatic Premium 4 Porte Coupe
117.748 km 2019 diesel automatico Garanzia 12 mesi
37.500 iva inclusa