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


Lanseta Nevis Vanity Carp Feeder XH 3.00m 50-180g
Exclusiv online!

Lanseta Nevis Vanity Carp Feeder XH 3.00m 50-180g

1843-301
Livrare 48-72 ore

279,00Lei

CLESTE CUDA TITANIUM NITRIDE BONDED RING SPLITTER, 22CM
Exclusiv online!

CLESTE CUDA TITANIUM NITRIDE BONDED RING SPLITTER, 22CM

80950838
Livrare 24-48 ore

119,00Lei

MULINETA ENERGOTEAM KAMASAKI JUNIOR VERDE

MULINETA ENERGOTEAM KAMASAKI JUNIOR VERDE

20402502
Livrare imediată!

29,00Lei

Cantar Digital NGT XPR Digital Scales, 50kg

Cantar Digital NGT XPR Digital Scales, 50kg

ngt-fu-scales-xpr
Livrare imediată!

129,00Lei

CAP MINCIOG CARP EXPERT SUPER RUBBER, 50X60X60CM

CAP MINCIOG CARP EXPERT SUPER RUBBER, 50X60X60CM

71024150
Livrare imediată!

75,01Lei

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16
Exclusiv online!

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16

amhw26
Livrare 48-72 ore

13,99Lei

Fir fluorocarbon coated P-Line CX Premium Moss Green 0.25mm/7.28kg/1000m

Fir fluorocarbon coated P-Line CX Premium Moss Green 0.25mm/7.28kg/1000m

750184166
Livrare imediată!

60,00Lei

PILKER SPRO CAST X POLLACK 60GR
Exclusiv online!

PILKER SPRO CAST X POLLACK 60GR

004500-00601-00000
Livrare 48-72 ore

18,80Lei

EXPRESS ATRACTOR CARP ZOOM 50ml SCOPEX
Exclusiv online!

EXPRESS ATRACTOR CARP ZOOM 50ml SCOPEX

cz7606
Livrare 48-72 ore

7,00Lei

Benzar Jelly Baits Baby Worm Maro Rosu
Exclusiv online!

Benzar Jelly Baits Baby Worm Maro Rosu

79475082
Livrare 24-48 ore

13,60Lei

VIDRAX PLUTA BALSA MODEL005, 0,50G
Exclusiv online!

VIDRAX PLUTA BALSA MODEL005, 0,50G

a1.v005.005
Livrare 24-48 ore

3,65Lei

CIZME LEMIGO -50 C EVA ARCTIC TERMO+ 875 MAR.41
Exclusiv online!

CIZME LEMIGO -50 C EVA ARCTIC TERMO+ 875 MAR.41

lx.7587500.41
Livrare 24-48 ore

235,66Lei

Fir ASSO Ultra Cast Galben Fluo 0.18mm 150m
Exclusiv online!

Fir ASSO Ultra Cast Galben Fluo 0.18mm 150m

603080013
Livrare 48-72 ore

19,79Lei

FIR JAXON MONOLITH PREMIUM 0.10mm 150m
Exclusiv online!

FIR JAXON MONOLITH PREMIUM 0.10mm 150m

zj-hop010a
Livrare 48-72 ore

16,51Lei

VARTEJ CU RULMENT MAVER ELITE NR 4, 102 KG -40%
Exclusiv online!

VARTEJ CU RULMENT MAVER ELITE NR 4, 102 KG

1505004
Livrare 48-72 ore

53,00Lei(-40%) 31,80Lei

Senzor TIGERNUTS NATURAL 150g

Senzor TIGERNUTS NATURAL 150g

snz99834
Livrare imediată!

15,00Lei

Varf Feeder Maver Genesis Extreme Distance 3.6m/150gr 1oz
Exclusiv online!

Varf Feeder Maver Genesis Extreme Distance 3.6m/150gr 1oz

a2311
Livrare 48-72 ore

49,00Lei

Varga Nevis Patriot 5m -24%

Varga Nevis Patriot 5m

1643-500
Livrare imediată!

229,00Lei(-24%) 173,89Lei

FIR JAXON MONOLITH FEEDER 0.27mm 150m

FIR JAXON MONOLITH FEEDER 0.27mm 150m

zj-hof027a
Livrare imediată!

22,00Lei

Carlig Owner 50286 Rosu Tija Lunga Nr 7 - 15buc/plic

Carlig Owner 50286 Rosu Tija Lunga Nr 7 - 15buc/plic

5028605
Livrare imediată!

10,41Lei

Afişare 5781 - 5800 din 17617 (881 pagini)
Queries: 5, Total time: 793.963 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '424a8a93bb1a09beb766c92363'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (718.720)
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 (pd.tag LIKE "%50%") 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 (74.852)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 5780, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.210)
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