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 300 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


Geanta Lucky John EVA BOAT BAG SET small 36x23x25cm
Exclusiv online!

Geanta Lucky John EVA BOAT BAG SET small 36x23x25cm

lj3825-019ebbd
Livrare 48-72ore

339,00Lei

Geanta Lucky John Lucky EVA BOAT BAG SET large 40x22.5x14cm
Exclusiv online!

Geanta Lucky John Lucky EVA BOAT BAG SET large 40x22.5x14cm

lj3825-030ebbd
Livrare 48-72ore

477,00Lei

Geanta Mitchelll MX Camo Sling Bag, 3 Cutii, 28x22x15cm
Exclusiv online!

Geanta Mitchelll MX Camo Sling Bag, 3 Cutii, 28x22x15cm

1561549
Livrare 7-14 zile

179,96Lei

Geantă & Cutie Delphin PROXES Easy, Marime L

Geantă & Cutie Delphin PROXES Easy, Marime L

101003675
Livrare imediată!

95,90Lei

Mulineta Team Feeder By Dome Master Long Cast 6700

Mulineta Team Feeder By Dome Master Long Cast 6700

2534-770
Livrare imediată!

525,00Lei

Borseta Fox Rage Street Fighter Modular Pouch

Borseta Fox Rage Street Fighter Modular Pouch

nlu119
Livrare imediată!

112,46Lei

Borseta Shakespeare SKP Bits/Bobs Pouch M
Exclusiv online!

Borseta Shakespeare SKP Bits/Bobs Pouch M

1550322
Livrare 7-14 zile

58,46Lei

Geanta Berkley Box Storer Bag 28x19.5x18.5cm + 4 Cutii Naluci, 27x17.5x4 cm

Geanta Berkley Box Storer Bag 28x19.5x18.5cm + 4 Cutii Naluci, 27x17.5x4 cm

1152869
Livrare imediată!

157,46Lei

Borseta Trakker Nxg Compact Tackle Bag, 22x22x7cm

Borseta Trakker Nxg Compact Tackle Bag, 22x22x7cm

204106
Livrare imediată!

199,96Lei

Geantă, &, Cutie, Delphin, PROXES, Easy,, Marime, XL, 101003676, Genti si Borsete Spinning, Genti si Borsete Spinning Delphin, Delphin
Varga Trabucco Dream Team XTR Alborella, 4.5m
Exclusiv online!

Varga Trabucco Dream Team XTR Alborella, 4.5m

134-47-450
Livrare 48-72 ore

230,00Lei

Mulineta Team Feeder By Dome Master Long Cast 6600

Mulineta Team Feeder By Dome Master Long Cast 6600

2534-760
Livrare imediată!

515,00Lei

Viermi Artificiali Berkley Gulp! Alive Honey Worm Original Scent Honey Yellow 18buc/borcan

Viermi Artificiali Berkley Gulp! Alive Honey Worm Original Scent Honey Yellow 18buc/borcan

1480775
Livrare imediată!

35,96Lei

Borseta Fox Rage Street Fighter
Exclusiv online!

Borseta Fox Rage Street Fighter

nlu117
Livrare 7-14 zile

188,96Lei

Geanta, Mikado, Eva, Jaws, Cu, 3, Cutii, Pentru, Accesorii, M,, 30x20x23cm, , UWI-016, Genti si Borsete Spinning, Genti si Borsete Spinning Mikado, Genti Mikado, Borsete Mikado, Spinning Mikado, Mikado
Geanta Mitchell MX Camo Shoulder Bag, 35x10x26cm
Exclusiv online!

Geanta Mitchell MX Camo Shoulder Bag, 35x10x26cm

1561552
Livrare 7-14 zile

112,46Lei

Set Trabucco Dream Team XTR Alborella 5buc
Exclusiv online!

Set Trabucco Dream Team XTR Alborella 5buc

134-47-500
Livrare 48-72 ore

860,00Lei

Viermi Artificiali Berkley Gulp! Alive Honey Worm Original Scent Bubblegum 18buc/borcan

Viermi Artificiali Berkley Gulp! Alive Honey Worm Original Scent Bubblegum 18buc/borcan

1480773
Livrare imediată!

35,96Lei

Wafter, 2.20, Baits, Supreme, Pre, Washed, 10mm, 50ml/borcan, 6137224779994, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters 220Baits, 220Baits
Borseta Mikado Neagra, 30x14x12cm
Exclusiv online!

Borseta Mikado Neagra, 30x14x12cm

uwi-007
Livrare 48-72 ore

40,00Lei

Afişare 121 - 140 din 739 (37 pagini)
Queries: 12, Total time: 229.735 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '871960c1c3906513d77dc38f99'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (218.168)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%bor%") 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:698
4 (0.204)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (3.079)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.134)
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.129)
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.846)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
9 (0.118)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
10 (0.212)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
11 (6.535)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
12 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38