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 Delphin FIN Method FEED 200m Maro 0.20mm

Fir Delphin FIN Method FEED 200m Maro 0.20mm

500650320
Livrare imediată!

21,00Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.39mm 30m 8.04kg
Exclusiv online!

Fir Fluorocarbon Savage Gear Soft Seabass 0.39mm 30m 8.04kg

a.sg.74488
Livrare 24-48 ore

48,49Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M -8%

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M

d.12940.023
Livrare imediată!

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

Fir Monofilament Carp Academy Deep Purple 300m 0.25mm 8.50kg

Fir Monofilament Carp Academy Deep Purple 300m 0.25mm 8.50kg

3234-325
Livrare imediată!

27,91Lei

Fir monofilament DAM Tectan Superior Soft Leader 0.50mm 22.7kg 100m

Fir monofilament DAM Tectan Superior Soft Leader 0.50mm 22.7kg 100m

11010966198
Livrare imediată!

32,18Lei

Fir Multifilament Team Feeder Blue Feeder Braid 150m 0.12mm
Exclusiv online!

Fir Multifilament Team Feeder Blue Feeder Braid 150m 0.12mm

3226-012
Livrare 48-72 ore

37,79Lei

FIR MONOFILAMENT ENERGOTEAM EXCALIBUR CARP FLUO YELLOW 3000M 0.25mm 8.70kg
Exclusiv online!

FIR MONOFILAMENT ENERGOTEAM EXCALIBUR CARP FLUO YELLOW 3000M 0.25mm 8.70kg

34065925
Livrare 24-48 ore

139,00Lei

Fir Monofilament Asso Invisilk Yellow 0.28mm 600m 10.4kg

Fir Monofilament Asso Invisilk Yellow 0.28mm 600m 10.4kg

602080103
Livrare imediată!

57,07Lei

Fir Monofilament Carp Academy Deep Purple 1000m 0.30mm 11.80kg

Fir Monofilament Carp Academy Deep Purple 1000m 0.30mm 11.80kg

3234-830
Livrare imediată!

77,00Lei

Fir monofilament Delphin MAMBA Feeder camuflaj 0.20mm 7.7lbs 300m

Fir monofilament Delphin MAMBA Feeder camuflaj 0.20mm 7.7lbs 300m

101001647
Livrare imediată!

41,00Lei

Fir monofilament Fudo Hooks FDN-1 100m, 0.200mm, 5.48kg -32%

Fir monofilament Fudo Hooks FDN-1 100m, 0.200mm, 5.48kg

fdn-1-0.20mm-100m
Livrare imediată!

19,00Lei(-32%) 12,90Lei

Fir Fluorocarbon Savage Gear Semi Soft Seabass 0.21mm 30m 2.7kg
Exclusiv online!

Fir Fluorocarbon Savage Gear Semi Soft Seabass 0.21mm 30m 2.7kg

a.sg.74483
Livrare 24-48 ore

30,84Lei

Fir Monofilament Asso Invisilk Yellow 0.22mm 600m 8.10kg

Fir Monofilament Asso Invisilk Yellow 0.22mm 600m 8.10kg

602080100
Livrare imediată!

51,19Lei

FIR MONOFILAMENT GAMAKATSU G-LINE SHOCK 0.57MM 50M

FIR MONOFILAMENT GAMAKATSU G-LINE SHOCK 0.57MM 50M

gk.5133.040
Livrare imediată!

35,63Lei

Fir Multifilament Team Feeder Blue Feeder Braid 150m 0.14mm
Exclusiv online!

Fir Multifilament Team Feeder Blue Feeder Braid 150m 0.14mm

3226-014
Livrare 48-72 ore

37,79Lei

FIR MONOFILAMENT LAZER TORNADO 200M 0.35MM
Exclusiv online!

FIR MONOFILAMENT LAZER TORNADO 200M 0.35MM

laz-00000441
Livrare 48-72 ore

36,50Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg
Exclusiv online!

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg

a.sg.74487
Livrare 24-48 ore

39,64Lei

Fir monofilament Fudo Hooks FDN-1 100m, 0.180mm, 3.93kg

Fir monofilament Fudo Hooks FDN-1 100m, 0.180mm, 3.93kg

fdn-1-0.18mm-100m
Livrare imediată!

17,50Lei

FIR MONOFILAMENT GAMAKATSU G-LINE SHOCK 0.47MM 50M

FIR MONOFILAMENT GAMAKATSU G-LINE SHOCK 0.47MM 50M

gk.5133.030
Livrare imediată!

34,76Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.25mm 30m 3.66kg
Exclusiv online!

Fir Fluorocarbon Savage Gear Soft Seabass 0.25mm 30m 3.66kg

a.sg.74484
Livrare 24-48 ore

33,24Lei

Afişare 3081 - 3100 din 4620 (231 pagini)
Queries: 5, Total time: 131.959 ms [By time] [By id] [By file]
1 (0.204)
SELECT data
FROM `oc_session`
WHERE session_id = 'a947e1c6a6605b82bfedc2efeb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.146)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (111.984)
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:737
4 (19.463)
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 3080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.162)
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