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


Grub Single Tail Owner RB-3 15 Pearl Blue Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 15 Pearl Blue Ring Single Tail 82914 3.8cm

8291415
Livrare imediată!

15,29Lei

Rig Crap Owner 56996 Nr.4 25Lb Combi Rig
Exclusiv online!

Rig Crap Owner 56996 Nr.4 25Lb Combi Rig

5699604
Livrare 48-72 ore

20,15Lei

Carlig Owner Iseama 50057 Nr 12
Exclusiv online!

Carlig Owner Iseama 50057 Nr 12

5005715
Livrare 48-72 ore

10,40Lei

Jig, Jaxon, cu, carlig, Owner, Big, Game, carlig, nr, 7/0, 12GR, 3/PLIC, gj-og7/012bc, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon -22%

Jig, Jaxon, cu, carlig, Owner, Big, Game, carlig, nr, 7/0, 12GR, 3/PLIC, gj-og7/012bc, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

gj-og7/012bc
Livrare imediată!

19,00Lei(-22%) 14,90Lei

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.2/0 8.00gr Round Jig Head

56978280
Livrare imediată!

31,05Lei

JIG OWNER DOWN SHOT OFFSET HOOK cod 5133 NR.2/0
Exclusiv online!

JIG OWNER DOWN SHOT OFFSET HOOK cod 5133 NR.2/0

5133002
Livrare 48-72 ore

14,54Lei

Fir, Textil, Owner, Kizuna, X8, Broad,, 40.00kg,, 0.42mm,, Chartreuse,, 270m, 11040256120-042, Fire Textile Rapitori, Fire Textile Rapitori Owner, Fire Owner, Textile Owner, Rapitori Owner, Owner
Shad Owner Juster JRS105 105mm Scuppernong
Exclusiv online!

Shad Owner Juster JRS105 105mm Scuppernong

801025589030
Livrare 48-72 ore

26,61Lei

Vartej Owner Amaz 72445 KS-11 Rolling King Stainless Swivel, Nr.4, 81kg, 15buc -30%

Vartej Owner Amaz 72445 KS-11 Rolling King Stainless Swivel, Nr.4, 81kg, 15buc

407260003
Livrare imediată!

14,30Lei(-30%) 10,01Lei

Carlig Owner Seigo 50610 Nr.2/0
Exclusiv online!

Carlig Owner Seigo 50610 Nr.2/0

5061002
Livrare 48-72 ore

11,23Lei

Carlig, Owner, Seigo, BH, 51440, Nr., 8, 5144008, Carlige Crap, Carlige Crap Owner, Owner
Exclusiv online!

Carlig, Owner, Seigo, BH, 51440, Nr., 8, 5144008, Carlige Crap, Carlige Crap Owner, Owner

5144008
Livrare 48-72 ore

8,29Lei

Rig, Feeder, Owner, 56931, Nr.12, 0.20, FD-51, Spear, BL, 5693312, Carlige Legate Feeder, Carlige Legate Feeder Owner, Owner
Carlig, Owner, Chika, 50363, Nr, 15, 5036308, Carlige Stationar, Carlige Stationar Owner, Owner -25%

Carlig, Owner, Chika, 50363, Nr, 15, 5036308, Carlige Stationar, Carlige Stationar Owner, Owner

5036308
Livrare imediată!

8,29Lei(-25%) 6,22Lei

Jig, Jaxon, cu, carlig, Owner, Big, Game, carlig, nr, 6/0, 20GR, 3/PLIC, gj-og6/020bc, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon -19%

Jig, Jaxon, cu, carlig, Owner, Big, Game, carlig, nr, 6/0, 20GR, 3/PLIC, gj-og6/020bc, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

gj-og6/020bc
Livrare imediată!

27,00Lei(-19%) 21,90Lei

Carlig, Owner, Pint-S, 51789, Nr, 4, 5178901, Carlige Crap, Carlige Crap Owner, Owner

Carlig, Owner, Pint-S, 51789, Nr, 4, 5178901, Carlige Crap, Carlige Crap Owner, Owner

5178901
Livrare imediată!

11,89Lei

Grub Single Tail Owner RB-3 14 Grow Pink Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 14 Grow Pink Ring Single Tail 82914 3.8cm

8291414
Livrare imediată!

15,29Lei

Rig, Feeder, Owner, 56932, No.12, 0.20, FD-11, Spear, 12030256932-12, Carlige Legate Feeder, Carlige Legate Feeder Owner, Owner
Exclusiv online!

Rig, Feeder, Owner, 56932, No.12, 0.20, FD-11, Spear, 12030256932-12, Carlige Legate Feeder, Carlige Legate Feeder Owner, Owner

12030256932-12
Livrare 48-72 ore

22,46Lei

Carlig Owner Yamame 50702 Nr 7 -25%

Carlig Owner Yamame 50702 Nr 7

5070205
Livrare imediată!

8,29Lei(-25%) 6,22Lei

Jig Owner Bila 11751 Nr. 1/0 9 gr -21%

Jig Owner Bila 11751 Nr. 1/0 9 gr

117511009
Livrare imediată!

15,01Lei(-21%) 11,90Lei

Carlige, Spinnerbait, Trailer, Hook, Owner, 11567, Nr.1/0, 1156710, Carlige Rapitor, Carlige Rapitor Owner, Owner
Afişare 1001 - 1020 din 1658 (83 pagini)
Queries: 9, Total time: 222.132 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'f9abd8ba37ff809b12c19b4f6f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.136)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (215.342)
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 "%owner%") 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 (5.962)
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 1000, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.145)
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:1231
7 (0.073)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.106)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.116)
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