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


CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz7 SHORT 3BUC -20%

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 25lb sz7 SHORT 3BUC

ccr165
Livrare imediată!

35,74Lei(-20%) 28,60Lei

Mulineta K-Karp FUSION 6500
Exclusiv online!

Mulineta K-Karp FUSION 6500

037-81-065
Livrare 48-72 ore

368,00Lei

TARGET GARDNER FLUOROCARBON 5Ib 2.3Kg 25m -36%

TARGET GARDNER FLUOROCARBON 5Ib 2.3Kg 25m

tfc5
Livrare imediată!

27,94Lei(-36%) 17,90Lei

CARLIG OWNER 50335 Nr.3-Auriu Semirotund -26%

CARLIG OWNER 50335 Nr.3-Auriu Semirotund

5033502
Livrare imediată!

10,75Lei(-26%) 7,90Lei

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 STD 3BUC -34%

CARLIGE LEGATE FOX Edge Armapoint stiff rig beaked Chod rigs 30lb sz4 STD 3BUC

ccr155
Livrare imediată!

35,96Lei(-34%) 23,90Lei

INDICATOR CU BILA JAXON LARGE 25BUC/PLIC
Exclusiv online!

INDICATOR CU BILA JAXON LARGE 25BUC/PLIC

aj-316
Livrare 48-72 ore

16,01Lei

FIR JAXON TEXTIL PRO CARP SINKING VERDE 20LB 10m

FIR JAXON TEXTIL PRO CARP SINKING VERDE 20LB 10m

zj-pag20c
Livrare imediată!

18,00Lei

MOMITOR CARP ZOOM STRIAT 30gr

MOMITOR CARP ZOOM STRIAT 30gr

cz9815
Livrare imediată!

6,00Lei

MULINETA JAXON MAGNET CARP FRXL 600 3RUL
Exclusiv online!

MULINETA JAXON MAGNET CARP FRXL 600 3RUL

kj-mca600xl
Livrare 48-72 ore

271,00Lei

Carlig Owner 50404 Auriu Rotund Tija Scurta Nr 1/0 - 5buc/plic

Carlig Owner 50404 Auriu Rotund Tija Scurta Nr 1/0 - 5buc/plic

5040405
Livrare imediată!

10,25Lei

Minciog Crap Carp Expert Coada 180cm Brate 100x100cm
Exclusiv online!

Minciog Crap Carp Expert Coada 180cm Brate 100x100cm

71033610
Livrare 24-48 ore

141,00Lei

MULINETA LINEAEFFE TS HEAVY SPECIMEN 5000 -20%
Exclusiv online!

MULINETA LINEAEFFE TS HEAVY SPECIMEN 5000

l.1285250
Livrare 24-48 ore

227,21Lei(-20%) 181,77Lei

FIR COLMIC FLUOROCARBON WIND 50M 0.22mm
Exclusiv online!

FIR COLMIC FLUOROCARBON WIND 50M 0.22mm

nywin22
Livrare 48-72 ore

43,99Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 300m, 0.31mm, 12.65kg
Exclusiv online!

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 300m, 0.31mm, 12.65kg

cz2936
Livrare 48-72 ore

22,00Lei

Carlige PB Products Jungle Hooks Nr.4, 10buc/plic

Carlige PB Products Jungle Hooks Nr.4, 10buc/plic

pb24011
Livrare imediată!

30,00Lei

FIR KORDA FLUOROCARBON IQ 10LBS/20M

FIR KORDA FLUOROCARBON IQ 10LBS/20M

a.kiq10
Livrare imediată!

65,00Lei

PB ARMABRAID 15LB 20M WEED-VEGETATIE FIR PT MONTURI

PB ARMABRAID 15LB 20M WEED-VEGETATIE FIR PT MONTURI

pb10090
Livrare imediată!

53,00Lei

PB Rig Rings Medium, 3.7mm, 5buc/pac -41%

PB Rig Rings Medium, 3.7mm, 5buc/pac

pb23101
Livrare imediată!

20,00Lei(-41%) 11,90Lei

Carlig Owner Cps 5106 Negru Nr 1 - 7buc/plic -27%

Carlig Owner Cps 5106 Negru Nr 1 - 7buc/plic

5106002
Livrare imediată!

15,96Lei(-27%) 11,65Lei

Carlige Gamakatsu 3310g 25BUC/PLIC nr 4

Carlige Gamakatsu 3310g 25BUC/PLIC nr 4

gk.146576.4
Livrare imediată!

28,18Lei

Afişare 3541 - 3560 din 10398 (520 pagini)
Queries: 4, Total time: 236.332 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'dd11bcf50f56d9b39c74dd881e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (235.901)
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('+crap' 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.170)
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