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


CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.11 0.028gr
Exclusiv online!

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.11 0.028gr

pobb111
Livrare 48-72 ore

12,99Lei

BROASCA DAIWA PROREX MICRO SOFT BAIT FROG, YELLOW TOAD, 3.5CM
Exclusiv online!

BROASCA DAIWA PROREX MICRO SOFT BAIT FROG, YELLOW TOAD, 3.5CM

f.d.15403.003
Livrare 24-48 ore

35,51Lei

SEMNALIZATOR JAXON COPCA SC1 8cm Soft
Exclusiv online!

SEMNALIZATOR JAXON COPCA SC1 8cm Soft

mp-sc1
Livrare 48-72 ore

63,00Lei

BROASCA DAIWA PROREX MICRO SOFT BAIT FROG, MAD BROWN, 3.5CM

BROASCA DAIWA PROREX MICRO SOFT BAIT FROG, MAD BROWN, 3.5CM

f.d.15403.001
Livrare imediată!

35,51Lei

SEMNALIZATOR JAXON COPCA SA1 8cm Soft
Exclusiv online!

SEMNALIZATOR JAXON COPCA SA1 8cm Soft

mp-sa1
Livrare 48-72 ore

63,00Lei

CAP MINCIOG MAVER MATCH SOFT 55x45CM
Exclusiv online!

CAP MINCIOG MAVER MATCH SOFT 55x45CM

1970002
Livrare 48-72 ore

101,99Lei

Shad Mann's Soft 6cm Clear/Glitter 10 buc

Shad Mann's Soft 6cm Clear/Glitter 10 buc

88010227
Livrare imediată!

9,50Lei

Fir monofilament Trabucco TF XPS Super Soft Plus 0,283mm/9,90kg/150m -26%

Fir monofilament Trabucco TF XPS Super Soft Plus 0,283mm/9,90kg/150m

050-55-280
Livrare imediată!

58,00Lei(-26%) 42,90Lei

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.13 0.013gr
Exclusiv online!

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.13 0.013gr

pobb113
Livrare 48-72 ore

12,99Lei

CAP MINCIOG MAVER MATCH SOFT 50x40CM
Exclusiv online!

CAP MINCIOG MAVER MATCH SOFT 50x40CM

1970001
Livrare 48-72 ore

96,00Lei

Carlige Offset Sebile SOFT WEIGHT SISTEM 4/0 + 0,7gr (2 Carlige + 18 Softweight) -30%

Carlige Offset Sebile SOFT WEIGHT SISTEM 4/0 + 0,7gr (2 Carlige + 18 Softweight)

1250958
Livrare imediată!

28,41Lei(-30%) 19,90Lei

Fir textil Carp Spirit Combi Soft 20lb/20m Black Silt

Fir textil Carp Spirit Combi Soft 20lb/20m Black Silt

acs640084
Livrare imediată!

69,00Lei

BILUTE MOSTIRO SOFT ANTISOC 4 5 6 7 MM

BILUTE MOSTIRO SOFT ANTISOC 4 5 6 7 MM

4100
Livrare imediată!

4,30Lei

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.10

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.10

cz4602
Livrare imediată!

3,00Lei

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.12

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.12

cz4619
Livrare imediată!

3,00Lei

FIR FLUOROCARBON MAVER SUPER SOFT 12lb 20M -40%
Exclusiv online!

FIR FLUOROCARBON MAVER SUPER SOFT 12lb 20M

t340
Livrare 48-72 ore

52,00Lei(-40%) 31,20Lei

FIR SAVAGE SOFT FLUOROCARBON 046MM 12.3KG 35M
Exclusiv online!

FIR SAVAGE SOFT FLUOROCARBON 046MM 12.3KG 35M

a.sg.54853
Livrare 24-48 ore

83,75Lei

Porumb artificial Enterprise Tackle Super Soft Pop-up Sweetcorn - Yellow

Porumb artificial Enterprise Tackle Super Soft Pop-up Sweetcorn - Yellow

et13yis
Livrare imediată!

18,00Lei

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.14

CARLIGE CARP ZOOM FEEDER SOFT PELLET nr.14

cz4626
Livrare imediată!

3,00Lei

Benzar Mix Turbo Soft Pellet XL Crap-crucian

Benzar Mix Turbo Soft Pellet XL Crap-crucian

98085761
Livrare imediată!

17,51Lei

Afişare 221 - 240 din 1144 (58 pagini)
Queries: 4, Total time: 24.690 ms [By time] [By id] [By file]
1 (0.227)
SELECT data
FROM `oc_session`
WHERE session_id = 'd2a88fa0533c38d51671f3bf10'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.237)
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('+soft' 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.150)
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