Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

PLUMB Trakko MAGIC GLOBE 1g

7008-1

Stoc epuizat

11,50Lei

PLUMB Trakko MAGIC GLOBE 3g

7008-3

Stoc epuizat

11,50Lei

PLUMBI CULISANTI CRALUSSO 8.0G 5buc/plic

54119080

Stoc epuizat

8,00Lei

PLUMB Trakko MAGIC GLOBE 2g

7008-2

Stoc epuizat

11,50Lei

PLUMBI PICATURA CRALUSSO 5G

54120050

Stoc epuizat

20,00Lei

-18%

Plumb Falcon Culisant cu Varnis Torrpille, 5buc/plic 1.50g

f25-5575

Stoc epuizat

5,50Lei(-18%) 4,50Lei

PLUMB KORDA SQUARE PEAR INLINE 70G 2BUC/PLIC

a3.ksqpib25

Stoc epuizat

18,83Lei

PLUMB KORDA CULISANT PLAT PARA 2.5 70G PT.MONT 2BUC/PLIC

a3.kfpib25

Stoc epuizat

18,80Lei

Cutie Alice de Plumb Despicate Mostiro 100g; 0.5g, 2.0g

mos-7301

Stoc epuizat

8,90Lei

-20%

Cutie Plumbi Maver Alice Elite Micro Super Soft, 5 compartimente

k845

Stoc epuizat

46,01Lei(-20%) 36,79Lei

SET PLUMBI PRESTON STOTZ SMALLER SIZES 6 WAY DISPENSER NR 8-13

p0220089

Stoc epuizat

62,96Lei

Set Plumbi Culisanti Filfishing 7 Compartimente, 0.75-3g

fil9886

Stoc epuizat

24,89Lei

Set Plumbi Culisanti cu Silicon Filfishing 7 Compartimente, 1-5g

fil6106

Stoc epuizat

31,90Lei

Set Varnis Pluta Filex Super Soft, Plumbi Moi, 7 Compartimente

fil3011

Stoc epuizat

12,99Lei

Plumbi Guru Lest Tungsten Olivete 1.00g, 5buc/pac

a3.gu.got003

Stoc epuizat

27,74Lei

Set Plumbi Culisanti Filfishing 7 Compartimente, 2-8g

fil9893

Stoc epuizat

25,89Lei

PLUMB MIKADO PICATURA CU TUB 3.5g 5buc

omc-01100-3.5

Stoc epuizat

4,00Lei

Alice Plumb Matrix Cube Shot Nr.8

gac427

Stoc epuizat

11,21Lei

Cutie Alice de Plumb Despicate Mostiro 40g; 0.65g, 2.0g

mos-7303

Stoc epuizat

5,00Lei

Plumbi Torpile Culisanti cu Silicon Filfishing, 10g, 5buc/pac

fil5674

Stoc epuizat

7,00Lei

Afişare 501 - 520 din 539 (27 pagini)

Queries: 9, Total time: 180.185 ms [By time] [By id] [By file]

1 (0.134)

SELECT data
FROM `oc_session`
WHERE session_id = '4d6c0ac554b651176e9a2a64c2'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.135)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.098)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (173.934)

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 = '0' AND ((pd.tag LIKE '%plumbi%' AND pd.tag LIKE '%stationar%')) 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:697

5 (0.294)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066

6 (5.250)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911

7 (0.112)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

8 (0.109)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.119)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare