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 Daiwa Prorex Slim Shady, Golden Shiner, 7.5cm, 3.3g, 4buc/pac
Exclusiv online!

Shad Daiwa Prorex Slim Shady, Golden Shiner, 7.5cm, 3.3g, 4buc/pac

d.15100.101
Livrare 24-48 ore

22,23Lei

Shad Daiwa Prorex Slim Shady, White Ghost, 7.5cm, 3.3g, 4buc/pac
Exclusiv online!

Shad Daiwa Prorex Slim Shady, White Ghost, 7.5cm, 3.3g, 4buc/pac

d.15100.107
Livrare 24-48 ore

23,94Lei

Shad Daiwa Steez Stirring 8.5cm, 8g, Test Color, 7buc/pac
Exclusiv online!

Shad Daiwa Steez Stirring 8.5cm, 8g, Test Color, 7buc/pac

d.17513.301
Livrare 24-48 ore

30,64Lei

Shad Delalande Skeleton 11cm Sky Blue 111

Shad Delalande Skeleton 11cm Sky Blue 111

3520519894275
Livrare imediată!

6,90Lei

Shad Delalande Skeleton 8cm Chartreuse 18

Shad Delalande Skeleton 8cm Chartreuse 18

3520519836114
Livrare imediată!

3,50Lei

Shad Mann's PBBGG, 8cm, 4buc/pac
Exclusiv online!

Shad Mann's PBBGG, 8cm, 4buc/pac

88010365
Livrare 24-48 ore

12,85Lei

Shad Relax Bass Laminat L230, 12.5cm, 3buc/pac
Exclusiv online!

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

bas5-l230-b
Livrare 48-72ore

11,00Lei

Shad Relax Bass Laminat L234, 12.5cm, 3buc/pac
Exclusiv online!

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

bas5-l234-b
Livrare 48-72ore

11,00Lei

Shad Relax Bass Laminat L523, 12.5cm, 3buc/pac
Exclusiv online!

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

bas5-l523-b
Livrare 48-72ore

11,00Lei

Shad Relax Jankes Tail T065, 5cm, 5buc/pac
Exclusiv online!

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

rj2-t065-b
Livrare 48-72ore

9,00Lei

Shad Relax King Shad Laminat Blister L220 10cm 4 buc/plic

Shad Relax King Shad Laminat Blister L220 10cm 4 buc/plic

ks4-l220-b
Livrare imediată!

11,00Lei

Shad Relax Kopyto Standard Blister, S049, 0.7g, 3cm, 8buc/plic
Exclusiv online!

Shad Relax Kopyto Standard Blister, S049, 0.7g, 3cm, 8buc/plic

bls1-s049-b
Livrare 48-72ore

9,00Lei

Shad Relax Ohio 2.5 inch Standard, 7.5cm S041 10 buc/plic

Shad Relax Ohio 2.5 inch Standard, 7.5cm S041 10 buc/plic

oh25-s041
Livrare imediată!

24,00Lei

Shad Relax Ohio Standard S037 10.5cm, 10buc/plic

Shad Relax Ohio Standard S037 10.5cm, 10buc/plic

oh4-s037
Livrare imediată!

22,00Lei

Shad Sakura Slit Evo, Ayu 048, 8.5cm, 6buc
Exclusiv online!

Shad Sakura Slit Evo, Ayu 048, 8.5cm, 6buc

130134saple501085-048
Livrare 48-72 ore

26,91Lei

Shad Sakura Slit Evo, Fire Chart 059, 10cm, 5buc
Exclusiv online!

Shad Sakura Slit Evo, Fire Chart 059, 10cm, 5buc

130134saple5010100-059
Livrare 48-72 ore

27,82Lei

Shad Sakura Slit Evo, Glow White 006, 10cm, 5buc
Exclusiv online!

Shad Sakura Slit Evo, Glow White 006, 10cm, 5buc

130134saple5010100-006
Livrare 48-72 ore

27,82Lei

Shad Spro Super Natural Bait Fish 10cm, 10g, 4buc

Shad Spro Super Natural Bait Fish 10cm, 10g, 4buc

004859-00128-00000
Livrare imediată!

18,30Lei

Shad Spro Super Natural Bait Fish 8cm, 6.5g, 4buc

Shad Spro Super Natural Bait Fish 8cm, 6.5g, 4buc

004859-00127-00000
Livrare imediată!

14,20Lei

Jackson Quick Head GOL, 14g
Exclusiv online!

Jackson Quick Head GOL, 14g

jks-qh14-gol
Livrare 48-72ore

42,00Lei

Afişare 4121 - 4140 din 7348 (368 pagini)
Queries: 11, Total time: 622.822 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '20f2612f7988456001fbfb4baa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (594.172)
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 = '2' AND (pd.tag LIKE "%shad-uri%") 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 (27.735)
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 4120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.163)
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.098)
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.092)
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.089)
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.074)
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.080)
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.076)
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