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


Inele Elastice Matrix Super Soft Bait Bands Medium 100pcs

Inele Elastice Matrix Super Soft Bait Bands Medium 100pcs

gac454
Livrare imediată!

11,21Lei

Lanseta Energoteam Kamasaki Super Tele 3.00m, 60-120g

Lanseta Energoteam Kamasaki Super Tele 3.00m, 60-120g

13591300
Livrare imediată!

96,00Lei

Montura Orange cu Momitor Triangular 30gr si 2 Carlige Carp Super Method Nr.4

Montura Orange cu Momitor Triangular 30gr si 2 Carlige Carp Super Method Nr.4

40541mf2930
Livrare imediată!

19,05Lei

Aroma Lichida Bait Tech Super Sprays Savoury, 10ml

Aroma Lichida Bait Tech Super Sprays Savoury, 10ml

bt-supe02
Livrare imediată!

15,00Lei

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Super Narrow, 18mm x 4m -43%

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Super Narrow, 18mm x 4m

t8663
Livrare imediată!

78,99Lei(-43%) 44,90Lei

Pilker Rhino Trout Killer Super Shiner 8,5cm, 12gr -48%

Pilker Rhino Trout Killer Super Shiner 8,5cm, 12gr

3397047
Livrare imediată!

26,78Lei(-48%) 13,90Lei

Rezerva Plasa Protectie Nash Claw Cracker Bait Mesh Refill Super Narrow, 18mm x 7.5m -39%

Rezerva Plasa Protectie Nash Claw Cracker Bait Mesh Refill Super Narrow, 18mm x 7.5m

t8674
Livrare imediată!

38,98Lei(-39%) 23,90Lei

Set Varnis Pluta Filex Super Soft Rotund Marime S, 5 Compartimente
Exclusiv online!

Set Varnis Pluta Filex Super Soft Rotund Marime S, 5 Compartimente

fil3455
Livrare 48-72 ore

6,50Lei

Set Varnis Pluta Filex Super Soft, Plumbi Moi, 7 Compartimente
Exclusiv online!

Set Varnis Pluta Filex Super Soft, Plumbi Moi, 7 Compartimente

fil3011
Livrare 48-72 ore

12,99Lei

Swimbait Fox Rage Replicant Catfish Super Natural Albino Catfish 20cm, 110g

Swimbait Fox Rage Replicant Catfish Super Natural Albino Catfish 20cm, 110g

nre191
Livrare imediată!

62,96Lei

Aroma Lichida Bait Tech Super Sprays Dulce, 10ml

Aroma Lichida Bait Tech Super Sprays Dulce, 10ml

bt-supe03
Livrare imediată!

15,00Lei

Carlig Guru Super Fine Pole Barbed, Nr.18, 10buc/plic
Exclusiv online!

Carlig Guru Super Fine Pole Barbed, Nr.18, 10buc/plic

gu.gsfp20
Livrare 24-48 ore

11,53Lei

Creatura Filex Super Soft Orange, 25mm, 5buc/pac
Exclusiv online!

Creatura Filex Super Soft Orange, 25mm, 5buc/pac

13010780-7776
Livrare 48-72 ore

12,38Lei

Fir Monofilament Sufix Super 21 300m, 0.20mm, 3.50kg
Exclusiv online!

Fir Monofilament Sufix Super 21 300m, 0.20mm, 3.50kg

ds1mm020024c9r
Livrare 48-72ore

39,00Lei

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG F1 - Dark
Exclusiv online!

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG F1 - Dark

s1770018
Livrare 7-14 zile

62,96Lei

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG Match Method Dark
Exclusiv online!

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG Match Method Dark

s1770021
Livrare 7-14 zile

62,96Lei

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG Super Carp Method Mix -20%
Exclusiv online!

GROUNDBAIT SONUBAITS SUPER CRUSH 2KG Super Carp Method Mix

s1770012
Livrare 7-14 zile

62,96Lei(-20%) 50,37Lei

Kit Plasa Solubila + Tija Compresie Nash Webcast PVA System Super Narrow, 18mm x 7m

Kit Plasa Solubila + Tija Compresie Nash Webcast PVA System Super Narrow, 18mm x 7m

t8660
Livrare imediată!

72,99Lei

Plumb Nash Super Flat Pear In-Line Lead 12oz, 340g
Exclusiv online!

Plumb Nash Super Flat Pear In-Line Lead 12oz, 340g

t2453
Livrare 7-14 zile

25,92Lei

Rezerva Plasa Solubila PVA Webcast PVA Refill Super Narrow, 18mm x 5m

Rezerva Plasa Solubila PVA Webcast PVA Refill Super Narrow, 18mm x 5m

t8666
Livrare imediată!

38,98Lei

Afişare 581 - 600 din 1192 (60 pagini)
Queries: 6, Total time: 34.223 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '51b721626ca7740721e172c763'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (28.422)
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('+super' 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 (5.167)
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 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.177)
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.195)
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