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 300 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


Kit PVA System CARP EXPERT 4 Season, 45mm, 5m
Exclusiv online!

Kit PVA System CARP EXPERT 4 Season, 45mm, 5m

30146045
Livrare 24-48 ore

42,99Lei

Kit PVA System CARP EXPERT Anti Fraying, 45mm, 10m
Exclusiv online!

Kit PVA System CARP EXPERT Anti Fraying, 45mm, 10m

30147245
Livrare 24-48 ore

68,00Lei

Kit PVA System CARP EXPERT Anti Fraying, 45mm, 5m
Exclusiv online!

Kit PVA System CARP EXPERT Anti Fraying, 45mm, 5m

30147045
Livrare 24-48 ore

52,00Lei

Kit PVA System CARP EXPERT Micro Mesh 45mm, 5m
Exclusiv online!

Kit PVA System CARP EXPERT Micro Mesh 45mm, 5m

30145045
Livrare 24-48 ore

42,99Lei

Rezerva, Plasa, Solubila, Saculeti, CARP, EXPERT, 4, Season,, 45mm,, 5m, , 30146545, Materiale Pva, Materiale Pva Carp Expert, Materiale Carp Expert, Pva Carp Expert, Carp Expert
Rezerva, Plasa, Solubila, Saculeti, CARP, EXPERT, Micro, PVA, CXP,, 45mm,, 5m, , 30145545, Materiale Pva, Materiale Pva Carp Expert, Materiale Carp Expert, Pva Carp Expert, Carp Expert
FIR MONOFILAMENT SUFIX TRITANIUM NEON ORANGE 680M 0.45MM 13.7kg

FIR MONOFILAMENT SUFIX TRITANIUM NEON ORANGE 680M 0.45MM 13.7kg

ds1sy0450msg2t
Livrare imediată!

89,00Lei

Fir, Jaxon, Crocodile, Marine, Verde, Fluo,, 300m,, 0.45mm,, 30kg, zj-crm045b, Fire Monofilament Crap, Fire Monofilament Crap Jaxon, Fire Jaxon, Monofilament Jaxon, Crap Jaxon, Jaxon
FIR JAXON CARAT CATFISH 0.45mm, 30kg, 250m
Exclusiv online!

FIR JAXON CARAT CATFISH 0.45mm, 30kg, 250m

zj-kad045b
Livrare 48-72 ore

39,00Lei

FIR COLMIC ATOMIC 500M 0.45mm

FIR COLMIC ATOMIC 500M 0.45mm

nyat645
Livrare imediată!

42,99Lei

FLUOROCARBON CARP SPIRIT OPTI-MEX 0.45MM 25LB 14.8KG 20MT

FLUOROCARBON CARP SPIRIT OPTI-MEX 0.45MM 25LB 14.8KG 20MT

acs640041
Livrare imediată!

51,00Lei

Fir Textil Jaxon Sumato Catfish 250m, 0.45mm, 65kg
Exclusiv online!

Fir Textil Jaxon Sumato Catfish 250m, 0.45mm, 65kg

zj-rac045b
Livrare 48-72 ore

150,00Lei

CUTIE VOBLER JAXON 155X95X45MM

CUTIE VOBLER JAXON 155X95X45MM

rh-108
Livrare imediată!

20,00Lei

FIR JAXON CROCODILE FLUOROCARBON COATED 150m 0.45mm 30.00 kg
Exclusiv online!

FIR JAXON CROCODILE FLUOROCARBON COATED 150m 0.45mm 30.00 kg

zj-crfa045
Livrare 48-72 ore

21,00Lei

FIR COLMIC PROJECT 360 NX30 300M 0.45mm
Exclusiv online!

FIR COLMIC PROJECT 360 NX30 300M 0.45mm

nypr30045
Livrare 48-72 ore

46,01Lei

CUTIE SPRO HARDBAITS M 200X155X45MM

CUTIE SPRO HARDBAITS M 200X155X45MM

006515-01900-00000
Livrare imediată!

41,00Lei

FIR JAXON TEXTIL SUMATO CATFISH 1000m 0.45mm
Exclusiv online!

FIR JAXON TEXTIL SUMATO CATFISH 1000m 0.45mm

zj-rac045x
Livrare 48-72 ore

536,00Lei

FIR JAXON CARAT MARINE 250m 0,45mm 30.00 kg Galben Fluo

FIR JAXON CARAT MARINE 250m 0,45mm 30.00 kg Galben Fluo

zj-kam045b
Livrare imediată!

40,00Lei

CUTIE PANARO 1/15 COMPART. AJUSTABILE 276X188X45MM
Exclusiv online!

CUTIE PANARO 1/15 COMPART. AJUSTABILE 276X188X45MM

a4.p196
Livrare 24-48 ore

47,68Lei

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.45mm, 25kg
Exclusiv online!

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.45mm, 25kg

zj-sagp045f
Livrare 48-72 ore

42,00Lei

Afişare 41 - 60 din 209 (11 pagini)
Queries: 10, Total time: 167.509 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = 'b030be75b590c1d8e4084d1285'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (163.066)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%45mm%") 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:698
4 (0.107)
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
5 (1.164)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.380)
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:1209
7 (0.116)
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:1231
8 (0.128)
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:996
9 (2.185)
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:910
10 (0.114)
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