select i.id,i.name_en as name,i.code,i.brand,i.price,(i.cnt-i.cnto) as cnt,i.ims, i.imgdir_suffix,i.img_suffix,i.status,i.priceVis,ip.prNew,ip.prSale,ip.prAction,ip.prRcmnd,ip.prDscnt,ip.prPrepare,ip.prUsed,ip.prDamaged, i.eprice as price_eur, case when subQ.id is null then 0 else 1 end as regionAvail from kav_news_items ni join kav_items i on (ni.iid=i.id and ni.nid=53) join kav_cat_items ci on (ci.item_id = i.id) join kav_items_params ip on (i.id=ip.iid) left join (select i.id from kav_items i left join (select i.item_id, group_concat(sc.tree_id,'+',sc.parent) as cidd FROM kav_cat_items i join kav_subcat sc on sc.child = i.cat_id group by i.item_id) as cc on cc.item_id = i.id where (i.brand_id in (60))) as subQ on subQ.id = i.id where i.erased=0 and i.vis=1 and i.web=1 group by i.id order by ni.ord,ci.prior DESC,i.id News - KAVANRC.com

27.11.2023

KAVAN GRT-16

New in the KAVAN garage are KAVAN Tracker monster trucks in 1:16 scale for the youngest racers.

They have a simple and robust chassis design. This makes them resistant to impacts and crashes, which are unavoidable in the beginning. The all-wheel drive, deep tread tires and independent wheel suspension reliably tackle any obstacle. The heart is a 390- size DC motor and 850mAh 7.4V 2S LiPo battery. The maximum speed can be conveniently limited directly on the transmitter.

KAVAN GRT-16 Tracker RTR 4WD Monster Truck 1:16 - red

€71.60

KAVAN GRT-16 Tracker RTR 4WD Monster Truck 1:16 - green

€71.60

Information

© 2024, KAVAN Europe s.r.o.