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
774 auto usate Filtra Auto
Volvo V40 Cross Country D2 Geartronic Cross Country Business 5 Porte Berlina
89.962 km 2018 diesel automatico Garanzia 12 mesi
18.200 iva inclusa
Volkswagen Tiguan 2.0 Tdi Scr 110kw Business Bmt Dsg
122.990 km 2017 diesel automatico Garanzia 12 mesi
22.250 iva inclusa
Volvo V40 D2 Kinetic 5 Porte Berlina
54.531 km 2018 diesel manuale Garanzia 12 mesi
16.250 iva inclusa
Toyota C-hr 1.8h 98cv E-cvt Business
91.532 km 2019 ibrida automatico Garanzia 12 mesi
20.000 iva inclusa
Toyota Yaris 1.5 Hybrid Active Autom. 5 Porte Berlina
78.193 km 2015 ibrida automatico Garanzia 12 mesi
12.100 iva inclusa
Toyota Yaris 1.5 Hybrid Business Autom. 5 Porte Berlina
65.449 km 2019 ibrida automatico Garanzia 12 mesi
16.450 iva inclusa
Volkswagen Golf Vii 1.6 Tdi Business 4 Free Bmt 5 Porte Berlina
136.448 km 2016 diesel manuale Garanzia 12 mesi
13.900 iva inclusa
Volkswagen Golf Vii 1.6 Tdi Business Bmt Dsg 5 Porte Berlina
144.463 km 2017 diesel automatico Garanzia 12 mesi
15.450 iva inclusa
Volkswagen Golf Vii 1.6 Tdi Highline Bmt 5 Porte Berlina
150.445 km 2017 diesel manuale Garanzia 12 mesi
15.000 iva inclusa
Volkswagen Golf Variant Vii 1.6 Tdi Business Bmt
122.341 km 2019 diesel manuale Garanzia 12 mesi
14.600 iva inclusa
Volkswagen Passat Variant 1.6 Tdi 88kw Business Bmt
135.199 km 2017 diesel manuale Garanzia 12 mesi
16.750 iva inclusa
Volkswagen Passat Variant 1.6 Tdi 88kw Business Bmt
99.350 km 2017 diesel manuale Garanzia 12 mesi
17.000 iva inclusa
Volkswagen Tiguan 2.0 Tdi 110kw Business Bmt 4motion
84.066 km 2016 diesel manuale Garanzia 12 mesi
22.250 iva inclusa
Volkswagen Tiguan 2.0 Tdi Scr 110kw Business Bmt 4motion
82.077 km 2017 diesel manuale Garanzia 12 mesi
23.400 iva inclusa
Renault Clio 1.5 Dci 75cv Wave N1 Fase 2 Autocarro
141.221 km 2015 diesel manuale Garanzia 12 mesi
6.000 iva inclusa
Renault Clio 0.9 Tce 90cv Gpl Business (autocarro) 5 Porte
157.727 km 2019 gpl manuale Garanzia 12 mesi
10.000 iva inclusa
Renault Clio 0.9 Tce 90cv Gpl Business 5 Porte Berlina
65.449 km 2019 gpl manuale Garanzia 12 mesi
13.850 iva inclusa
Renault Kadjar 1.5 Energy Dci 110cv Business Edc
60.156 km 2018 diesel automatico Garanzia 12 mesi
19.300 iva inclusa
Renault Scenic 1.5 Dci 110cv Energy Intens
135.915 km 2017 diesel manuale Garanzia 12 mesi
15.650 iva inclusa
Peugeot 3008 Bluehdi 120 Eat6 S&s Business
152.338 km 2017 diesel automatico Garanzia 12 mesi
19.100 iva inclusa
Peugeot 3008 Bluehdi 120 S&s Business
82.730 km 2017 diesel manuale Garanzia 12 mesi
20.850 iva inclusa
Peugeot 3008 Bluehdi 120 S&s Business Bc
157.356 km 2017 diesel manuale Garanzia 12 mesi
18.200 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Gt Line
56.457 km 2019 diesel automatico Garanzia 12 mesi
29.100 iva inclusa
Peugeot 3008 Bluehdi 130 S&s Allure
142.502 km 2019 diesel manuale Garanzia 12 mesi
22.950 iva inclusa