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


Soc Intern Fair TC XP70 1/4 CAL 12
Exclusiv online!

Soc Intern Fair TC XP70 1/4 CAL 12

vf.soc.xp70.12.4
Livrare 24-48 ore

198,68Lei

Covoras Coghlans pentru Incaltaminte, 71x46cm
Exclusiv online!

Covoras Coghlans pentru Incaltaminte, 71x46cm

c0690
Livrare 24-48 ore

73,99Lei

CUTIE CU VARNISURI SILICONICE 0.6-0.7-0.8-0.9-1MM

CUTIE CU VARNISURI SILICONICE 0.6-0.7-0.8-0.9-1MM

64-16230
Livrare imediată!

7,50Lei

Elastic Trabucco Power Gum, 1.00mm, 10m

Elastic Trabucco Power Gum, 1.00mm, 10m

102-81-010
Livrare imediată!

19,00Lei

FEEDER GUM MARO FL 10M 0.6MM

FEEDER GUM MARO FL 10M 0.6MM

65-25796
Livrare imediată!

8,90Lei

FEEDER GUM MARO FL 10M 1.0MM

FEEDER GUM MARO FL 10M 1.0MM

65-25819
Livrare imediată!

8,90Lei

Kit Trakker Gazebo Door Pole Kit

Kit Trakker Gazebo Door Pole Kit

201640
Livrare imediată!

174,95Lei

Pluta Abu Garcia Bombarda Float Stop, Clear, 20g

Pluta Abu Garcia Bombarda Float Stop, Clear, 20g

1110078
Livrare imediată!

18,71Lei

Prosop Daiwa 28x20cm
Exclusiv online!

Prosop Daiwa 28x20cm

d.15803.060
Livrare 24-48 ore

35,39Lei

Prosop pentru Racorire Coghlans
Exclusiv online!

Prosop pentru Racorire Coghlans

c2036
Livrare 24-48 ore

55,00Lei

Capsula Etansa din Aluminiu S Coghlans
Exclusiv online!

Capsula Etansa din Aluminiu S Coghlans

c1970
Livrare 24-48 ore

22,00Lei

FEEDER GUM TRANSPARENT FL 10M 0.8MM

FEEDER GUM TRANSPARENT FL 10M 0.8MM

65-25772
Livrare imediată!

8,90Lei

Suport Coghlans pentru 12 Oua
Exclusiv online!

Suport Coghlans pentru 12 Oua

c511a
Livrare 24-48 ore

30,00Lei

Capsula Etansa din Aluminiu L Coghlans
Exclusiv online!

Capsula Etansa din Aluminiu L Coghlans

c1976
Livrare 24-48 ore

35,00Lei

Degorjor Carp Zoom Cu Ac 8502, 1buc/plic
Exclusiv online!

Degorjor Carp Zoom Cu Ac 8502, 1buc/plic

cz2360
Livrare 48-72 ore

13,99Lei

FEEDER GUM TRANSPARENT FL 10M 0.6MM

FEEDER GUM TRANSPARENT FL 10M 0.6MM

65-25765
Livrare imediată!

8,90Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

1110089
Livrare imediată!

9,50Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 25g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 25g

1110091
Livrare imediată!

9,50Lei

Prosop Feeder Bait Black Yellow
Exclusiv online!

Prosop Feeder Bait Black Yellow

fb-prosop
Livrare 48-72 ore

79,00Lei

Prosop Steg 60x40cm
Exclusiv online!

Prosop Steg 60x40cm

8100-298
Livrare 48-72 ore

27,00Lei

Afişare 61 - 80 din 863 (44 pagini)
Queries: 6, Total time: 21.076 ms [By time] [By id] [By file]
1 (0.538)
SELECT data
FROM `oc_session`
WHERE session_id = '9ec5575130e4a5ada1d55ff71d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (16.674)
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('+diverse' 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 (3.479)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.126)
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