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


TUB SILICONIC LINEAEFFE SUPER SOFT SIZE 1.00M D 2.00mm

TUB SILICONIC LINEAEFFE SUPER SOFT SIZE 1.00M D 2.00mm

a.6630027
Stoc epuizat

11,84Lei

Montura Lineaeffe Helicopter Nr.4 23cm

Montura Lineaeffe Helicopter Nr.4 23cm

a.7602114
Stoc epuizat

10,15Lei

Lanseta Lineaeffe Deep Walker 150 2.10CM 150g 2SEG

Lanseta Lineaeffe Deep Walker 150 2.10CM 150g 2SEG

l.2230221
Stoc epuizat

145,80Lei

MANER MINCIOG LINEAEFFE DOUBLE TELE 3M

MANER MINCIOG LINEAEFFE DOUBLE TELE 3M

a2.6300730
Stoc epuizat

105,21Lei

INEL LINEAEFFE VIRF SIC TUB=3,0MM/D=12,0MM

INEL LINEAEFFE VIRF SIC TUB=3,0MM/D=12,0MM

a9.2999884
Stoc epuizat

7,90Lei

TUB SILICONIC LINEAEFFE L=30CM 4BUC/PLIC

TUB SILICONIC LINEAEFFE L=30CM 4BUC/PLIC

a.6630003
Stoc epuizat

14,70Lei

TUB SILICONIC LINEAEFFE SUPER SOFT SIZE 1.00M D 1.5mm

TUB SILICONIC LINEAEFFE SUPER SOFT SIZE 1.00M D 1.5mm

a.6630025
Stoc epuizat

7,90Lei

INEL LINEAEFFE VIRF SIC TUB=2,5MM/D=10,0MM

INEL LINEAEFFE VIRF SIC TUB=2,5MM/D=10,0MM

a9.2999882
Stoc epuizat

5,06Lei

SHAD LINEAEFFE NOMURA ROLLING 10CM/9G BLUE GREEN CHART 10BUC/PL

SHAD LINEAEFFE NOMURA ROLLING 10CM/9G BLUE GREEN CHART 10BUC/PL

f1.nm.70100810
Stoc epuizat

34,13Lei

OCHELARI LINEAEFFE POLARIZANTI

OCHELARI LINEAEFFE POLARIZANTI

a8.9800012
Stoc epuizat

153,28Lei

Lanseta Lineaeffe XTR Carp MT 3.60m 3lbs 2SEG

Lanseta Lineaeffe XTR Carp MT 3.60m 3lbs 2SEG

l.2724037
Stoc epuizat

73,67Lei

LANSETA LINEAEFE FLY STREAM 2.55M CL.5.6

LANSETA LINEAEFE FLY STREAM 2.55M CL.5.6

l.2862255
Stoc epuizat

86,54Lei

MINCIOG LINEAEFFE TELESCOPIC 2,60M -30%

MINCIOG LINEAEFFE TELESCOPIC 2,60M

a2.m6101600
Stoc epuizat

122,53Lei(-30%) 85,78Lei

MULINETA LINEAEFFE VIGOR XTM FREE 4000 3RUL/485MX040MM/5,2:1 -30%

MULINETA LINEAEFFE VIGOR XTM FREE 4000 3RUL/485MX040MM/5,2:1

l.1289304
Stoc epuizat

105,98Lei(-30%) 74,18Lei

MULINETA LINEAEFFE VIGOR PRIME 4000 FD 1RUL/175MX030MM/5,2:1 -20%

MULINETA LINEAEFFE VIGOR PRIME 4000 FD 1RUL/175MX030MM/5,2:1

l.1206740
Stoc epuizat

61,59Lei(-20%) 49,28Lei

MULINETA LINEAEFFE VIGOR POP FD 1000 1RUL/320MX015MM/5,5:1

MULINETA LINEAEFFE VIGOR POP FD 1000 1RUL/320MX015MM/5,5:1

l.1207510
Stoc epuizat

28,85Lei

Vartej Lineaeffe cu Rulment nr.8 5buc/plic -30%

Vartej Lineaeffe cu Rulment nr.8 5buc/plic

a7.8001208b
Stoc epuizat

28,35Lei(-30%) 19,84Lei

SUPORT U LINEAEFFE FLEXIBIL PENTRU LANSETA

SUPORT U LINEAEFFE FLEXIBIL PENTRU LANSETA

a6.6313076
Stoc epuizat

10,27Lei

MULINETA LINEAEFFE VIGOR PRIME 1000 FD 1RUL/235MX018MM/5,5:1 -20%

MULINETA LINEAEFFE VIGOR PRIME 1000 FD 1RUL/235MX018MM/5,5:1

l.1206710
Stoc epuizat

56,68Lei(-20%) 45,34Lei

BULDO LINEAEFFE OVAL TRANSPARENT SMALL 20g

BULDO LINEAEFFE OVAL TRANSPARENT SMALL 20g

a.4900000
Stoc epuizat

4,76Lei

Afişare 681 - 700 din 714 (36 pagini)
Queries: 4, Total time: 18.236 ms [By time] [By id] [By file]
1 (0.172)
SELECT data
FROM `oc_session`
WHERE session_id = 'd3d09aa9dc5a83ab4f92a615f4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.120)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.775)
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 = '2' AND (MATCH(pd.tag) AGAINST('+lineaeffe' 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 (0.169)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38