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


Shad Konger Blinky, 011 Ghost, 5cm, 12buc/pac
Exclusiv online!

Shad Konger Blinky, 011 Ghost, 5cm, 12buc/pac

130106337000011
Livrare 48-72 ore

18,99Lei

Sistem Masurare Distanta Konger Specialist Distance Sticks, 60cm, 5m
Exclusiv online!

Sistem Masurare Distanta Konger Specialist Distance Sticks, 60cm, 5m

42106970006079
Livrare 48-72 ore

85,12Lei

Spinnertail Konger Boogie, 001 Black Ridge, 10g
Exclusiv online!

Spinnertail Konger Boogie, 001 Black Ridge, 10g

131606381102001
Livrare 48-72 ore

30,33Lei

Varga Konger Grafitex Pole 6.00m, 5-20gr, 6seg
Exclusiv online!

Varga Konger Grafitex Pole 6.00m, 5-20gr, 6seg

10106143002600
Livrare 48-72 ore

132,71Lei

Monofilament Konger Techron Soft Nylon 150m 0.10mm
Exclusiv online!

Monofilament Konger Techron Soft Nylon 150m 0.10mm

218150010
Livrare 48-72 ore

22,49Lei

Monofilament Konger Techron Soft Nylon 150m 0.12mm -40%

Monofilament Konger Techron Soft Nylon 150m 0.12mm

218150012
Livrare imediată!

23,32Lei(-40%) 13,90Lei

Monofilament Konger Steelon Soft Line 150m 0.22mm -44%

Monofilament Konger Steelon Soft Line 150m 0.22mm

219150022
Livrare imediată!

12,32Lei(-44%) 6,90Lei

Monofilament Konger Techron Fluorocarbon 100M 0.25MM
Exclusiv online!

Monofilament Konger Techron Fluorocarbon 100M 0.25MM

209100025
Livrare 48-72 ore

130,26Lei

Multifilament Konger Techron Olive 100m 0.06mm
Exclusiv online!

Multifilament Konger Techron Olive 100m 0.06mm

259100006
Livrare 48-72 ore

140,00Lei

Monofilament Konger Techron Fluorocarbon 100M 0.22MM
Exclusiv online!

Monofilament Konger Techron Fluorocarbon 100M 0.22MM

209100020
Livrare 48-72 ore

126,12Lei

Fir Textil Konger Rigging Line Braider X8 Black, 10m, 0.12mm, 11.8kg
Exclusiv online!

Fir Textil Konger Rigging Line Braider X8 Black, 10m, 0.12mm, 11.8kg

110806250013012
Livrare 48-72 ore

9,81Lei

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.30mm, 12.1kg, 150m
Exclusiv online!

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.30mm, 12.1kg, 150m

110706257150030
Livrare 48-72 ore

18,10Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.35mm, 13.5kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.35mm, 13.5kg

110106229001035
Livrare 48-72 ore

48,05Lei

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.22mm, 6.65kg

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.22mm, 6.65kg

110706240050022
Livrare imediată!

5,99Lei

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.08mm, 7.6kg
Exclusiv online!

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.08mm, 7.6kg

110806250012008
Livrare 48-72 ore

9,56Lei

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.28mm, 10.5kg, 150m

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.28mm, 10.5kg, 150m

110706257150028
Livrare imediată!

18,10Lei

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.14mm, 3.35kg

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.14mm, 3.35kg

110706240050014
Livrare imediată!

5,99Lei

Montura Somn Konger Dread Cat Hakami 80cm, 36.3kg, Carlig Nr.6/0, 1buc/pac
Exclusiv online!

Montura Somn Konger Dread Cat Hakami 80cm, 36.3kg, Carlig Nr.6/0, 1buc/pac

120406865100002
Livrare 48-72 ore

39,70Lei

Cicada Konger Viber Blue Ridge 002, 9g
Exclusiv online!

Cicada Konger Viber Blue Ridge 002, 9g

130606381302002
Livrare 48-72 ore

29,06Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.40mm, 15.3kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.40mm, 15.3kg

110106229001040
Livrare 48-72 ore

56,33Lei

Afişare 161 - 180 din 413 (21 pagini)
Queries: 5, Total time: 701.526 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '79ad54d0145bda4fe66641f91c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (699.192)
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 "%konger%") 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:724
4 (2.020)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.100)
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