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
1213 auto usate
Filtra Auto
Toyota Corolla
Ts Hybrid Business Wagon
134.261 km
2021
automatico
ibrida
Euro 6
Garanzia 12 mesi
Toyota Yaris Cross
1.5h 92cv E-cvt Business
98.335 km
2022
automatico
ibrida
Euro 6
Garanzia 12 mesi
Toyota Yaris Cross
1.5h 92cv E-cvt Lounge
10.506 km
2024
automatico
ibrida
Euro 6
Garanzia 12 mesi
Seat Leon
2.0 Tdi 110kw Fr Dsg 5 Porte
118.152 km
2022
automatico
diesel
Euro 6
Garanzia 12 mesi
Renault Captur
1.5 Dci Blue 70kw Business
120.173 km
2021
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Clio
1.5 Dci Blue 63kw Business 5 Porte
111.529 km
2019
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Clio
1.5 Dci Blue 74kw Evolution 5 Porte
34.288 km
2023
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Kadjar
1.5 Blue Dci Business Edc
98.200 km
2021
automatico
diesel
Euro 6
Garanzia 12 mesi
Renault Kangoo
Express 1.5 Blue Dci 95 Ice Furgone 4 Porte
115.254 km
2020
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Megane
Sporter 1.5 Dci 85kw Blue Business Edc Wagon
134.555 km
2021
automatico
diesel
Euro 6
Garanzia 12 mesi
Seat Ibiza
1.0 Tgi 66kw Style 5 Porte
64.859 km
2020
manuale
metano
Euro 6
Garanzia 12 mesi
Peugeot 3008
Bluehdi 130 Eat8 S&s Allure Autocarro
122.429 km
2021
automatico
diesel
Euro 6
Garanzia 12 mesi
Peugeot 308
Allure Bluehdi 130 S&s 5 Porte
76.509 km
2022
manuale
diesel
Euro 6
Garanzia 12 mesi
Peugeot 308
Wagon Allure Bluehdi 130 Eat8 S&s Aut.
127.802 km
2022
automatico
diesel
Euro 6
Garanzia 12 mesi
Peugeot 5008
Bluehdi 180 Allure Eat8 S/s Aut.
109.418 km
2021
automatico
diesel
Euro 6
Garanzia 12 mesi
Peugeot Expert
2.0 Bluehdi 120 Premium Standard Furgone 4 Porte
139.567 km
2021
manuale
diesel
Euro 6
Garanzia 12 mesi
Peugeot Partner
L1 Bluehdi 100cv Premium Furgone 4 Porte
116.022 km
2018
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Captur
1.5 Dci Blue 70kw Business
57.145 km
2021
manuale
diesel
Euro 6
Garanzia 12 mesi
Renault Captur
1.5 Dci Blue 70kw Business
116.322 km
2021
manuale
diesel
Euro 6
Garanzia 12 mesi
Mercedes-benz Classe Gla
Gla 200 D Automatic Sport Plus
43.703 km
2023
automatico
diesel
Euro 6
Garanzia 12 mesi
Mercedes-benz Classe Glb
Glb 200 Automatic Business Extra
79.928 km
2021
automatico
benzina
Euro 6
Garanzia 12 mesi
Mercedes-benz Classe Glc
Glc 200 D 4matic Premium Plus Aut.
114.523 km
2022
automatico
diesel
Euro 6
Garanzia 12 mesi
Mercedes-benz Classe Glc
Glc 300 D 4matic Premium Aut. Coupe
104.341 km
2022
automatico
diesel
Euro 6
Garanzia 12 mesi
Mg Ehs
1.5 T Plug-in Hybrid Exclusive Autom.
68.878 km
2022
automatico
ibrida
Euro 6
Garanzia 12 mesi