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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Vartej Rapid cu Anou Prologic 15buc/pac

Vartej Rapid cu Anou Prologic 15buc/pac

a.pro.49932
Stoc epuizat

31,57Lei

BLUZA FLECE GNT PRO MICRO XL

BLUZA FLECE GNT PRO MICRO XL

049-28-300
Stoc epuizat

129,00Lei

Husa DAM Effzett Pro-Tact Single Rod Sleeve 150cm Up To 2.75m

Husa DAM Effzett Pro-Tact Single Rod Sleeve 150cm Up To 2.75m

9052971261
Stoc epuizat

125,35Lei

Lanseta Prologic XLNT Big Fish Feeder 3.90m 50-170g

Lanseta Prologic XLNT Big Fish Feeder 3.90m 50-170g

o.pro.60884
Stoc epuizat

272,20Lei

TUB SILICON PROLOGIC 1,5MM/2MM L 5CM 20BUC/P

TUB SILICON PROLOGIC 1,5MM/2MM L 5CM 20BUC/P

a.pro.49912
Stoc epuizat

11,66Lei

SEMI FIXED PROLOGIC RIG BUFFER RING 15BUC/PL

SEMI FIXED PROLOGIC RIG BUFFER RING 15BUC/PL

a.pro.49903
Stoc epuizat

9,42Lei

FIR TRABUCCO S FORCE XPS VELVET PRO CAST 0.18 3.34Kg 300M

FIR TRABUCCO S FORCE XPS VELVET PRO CAST 0.18 3.34Kg 300M

052-15-180
Stoc epuizat

34,00Lei

Lanseta Prologic C3 Fulcrum Spod / Marker 3.60m, 5.00lbs, 2seg

Lanseta Prologic C3 Fulcrum Spod / Marker 3.60m, 5.00lbs, 2seg

o.pro.72644
Stoc epuizat

1.007,11Lei

Twister Fox Rage Pro Grub UV Perch 8cm 1buc/pac -20%

Twister Fox Rage Pro Grub UV Perch 8cm 1buc/pac

npg009-bucxxx
Stoc epuizat

5,14Lei(-20%) 4,11Lei

Geanta DAM Effzett Pro-Tact Streetfishing Bag 27.5x18.5x4.5cm 2 M Lure Cases

Geanta DAM Effzett Pro-Tact Streetfishing Bag 27.5x18.5x4.5cm 2 M Lure Cases

9042971257
Stoc epuizat

293,73Lei

Geanta DAM Effzett Pro-Tact Spinning Bag 27.5x18.5x4.5cm 4 M Lure Cases

Geanta DAM Effzett Pro-Tact Spinning Bag 27.5x18.5x4.5cm 4 M Lure Cases

9042971252
Stoc epuizat

463,92Lei

BLUZA FLECE GNT PRO MICRO M

BLUZA FLECE GNT PRO MICRO M

049-28-100
Stoc epuizat

129,00Lei

Grub Fox Rage Pro Fire Tiger 8cm 1buc/pac -20%

Grub Fox Rage Pro Fire Tiger 8cm 1buc/pac

nsl1107-bucxxx
Stoc epuizat

5,11Lei(-20%) 4,08Lei

BLUZA FLECE GNT PRO MICRO L

BLUZA FLECE GNT PRO MICRO L

049-28-200
Stoc epuizat

129,00Lei

GEANTA GURU EVA FUSION BAIT PRO

GEANTA GURU EVA FUSION BAIT PRO

a4.gu.glg019
Stoc epuizat

417,98Lei

Grub Fox Rage Pro Bulk, Pike, 10cm, 1buc/pac -58%

Grub Fox Rage Pro Bulk, Pike, 10cm, 1buc/pac

npg038-bucxxx
Stoc epuizat

7,38Lei(-58%) 3,07Lei

Fir Monofilament PROLOGIC XLNT HP GREEN 0.35MM/8.1KG/1000M -40%

Fir Monofilament PROLOGIC XLNT HP GREEN 0.35MM/8.1KG/1000M

a.pro.57103
Stoc epuizat

86,87Lei(-40%) 52,12Lei

Lanseta Prologic XLNT Feeder 3.60m, 150g, 3seg

Lanseta Prologic XLNT Feeder 3.60m, 150g, 3seg

o.pro.60889
Stoc epuizat

250,91Lei

Grub Fox Rage Pro Bulk, Firetiger, 10cm, 1buc/pac -20%

Grub Fox Rage Pro Bulk, Firetiger, 10cm, 1buc/pac

npg035-bucxxx
Stoc epuizat

7,38Lei(-20%) 5,90Lei

Shad Fox Rage Pro Natural Classics 2 Fire Tiger 10cm

Shad Fox Rage Pro Natural Classics 2 Fire Tiger 10cm

nsl1321
Stoc epuizat

7,60Lei

Afişare 2881 - 2900 din 3891 (195 pagini)
Queries: 6, Total time: 106.994 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = 'e78ff19be43d438457f98757c2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (89.840)
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('+pro' 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 (16.630)
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 2880, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.146)
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