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


VARTEJ CU AGRAFA RAPIDA HEAVY DUTY JAXON

VARTEJ CU AGRAFA RAPIDA HEAVY DUTY JAXON

ac-356416
Stoc epuizat

8,00Lei

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm Camou

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm Camou

ak-kzy101m
Stoc epuizat

122,00Lei

LANSETA COLMIC PREMIUM INDYO CAST 7" 1/4-3/4 Medium Heavy

LANSETA COLMIC PREMIUM INDYO CAST 7" 1/4-3/4 Medium Heavy

cahkpr04
Stoc epuizat

1.358,00Lei

SCAUN JAXON PLIANT HEAVY DUTY 60x51x53/85CM 20MM

SCAUN JAXON PLIANT HEAVY DUTY 60x51x53/85CM 20MM

ak-kz034
Stoc epuizat

303,00Lei

Lanseta DAM Sensomax II XX-Heavy Feeder 4.20m 150-200gr

Lanseta DAM Sensomax II XX-Heavy Feeder 4.20m 150-200gr

2050966329
Stoc epuizat

384,22Lei

FOARFECA HEAVY DUTY CARP ZOOM

FOARFECA HEAVY DUTY CARP ZOOM

cz3643
Stoc epuizat

29,00Lei

CARLIGE OFFSET NOGALES HEAVY NR.1/0 - VC83H1/0

CARLIGE OFFSET NOGALES HEAVY NR.1/0 - VC83H1/0

vc83h1/0
Stoc epuizat

15,01Lei

CARLIGE OFFSET NOGALES HEAVY NR.2/0 - vc83h2/0

CARLIGE OFFSET NOGALES HEAVY NR.2/0 - vc83h2/0

vc83h2/0
Stoc epuizat

15,01Lei

ARGILA COLMIC HEAVY DAMP DARK BROWN 2kg

ARGILA COLMIC HEAVY DAMP DARK BROWN 2kg

pcbel50c
Stoc epuizat

17,01Lei

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm

ak-kzy101
Stoc epuizat

118,00Lei

MULINETA LINEAEFFE TS HEAVY SPECIMEN 6000

MULINETA LINEAEFFE TS HEAVY SPECIMEN 6000

l.1285260
Stoc epuizat

186,81Lei

PLUMB CARP ZOOM FANATIC HEAVY INLINE 100GR

PLUMB CARP ZOOM FANATIC HEAVY INLINE 100GR

cz1374
Stoc epuizat

12,00Lei

PLUMB CARP ZOOM FANATIC HEAVY 120GR

PLUMB CARP ZOOM FANATIC HEAVY 120GR

cz1329
Stoc epuizat

13,99Lei

Lanseta Maver IT THOR MASTER XXX-HEAVY FEEDER 3.9M 175-250GR

Lanseta Maver IT THOR MASTER XXX-HEAVY FEEDER 3.9M 175-250GR

5733005
Stoc epuizat

660,00Lei

Lanseta Sportex XCLUSIVE FEEDER NT HEAVY 4.20, 150-220g, 3+3seg

Lanseta Sportex XCLUSIVE FEEDER NT HEAVY 4.20, 150-220g, 3+3seg

hf4229
Stoc epuizat

1.559,99Lei

FIR CPK HEAVY LEADCORE 45 lb CAMO BROWN

FIR CPK HEAVY LEADCORE 45 lb CAMO BROWN

999967
Stoc epuizat

32,00Lei

Lanseta DAM Madcat Green Heavy Duty 2.40m 200-400gr

Lanseta DAM Madcat Green Heavy Duty 2.40m 200-400gr

20955835
Stoc epuizat

312,57Lei

PLUMB EXTRA CARP HEAVY INLINE 100GR -29%

PLUMB EXTRA CARP HEAVY INLINE 100GR

ec3946-100
Stoc epuizat

7,50Lei(-29%) 5,36Lei

PLUMB CARP ZOOM FANATIC HEAVY INLINE 80GR

PLUMB CARP ZOOM FANATIC HEAVY INLINE 80GR

cz1367
Stoc epuizat

11,50Lei

Varf Rezerva CARP EXPERT TELEFEEDER HEAVY 3.60 CARBON Rosu -20%

Varf Rezerva CARP EXPERT TELEFEEDER HEAVY 3.60 CARBON Rosu

12305367
Stoc epuizat

23,50Lei(-20%) 18,80Lei

Afişare 341 - 360 din 399 (20 pagini)
Queries: 6, Total time: 11.908 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'cb1e97e844775430c16fc66e1b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (11.354)
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('+heavy' 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.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (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