select model_id,model_name , time
,images ,lot , mileage ,marka_id, pw , marka_name, year,
kpp, eng_v,grade,rate, auction , auction_date, kuzov ,start, finish
,avg_price, id from korea where 'id' like '%' AND marka_id='241' AND model_id='38937' AND finish >= 1 AND year BETWEEN 1900 AND 2023 ORDER BY lot DESC limit 18
Цена в России
1 860 139 ₽
Оставить заявку
Цена в России
1 924 839 ₽
Оставить заявку
