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


Lanseta Garbolino Zombie Predator Spin, 10-30g, 2.10m, 2seg

Lanseta Garbolino Zombie Predator Spin, 10-30g, 2.10m, 2seg

20430goprk8035210-2m
Livrare imediată!

126,91Lei

Cap Minciog Garbolino Zombie Carp D55

Cap Minciog Garbolino Zombie Carp D55

50330gomng6506-d55
Livrare imediată!

123,17Lei

Lanseta Garbolino Zombie Predator Spin, 15-50g, 2.40m, 2seg

Lanseta Garbolino Zombie Predator Spin, 15-50g, 2.40m, 2seg

20430goprk8035240-2h
Livrare imediată!

134,32Lei

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.60m, 50-150g, 3seg

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.60m, 50-150g, 3seg

20505gofrl8227360-3
Livrare imediată!

455,89Lei

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.90m, 50-180g, 3seg
Exclusiv online!

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.90m, 50-180g, 3seg

20505gofrl8227390-3
Livrare 48-72 ore

516,92Lei

Lanseta Garbolino Zombie Predator Spin, 5-15g, 1.80m, 2seg

Lanseta Garbolino Zombie Predator Spin, 5-15g, 1.80m, 2seg

20430goprk8035180-2l
Livrare imediată!

109,31Lei

Lanseta Garbolino Zombie Predator Spin, 5-15g, 2.10m, 2seg

Lanseta Garbolino Zombie Predator Spin, 5-15g, 2.10m, 2seg

20430goprk8035210-2l
Livrare imediată!

113,94Lei

Mulineta Garbolino Zombie Feeder Long Cast 6000 FD

Mulineta Garbolino Zombie Feeder Long Cast 6000 FD

30505gofrl7275605fd
Livrare imediată!

381,40Lei

Cutie Naluci pentru Copii Plano Youth Zombie Tackle Box

Cutie Naluci pentru Copii Plano Youth Zombie Tackle Box

pmc500101
Livrare imediată!

89,96Lei

Lanseta Garbolino Zombie Carp Match, 3.60m, 10-50g, 3seg
Exclusiv online!

Lanseta Garbolino Zombie Carp Match, 3.60m, 10-50g, 3seg

20605gofrg8223360-3xp
Livrare 48-72 ore

336,92Lei

Atractant Lichid BENZAR MIX Catfish Spray, Zombie Fish, 50ml
Exclusiv online!

Atractant Lichid BENZAR MIX Catfish Spray, Zombie Fish, 50ml

93740055
Livrare 24-48 ore

28,00Lei

Naluca Black Cat Curly 17cm culoare Yellow Zombie
Exclusiv online!

Naluca Black Cat Curly 17cm culoare Yellow Zombie

3540001
Livrare 7-14 zile

22,28Lei

Naluca Black Cat Shad Worm Yellow Zombie 17cm 25g
Exclusiv online!

Naluca Black Cat Shad Worm Yellow Zombie 17cm 25g

3541001
Livrare 7-14 zile

22,28Lei

Creatura Black Cat Calamar U-float, Yellow Zombie, 20g -15%

Creatura Black Cat Calamar U-float, Yellow Zombie, 20g

5550002
Livrare imediată!

49,69Lei(-15%) 42,40Lei

Pelete, Benzar, Mix, Catfish,, Zombie, Fish,, 30mm,, 400g, 98054556, Pelete de Carlig, Pelete de Carlig Benzar Mix, Pelete Benzar Mix, Carlig Benzar Mix, Benzar Mix
Suport Lansete Garbolino Kit Zombie 8 Pozitii, 60cm

Suport Lansete Garbolino Kit Zombie 8 Pozitii, 60cm

42405gomeh3210-8b
Stoc epuizat

233,03Lei

Lanseta Delphin ZOMBIE 3.00m, 65g, 2seg

Lanseta Delphin ZOMBIE 3.00m, 65g, 2seg

101003155
Stoc epuizat

198,60Lei

Lanseta Delphin ZOMBIE 3.60m, 80g, 2seg

Lanseta Delphin ZOMBIE 3.60m, 80g, 2seg

101003156
Stoc epuizat

209,20Lei

Boilies Radical Method Marbles Yellow Zombie 9mm 75g

Boilies Radical Method Marbles Yellow Zombie 9mm 75g

9013962104
Stoc epuizat

31,12Lei

Dip Radical Yellow Zombie Dip 150ml

Dip Radical Yellow Zombie Dip 150ml

9053950010
Stoc epuizat

36,19Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 13, Total time: 239.127 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'a4a0b466c7dcdb208c0733001e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (237.341)
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 = '2' AND (pd.tag LIKE "%zombie%") 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:697
5 (0.150)
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:1547
6 (0.321)
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 ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.179)
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:1204
8 (0.086)
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:1223
9 (0.067)
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:982
10 (0.444)
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:904
11 (0.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.089)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.084)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38