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 - Clesti Filfishing

Produse ce potrivesc criteriilor de căutare


ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

a.49.53115
Livrare imediată!

5,63Lei

CUTIE ORGANIZATOR GURU PENTRU CARLIGE 15CM

CUTIE ORGANIZATOR GURU PENTRU CARLIGE 15CM

a4.gu.grc03
Livrare imediată!

69,66Lei

Husa Rigida FL 1 Compartiment 115cm

Husa Rigida FL 1 Compartiment 115cm

5752123467530
Livrare imediată!

75,90Lei

HUSA MULINETE TEAM FEEDER BY DOME DLX 40X30X15CM

HUSA MULINETE TEAM FEEDER BY DOME DLX 40X30X15CM

5301-007
Livrare imediată!

118,00Lei

Husa FL Kaki Camouflage 2 Lansete + 2 Mulinete 215cm

Husa FL Kaki Camouflage 2 Lansete + 2 Mulinete 215cm

6752162379022
Livrare imediată!

109,90Lei

DAIWA GEANTA 56cm x 32cm x 15cm
Exclusiv online!

DAIWA GEANTA 56cm x 32cm x 15cm

d.ddb1
Livrare 24-48 ore

666,71Lei

SUPORT MOSTIRO NN ALU STORM CU INFILETARE 67-115cm

SUPORT MOSTIRO NN ALU STORM CU INFILETARE 67-115cm

nn-6656
Livrare imediată!

17,50Lei

Penar Preston Mag Store System 15cm
Exclusiv online!

Penar Preston Mag Store System 15cm

p0220068
Livrare 7-14 zile

76,46Lei

SHAD Quantum 9.15cm 4street B-Ass Shad sunset 7BUC/PLIC -49%

SHAD Quantum 9.15cm 4street B-Ass Shad sunset 7BUC/PLIC

3337013
Livrare imediată!

31,29Lei(-49%) 15,90Lei

Grub Berkley Gulp Alive Sandworm, Bloody, 15cm, 11.20g, 28buc/pac

Grub Berkley Gulp Alive Sandworm, Bloody, 15cm, 11.20g, 28buc/pac

1130351
Livrare imediată!

152,96Lei

Croseta tip Ac Madcat Pellet Needle 15cm

Croseta tip Ac Madcat Pellet Needle 15cm

4153170833
Livrare imediată!

36,45Lei

Naluca Berkley Gulp Sandworm Dark Brown 15cm

Naluca Berkley Gulp Sandworm Dark Brown 15cm

1109382
Livrare imediată!

53,95Lei

PENAR JIGURI SAVAGE GEAR 32X13CM 15CM/20-60G -20%
Exclusiv online!

PENAR JIGURI SAVAGE GEAR 32X13CM 15CM/20-60G

a8.sg.77319
Livrare 24-48 ore

61,42Lei(-20%) 49,12Lei

SHAD Quantum 9.15cm 4street B-Ass Shad green pumpkin chartreuse 7BUC/PLIC -49%

SHAD Quantum 9.15cm 4street B-Ass Shad green pumpkin chartreuse 7BUC/PLIC

3337002
Livrare imediată!

31,29Lei(-49%) 15,90Lei

Shad Berkley Gulp Alive Sandworm Camo 15cm 11.20 gr

Shad Berkley Gulp Alive Sandworm Camo 15cm 11.20 gr

1130352
Livrare imediată!

152,96Lei

SHAD Quantum 9.15cm 4street B-Ass Shad appleseed 7BUC/PLIC -49%

SHAD Quantum 9.15cm 4street B-Ass Shad appleseed 7BUC/PLIC

3337011
Livrare imediată!

31,29Lei(-49%) 15,90Lei

SHAD Quantum 9.15cm 4street B-Ass Shad motor oil 7BUC/PLIC -49%

SHAD Quantum 9.15cm 4street B-Ass Shad motor oil 7BUC/PLIC

3337014
Livrare imediată!

31,29Lei(-49%) 15,90Lei

SHAD Quantum 9.15cm 4street B-Ass Shad firetiger 7BUC/PLIC -25%

SHAD Quantum 9.15cm 4street B-Ass Shad firetiger 7BUC/PLIC

3337008
Livrare imediată!

31,29Lei(-25%) 23,50Lei

GEANTA DAIWA PT. ACCESORII L 38X25X15CM

GEANTA DAIWA PT. ACCESORII L 38X25X15CM

d.dabl
Livrare imediată!

401,71Lei

PICHET AVID CARP 15CM

PICHET AVID CARP 15CM

a0480001
Livrare imediată!

53,95Lei

Afişare 1 - 20 din 606 (31 pagini)
Queries: 8, Total time: 217.156 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '4d666d56c31886028b0f3bf7e6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (213.803)
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 "%15cm%") 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 (2.764)
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:184
6 (0.095)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.077)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.072)
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