Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Lanterna Coleman Cu Led Divide Plus 75

Lanterna Coleman Cu Led Divide Plus 75

2000024455
Livrare imediată!

97,00Lei

Lanterna Coleman Cu Led Divide Plus 200
Exclusiv online!

Lanterna Coleman Cu Led Divide Plus 200

2000024454
Livrare 24-48 ore

115,00Lei

Lanterna Led Camor Cu Carabina
Exclusiv online!

Lanterna Led Camor Cu Carabina

74990118
Livrare 24-48 ore

18,50Lei

Lanterna Fenix Model Ld02 V2.0
Exclusiv online!

Lanterna Fenix Model Ld02 V2.0

adv-381
Livrare 48-72 ore

150,00Lei

Lanterna Led Lenser P5r Core 500lm/li-ion + Cablu Usb
Exclusiv online!

Lanterna Led Lenser P5r Core 500lm/li-ion + Cablu Usb

a8.z502178
Livrare 24-48 ore

344,90Lei

Lanterna Led Lenser P4r Core 200lm Li-ion +cablu Usb
Exclusiv online!

Lanterna Led Lenser P4r Core 200lm Li-ion +cablu Usb

a8.z502177
Livrare 24-48 ore

209,04Lei

Lanterna Led Lenser P6r Core 900lm/li-ion + Cablu Usb
Exclusiv online!

Lanterna Led Lenser P6r Core 900lm/li-ion + Cablu Usb

a8.z502179
Livrare 24-48 ore

431,59Lei

Lanterna Carp Expert De Mana Neo Incarcare Usb
Exclusiv online!

Lanterna Carp Expert De Mana Neo Incarcare Usb

74956550
Livrare 24-48 ore

53,00Lei

Lanterna Led Lenser P2r Core
Exclusiv online!

Lanterna Led Lenser P2r Core

a8.z502176
Livrare 24-48 ore

143,70Lei

Lanterna Led Lenser Iw7r Black 600lm Plus Incarcator
Exclusiv online!

Lanterna Led Lenser Iw7r Black 600lm Plus Incarcator

a8.z502005
Livrare 24-48 ore

528,12Lei

Lanterna Neo Style Uv Light 12 Led Red
Exclusiv online!

Lanterna Neo Style Uv Light 12 Led Red

ns812119
Livrare 48-72 ore

102,99Lei

Lanterna Cu Led Nebo Davinci , 2000 Lm, Ipx7, 2000 Mah Li-ion, Magnet, Aluminiu

Lanterna Cu Led Nebo Davinci , 2000 Lm, Ipx7, 2000 Mah Li-ion, Magnet, Aluminiu

neb-flt-0020-g
Livrare imediată!

279,88Lei

Lanterna Nitecore Headlamp Hc35 (1x21700 Accessory) 4xcree Xp-g3 S3 (2700 Lumeni)

Lanterna Nitecore Headlamp Hc35 (1x21700 Accessory) 4xcree Xp-g3 S3 (2700 Lumeni)

hc35
Livrare imediată!

544,29Lei

Lanterna Duracell Worklight Dw500se (+3aa) Ipx4 (500 Lumen)

Lanterna Duracell Worklight Dw500se (+3aa) Ipx4 (500 Lumen)

8616-dw500se
Livrare imediată!

87,91Lei

Lanterna Cu Led Nebo Franklin Pivot, 300 Lm, Ipx4, 2000mah Li-ion, Magnet, Aluminiu

Lanterna Cu Led Nebo Franklin Pivot, 300 Lm, Ipx4, 2000mah Li-ion, Magnet, Aluminiu

neb-wlt-0023-g
Livrare imediată!

139,94Lei

Lanterna Cu Led Nebo Newton, 1000 Lm, Ipx7, 4x6v Aa Alkaline, Magnet, Aluminiu

Lanterna Cu Led Nebo Newton, 1000 Lm, Ipx7, 4x6v Aa Alkaline, Magnet, Aluminiu

neb-flt-0016-g
Livrare imediată!

159,92Lei

Lanterna Cu Led Nebo Davinci , 3500 Lm, Ip67, 4500 Mah Li-ion, Magnet, Aluminiu

Lanterna Cu Led Nebo Davinci , 3500 Lm, Ip67, 4500 Mah Li-ion, Magnet, Aluminiu

neb-flt-0021-g
Livrare imediată!

359,84Lei

Lanterna Led Nebo Columbo Keychain, 100 Lm, Aaa Alkaline, Aluminiu

Lanterna Led Nebo Columbo Keychain, 100 Lm, Aaa Alkaline, Aluminiu

neb-poc-1003-g
Livrare imediată!

39,90Lei

Lanterna Nebo Torchy 2k Rechargeable, 2000 Lm, Li-ion 18650 2200 Mah, Aluminiu

Lanterna Nebo Torchy 2k Rechargeable, 2000 Lm, Li-ion 18650 2200 Mah, Aluminiu

neb-flt-1006-g
Livrare imediată!

179,90Lei

Lanterna Nebo Slim Mini Rechargeable, 250 Lm, Li-ion 602040 450mah 3.7v, Magnet, Aluminiu

Lanterna Nebo Slim Mini Rechargeable, 250 Lm, Li-ion 602040 450mah 3.7v, Magnet, Aluminiu

neb-flt-1042-g
Livrare imediată!

122,90Lei

Afişare 41 - 60 din 91 (5 pagini)

Descoperă gama noastră de lanterne de mână, ideale pentru pescuit, camping, drumeții și activități outdoor.
Lanternele LED reîncărcabile oferă iluminare puternică și autonomie extinsă pentru utilizare prelungită.
Modelele impermeabile și rezistente la șocuri sunt perfecte pentru condiții dificile de teren.
Alege lanterne de mână cu zoom reglabil pentru o focalizare precisă a fasciculului luminos.
Lanternele portabile compacte sunt ușor de transportat și depozitat în orice bagaj.
Produsele cu acumulator de mare capacitate asigură funcționare continuă fără întreruperi.
Lanternele tactice și ultra-luminoase sunt potrivite pentru vânătoare și utilizare profesională.
Modelele multifuncționale includ moduri de iluminare variate pentru orice nevoie.
Toate produsele sunt testate pentru fiabilitate și durabilitate în condiții extreme.
Alege lanterne de mână de calitate pentru o vizibilitate excelentă în orice mediu!

Queries: 15, Total time: 11.398 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '44c2640f64f1298aa4b5525ca8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lanterne-si-felinare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.419)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '156' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (3.364)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '156' AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:857
6 (0.155)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
7 (0.618)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name DESC LIMIT 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (4.633)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
9 (0.220)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
10 (0.079)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
11 (0.083)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
12 (1.201)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
13 (0.145)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"156"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
14 (0.123)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"156"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
15 (0.095)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37