Продажа Citroen Grand c4 picasso с аукционов Японии
Найдено
0
автомобилей
select model_id,model_name , time ,images ,lot , mileage ,marka_id, pw , marka_name, year,kpp, eng_v,grade,rate, auction , auction_date, kuzov ,finish ,avg_price, id from main where 'lot' like '%' AND marka_id='16' AND model_id='27502' AND year BETWEEN 1900 AND 2023 ORDER BY auction_date ASC limit 18
CITROEN