Продажа Mercedes benz 190 series с аукционов Японии
Найдено
1
автомобиль
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='24' AND model_id='20597' AND year BETWEEN 1900 AND 2023 ORDER BY auction_date ASC limit 18
MERCEDES BENZ