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 - spreader

Produse ce potrivesc criteriilor de căutare


Cap Jig Quantum Screw Jig Head 35gr

Cap Jig Quantum Screw Jig Head 35gr

3148035
Stoc epuizat

31,29Lei

PLUMB JIG JAXON CHEBURASKA 1GR

PLUMB JIG JAXON CHEBURASKA 1GR

gj-xc01
Stoc epuizat

20,00Lei

Plumb cu agrafa Delphin BARBED 80g

Plumb cu agrafa Delphin BARBED 80g

830511080
Stoc epuizat

8,00Lei

Alice Plumb Garbolino Nr.6 0.10g Plomb Extra-Doux

Alice Plumb Garbolino Nr.6 0.10g Plomb Extra-Doux

41030pri6
Stoc epuizat

12,74Lei

Plumb cu agrafa Delphin BARBED 60g

Plumb cu agrafa Delphin BARBED 60g

830511060
Stoc epuizat

7,00Lei

SET PLUMBI JAXON PICATURA NR 12 100GR 3/3.5/4/4.5/5GR

SET PLUMBI JAXON PICATURA NR 12 100GR 3/3.5/4/4.5/5GR

cc-z012
Stoc epuizat

42,00Lei

PLUMBI JAXON OLIVETA INLINE 18GR

PLUMBI JAXON OLIVETA INLINE 18GR

cc-ab18g
Stoc epuizat

4,50Lei

Plumb Rapture Dropshot Straight 14g 5buc/plic

Plumb Rapture Dropshot Straight 14g 5buc/plic

188-10-214
Stoc epuizat

12,25Lei

SET PLUMBI KAMASAKI 0.10 - 0.35 g

SET PLUMBI KAMASAKI 0.10 - 0.35 g

54106120
Stoc epuizat

2,80Lei

PLUMB PARA CU VARTEJ DELPHIN LEADS SWIVEL 5BUC PLIC 11g -37%

PLUMB PARA CU VARTEJ DELPHIN LEADS SWIVEL 5BUC PLIC 11g

965903011
Stoc epuizat

12,00Lei(-37%) 7,60Lei

Cap Jig Fanatik Articulat Granennyy 5gr Negru 5buc/plic

Cap Jig Fanatik Articulat Granennyy 5gr Negru 5buc/plic

41713cfg00105
Stoc epuizat

6,24Lei

PLUMBI JAXON OLIVETA INLINE 14GR

PLUMBI JAXON OLIVETA INLINE 14GR

cc-ab14g
Stoc epuizat

4,50Lei

RAPTURE FLEXY BOTTOM JIG 7g 6buc/plic

RAPTURE FLEXY BOTTOM JIG 7g 6buc/plic

188-26-520
Stoc epuizat

12,50Lei

PLUMB CARP EXPERT PASTA BOILIES INLINE 60GR 2buc/plic

PLUMB CARP EXPERT PASTA BOILIES INLINE 60GR 2buc/plic

58216360
Stoc epuizat

8,00Lei

PLUMB PARA CU VARTEJ DELPHIN LEADS SWIVEL 5BUC PLIC 15g -18%

PLUMB PARA CU VARTEJ DELPHIN LEADS SWIVEL 5BUC PLIC 15g

965903015
Stoc epuizat

13,99Lei(-18%) 11,50Lei

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 14g 5buc/plic

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 14g 5buc/plic

188-11-114
Stoc epuizat

19,00Lei

Plumbi Rapture Bullet Head Teck Sinker 5g 10buc/plic

Plumbi Rapture Bullet Head Teck Sinker 5g 10buc/plic

188-11-205
Stoc epuizat

7,09Lei

RAPTURE FLEXY BOTTOM JIG 14g 4buc/plic

RAPTURE FLEXY BOTTOM JIG 14g 4buc/plic

188-26-550
Stoc epuizat

12,50Lei

PLUMB KORDA CULISANT PLAT PARA 2BUC/PLIC 112G

PLUMB KORDA CULISANT PLAT PARA 2BUC/PLIC 112G

a3.kfpib4
Stoc epuizat

20,69Lei

RAPTURE FLEXY BOTTOM JIG 18g 3buc/plic

RAPTURE FLEXY BOTTOM JIG 18g 3buc/plic

188-26-560
Stoc epuizat

9,50Lei

Afişare 1721 - 1740 din 1923 (97 pagini)
Queries: 8, Total time: 53.095 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '0098764a20a788c2fa7576210a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.104)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (45.058)
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 (MATCH(pd.tag) AGAINST('+plumbi' 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
5 (7.447)
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 1720, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.118)
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
7 (0.093)
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
8 (0.100)
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