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


Suport Lansete Carp Expert Asimetric Side Stop, Black
Exclusiv online!

Suport Lansete Carp Expert Asimetric Side Stop, Black

79639263
Livrare 24-48 ore

5,41Lei

Surub Momeala Nash Zig Screw, Black, 6buc/plic
Exclusiv online!

Surub Momeala Nash Zig Screw, Black, 6buc/plic

t7850
Livrare 7-14 zile

34,25Lei

Teaser Black Cat Real Worm, Real Worm, 80g

Teaser Black Cat Real Worm, Real Worm, 80g

6244081
Livrare imediată!

109,50Lei

Agrafa VMC 3536 Black/Nickel Nr.2, 10buc/pac
Exclusiv online!

Agrafa VMC 3536 Black/Nickel Nr.2, 10buc/pac

3536bn 2 x10
Livrare 48-72ore

13,99Lei

Agrafa VMC 3538 Black/Nickel Nr.2, 10buc/pac
Exclusiv online!

Agrafa VMC 3538 Black/Nickel Nr.2, 10buc/pac

avm290173
Livrare 48-72ore

10,00Lei

Briceag Multifunctional TRUE UTILITY Smartknife , Black Oxide 420 Steel, Lama 5.50cm

Briceag Multifunctional TRUE UTILITY Smartknife , Black Oxide 420 Steel, Lama 5.50cm

tu6869
Livrare imediată!

103,30Lei

Briceag Multifunctional Victorinox Outrider, Black, 11.10cm
Exclusiv online!

Briceag Multifunctional Victorinox Outrider, Black, 11.10cm

0.8513.3
Livrare 48-72ore

351,50Lei

Cana Fox Black & Camo Head Ceramic Mug 350ml

Cana Fox Black & Camo Head Ceramic Mug 350ml

ccw024
Livrare imediată!

38,21Lei

Cana Fox Collection Green & Black Logo Ceramic Mug 350ml

Cana Fox Collection Green & Black Logo Ceramic Mug 350ml

ccw023
Livrare imediată!

38,00Lei

Carlige Gamakatsu LS-3310F, Black, nr.1.5, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.1.5, 25buc/plic

ls-3310f-1.5
Livrare 48-72 ore

28,20Lei

Carlige Gamakatsu LS-3310F, Black, nr.12, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.12, 25buc/plic

ls-3310f-012
Livrare 48-72 ore

18,50Lei

Carlige Gamakatsu LS-3310F, Black, nr.2, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.2, 25buc/plic

ls-3310f-002
Livrare 48-72 ore

25,80Lei

Carlige Gamakatsu LS-3310F, Black, nr.2/0, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.2/0, 25buc/plic

ls-3310f-200
Livrare 48-72 ore

32,50Lei

Carlige Gamakatsu LS-3310F, Black, nr.5, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.5, 25buc/plic

ls-3310f-005
Livrare 48-72 ore

20,10Lei

Carlige Gamakatsu LS-3310F, Black, nr.6, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.6, 25buc/plic

ls-3310f-006
Livrare 48-72 ore

18,50Lei

Cicada Konger Viber Black Ridge 001, 3g
Exclusiv online!

Cicada Konger Viber Black Ridge 001, 3g

130606381300001
Livrare 48-72 ore

28,17Lei

Cicada Konger Viber Black Ridge 001, 6g
Exclusiv online!

Cicada Konger Viber Black Ridge 001, 6g

130606381301001
Livrare 48-72 ore

28,68Lei

Creatura Black Cat Calamar U-float, Natural, 20g

Creatura Black Cat Calamar U-float, Natural, 20g

5550001
Livrare imediată!

49,69Lei

Cutie Sakura SK-9312 Black 20.5x14.5x6cm
Exclusiv online!

Cutie Sakura SK-9312 Black 20.5x14.5x6cm

90934sapab0011
Livrare 48-72 ore

36,58Lei

Fir Monofilament Konger Team Carp Black 0.22mm, 6.6kg, 1000m
Exclusiv online!

Fir Monofilament Konger Team Carp Black 0.22mm, 6.6kg, 1000m

110106228001022
Livrare 48-72 ore

35,18Lei

Afişare 2701 - 2720 din 4757 (238 pagini)
Queries: 8, Total time: 132.267 ms [By time] [By id] [By file]
1 (0.191)
SELECT data
FROM `oc_session`
WHERE session_id = 'f680025d759bbf56cd2c7273a2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (111.653)
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('+black' 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 (19.780)
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 2700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.155)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.130)
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