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


PLUMBI, COLMIC, OLIVETA, SUPREME, 0.80gr, tos0080, Plumbi Stationar, Plumbi Stationar Colmic, Colmic
Exclusiv online!

PLUMBI, COLMIC, OLIVETA, SUPREME, 0.80gr, tos0080, Plumbi Stationar, Plumbi Stationar Colmic, Colmic

tos0080
Livrare 48-72 ore

16,51Lei

CUTIE, PLUMBI, COLMIC, 6, ALICE, 6, COMPARTIMENTE, 90gr, pomap6, Plumbi Stationar, Plumbi Stationar Jaxon, Jaxon
Exclusiv online!

CUTIE, PLUMBI, COLMIC, 6, ALICE, 6, COMPARTIMENTE, 90gr, pomap6, Plumbi Stationar, Plumbi Stationar Jaxon, Jaxon

pomap6
Livrare 48-72 ore

32,00Lei

Kit Montura Jaxon Plumb Pierdut

Kit Montura Jaxon Plumb Pierdut

ac-356411
Livrare imediată!

4,50Lei

PLUMB KORDA BIG GRIPPA CU VARTEJ 113G
Exclusiv online!

PLUMB KORDA BIG GRIPPA CU VARTEJ 113G

a3.kbg4
Livrare 24-48 ore

10,57Lei

Con Plumb Pierdut Nash Lead Clip, Silt, 10buc/plic -30%

Con Plumb Pierdut Nash Lead Clip, Silt, 10buc/plic

t8424
Livrare imediată!

19,99Lei(-30%) 13,99Lei

PLUMB, EXTRA, CARP, GRIPPA, CU, VARTEJ, NEGRU, 140Gr, ec4929, Plumbi Crap, Plumbi Crap Extra Carp, Extra Carp
Plumbi Fox Camotex Impact Inline 142g - 1buc/set -29%

Plumbi Fox Camotex Impact Inline 142g - 1buc/set

cld234
Livrare imediată!

11,14Lei(-29%) 7,90Lei

Geanta, Delphin, Area, Lead, Carpath, 420220230, Genti pentru Plumbi, Genti pentru Plumbi Delphin, Delphin

Geanta, Delphin, Area, Lead, Carpath, 420220230, Genti pentru Plumbi, Genti pentru Plumbi Delphin, Delphin

420220230
Livrare imediată!

108,00Lei

PLUMBI COLMIC OLIVETA JAZ 2.25gr
Exclusiv online!

PLUMBI COLMIC OLIVETA JAZ 2.25gr

toj0225
Livrare 48-72 ore

23,00Lei

PLUMB CU SPINI JAXON ANTIALUNECARE 80GR

PLUMB CU SPINI JAXON ANTIALUNECARE 80GR

ce-aax080
Livrare imediată!

12,00Lei

Plumb Energo Team Betisor Tirolez 20g

Plumb Energo Team Betisor Tirolez 20g

52290020
Livrare imediată!

3,50Lei

PLUMB ENERGOTEAM DROP SHOT CU VARTEJ 10G

PLUMB ENERGOTEAM DROP SHOT CU VARTEJ 10G

59216010
Livrare imediată!

3,00Lei

MOMITOR, CU, PLUMB, JAXON, 15GR, 7.5cm, , aj-035m, Momitoare Crap, Momitoare Crap Jaxon, Jaxon

MOMITOR, CU, PLUMB, JAXON, 15GR, 7.5cm, , aj-035m, Momitoare Crap, Momitoare Crap Jaxon, Jaxon

aj-035m
Livrare imediată!

12,00Lei

MOMITOR, JAXON, CU, PLUMB, 2X10GR, 7.5cm, 25BUC/SET, aj-031, Momitoare Crap, Momitoare Crap Jaxon, Jaxon
Exclusiv online!

MOMITOR, JAXON, CU, PLUMB, 2X10GR, 7.5cm, 25BUC/SET, aj-031, Momitoare Crap, Momitoare Crap Jaxon, Jaxon

aj-031
Livrare 48-72 ore

138,00Lei

PLUMB CARP ZOOM FANATIC HEAVY 120GR
Exclusiv online!

PLUMB CARP ZOOM FANATIC HEAVY 120GR

cz1329
Livrare 48-72 ore

13,99Lei

PLUMB JAXON DROP SHOT CU VARTEJ 3GR

PLUMB JAXON DROP SHOT CU VARTEJ 3GR

cp-ds03
Livrare imediată!

9,00Lei

PLUMBI COLMIC SFERA CALIBRATA 0.80gr
Exclusiv online!

PLUMBI COLMIC SFERA CALIBRATA 0.80gr

posfe01a
Livrare 48-72 ore

24,00Lei

SONDA COLMIC ADANCIME NEOPREN 20gr
Exclusiv online!

SONDA COLMIC ADANCIME NEOPREN 20gr

son20
Livrare 48-72 ore

15,01Lei

PLUMB JIGGING JAXON 25GR 2BUC/PLIC -30%
Exclusiv online!

PLUMB JIGGING JAXON 25GR 2BUC/PLIC

ce-ab25
Livrare 48-72 ore

4,61Lei(-30%) 3,20Lei

WAGLER MAVER TRANSPARENT PLUMBAT 4BB

WAGLER MAVER TRANSPARENT PLUMBAT 4BB

h1418
Livrare imediată!

10,50Lei

Afişare 661 - 680 din 2166 (109 pagini)
Queries: 5, Total time: 226.640 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = 'b2660ff78bb7a40cc75a3484f5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (218.008)
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 "%plumb%") 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 (8.274)
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 660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.170)
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