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
676 auto usate
Filtra Auto
Peugeot 308
Business 1.6 Bluehdi 120cv 5 Porte Berlina
101.056 km
2016
manuale
diesel
Euro 6
Garanzia 12 mesi
Volkswagen Sharan
2.0 Tdi Scr 135kw Executive Bmt Dsg
139.889 km
2018
automatico
diesel
Euro 6
Garanzia 12 mesi
Volvo Xc40
D3 Business
109.407 km
2019
manuale
diesel
Euro 6
Garanzia 12 mesi
Volvo Xc40
D3 Geartronic Business
92.590 km
2019
automatico
diesel
Euro 6
Garanzia 12 mesi
Audi Q3
35 Tdi S Tronic S Line Edition
52.396 km
2019
automatico
diesel
Euro 6
Garanzia 12 mesi
Peugeot 3008
Bluehdi 130 Eat8 S&s Allure
106.688 km
2018
automatico
diesel
Euro 6
Garanzia 12 mesi
Renault Clio
0.9 Tce Energy Zen 5 Porte Berlina
108.282 km
2018
manuale
benzina
Euro 6
Garanzia 12 mesi
Renault Scenic
1.7 Dci 110kw Blue Intens Edc
137.791 km
2019
automatico
diesel
Euro 6
Garanzia 12 mesi
Skoda Kodiaq
2.0 Tdi 110kw Executive Dsg 7p
5.609 km
2023
automatico
diesel
Garanzia 12 mesi
Skoda Octavia
Wagon 2.0 Tdi Executive Dsg
108.484 km
2020
automatico
diesel
Euro 6
Garanzia 12 mesi
Smart Fortwo
Eq 41kw Youngster
44.998 km
2019
automatico
elettrica
Garanzia 12 mesi
Toyota Yaris
1.5 Hybrid Business 5 Porte
45.105 km
2018
automatico
ibrida
Euro 6
Garanzia 12 mesi
Toyota Yaris
1.5 Hybrid Business 5 Porte
67.360 km
2019
automatico
ibrida
Euro 6
Garanzia 12 mesi
Volkswagen Passat Variant
2.0 Tdi 110kw Business Bmt Dsg
81.941 km
2018
automatico
diesel
Euro 6
Garanzia 12 mesi
Peugeot 508
Wagon Bluehdi 130 Active Business Sw S/s Eat8
28.439 km
2021
automatico
diesel
Garanzia 12 mesi
Porsche Cayenne
3.0 V6 E-hybrid Autom. Coupe
52.304 km
2021
automatico
ibrida
Euro 6
Garanzia 12 mesi
Porsche Macan
2.0 Autom.
41.569 km
2020
automatico
benzina
Garanzia 12 mesi
Renault Captur
1.5 Dci 90cv Sport Edition2 Edc
157.212 km
2019
automatico
diesel
Euro 6
Garanzia 12 mesi
Nissan Juke
1.0 Dig-t 117 N-connecta Dct
50.152 km
2020
automatico
benzina
Garanzia 12 mesi
Nissan Juke
1.0 Dig-t 117 N-connecta Mt
17.690 km
2020
manuale
benzina
Euro 6
Garanzia 12 mesi
Nissan Qashqai
1.5 Dci 110 Business
53.547 km
2018
manuale
diesel
Euro 6
Garanzia 12 mesi
Nissan Qashqai
1.5 Dci 115 Business
108.156 km
2019
manuale
diesel
Garanzia 12 mesi
Nissan Qashqai
1.5 Dci 115 Business Dct
90.078 km
2019
automatico
diesel
Euro 6
Garanzia 12 mesi
Opel Astra
Wagon St 1.6 Cdti Business 110cv S&s Mt6
144.261 km
2017
manuale
diesel
Euro 6
Garanzia 12 mesi