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


OPRITOR CAUCIUC KORDA CU PROTECTIE NOD D=4MM/25BUCATI/PLIC

OPRITOR CAUCIUC KORDA CU PROTECTIE NOD D=4MM/25BUCATI/PLIC

a.k4rbg
Livrare imediată!

16,68Lei

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 2G

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 2G

a1.4593020
Livrare imediată!

4,76Lei

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 3G

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 3G

a1.4593030
Livrare imediată!

4,76Lei

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 4G -18%

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 4G

a1.4593040
Livrare imediată!

4,76Lei(-18%) 3,90Lei

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 5G

PLUTA LINEAEFE PVC CULISANTA PORTSTARLITA D=4,5MM 5G

a1.4593050
Livrare imediată!

4,76Lei

VIRF LINEAEFE CARBON L=100CM D=4,50/1,5MM

VIRF LINEAEFE CARBON L=100CM D=4,50/1,5MM

l.2979949
Livrare imediată!

30,79Lei

VIRF LINEAEFE CARBON L=100CM D=4,20/1,5MM

VIRF LINEAEFE CARBON L=100CM D=4,20/1,5MM

l.2979948
Livrare imediată!

32,89Lei

VIRF LINEAEFE CARBON L=100CM D=4,80/1,50MM
Exclusiv online!

VIRF LINEAEFE CARBON L=100CM D=4,80/1,50MM

l.2979952
Livrare 24-48 ore

34,44Lei

Juvelnic Lineaeffe Rotund D=40cm 1.5m

Juvelnic Lineaeffe Rotund D=40cm 1.5m

a2.j6201440
Livrare imediată!

37,57Lei

Juvelnic Lineaeffe Rotund D=40cm 2m

Juvelnic Lineaeffe Rotund D=40cm 2m

a2.j6201441
Livrare imediată!

43,83Lei

Opritor Lineaeffe Din Cauciuc 10buc/plic D=4mm

Opritor Lineaeffe Din Cauciuc 10buc/plic D=4mm

a.4960500
Livrare imediată!

6,21Lei

VIRF LINEAEFE CARBON L=100CM D=4,68/1,50MM

VIRF LINEAEFE CARBON L=100CM D=4,68/1,50MM

l.2979950
Livrare imediată!

36,53Lei

INEL LINEAEFFE VIRF TITAN TUB=0,8MM/D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VIRF TITAN TUB=0,8MM/D=4MM

a9.3000208
Livrare 24-48 ore

3,95Lei(-30%) 2,77Lei

VIRF LINEAEFE FIBRA L=60CM D=4,0/0,7MM
Exclusiv online!

VIRF LINEAEFE FIBRA L=60CM D=4,0/0,7MM

l.2980061
Livrare 24-48 ore

7,31Lei

INEL LINEAEFFE VARF TITAN TUB=1.0MM D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=1.0MM D=4MM

a9.3000210
Livrare 24-48 ore

4,50Lei(-30%) 3,15Lei

INEL LINEAEFFE 1 PICIOR SIC D=4.0MM -30%
Exclusiv online!

INEL LINEAEFFE 1 PICIOR SIC D=4.0MM

a9.2999204
Livrare 24-48 ore

3,39Lei(-30%) 2,37Lei

INEL LINEAEFFE VARF TITAN TUB=1.6MM D=4MM
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=1.6MM D=4MM

a9.3000216
Livrare 24-48 ore

3,37Lei

INEL LINEAEFFE VARF TITAN TUB=0.9MM D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=0.9MM D=4MM

a9.3000209
Livrare 24-48 ore

3,96Lei(-30%) 2,77Lei

INEL LINEAEFFE VARF TITAN TUB=0.7MM D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=0.7MM D=4MM

a9.3000207
Livrare 24-48 ore

3,96Lei(-30%) 2,77Lei

INEL LINEAEFFE VARF TITAN TUB=2.0MM D=4MM -30%
Exclusiv online!

INEL LINEAEFFE VARF TITAN TUB=2.0MM D=4MM

a9.3000220
Livrare 24-48 ore

4,50Lei(-30%) 3,15Lei

Afişare 1 - 20 din 25 (2 pagini)
Queries: 5, Total time: 598.008 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = '6ef0fe9f55fa8cf4bb0553bb91'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (597.209)
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 "%d=4%") 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 (0.424)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.124)
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