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


Vobler Hunter Fanatic 9cm 16g AL

Vobler Hunter Fanatic 9cm 16g AL

fa916s-al
Stoc epuizat

41,00Lei

Vobler Hunter Faworyt Sinking, AL, 6cm, 9g

Vobler Hunter Faworyt Sinking, AL, 6cm, 9g

faw6s9-al
Stoc epuizat

39,00Lei

Briceag Multifunctional VICTORINOX Hunter, Rosu

Briceag Multifunctional VICTORINOX Hunter, Rosu

h.vx0.8573
Stoc epuizat

255,43Lei

Grub Delalande Sandra, River Hunter, 12cm, 3buc/pac

Grub Delalande Sandra, River Hunter, 12cm, 3buc/pac

DEL6021064-12-PLIC
Stoc epuizat

20,69Lei

Grub Delalande Sandra, River Hunter, 9cm, 4buc/pac

Grub Delalande Sandra, River Hunter, 9cm, 4buc/pac

DEL6020064-9-PLIC
Stoc epuizat

19,60Lei

Vobler Hunter Faworyt Sinking, OL, 6cm, 9g

Vobler Hunter Faworyt Sinking, OL, 6cm, 9g

faw6s9-ol
Stoc epuizat

39,00Lei

Vobler Hunter Faworyt Sinking, TIG, 8.2cm, 23g

Vobler Hunter Faworyt Sinking, TIG, 8.2cm, 23g

faw8s23-par
Stoc epuizat

41,00Lei

Vobler Hunter Tekla Sinking 3.5cm 3.2g BR

Vobler Hunter Tekla Sinking 3.5cm 3.2g BR

te35f-gr
Stoc epuizat

30,00Lei

ARROW DULAP METALIC HUNTER 4 ARME 150X26X25CM

ARROW DULAP METALIC HUNTER 4 ARME 150X26X25CM

vd.a255
Stoc epuizat

1.366,87Lei

CHEMATOARE GASCA SHAVED REED PRIMOS HUNTING'S

CHEMATOARE GASCA SHAVED REED PRIMOS HUNTING'S

vb.826
Stoc epuizat

172,68Lei

DULAP ARROW HUNTER 7 ARME 2MM 156X37X32CM

DULAP ARROW HUNTER 7 ARME 2MM 156X37X32CM

vd.0210
Stoc epuizat

2.202,32Lei

DULAP ARROW HUNTER 11 ARME 2MM 156X54X32CM

DULAP ARROW HUNTER 11 ARME 2MM 156X54X32CM

vd.0209
Stoc epuizat

2.779,41Lei

PISTON GAS GAMO HUNTER

PISTON GAS GAMO HUNTER

g.35450
Stoc epuizat

182,47Lei

HUSA WINCHESTER GUNS HUNTER SEMIAUTOMATA 132CM

HUSA WINCHESTER GUNS HUNTER SEMIAUTOMATA 132CM

a8.bo.6410818852
Stoc epuizat

235,07Lei

Vesta Blaser Hunter Pure Blaze, Marime Univ.

Vesta Blaser Hunter Pure Blaze, Marime Univ.

bl.232013.012
Stoc epuizat

35,85Lei

Afişare 401 - 415 din 415 (21 pagini)
Queries: 10, Total time: 12.211 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = 'f30d27f74d555913495d287ded'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (9.582)
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('+hunter' 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 (1.636)
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 400, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.145)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.129)
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