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

Căutare

Produse ce potrivesc criteriilor de căutare


Vobler Berkley Berkley J-Walker 120, 12cm, 19gr, Culoare Chrome -63%
Exclusiv online!

Vobler Berkley Berkley J-Walker 120, 12cm, 19gr, Culoare Chrome

1487122
Livrare 48-72ore

48,79Lei(-63%) 17,85Lei

Vobler Colmic Herakles WT-Dog 85 8.5cm 9.5g Blue Fish
Exclusiv online!

Vobler Colmic Herakles WT-Dog 85 8.5cm 9.5g Blue Fish

arwtd8508
Livrare 48-72 ore

51,00Lei

Vobler Cormoran Cor F15 Green Pellet, 3.7cm, 4.5g, 1buc/pac
Exclusiv online!

Vobler Cormoran Cor F15 Green Pellet, 3.7cm, 4.5g, 1buc/pac

f3.53.04431
Livrare 24-48 ore

26,63Lei

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.6g
Exclusiv online!

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.6g

f3.d17510.202
Livrare 24-48 ore

74,08Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g
Exclusiv online!

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g

f.d.17511.000
Livrare 24-48 ore

76,93Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Natural Ghost Shad, 12.7g
Exclusiv online!

Vobler Daiwa Steez Prop 85F 8.5cm, Natural Ghost Shad, 12.7g

f.d.17511.003
Livrare 24-48 ore

76,93Lei

Vobler DUO Realis Fang POP 10.5cm 24.5g AQA3613 Juliana Pink F
Exclusiv online!

Vobler DUO Realis Fang POP 10.5cm 24.5g AQA3613 Juliana Pink F

duo94140
Livrare 48-72 ore

92,00Lei

VOBLER JAXON ATRACT BLEACK F, CULOARE D, 8CM, 7G
Exclusiv online!

VOBLER JAXON ATRACT BLEACK F, CULOARE D, 8CM, 7G

vr-xhn080d
Livrare 48-72 ore

19,00Lei

VOBLER JAXON ATRACT BLEACK F, CULOARE J, 8CM, 7G
Exclusiv online!

VOBLER JAXON ATRACT BLEACK F, CULOARE J, 8CM, 7G

vr-xhn080j
Livrare 48-72 ore

19,00Lei

Vobler Kenart Hunter Floating 3cm 2.5gr NPB Natural Perch Brown 1 buc/pac
Exclusiv online!

Vobler Kenart Hunter Floating 3cm 2.5gr NPB Natural Perch Brown 1 buc/pac

hu3f-npb
Livrare 48-72ore

21,50Lei

Vobler Lucky John Chubby 4F 017 4cm 4g
Exclusiv online!

Vobler Lucky John Chubby 4F 017 4cm 4g

ljo2004f-017
Livrare 48-72ore

21,00Lei

Vobler Popper Mikado Fh Shutoku, Floating, A05, 7cm
Exclusiv online!

Vobler Popper Mikado Fh Shutoku, Floating, A05, 7cm

pwf-shu-7f-a05
Livrare 48-72 ore

29,00Lei

Vobler Popper Mikado Fh Shutoku, Floating, S119, 7cm
Exclusiv online!

Vobler Popper Mikado Fh Shutoku, Floating, S119, 7cm

pwf-shu-7f-119
Livrare 48-72 ore

29,00Lei

Vobler Sakura Notobug 22F, DR Albastru, 1.4g, 2.2cm

Vobler Sakura Notobug 22F, DR Albastru, 1.4g, 2.2cm

80234saplb503922dr
Livrare imediată!

43,99Lei

Vobler Sakura Notobug 30F, BLB Rosu, 3.5g, 3cm

Vobler Sakura Notobug 30F, BLB Rosu, 3.5g, 3cm

80234saplb503930blb
Livrare imediată!

47,99Lei

Vobler Sakura Pop'N Dog 40F P08 French White 4cm, 3.3g
Exclusiv online!

Vobler Sakura Pop'N Dog 40F P08 French White 4cm, 3.3g

131534sapla500140-p08
Livrare 48-72 ore

57,36Lei

Vobler Salmo Fatso Floating 14F Limited Edition Holo Perch 14cm, 85g

Vobler Salmo Fatso Floating 14F Limited Edition Holo Perch 14cm, 85g

qfa034
Livrare imediată!

107,96Lei

Vobler Salmo Fatso Floating 14F Limited Edition Phantom Perch 14cm, 85g
Exclusiv online!

Vobler Salmo Fatso Floating 14F Limited Edition Phantom Perch 14cm, 85g

qfa077
Livrare 7-14 zile

107,96Lei

Vobler Salmo Minnow 6 Floating Lake Charr 6cm, 4g
Exclusiv online!

Vobler Salmo Minnow 6 Floating Lake Charr 6cm, 4g

qmw197
Livrare 7-14 zile

44,96Lei

Vobler Salmo Tiny Sinking, Holo Stickleback, 3.0cm, 2.5g
Exclusiv online!

Vobler Salmo Tiny Sinking, Holo Stickleback, 3.0cm, 2.5g

qit037
Livrare 7-14 zile

42,71Lei

Afişare 2501 - 2520 din 4263 (214 pagini)
Queries: 8, Total time: 126.456 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = 'e3084d3011a58b1ea045619f36'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (109.321)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+floating' IN BOOLEAN MODE)) 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:737
4 (16.397)
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 2500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.179)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.140)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38