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

Produse ce potrivesc criteriilor de căutare


SHRINK TUB CARP ZOOM VERDE 2.4/2.6MM 5Cm

SHRINK TUB CARP ZOOM VERDE 2.4/2.6MM 5Cm

cz2141
Livrare imediată!

6,00Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 012MM/6,4KG/135M
Exclusiv online!

FIR TEXTIL CORMORAN CORASTRONG VERDE 012MM/6,4KG/135M

c.32.013512
Livrare 24-48 ore

33,18Lei

Fir Textil Jaxon Sumato Premium, Verde, 125m, 0.12mm, 10kg -24%

Fir Textil Jaxon Sumato Premium, Verde, 125m, 0.12mm, 10kg

zj-rap012g
Livrare imediată!

77,00Lei(-24%) 58,91Lei

Hanger Carp Hunter Verde

Hanger Carp Hunter Verde

77090924
Livrare imediată!

23,50Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.20mm 5.60kg Verde
Exclusiv online!

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.20mm 5.60kg Verde

cz2052
Livrare 48-72 ore

19,00Lei

SWINGER EXTRA CARP EXC LANCER ILUMINATED VERDE

SWINGER EXTRA CARP EXC LANCER ILUMINATED VERDE

ec9658
Livrare imediată!

49,99Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.06MM 4,0KG 150M
Exclusiv online!

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.06MM 4,0KG 150M

d.12751.006
Livrare 24-48 ore

75,76Lei

CARP ZOOM METHOD CRUSH FEEDER COMPETITION 120gr Verde -30%

CARP ZOOM METHOD CRUSH FEEDER COMPETITION 120gr Verde

cz5370
Livrare imediată!

11,00Lei(-30%) 7,70Lei

FIR TEXTIL CARP ZOOM PREDATOR Z OPLUS SILENT UL 100m 0.04mm 4lbs Verde -30%
Exclusiv online!

FIR TEXTIL CARP ZOOM PREDATOR Z OPLUS SILENT UL 100m 0.04mm 4lbs Verde

cz2236
Livrare 48-72 ore

70,00Lei(-30%) 49,00Lei

Fir ASSO Evergreen PE 8X Verde 0.58mm 130m 81.80 kg

Fir ASSO Evergreen PE 8X Verde 0.58mm 130m 81.80 kg

608080012
Livrare imediată!

97,79Lei

Fir Monofilament Benzar Method Feeder Mono Dark Green Verde Inchis 600m 0.25mm

Fir Monofilament Benzar Method Feeder Mono Dark Green Verde Inchis 600m 0.25mm

30606025
Livrare imediată!

34,00Lei

FIR TEXTIL TRAKKO DYNEEMA PERFORMANCE SPINNING VERDE FLUO 100M 0.10MM -26%

FIR TEXTIL TRAKKO DYNEEMA PERFORMANCE SPINNING VERDE FLUO 100M 0.10MM

mxt010
Livrare imediată!

69,20Lei(-26%) 51,05Lei

TUB SILICON CARP ZOOM VERDE 1.0/2.0MM 1m

TUB SILICON CARP ZOOM VERDE 1.0/2.0MM 1m

cz2066
Livrare imediată!

4,00Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.26mm 8.20kg Verde

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.26mm 8.20kg Verde

cz2083
Livrare imediată!

19,00Lei

AVERTIZOR JAXON XTR CRAP LIBRA G VERDE
Exclusiv online!

AVERTIZOR JAXON XTR CRAP LIBRA G VERDE

aj-syb105sg
Livrare 48-72 ore

208,00Lei

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.25MM

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.25MM

l.3016025
Livrare imediată!

37,29Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 018MM/9,8KG/135M
Exclusiv online!

FIR TEXTIL CORMORAN CORASTRONG VERDE 018MM/9,8KG/135M

c.32.013518
Livrare 24-48 ore

33,18Lei

FIR JAXON TEXTIL PRO CARP SINKING VERDE 20LB 10m

FIR JAXON TEXTIL PRO CARP SINKING VERDE 20LB 10m

zj-pag20c
Livrare imediată!

18,00Lei

Swinger Mivardi iluminated 135 verde
Exclusiv online!

Swinger Mivardi iluminated 135 verde

m-swin135g
Livrare 48-72 ore

45,01Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 6G VERDE
Exclusiv online!

AVERTIZOR JAXON XTR CARP SENSITIVE 6G VERDE

aj-sya106g
Livrare 48-72 ore

51,00Lei

Afişare 341 - 360 din 1278 (64 pagini)
Queries: 4, Total time: 5,175.680 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = 'ac3f4969fad8de39d00eef1cf4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (5,175.227)
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 = '2' AND (pd.tag LIKE "%verde%") 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:725
4 (0.224)
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