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 VARIVAS SUPER TROUT AREA MASTER SUPER ESTER 150m 0.117mm 2.3lb

FIR VARIVAS SUPER TROUT AREA MASTER SUPER ESTER 150m 0.117mm 2.3lb

v2715005
Stoc epuizat

56,00Lei

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 1,80M/5-25G

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 1,80M/5-25G

c.27.2025180
Stoc epuizat

146,66Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 4.5lb 75m

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 4.5lb 75m

v44075015
Stoc epuizat

224,01Lei

MULINETA JAXON TRADA MASTER 7 8

MULINETA JAXON TRADA MASTER 7 8

kj-trb7/8
Stoc epuizat

109,00Lei

Lanseta Cormoran Black Master Jigger, 2.70m, 8-35g, 2buc

Lanseta Cormoran Black Master Jigger, 2.70m, 8-35g, 2buc

c.27.2035270
Stoc epuizat

161,90Lei

VARF TRABUCCO ULTIMATE PROFESSIONAL MASTER FEEDER PM1

VARF TRABUCCO ULTIMATE PROFESSIONAL MASTER FEEDER PM1

150-86-001
Stoc epuizat

69,00Lei

Lanseta Cormoran Black Master Jigger, 2.40m, 7-28g, 2buc

Lanseta Cormoran Black Master Jigger, 2.40m, 7-28g, 2buc

c.27.2028240
Stoc epuizat

209,15Lei

VARF TRABUCCO ULTIMATE PROFESSIONAL MASTER FEEDER PM2

VARF TRABUCCO ULTIMATE PROFESSIONAL MASTER FEEDER PM2

150-86-002
Stoc epuizat

69,00Lei

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,20M, 3-14G -23%

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,20M, 3-14G

c.27.2014220
Stoc epuizat

133,30Lei(-23%) 102,90Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 7lb 75m

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 7lb 75m

v4407503
Stoc epuizat

142,00Lei

FIR VARIVAS SUPER TROUT AREA MASTER SUPER ESTER 150m 0.09mm 1.4lb

FIR VARIVAS SUPER TROUT AREA MASTER SUPER ESTER 150m 0.09mm 1.4lb

v2715003
Stoc epuizat

56,00Lei

LANSETA ULTIMATE PROF.MASTER FEEDER 3.85M M 60G

LANSETA ULTIMATE PROF.MASTER FEEDER 3.85M M 60G

150-86-020
Stoc epuizat

530,00Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 5.5lb 75m

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 5.5lb 75m

v440750175
Stoc epuizat

191,99Lei

LANSETA ULTIMATE PROF MASTER FEEDER 3.55M M 60G

LANSETA ULTIMATE PROF MASTER FEEDER 3.55M M 60G

150-86-010
Stoc epuizat

489,99Lei

FIR MONOFILAMENT VARIVAS SUPER TROUT AREA MASTER SVG 150M 0.128MM 3.5LB

FIR MONOFILAMENT VARIVAS SUPER TROUT AREA MASTER SVG 150M 0.128MM 3.5LB

v263150035
Stoc epuizat

61,00Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 6.5lb 75m

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 6.5lb 75m

v4407502
Stoc epuizat

165,01Lei

Nada Colmic Master Series Feeder Bream 1kg -30%

Nada Colmic Master Series Feeder Bream 1kg

pcmsf01
Stoc epuizat

30,00Lei(-30%) 21,00Lei

Lanseta Maver IT THOR MASTER HEAVY FEEDER 3.3M 75-125GR

Lanseta Maver IT THOR MASTER HEAVY FEEDER 3.3M 75-125GR

5733002
Stoc epuizat

540,00Lei

Lanseta Bologneza Trabucco Frangente X-Master Bolo 6m 20g

Lanseta Bologneza Trabucco Frangente X-Master Bolo 6m 20g

121-06-060
Stoc epuizat

930,00Lei

CARLIGE GENLOG COMPETITION FEEDER METHOD MASTER NR 12 10 PCS

CARLIGE GENLOG COMPETITION FEEDER METHOD MASTER NR 12 10 PCS

gmmf-01-12-kpl
Stoc epuizat

6,50Lei

Afişare 281 - 300 din 405 (21 pagini)
Queries: 4, Total time: 10.647 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = 'f8026738d7b314c435fb4950a5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.278)
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('+master' 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 (0.125)
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