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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


VARTEJ CU CARABINA SNAP NR 6 MAVER

VARTEJ CU CARABINA SNAP NR 6 MAVER

1489006
Stoc epuizat

12,50Lei

PLUMB BETISOR JAXON CU VARTEJ 6GR 2BUC/PLIC

PLUMB BETISOR JAXON CU VARTEJ 6GR 2BUC/PLIC

ck-aa06
Stoc epuizat

7,00Lei

CARABINA SNAP COLMIC CU VARTEJ 22

CARABINA SNAP COLMIC CU VARTEJ 22

gm300322
Stoc epuizat

9,50Lei

VARTEJ CU CARABINA JAXON INTERLOCK NR 20

VARTEJ CU CARABINA JAXON INTERLOCK NR 20

aj-ka10220c
Stoc epuizat

4,50Lei

VARTEJ STRONG NR 22 - 6 KG MAVER

VARTEJ STRONG NR 22 - 6 KG MAVER

1535022
Stoc epuizat

4,50Lei

PLUMB TRAPEZ CU VARTEJ JAXON VERDE 80GR 1BUC/PLIC

PLUMB TRAPEZ CU VARTEJ JAXON VERDE 80GR 1BUC/PLIC

cp-0006080g
Stoc epuizat

12,50Lei

VARTEJ JAXON BARREL CU AGRAFA POWER MAX NR 2

VARTEJ JAXON BARREL CU AGRAFA POWER MAX NR 2

aj-ka11002n
Stoc epuizat

7,00Lei

AGRAFA+VARTEJ DAIWA TYPE.2 NR.4/10,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA TYPE.2 NR.4/10,0KG/10BUC/PL

a7.14905.304
Stoc epuizat

11,52Lei

VARTEJ CU CARABINA MAVER NR 18

VARTEJ CU CARABINA MAVER NR 18

1501018
Stoc epuizat

9,00Lei

VARTEJ ROLLING CU CARABINA NR 22 - 5 KG MAVER

VARTEJ ROLLING CU CARABINA NR 22 - 5 KG MAVER

1536022
Stoc epuizat

8,00Lei

VARTEJ SIMPLU NR 24 MAVER

VARTEJ SIMPLU NR 24 MAVER

1504024
Stoc epuizat

5,70Lei

PLUMB DROP SHOT JAXON CU VARTEJ 40GR

PLUMB DROP SHOT JAXON CU VARTEJ 40GR

cp-ds40
Stoc epuizat

13,99Lei

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 20 - 12 KG -30%

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 20 - 12 KG

1508020
Stoc epuizat

18,00Lei(-30%) 12,60Lei

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 12 - 20 KG -30%

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 12 - 20 KG

1508012
Stoc epuizat

19,50Lei(-30%) 13,60Lei

Agrafa cu Vartej MAVER UNIVERSAL NR 24

Agrafa cu Vartej MAVER UNIVERSAL NR 24

1515024
Stoc epuizat

6,00Lei

Vartej Sunset ST Rolling Titanium ST-S-1007 Nr2 43kg

Vartej Sunset ST Rolling Titanium ST-S-1007 Nr2 43kg

412011180
Stoc epuizat

7,79Lei

VARTEJ CU CARABINA MAVER NR 20

VARTEJ CU CARABINA MAVER NR 20

1501020
Stoc epuizat

9,00Lei

PLUMB LONGCAST JAXON CU VARTEJ VERDE 90GR -30%

PLUMB LONGCAST JAXON CU VARTEJ VERDE 90GR

cp-003290g
Stoc epuizat

8,70Lei(-30%) 6,10Lei

VARTEJ STRONG JAXON CU AGRAFA HOOK NR 8

VARTEJ STRONG JAXON CU AGRAFA HOOK NR 8

aj-ka10408c
Stoc epuizat

7,50Lei

VARTEJ CU CARABINA MAVER UNIVERSAL NR 20

VARTEJ CU CARABINA MAVER UNIVERSAL NR 20

1515020
Stoc epuizat

6,00Lei

Afişare 1521 - 1540 din 1798 (90 pagini)
Queries: 5, Total time: 31.403 ms [By time] [By id] [By file]
1 (0.141)
SELECT data
FROM `oc_session`
WHERE session_id = '5ea30d3eb080212da96ae39614'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (30.870)
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('+vartej' 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
5 (0.150)
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