Продажа Mitsubishi Fuso canter guts с аукционов Японии
Найдено
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='4' AND model_id='27264' AND year BETWEEN 1900 AND 2023 ORDER BY auction_date ASC limit 18
MITSUBISHI