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

Produse ce potrivesc criteriilor de căutare


Cizme Treesco Percussion Cambridge Zip Neoprene Kaki, Marime 44

Cizme Treesco Percussion Cambridge Zip Neoprene Kaki, Marime 44

bt.1769.44
Stoc epuizat

700,70Lei

Cizme Treesco Percussion Cambridge Zip Neoprene Kaki, Marime 46

Cizme Treesco Percussion Cambridge Zip Neoprene Kaki, Marime 46

bt.1769.46
Stoc epuizat

700,70Lei

Vesta Blaser Endeavor Reversibila Olive Camo Marime M

Vesta Blaser Endeavor Reversibila Olive Camo Marime M

bl.231001.140.m
Stoc epuizat

905,03Lei

Cartusiera Arrow Tapel Deschisa Reglabila Piele Cal.12

Cartusiera Arrow Tapel Deschisa Reglabila Piele Cal.12

ve.t707rdm
Stoc epuizat

264,00Lei

Cartusiera Arrow Tapel Deschisa Reglabila Piele Cal.12, 25 Posturi

Cartusiera Arrow Tapel Deschisa Reglabila Piele Cal.12, 25 Posturi

ve.t707rd
Stoc epuizat

319,00Lei

Cartusiera Arrow Tapel Lux Reglabila Piele, Cal.12, 25 Posturi

Cartusiera Arrow Tapel Lux Reglabila Piele, Cal.12, 25 Posturi

ve.t710l
Stoc epuizat

380,00Lei

Cartusiera Arrow Tapel Mixta Cu Buzunar Piele

Cartusiera Arrow Tapel Mixta Cu Buzunar Piele

ve.t709b
Stoc epuizat

385,00Lei

Port Insigna Arrow Tapel Piele Cu Lant

Port Insigna Arrow Tapel Piele Cu Lant

ve.t756ln
Stoc epuizat

61,00Lei

Cartusiera Arrow Tapel Piele Cal.12, Verde

Cartusiera Arrow Tapel Piele Cal.12, Verde

ve.t710rpi.12.v
Stoc epuizat

325,00Lei

Cartusiera Arrow Tapel Piele Cal.20, Maro

Cartusiera Arrow Tapel Piele Cal.20, Maro

ve.t710rpi.20.r
Stoc epuizat

325,00Lei

Lanseta Shimano Vengeance CX Sensitive, 2.10m, 1-10g, 2seg -37%

Lanseta Shimano Vengeance CX Sensitive, 2.10m, 1-10g, 2seg

svcx21lssc
Stoc epuizat

280,00Lei(-37%) 175,00Lei

Lanseta Shimano Vengeance CX Sensitive, 2.10m, 3-15g, 2seg

Lanseta Shimano Vengeance CX Sensitive, 2.10m, 3-15g, 2seg

svcx21mlssc
Stoc epuizat

190,80Lei

Cartusiera Arrow Tapel Fixa Deschisa Piele, Cal.12

Cartusiera Arrow Tapel Fixa Deschisa Piele, Cal.12

ve.t707fd.12
Stoc epuizat

264,00Lei

CARTUSIERA NEOPREN JAKELE 6 POST GLONT

CARTUSIERA NEOPREN JAKELE 6 POST GLONT

vjk.3130006.001
Stoc epuizat

128,90Lei

Toc Arrow Tapel Piele Port Glont Simplu Elastic, 10 Posturi

Toc Arrow Tapel Piele Port Glont Simplu Elastic, 10 Posturi

ve.t794
Stoc epuizat

83,00Lei

Tolba Tapel Piele Piele Si Textil Model 1, 23x19x6cm

Tolba Tapel Piele Piele Si Textil Model 1, 23x19x6cm

ve.t720.1tex.mistret
Stoc epuizat

654,00Lei

Afişare 17561 - 17576 din 17576 (879 pagini)
Queries: 7, Total time: 739.873 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '6ab3738c004b9106ee8257596c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (664.882)
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 (pd.tag LIKE "%si%") 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
4 (74.293)
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 17560, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.197)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.177)
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