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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


FIR JAXON CARAT CRAP 600M 0.32mm

FIR JAXON CARAT CRAP 600M 0.32mm

zj-kac032d
Livrare imediată!

61,00Lei

FIR MONOFILAMENT CARBOTEX BOILIE CARP 040MM/20,65KG/400M
Exclusiv online!

FIR MONOFILAMENT CARBOTEX BOILIE CARP 040MM/20,65KG/400M

e.7700.040
Livrare 24-48 ore

35,16Lei

FIR CARP EXPERT CARBON 1000M 0.25mm 8.50kg

FIR CARP EXPERT CARBON 1000M 0.25mm 8.50kg

30100825
Stoc epuizat

36,50Lei

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

l.3001406
Livrare imediată!

20,83Lei

FIR MONOFILAMENT MAVER ZERO G3 SMART 1000M 0.205MM -50%
Exclusiv online!

FIR MONOFILAMENT MAVER ZERO G3 SMART 1000M 0.205MM

640205
Livrare 48-72 ore

101,00Lei(-50%) 50,50Lei

FIR MONOFILAMENT SUFIX ULTRA KNOT Yellow Orange 0.305MM 1195M

FIR MONOFILAMENT SUFIX ULTRA KNOT Yellow Orange 0.305MM 1195M

ds1uk0300sapbp
Livrare imediată!

99,00Lei

Fir monofilament Trabucco T-Force Pro Carp 0.30mm/11.95kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.30mm/11.95kg/300m

053-15-300
Livrare imediată!

37,00Lei

FIR MONOFILAMENT MIVARDI CARBON CARP 0.285mm/600m/9.40kg

FIR MONOFILAMENT MIVARDI CARBON CARP 0.285mm/600m/9.40kg

miv-lcc6028
Livrare imediată!

79,99Lei

FIR JAXON CARAT CRAP 600M 0.25mm
Exclusiv online!

FIR JAXON CARAT CRAP 600M 0.25mm

zj-kac025d
Livrare 48-72 ore

50,00Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m
Exclusiv online!

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m

602080012
Livrare 48-72 ore

41,72Lei

FIR JAXON CROCODILE CARP 300m 0.32mm

FIR JAXON CROCODILE CARP 300m 0.32mm

zj-crc032b
Livrare imediată!

27,00Lei

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE CARP 1000MT 0.30MM

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE CARP 1000MT 0.30MM

057-18-300
Livrare imediată!

62,00Lei

FIR JAXON ETERNUM CRAP 600m 0.32mm -30%

FIR JAXON ETERNUM CRAP 600m 0.32mm

zj-etc032d
Livrare imediată!

48,00Lei(-30%) 33,61Lei

FIR JAXON CARAT CRAP 300M 0.25mm
Exclusiv online!

FIR JAXON CARAT CRAP 300M 0.25mm

zj-kac025b
Livrare 48-72 ore

30,00Lei

Fir monofilament Trabucco T-Force Pro Carp 0.25mm/8.36kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.25mm/8.36kg/300m

053-15-250
Livrare imediată!

37,00Lei

FIR COLMIC ATOMIC 500M 0.22mm
Exclusiv online!

FIR COLMIC ATOMIC 500M 0.22mm

nyat622
Livrare 48-72 ore

24,00Lei

Fir Asso Invisilk Pink 0.22 mm 300 m

Fir Asso Invisilk Pink 0.22 mm 300 m

602080041
Livrare imediată!

32,69Lei

FIR MONOFILAMENT MIVARDI CARBON CARP 0.260mm/600m/7.50kg

FIR MONOFILAMENT MIVARDI CARBON CARP 0.260mm/600m/7.50kg

miv-lcc6026
Livrare imediată!

75,01Lei

Fir fluorocarbon coated P-Line CX Premium Clear Fluorescent 0.26mm/6.50kg/1000m

Fir fluorocarbon coated P-Line CX Premium Clear Fluorescent 0.26mm/6.50kg/1000m

750185708
Livrare imediată!

59,00Lei

Fir Monofilament Carp Expert UV Fluo 0.25mm/1000m/8.90kg

Fir Monofilament Carp Expert UV Fluo 0.25mm/1000m/8.90kg

30120825
Livrare imediată!

60,00Lei

Afişare 621 - 640 din 1889 (95 pagini)
Queries: 11, Total time: 84.889 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = 'eb4cbfe82107df5c6e6593f3d2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (58.604)
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('+fire +monofilament +crap' 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 (0.304)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
6 (7.115)
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 620, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (1.340)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
8 (0.126)
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:1270
9 (0.379)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
10 (16.566)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
11 (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