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


Fir monofilament Delphin RODEO rosu 0.35mm 23lbs 17800m

Fir monofilament Delphin RODEO rosu 0.35mm 23lbs 17800m

101001341
Stoc epuizat

732,00Lei

FIR JAXON CROCODILE CARP 600m 0.30mm

FIR JAXON CROCODILE CARP 600m 0.30mm

zj-crc030d
Stoc epuizat

43,99Lei

FIR JAXON CROCODILE WINTER 50m 0.18mm

FIR JAXON CROCODILE WINTER 50m 0.18mm

zj-crw018d
Stoc epuizat

6,50Lei

FIR MONOFILAMENT DAIWA TN SW SHOCK LEADER T-N 0.70MM/30,6KG/50M

FIR MONOFILAMENT DAIWA TN SW SHOCK LEADER T-N 0.70MM/30,6KG/50M

d.12957.070
Stoc epuizat

40,40Lei

FIR MONOFILAMENT TORAY BAWO CARP 0.32MM/1000MT/ 8.1KG

FIR MONOFILAMENT TORAY BAWO CARP 0.32MM/1000MT/ 8.1KG

602210011
Stoc epuizat

158,69Lei

FIR JAXON CROCODILE FLUOROCARBON COATED 150m 0.45mm 30.00 kg

FIR JAXON CROCODILE FLUOROCARBON COATED 150m 0.45mm 30.00 kg

zj-crfa045
Stoc epuizat

21,00Lei

FIR COLMIC ATOMIC 500M 0.30mm

FIR COLMIC ATOMIC 500M 0.30mm

nyat630
Stoc epuizat

27,00Lei

FIR COLMIC IRIDE PT50 300M 0.20mm Orange Fluo

FIR COLMIC IRIDE PT50 300M 0.20mm Orange Fluo

nyir020
Stoc epuizat

38,00Lei

FIR MONOFILAMENT LOCHNESS MONSTER 012MM/2,0KG/150M

FIR MONOFILAMENT LOCHNESS MONSTER 012MM/2,0KG/150M

e.937.012
Stoc epuizat

13,44Lei

FIR COLMIC ATOMIC 500M 0.35mm

FIR COLMIC ATOMIC 500M 0.35mm

nyat635
Stoc epuizat

27,00Lei

FIR JAXON XT-PRO CARP 300M 0.32mm -30%

FIR JAXON XT-PRO CARP 300M 0.32mm

zj-xtc032a
Stoc epuizat

32,00Lei(-30%) 22,40Lei

FIR JAXON SATORI SURF CONIC 220m 0.30-0.50mm

FIR JAXON SATORI SURF CONIC 220m 0.30-0.50mm

zj-sas030
Stoc epuizat

71,00Lei

Fir Monofilament Daiwa Infinity Duo Camo 0.31mm/1210m/7.6kg

Fir Monofilament Daiwa Infinity Duo Camo 0.31mm/1210m/7.6kg

d.12981.031
Stoc epuizat

72,70Lei

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.34mm -30%

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.34mm

nyax34
Stoc epuizat

45,01Lei(-30%) 31,50Lei

Fir monofilament Trabucco T-Force Pro Carp 0.28mm/9.80kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.28mm/9.80kg/300m

053-15-280
Stoc epuizat

37,00Lei

FIR COLMIC PROJECT 360 NX30 300M 0.45mm

FIR COLMIC PROJECT 360 NX30 300M 0.45mm

nypr30045
Stoc epuizat

46,01Lei

FIR JAXON SATORI CARP 0.32mm 300M

FIR JAXON SATORI CARP 0.32mm 300M

zj-sac032b
Stoc epuizat

41,00Lei

FIR TRABUCCO S-FORCE L.CAST CARP 500m/0.32mm

FIR TRABUCCO S-FORCE L.CAST CARP 500m/0.32mm

052-20-320
Stoc epuizat

69,00Lei

FIR MONOFILAMENT OKUMA ULTRA MAX CARP 035MM/9,8KG/500M

FIR MONOFILAMENT OKUMA ULTRA MAX CARP 035MM/9,8KG/500M

o.19177
Stoc epuizat

13,20Lei

FIR MONOFILAMENT SUFIX TRITANIUM 1905M 0.25MM 4.2kg dark green

FIR MONOFILAMENT SUFIX TRITANIUM 1905M 0.25MM 4.2kg dark green

dtlsy025077g2t
Stoc epuizat

79,00Lei

Afişare 3421 - 3440 din 4620 (231 pagini)
Queries: 7, Total time: 128.460 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'dd837b129f5ef22141b4b50cce'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (109.463)
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('+monofilament' 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 (18.354)
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 3420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.148)
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
6 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.138)
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