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


Plumb Zfish Tribomb Lead, 70g, Negru

Plumb Zfish Tribomb Lead, 70g, Negru

70-2179
Stoc epuizat

6,39Lei

Plumbi Cheburashka Cu Agrafa Detasabila, Roz Fluo, 10g, 5buc/plic

Plumbi Cheburashka Cu Agrafa Detasabila, Roz Fluo, 10g, 5buc/plic

40341pl0110l
Stoc epuizat

15,83Lei

FOX PLUMB BOMB IN-LINE 2.5OZ -30%

FOX PLUMB BOMB IN-LINE 2.5OZ

cld185
Stoc epuizat

13,67Lei(-30%) 9,57Lei

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI 0.019GR -40%

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI 0.019GR

121012
Stoc epuizat

7,00Lei(-40%) 4,20Lei

Piatra Stonze Pallatrax Medium cu Vartej 50 Gr

Piatra Stonze Pallatrax Medium cu Vartej 50 Gr

414420016
Stoc epuizat

6,30Lei

CUTIE MOSTIRO ALICE DE PLUMB DESPICATE

CUTIE MOSTIRO ALICE DE PLUMB DESPICATE

2312800103525
Stoc epuizat

3,80Lei

PLUMBI CULISANTI MAVER CU BLOCAJ MATCH THIS TUNGSTEN 0.5GR -20%

PLUMBI CULISANTI MAVER CU BLOCAJ MATCH THIS TUNGSTEN 0.5GR

k420
Stoc epuizat

12,40Lei(-20%) 9,92Lei

PLUMB BACKLEADS KORDA 45G 3BUC/PLIC

PLUMB BACKLEADS KORDA 45G 3BUC/PLIC

a.kib15
Stoc epuizat

33,87Lei

Plumbi Strategy Central Shocker System 113g Green

Plumbi Strategy Central Shocker System 113g Green

008035-00721-00000
Stoc epuizat

35,00Lei

PLUMB FOX PASTE BOMB CU VARTEJ 2.5OZ 71GR -30%

PLUMB FOX PASTE BOMB CU VARTEJ 2.5OZ 71GR

cld182
Stoc epuizat

13,67Lei(-30%) 9,57Lei

SONDA ADANCIME MAVER 1/4OZ 7GR

SONDA ADANCIME MAVER 1/4OZ 7GR

k635
Stoc epuizat

4,61Lei

Alice Plumb DAM Bleischrot Fein 70gr

Alice Plumb DAM Bleischrot Fein 70gr

a3.dam.8000070
Stoc epuizat

19,06Lei

PLUMB JIGGING JAXON 10GR 3BUC/PLIC -47%

PLUMB JIGGING JAXON 10GR 3BUC/PLIC

ce-ab10
Stoc epuizat

2,90Lei(-47%) 1,55Lei

CUTIE ALICE DE PLUMB MOSTIRO DESPICATE 100G 0.6-2.00 G

CUTIE ALICE DE PLUMB MOSTIRO DESPICATE 100G 0.6-2.00 G

2831
Stoc epuizat

9,00Lei

PLUMB BACKLEADS KORDA 15G 3BUC/PLIC

PLUMB BACKLEADS KORDA 15G 3BUC/PLIC

a.kib05
Stoc epuizat

33,87Lei

Set Plumbi GoldStar Culisanti Picatura III 1-4g

Set Plumbi GoldStar Culisanti Picatura III 1-4g

54103150
Stoc epuizat

32,00Lei

Plumbi Fox Grappling Marker 85g -30%

Plumbi Fox Grappling Marker 85g

cld229
Stoc epuizat

39,79Lei(-30%) 27,85Lei

PLUMBI CULISANTI MAVER MATCH THIS TUNGSTEN 0.5GR

PLUMBI CULISANTI MAVER MATCH THIS TUNGSTEN 0.5GR

k340
Stoc epuizat

11,50Lei

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.2/0 0.394gr

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.2/0 0.394gr

pobb010
Stoc epuizat

12,99Lei

Cutie Plumbi Maver Alice Refill - SSG -25%

Cutie Plumbi Maver Alice Refill - SSG

k355
Stoc epuizat

13,99Lei(-25%) 10,50Lei

Afişare 1641 - 1660 din 1923 (97 pagini)
Queries: 7, Total time: 45.984 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '238057c0e05fec51ece49e2356'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (37.513)
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('+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
4 (7.832)
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 1640, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.122)
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.135)
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