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 300 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


Set, method, feeder, Filfishing, filex, 3+1buc/set, 40g, 50g, 60g, fil4439, Kit-uri Method Feeder, Kit-uri Method Feeder Filfishing, Filfishing
Agrafa Filex + Vartej Crane Swievel Castlock Snap, 40kg, Nr.3, 5buc/plic
Exclusiv online!

Agrafa Filex + Vartej Crane Swievel Castlock Snap, 40kg, Nr.3, 5buc/plic

fil1918
Livrare 48-72 ore

7,00Lei

Agrafa Filex + Vartej Crane Swievel Castlock Snap, 60kg, Nr.2/0, 5buc/plic
Exclusiv online!

Agrafa Filex + Vartej Crane Swievel Castlock Snap, 60kg, Nr.2/0, 5buc/plic

fil1895
Livrare 48-72 ore

9,00Lei

Agrafa, Filex, +, Vartej, cu, Rulment, BB, Swivel, &, Castlock, Snap,, Nr.6,, 70kg,, 5buc/plic, FIL2380, Agrafe Monturi, Agrafe Monturi Filfishing, Agrafe Filfishing, Monturi Filfishing, Filfishing
Agrafa, Filex, +, Vartej, cu, Rulment, BB, Swivel, &, Castlock, Snap,, Nr.5,, 55kg,, 5buc/plic, FIL2373, Agrafe Monturi, Agrafe Monturi Filfishing, Agrafe Filfishing, Monturi Filfishing, Filfishing
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, fil3011, Accesorii Diverse Stationar, Accesorii Diverse Stationar Filfishing, Filfishing
Suport cu Vas Filex Quick Change System pentru Picior de Scaun 25, 30, 36mm
Exclusiv online!

Suport cu Vas Filex Quick Change System pentru Picior de Scaun 25, 30, 36mm

fil9588
Livrare 48-72 ore

89,99Lei

Agrafa, Filex, +, Vartej, cu, Rulment, BB, Swivel, &, Castlock, Snap,, Nr.7,, 90kg,, 3buc/plic, FIL2397, Agrafe Monturi, Agrafe Monturi Filfishing, Agrafe Filfishing, Monturi Filfishing, Filfishing
Creatura Filex Super Soft Alb, 25mm, 5buc/pac
Exclusiv online!

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

13010780-7769
Livrare 48-72 ore

12,38Lei

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

Cutie Dubla Filex Pentru Voblere 27,5x15x5 cm

Cutie Dubla Filex Pentru Voblere 27,5x15x5 cm

fil0494
Livrare imediată!

42,99Lei

Agrafa Filex + Vartej Crane Swievel Castlock Snap, 50kg, Nr.1, 5buc/plic
Exclusiv online!

Agrafa Filex + Vartej Crane Swievel Castlock Snap, 50kg, Nr.1, 5buc/plic

fil1901
Livrare 48-72 ore

8,00Lei

Cutie, Accesorii, Filex, 12, Compartimente,, 25x19.5x4.5cm, fil9923, Cutii, Cutii Filfishing, Filfishing
Cutie Filex Dubla Pentru Voblere 21x17x5cm

Cutie Filex Dubla Pentru Voblere 21x17x5cm

fil0500
Livrare imediată!

32,00Lei

Cosulet Filfishing Filex Feeder L, 50g, 7x5cm
Exclusiv online!

Cosulet Filfishing Filex Feeder L, 50g, 7x5cm

fil3004
Livrare 48-72 ore

12,60Lei

Cutie, Accesorii, Filex, 14, Compartimente,, 19x13.4x3.8cm, fil0708, Cutii, Cutii Filfishing, Filfishing
Cutie, Accesorii, Filex, 9, Compartimente,, 19x15x3cm, fil9565, Cutii, Cutii Filfishing, Filfishing
Exclusiv online!

Cutie, Accesorii, Filex, 9, Compartimente,, 19x15x3cm, fil9565, Cutii, Cutii Filfishing, Filfishing

fil9565
Livrare 48-72 ore

11,00Lei

FIR TEXTIL NGT Filex GREEN 0.30MM 100M -19%

FIR TEXTIL NGT Filex GREEN 0.30MM 100M

30-7943
Livrare imediată!

49,50Lei(-19%) 39,90Lei

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

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

fil2427
Livrare 48-72 ore

8,50Lei

Afişare 101 - 120 din 220 (11 pagini)
Queries: 5, Total time: 207.880 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '9502e51974a65bd569965e7423'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (206.450)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%filex%") 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:698
4 (1.107)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.146)
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