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 ENERGO TEAM SPECIALIST CARP 0.30 MM 300M

FIR ENERGO TEAM SPECIALIST CARP 0.30 MM 300M

33200030
Livrare imediată!

10,00Lei

FIR KORDA CARP 028MM/8LB/1000M
Exclusiv online!

FIR KORDA CARP 028MM/8LB/1000M

a.kcm08
Livrare 24-48 ore

83,61Lei

FIR STRATEGY MONO HIGH ABRASION 0.30 MM 1000M
Exclusiv online!

FIR STRATEGY MONO HIGH ABRASION 0.30 MM 1000M

005820-00103-00000
Livrare 48-72 ore

126,00Lei

Fir monofilament Trabucco TF XPS Super Soft Plus 0,104mm/1,60kg/150m

Fir monofilament Trabucco TF XPS Super Soft Plus 0,104mm/1,60kg/150m

050-55-100
Livrare imediată!

38,00Lei

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg
Exclusiv online!

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg

zj-ets027a
Livrare 48-72 ore

17,50Lei

Fir monofilament Trabucco T-Force Pro Carp 0.32mm/13.85kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.32mm/13.85kg/300m

053-15-320
Livrare imediată!

37,00Lei

Fir Browning Cenex Feeder Mono 0.20mm 150m

Fir Browning Cenex Feeder Mono 0.20mm 150m

2226020
Livrare imediată!

35,78Lei

FIR STRATEGY FLUORO CARBON HYBRD 0.35 MM 1000 M
Exclusiv online!

FIR STRATEGY FLUORO CARBON HYBRD 0.35 MM 1000 M

005820-00101-00000
Livrare 48-72 ore

126,00Lei

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.50mm 25lb
Exclusiv online!

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.50mm 25lb

8700-10002-050
Livrare 48-72 ore

31,00Lei

Fir monofilament Daiwa Tournament Orange 040MM/8,2KG/740M

Fir monofilament Daiwa Tournament Orange 040MM/8,2KG/740M

d.tfmo040
Livrare imediată!

88,14Lei

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

Fir ASSO Ultra Molecular Shield Dark Green 0.31mm 300m

602080013
Livrare 48-72 ore

44,30Lei

Fir inaintas Climax CULT CRAP SHOCK LEADER 100m 0.60mm 45lb 20.3kg Camouflage
Exclusiv online!

Fir inaintas Climax CULT CRAP SHOCK LEADER 100m 0.60mm 45lb 20.3kg Camouflage

8511-10100-060
Livrare 48-72 ore

30,00Lei

Fir Asso Invisilk Yellow 0.24mm 300m

Fir Asso Invisilk Yellow 0.24mm 300m

602080092
Livrare imediată!

32,69Lei

Fir Dragon Invisible Fluorocarbon 0.50mm 20m -28%

Fir Dragon Invisible Fluorocarbon 0.50mm 20m

tpo3900050
Livrare imediată!

74,58Lei(-28%) 53,32Lei

FIR monofilament Climax CULT CATFISH HARD MONO LEADER 50m 1.20mm 100kg

FIR monofilament Climax CULT CATFISH HARD MONO LEADER 50m 1.20mm 100kg

8731-10050-120
Livrare imediată!

60,00Lei

Fir Monofilament Maver MV-R Carp Feeder Mono 150m, 0.24mm, 4.5kg
Exclusiv online!

Fir Monofilament Maver MV-R Carp Feeder Mono 150m, 0.24mm, 4.5kg

f623
Livrare 48-72 ore

42,99Lei

Monofilament Nevis Legacy Feeder 300m 0.25mm

Monofilament Nevis Legacy Feeder 300m 0.25mm

3202-325
Livrare imediată!

21,00Lei

FIR MONOFILAMENT MIVARDI FEEDER CARP 0.255mm/200m/7.20kg

FIR MONOFILAMENT MIVARDI FEEDER CARP 0.255mm/200m/7.20kg

miv-lcf225
Livrare imediată!

20,00Lei

FIR DAIWA PROREX FC LEADER 0.40MM/10.4KG/40M -8%
Exclusiv online!

FIR DAIWA PROREX FC LEADER 0.40MM/10.4KG/40M

d.12995.040
Livrare 24-48 ore

35,30Lei(-8%) 32,34Lei

Fir EnergoTeam Excalibur Carp Feeder Fluo Orange-Galben Camou 0.20mm 300m

Fir EnergoTeam Excalibur Carp Feeder Fluo Orange-Galben Camou 0.20mm 300m

34061020
Livrare imediată!

17,01Lei

Afişare 2041 - 2060 din 4620 (231 pagini)
Queries: 5, Total time: 149.684 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '60b3b17490647ed0bc2f464f5e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (126.559)
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('+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:724
4 (22.797)
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 2040, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.115)
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