SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,`status_extra`,`product_ean`,
`jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`, `jos_vm_category`.list_order AS list_order_0 FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
AND `jos_vm_shopper_group`.`default` = 1
AND `product_parent_id`=0
AND `product_publish`='Y'
AND `category_publish`='Y'
GROUP BY `jos_vm_product`.`product_sku`
ORDER BY list_order_0 ASC, `jos_vm_product_category_xref`.`product_list` LIMIT 0, 2000
Mosazný postřikovač zn. KÄRCHER
Kód zboží:
2.645-054.0
Výrobce:
KÄRCHER
Dostupnost:
skladem
Cena bez DPH:
215 Kč
Cena s DPH 21%:
260 Kč
Zavlažovací systém KÄRCHER
Mosazný postřikovač zn.KÄRCHER
Poloprofesionální robustní mosazný postřikovač.
Komfortní gumová rukojeť pro snadnou manipulaci.
Nástřik nastavitelný od tvrdého po měkký.
Systém klipu vhodný pro všechny známé značky!
Technické údaje:
Objednací číslo: 2.645-054.0
Hmotnost: 0,16 kg
Rozměry (D x Š x V): 140 x 105 x 45 mm
