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 XXH 3.90m 80-220g
Exclusiv online!

Lanseta Nevis Vanity Carp Feeder XXH 3.90m 80-220g

1843-390
Livrare 48-72 ore

367,00Lei

PASTA TUNGSTEN VERDE 20GR CARP ZOOM -20%

PASTA TUNGSTEN VERDE 20GR CARP ZOOM

cz1922
Livrare imediată!

51,00Lei(-20%) 40,90Lei

Montura EXTRA CARP Helicopter PVC Tube, 3 buc/pac
Exclusiv online!

Montura EXTRA CARP Helicopter PVC Tube, 3 buc/pac

ec6220
Livrare 48-72 ore

11,80Lei

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 9 - 15buc/pac
Exclusiv online!

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 9 - 15buc/pac

5048203
Livrare 48-72 ore

10,90Lei

COSULET CRESTA CAGE M 3.5X4.2CM 60 GR 1 BUC PLIC
Exclusiv online!

COSULET CRESTA CAGE M 3.5X4.2CM 60 GR 1 BUC PLIC

004020-00606-00000
Livrare 48-72 ore

11,00Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 020MM/11,2KG/135M
Exclusiv online!

FIR TEXTIL CORMORAN CORASTRONG VERDE 020MM/11,2KG/135M

c.32.013520
Livrare 24-48 ore

20,96Lei

BOILIES CRITIC ECHILIBRAT BUCOVINA CARP BAITS COMPETITION Z 120G

BOILIES CRITIC ECHILIBRAT BUCOVINA CARP BAITS COMPETITION Z 120G

5940000001926
Livrare imediată!

24,00Lei

FALCON Magic Feeder 20gr
Exclusiv online!

FALCON Magic Feeder 20gr

f6640
Livrare 48-72 ore

6,00Lei

GEANTA SAVAGE M 20X40X29CM PLUS 3 CUTII -20%
Exclusiv online!

GEANTA SAVAGE M 20X40X29CM PLUS 3 CUTII

a8.sg.54776
Livrare 24-48 ore

332,40Lei(-20%) 265,92Lei

Fir monofilament Delphin RODEO rosu 0.30mm 17lbs 1200m

Fir monofilament Delphin RODEO rosu 0.30mm 17lbs 1200m

101001337
Livrare imediată!

52,00Lei

Agrafa Vartej Sunset ST Rolling Hanging Snap ST-S-3017 Nr10 5kg

Agrafa Vartej Sunset ST Rolling Hanging Snap ST-S-3017 Nr10 5kg

412015460
Livrare imediată!

9,09Lei

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.55mm, 34kg
Exclusiv online!

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.55mm, 34kg

zj-sagp055f
Livrare 48-72 ore

56,00Lei

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.60mm, 38kg
Exclusiv online!

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.60mm, 38kg

zj-sagp060f
Livrare 48-72 ore

65,00Lei

AGRAFA SPRO FAST LOCK MATT BLACK NR 000 20 BUC 4KG

AGRAFA SPRO FAST LOCK MATT BLACK NR 000 20 BUC 4KG

004620-00201-00000
Livrare imediată!

12,90Lei

Carlig Owner 50302 Argintiu Tija Lunga pentru Salau Nr 4 - 7buc/plic

Carlig Owner 50302 Argintiu Tija Lunga pentru Salau Nr 4 - 7buc/plic

5030203
Livrare imediată!

10,25Lei

Masa Coleman Mini Camp

Masa Coleman Mini Camp

204395
Livrare imediată!

320,00Lei

CUTIE PANARO 4 COMPART. AJUSTABILE 20,5X14,5CM
Exclusiv online!

CUTIE PANARO 4 COMPART. AJUSTABILE 20,5X14,5CM

a4.p199
Livrare 24-48 ore

34,65Lei

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 20MM 150GR

PELETE CARLIG GAURITE CARP ZOOM BLOODY HALIBUT 20MM 150GR

cz4926
Livrare imediată!

13,00Lei

Fir Browning Black Magic Gold Mono 0.17mm 680m
Exclusiv online!

Fir Browning Black Magic Gold Mono 0.17mm 680m

6152220017
Livrare 48-72 ore

24,10Lei

Buzz Bar EnergoTeam 3 Lansete Extra Strong

Buzz Bar EnergoTeam 3 Lansete Extra Strong

77045203
Livrare imediată!

39,00Lei

Afişare 5101 - 5120 din 19333 (967 pagini)
Queries: 5, Total time: 836.708 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '3bfad81cc5e03f179da90b67f1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (765.368)
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 "%20%") 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 (71.070)
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 5100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.110)
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