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


Husa FL Camuflaj 1.45m 2 Compartimente

Husa FL Camuflaj 1.45m 2 Compartimente

7777035
Livrare imediată!

51,90Lei

Husa FL Camuflaj 1.15m 2 Compartimente

Husa FL Camuflaj 1.15m 2 Compartimente

5192146495347
Livrare imediată!

39,90Lei

HUSA MULTIFUNCTIONALA SHIMANO TRENCH STINK AND STICK BAG 140X23CM -21%

HUSA MULTIFUNCTIONALA SHIMANO TRENCH STINK AND STICK BAG 140X23CM

shttg11
Livrare imediată!

239,80Lei(-21%) 189,00Lei

Husa lansete Spro Double Camou 150x23x14cm; -23%

Husa lansete Spro Double Camou 150x23x14cm;

006204-01100-00000
Livrare imediată!

445,00Lei(-23%) 342,90Lei

Husa Pentru Navomodel Trakker NXG Bait Boat Bag, Medium, 76x46x28cm
Exclusiv online!

Husa Pentru Navomodel Trakker NXG Bait Boat Bag, Medium, 76x46x28cm

204961
Livrare 7-14 zile

624,95Lei

Husa pentru Navomodel Deluxe Smart Boat, Gri Camuflaj, 82x40x24cm -10%

Husa pentru Navomodel Deluxe Smart Boat, Gri Camuflaj, 82x40x24cm

5276230826146
Livrare imediată!

261,00Lei(-10%) 234,89Lei

Husa Pentru Navomodel Trakker NXG Bait Boat Bag, Large, 80x50x28cm
Exclusiv online!

Husa Pentru Navomodel Trakker NXG Bait Boat Bag, Large, 80x50x28cm

204962
Livrare 7-14 zile

649,95Lei

Husa Pentru Navomodel Deluxe Smart Boat, Verde Camuflaj, 82x40x24cm

Husa Pentru Navomodel Deluxe Smart Boat, Verde Camuflaj, 82x40x24cm

6276231204256
Livrare imediată!

261,00Lei

Husa FL Camuflaj 3 compartimente cu burta 135 cm Material Gros

Husa FL Camuflaj 3 compartimente cu burta 135 cm Material Gros

7777028
Livrare imediată!

81,10Lei

Husa FL Camuflaj 3 compartimente cu burta 145 cm Material Gros

Husa FL Camuflaj 3 compartimente cu burta 145 cm Material Gros

7777029
Livrare imediată!

86,30Lei

Husa Burduf FL Kaki 2 compartimente Material Gros 205 cm

Husa Burduf FL Kaki 2 compartimente Material Gros 205 cm

6111142456557
Livrare imediată!

156,90Lei

Husa FL Camuflaj 205cm Ieftina 2 Compartimente

Husa FL Camuflaj 205cm Ieftina 2 Compartimente

7777037
Livrare imediată!

60,00Lei

Husa FL Camuflaj 3 compartimente cu burta 162 cm Material Gros

Husa FL Camuflaj 3 compartimente cu burta 162 cm Material Gros

7777030
Livrare imediată!

91,50Lei

HUSA JGS PAT CARABINA CU CARTUSIERA 6 POSTURI
Exclusiv online!

HUSA JGS PAT CARABINA CU CARTUSIERA 6 POSTURI

vj.647.1
Livrare 24-48 ore

97,94Lei

HUSA WINCHESTER SEMIAUTOMATA SXR 124CM
Exclusiv online!

HUSA WINCHESTER SEMIAUTOMATA SXR 124CM

a8.bo.641908248
Livrare 24-48 ore

326,44Lei

HUSA GAMO ARMA+LUNETA L=125CM HARD
Exclusiv online!

HUSA GAMO ARMA+LUNETA L=125CM HARD

g.6212359
Livrare 24-48 ore

334,31Lei

HUSA ARROW PIELE CARABINA 130CM
Exclusiv online!

HUSA ARROW PIELE CARABINA 130CM

ve.npcb130
Livrare 24-48 ore

494,90Lei

HUSA PIELE CARABINA 120CM ARROW
Exclusiv online!

HUSA PIELE CARABINA 120CM ARROW

ve.npcb120
Livrare 24-48 ore

480,76Lei

Husa Burduf FL Kaki 2 compartimente Material Gros 145 cm

Husa Burduf FL Kaki 2 compartimente Material Gros 145 cm

7777054
Livrare imediată!

107,00Lei

HUSA PIELE PT.ARMA BASCULANTA(FRANTA) ARROW
Exclusiv online!

HUSA PIELE PT.ARMA BASCULANTA(FRANTA) ARROW

ve.14.08
Livrare 24-48 ore

442,64Lei

Afişare 801 - 820 din 1201 (61 pagini)
Queries: 5, Total time: 35.696 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '28dac7767b8bfc4ede49b3e3bd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (30.263)
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('+husa' 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
4 (5.111)
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 800, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
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