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


Shad Delalande Skeleton 8cm Smelt 40

Shad Delalande Skeleton 8cm Smelt 40

3520519888816
Stoc epuizat

3,50Lei

Shad Delalande Zand Shad 8cm Sky Green 115

Shad Delalande Zand Shad 8cm Sky Green 115

3520519894725
Stoc epuizat

6,50Lei

Shad Lucky John Baby Rockfish, Nagoya Shrimp, 3.5cm, 20buc/plic -13%

Shad Lucky John Baby Rockfish, Nagoya Shrimp, 3.5cm, 20buc/plic

140149-085
Stoc epuizat

19,00Lei(-13%) 16,51Lei

Shad Relax Ohio Standard Blister S056, 12,5cm, 14g, 3buc/plic

Shad Relax Ohio Standard Blister S056, 12,5cm, 14g, 3buc/plic

oh5-s056-b
Stoc epuizat

13,99Lei

Select Crazy Shad 10cm 999

Select Crazy Shad 10cm 999

crazy4.999
Stoc epuizat

12,50Lei

Naluca Select Crazy Shad 10cm 050

Naluca Select Crazy Shad 10cm 050

18703735
Stoc epuizat

12,00Lei

Shad Delalande Chabot 7cm Jungle 88

Shad Delalande Chabot 7cm Jungle 88

5940000601423
Stoc epuizat

6,00Lei

Shad Delalande DJ Line 12cm Jungle 88

Shad Delalande DJ Line 12cm Jungle 88

3520519889257
Stoc epuizat

8,00Lei

Shad Delalande DJ Line 14cm Jungle 88

Shad Delalande DJ Line 14cm Jungle 88

3520519889295
Stoc epuizat

10,50Lei

Shad Delalande DJ Line 14cm White Red Head 61

Shad Delalande DJ Line 14cm White Red Head 61

3520519889288
Stoc epuizat

10,50Lei

Shad Relax Bass Laminat L321, 12.5cm, 3buc/pac

Shad Relax Bass Laminat L321, 12.5cm, 3buc/pac

bas5-l321-b
Stoc epuizat

11,00Lei

Shad Relax Jankes Tail T031, 5cm, 5buc/pac

Shad Relax Jankes Tail T031, 5cm, 5buc/pac

rj2-t031-b
Stoc epuizat

9,00Lei

Shad Relax Ohio Standard Blister S004, 12,5cm, 14g, 3buc/plic

Shad Relax Ohio Standard Blister S004, 12,5cm, 14g, 3buc/plic

oh5-s004-b
Stoc epuizat

13,99Lei

Select Easy Shad 8.9cm 201

Select Easy Shad 8.9cm 201

18702427
Stoc epuizat

12,99Lei

Shad Berkley PowerBait Swimmer Soft, Hot Pink, 7cm, 8buc/plic -75%

Shad Berkley PowerBait Swimmer Soft, Hot Pink, 7cm, 8buc/plic

1524055
Stoc epuizat

47,95Lei(-75%) 11,76Lei

Shad Berkley URBN Shrug Minnow, Brown, 4cm, 8buc/plic -59%

Shad Berkley URBN Shrug Minnow, Brown, 4cm, 8buc/plic

1525638
Stoc epuizat

54,50Lei(-59%) 22,10Lei

Shad Delalande DJ Line 14cm Galactic Blue 153

Shad Delalande DJ Line 14cm Galactic Blue 153

3520519889271
Stoc epuizat

10,50Lei

Shad Delalande Shad GT 11cm Pearl Pink Orange 186

Shad Delalande Shad GT 11cm Pearl Pink Orange 186

3520519870873
Stoc epuizat

5,90Lei

Shad Delalande Skeleton 8cm Mojito 26

Shad Delalande Skeleton 8cm Mojito 26

3520519888809
Stoc epuizat

3,50Lei

Shad Relax Kopyto Floating 5cm, F003, 5 buc/plic

Shad Relax Kopyto Floating 5cm, F003, 5 buc/plic

bls2-f003-b
Stoc epuizat

9,00Lei

Afişare 2721 - 2740 din 2812 (141 pagini)
Queries: 11, Total time: 527.745 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'e43d6984364ee2c747aad316dc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (513.269)
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 (pd.tag LIKE "%shad-uri%l%") 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 (13.325)
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 2720, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.149)
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
6 (0.123)
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.129)
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.123)
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
9 (0.127)
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
10 (0.133)
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
11 (0.127)
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