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 300 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

Căutare

Produse ce potrivesc criteriilor de căutare


AVERTIZOR SPRO C-TEC XF BLUE LED

AVERTIZOR SPRO C-TEC XF BLUE LED

004706-00001-00000
Livrare imediată!

55,00Lei

SET KORDA MONTURI LEDCORE+RING 3BUC/PL GRAVEL
Exclusiv online!

SET KORDA MONTURI LEDCORE+RING 3BUC/PL GRAVEL

a.llrsg
Livrare 24-48 ore

37,13Lei

LANTERNA SPRO CU LED TIP LAMPA 150 LUMENI 3W CREE LED
Exclusiv online!

LANTERNA SPRO CU LED TIP LAMPA 150 LUMENI 3W CREE LED

004708-00500-00000
Livrare 48-72 ore

137,60Lei

KIT PRINDERE LANT. SEO PE CASCA LED LENSER
Exclusiv online!

KIT PRINDERE LANT. SEO PE CASCA LED LENSER

a8.z0368
Livrare 24-48 ore

48,50Lei

Pelete Dynamite Baits Krill Drilled Hook 8mm

Pelete Dynamite Baits Krill Drilled Hook 8mm

dy960
Livrare imediată!

35,00Lei

LAMPA JAXON CORT LED 3W 110/60LM
Exclusiv online!

LAMPA JAXON CORT LED 3W 110/60LM

aj-lar112
Livrare 48-72 ore

76,01Lei

Suport Matrix 3D-R Angled Rod Holder pentru Scaun Modular

Suport Matrix 3D-R Angled Rod Holder pentru Scaun Modular

gba016
Livrare imediată!

76,46Lei

LANTERNA LED LENSER K2L LIGHTRING 25LM/4XAG13

LANTERNA LED LENSER K2L LIGHTRING 25LM/4XAG13

a8.z8202.l
Livrare imediată!

45,28Lei

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

dy147
Livrare imediată!

25,00Lei

Pelete Dynamite Baits The Source Pellets 14mm Pre -Drilled 350Gr

Pelete Dynamite Baits The Source Pellets 14mm Pre -Drilled 350Gr

dy148
Livrare imediată!

25,00Lei

Acumulator Led Lenser Lithium-ion Battery 3000mAh

Acumulator Led Lenser Lithium-ion Battery 3000mAh

a8.z501001
Livrare imediată!

125,37Lei

Lanterna Frontala Led Lenser H19R Core Reincarcabila 3500 Lumeni 200 Metri

Lanterna Frontala Led Lenser H19R Core Reincarcabila 3500 Lumeni 200 Metri

a8.z502124
Livrare imediată!

1.142,26Lei

Lanterna Cap Led Lenser MH10 + USB + Husa + 2 Filtre, 600 Lumeni

Lanterna Cap Led Lenser MH10 + USB + Husa + 2 Filtre, 600 Lumeni

a8.z501513
Livrare imediată!

477,92Lei

CANTAR DIGITAL ENERGO TEAM CU LAMPA LED -20%
Exclusiv online!

CANTAR DIGITAL ENERGO TEAM CU LAMPA LED

80214400
Livrare 24-48 ore

85,00Lei(-20%) 68,00Lei

LANTERNA CAP LED LENSER MH11 BLACK BLUETOTH 1000LM CU ACUMULATOR SI USB

LANTERNA CAP LED LENSER MH11 BLACK BLUETOTH 1000LM CU ACUMULATOR SI USB

a8.z500996
Livrare imediată!

840,04Lei

LANTERNA JAXON CAP 14 LED

LANTERNA JAXON CAP 14 LED

aj-lar029
Livrare imediată!

36,00Lei

LANTERNA LED LENSER MT14 1000LM ACUMULATOR USB HUSA
Exclusiv online!

LANTERNA LED LENSER MT14 1000LM ACUMULATOR USB HUSA

a8.z500844
Livrare 24-48 ore

608,34Lei

Lanterna Cap Energo Team Outdoor Venus Led 2000lm 2 acumulatori 18650
Exclusiv online!

Lanterna Cap Energo Team Outdoor Venus Led 2000lm 2 acumulatori 18650

74957012
Livrare 24-48 ore

103,99Lei

LANTERNA, JAXON, CAP, CREE, LED, 3W, 109, aj-lar109, Lanterne De Cap, Lanterne De Cap Jaxon, Jaxon
Exclusiv online!

LANTERNA, JAXON, CAP, CREE, LED, 3W, 109, aj-lar109, Lanterne De Cap, Lanterne De Cap Jaxon, Jaxon

aj-lar109
Livrare 48-72 ore

99,00Lei

SWINGER CARP HUNTER LED VERDE
Exclusiv online!

SWINGER CARP HUNTER LED VERDE

77090334
Livrare 24-48 ore

19,50Lei

Afişare 81 - 100 din 351 (18 pagini)
Queries: 7, Total time: 246.616 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '51f90bd8a3c19b382afd68c7fa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (246.052)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY 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_description` AS pd ON (pd.product_id = p.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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%led%") 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:698
5 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.072)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.079)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38