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 24, 24
Tesla Model 3 75 Kwh Long Range Dual Motor Awd 4 Porte Berlina
46.269 km 2021 automatico elettrica Garanzia 12 mesi
34.950 iva inclusa
Toyota C-hr 1.8h 98cv E-cvt Business
70.563 km 2019 automatico ibrida Euro 6 Garanzia 12 mesi
18.000 iva inclusa
Renault Megane Sporter 1.5 Dci 85kw Blue Business Wagon
127.940 km 2021 manuale diesel Garanzia 12 mesi
13.150 iva inclusa
Seat Ateca 1.6 Tdi Business
112.084 km 2020 manuale diesel Euro 6 Garanzia 12 mesi
16.200 iva inclusa
Seat Ibiza 1.4 Tdi Cr 66kw Business High 5 Porte Berlina
127.264 km 2017 manuale diesel Euro 6 Garanzia 12 mesi
8.550 iva inclusa
Renault Kadjar 1.5 Energy Dci 110cv Business Edc
99.703 km 2019 automatico diesel Euro 6 Garanzia 12 mesi
15.000 iva inclusa
Renault Kadjar 1.5 Dci 85kw Blue Business
72.938 km 2019 manuale diesel Euro 6 Garanzia 12 mesi
16.200 iva inclusa
Renault Kadjar 1.5 Dci 85kw Blue Sport Edition 2 Edc
158.668 km 2020 automatico diesel Euro 6 Garanzia 12 mesi
18.000 iva inclusa
Renault Megane Sporter 1.5 Dci 70kw Blue Business Wagon
66.755 km 2019 manuale diesel Euro 6 Garanzia 12 mesi
11.950 iva inclusa
Renault Megane Sporter 1.5 Dci 85kw Blue Intens Wagon
141.743 km 2019 manuale diesel Euro 6 Garanzia 12 mesi
11.650 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Business
93.865 km 2020 automatico diesel Garanzia 12 mesi
18.950 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Business
117.301 km 2020 automatico diesel Garanzia 12 mesi
17.850 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Business
102.330 km 2020 automatico diesel Garanzia 12 mesi
18.650 iva inclusa
Peugeot 3008 Bluehdi 130 S&s Business
98.884 km 2020 manuale diesel Garanzia 12 mesi
17.650 iva inclusa
Peugeot 5008 Bluehdi 130 Allure S/s
59.926 km 2020 manuale diesel Garanzia 12 mesi
21.950 iva inclusa
Renault Captur 1.5 Dci Blue 70kw Business
83.075 km 2020 manuale diesel Euro 6 Garanzia 12 mesi
16.500 iva inclusa
Renault Clio 1.5 Dci 75cv Energy Zen 5 Porte Berlina
91.809 km 2017 manuale diesel Euro 6 Garanzia 12 mesi
9.850 iva inclusa
Renault Espace 2.0 Dci 118kw Blue Executive Edc
103.169 km 2019 automatico diesel Euro 6 Garanzia 12 mesi
21.000 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Allure
104.461 km 2019 automatico diesel Garanzia 12 mesi
18.500 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Allure
139.132 km 2020 automatico diesel Garanzia 12 mesi
18.500 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Business
48.616 km 2020 automatico diesel Garanzia 12 mesi
20.550 iva inclusa
Peugeot 3008 Bluehdi 130 Eat8 S&s Allure
131.669 km 2019 automatico diesel Euro 6 Garanzia 12 mesi
17.450 iva inclusa
Nissan Leaf Business 40kwh 5 Porte Berlina
11.084 km 2020 automatico elettrica Garanzia 12 mesi
14.900 iva inclusa
Nissan Micra Igt 92 Acenta 5 Porte
23.388 km 2021 manuale benzina Garanzia 12 mesi
13.900 iva inclusa