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


Heli-Chod PB Products Downforce Rubber & Beads X-Small 4buc/plic

Heli-Chod PB Products Downforce Rubber & Beads X-Small 4buc/plic

pb19230
Stoc epuizat

29,00Lei

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

40956387
Stoc epuizat

8,47Lei

VARTEJ CU CARABINA SNAP NR 6 MAVER

VARTEJ CU CARABINA SNAP NR 6 MAVER

1489006
Stoc epuizat

12,50Lei

VARTEJ CU CARABINA JAXON INTERLOCK NR 20

VARTEJ CU CARABINA JAXON INTERLOCK NR 20

aj-ka10220c
Stoc epuizat

4,50Lei

Agrafe rapide Delphin Crosslock B 04 BN NR.2/0

Agrafe rapide Delphin Crosslock B 04 BN NR.2/0

969b04200
Stoc epuizat

13,99Lei

MONTURA PROLOGIC 15CM CU CARLIG XC7 NR.4 2BUC

MONTURA PROLOGIC 15CM CU CARLIG XC7 NR.4 2BUC

a.pro.50106
Stoc epuizat

20,50Lei

TUB TUNGSTEN KORDA 2M

TUB TUNGSTEN KORDA 2M

a3.kdmts
Stoc epuizat

37,13Lei

Fir Delphin Fin HOOKLINE 6K Grass 20m 35lbs

Fir Delphin Fin HOOKLINE 6K Grass 20m 35lbs

500700235
Stoc epuizat

36,00Lei

Fir textil Climax CULT DURAMAX SHOCKLEADER 25m 15lb

Fir textil Climax CULT DURAMAX SHOCKLEADER 25m 15lb

9900-10006-014
Stoc epuizat

37,00Lei

MONTURA FOX CAMO LEADCORE POWER GRIP LEAD CLIP KWIK CHANGE LEADER 75CM 50LBS 3BUC/SET -20%

MONTURA FOX CAMO LEADCORE POWER GRIP LEAD CLIP KWIK CHANGE LEADER 75CM 50LBS 3BUC/SET

cac754
Stoc epuizat

31,27Lei(-20%) 25,03Lei

Montura Somn Madcat Golf Ball Snap-On Vertiball 100g -25%

Montura Somn Madcat Golf Ball Snap-On Vertiball 100g

12043165680
Stoc epuizat

50,44Lei(-25%) 37,90Lei

Agrafe Delphin A 02 BN NR.14

Agrafe Delphin A 02 BN NR.14

969a02014
Stoc epuizat

8,00Lei

Rig Crap DAM MAD Obstacle Rig Nr 1 25Lb

Rig Crap DAM MAD Obstacle Rig Nr 1 25Lb

711096873001
Stoc epuizat

14,15Lei

MONTURA PB KD RIG 08

MONTURA PB KD RIG 08

pb25042
Stoc epuizat

69,00Lei

Fir Delphin Fin HOOKLINE 6K Muddy 20m 35lbs

Fir Delphin Fin HOOKLINE 6K Muddy 20m 35lbs

500700135
Stoc epuizat

36,00Lei

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.20MM 10M

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.20MM 10M

34020020
Stoc epuizat

9,50Lei

Montura PB Bungy Rig Nr 8

Montura PB Bungy Rig Nr 8

pb25052
Stoc epuizat

18,50Lei

Fir Delphin FIN ARMADA SHOCK 40m 0.18mm 18kg

Fir Delphin FIN ARMADA SHOCK 40m 0.18mm 18kg

500722270
Stoc epuizat

95,00Lei

Kit Montura Prologic Plumb Pierdut Distance Leadclip & Tailrubber, 10 buc/plic

Kit Montura Prologic Plumb Pierdut Distance Leadclip & Tailrubber, 10 buc/plic

a.pro.49887
Stoc epuizat

22,78Lei

Riguri Korda Wide Gape X Loops Micro-Barbed NR6 18lbs 3buc/blister

Riguri Korda Wide Gape X Loops Micro-Barbed NR6 18lbs 3buc/blister

a.kcr121
Stoc epuizat

25,51Lei

Afişare 4201 - 4220 din 4595 (230 pagini)
Queries: 6, Total time: 113.354 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '1b849a4aa7caa008aa0ac35d24'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.144)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (94.591)
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('+monturi' 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 (18.230)
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 4200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.156)
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