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


Agrafa Cu Vartej Rive Rolling Snap, Marime 14+0, 10buc/plic

Agrafa Cu Vartej Rive Rolling Snap, Marime 14+0, 10buc/plic

41410810313
Livrare imediată!

10,17Lei

Agrafa cu Vartej Rive US Rolling, Marime 8+0, 10buc/pac

Agrafa cu Vartej Rive US Rolling, Marime 8+0, 10buc/pac

41410810318
Livrare imediată!

9,75Lei

Agrafa Pestisor la Somn Nevis Bait Clip for Catfishing, Marime S, 5buc/pac
Exclusiv online!

Agrafa Pestisor la Somn Nevis Bait Clip for Catfishing, Marime S, 5buc/pac

5584-001
Livrare 48-72 ore

9,60Lei

Bluza Norfin & Lucky John Pro Team Digital, Marime 2XL
Exclusiv online!

Bluza Norfin & Lucky John Pro Team Digital, Marime 2XL

am-7003-05xxl
Livrare 48-72ore

190,00Lei

Bocanci Aigle Bakke GTX Piele Maro, Marime 44
Exclusiv online!

Bocanci Aigle Bakke GTX Piele Maro, Marime 44

ai.na521.44
Livrare 24-48 ore

765,02Lei

Caciula Fox Collection Bobble Black & Orange, Marime Univ.
Exclusiv online!

Caciula Fox Collection Bobble Black & Orange, Marime Univ.

chh021
Livrare 7-14 zile

62,96Lei

Caciula Korda Negru, Marime Universala

Caciula Korda Negru, Marime Universala

a8.kbh33
Livrare imediată!

74,07Lei

Camasa Dama Blaser Charlotte, Olive & Red, Marime 42
Exclusiv online!

Camasa Dama Blaser Charlotte, Olive & Red, Marime 42

bl.121061.087.42
Livrare 24-48 ore

329,09Lei

Ciorapi Thermo Thermaltec, Marime 44-46
Exclusiv online!

Ciorapi Thermo Thermaltec, Marime 44-46

8623-004
Livrare 48-72 ore

62,00Lei

Cizme EVA Dry Walker Strong Truck Long Green, Marime 45
Exclusiv online!

Cizme EVA Dry Walker Strong Truck Long Green, Marime 45

152 / 45
Livrare 48-72 ore

129,00Lei

Cizme EVA Dry Walker Strong Truck Long Green, Marime 46
Exclusiv online!

Cizme EVA Dry Walker Strong Truck Long Green, Marime 46

152 / 46
Livrare 48-72 ore

129,00Lei

Cizme EVA Dry Walker Strong Truck Long Green, Marime 47
Exclusiv online!

Cizme EVA Dry Walker Strong Truck Long Green, Marime 47

152 / 47
Livrare 48-72 ore

129,00Lei

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime UK7 / EU41
Exclusiv online!

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime UK7 / EU41

cfw162
Livrare 7-14 zile

494,96Lei

Cizme Matrix Thermal EVA Boots, Marime UK11 / EU45
Exclusiv online!

Cizme Matrix Thermal EVA Boots, Marime UK11 / EU45

gfw024
Livrare 7-14 zile

314,96Lei

Cizme Matrix Thermal EVA Boots, Marime UK8 / EU42
Exclusiv online!

Cizme Matrix Thermal EVA Boots, Marime UK8 / EU42

gfw021
Livrare 7-14 zile

314,96Lei

Cizme Sold Mikado UMW02, Marime 45
Exclusiv online!

Cizme Sold Mikado UMW02, Marime 45

umw02-45
Livrare 48-72 ore

231,00Lei

Costum Iarna Mikado, Marime XL
Exclusiv online!

Costum Iarna Mikado, Marime XL

umb-273-xl
Livrare 48-72 ore

905,00Lei

Costum Norfin TORNADO PRO, Marime L
Exclusiv online!

Costum Norfin TORNADO PRO, Marime L

409003-l
Livrare 48-72ore

1.970,00Lei

Costum Ploaie Norfin ALPHA, Marime 2XL
Exclusiv online!

Costum Ploaie Norfin ALPHA, Marime 2XL

646005-xxl
Livrare 48-72ore

1.099,00Lei

Costum Ploaie Norfin BOAT, Marime L
Exclusiv online!

Costum Ploaie Norfin BOAT, Marime L

677003-l
Livrare 48-72ore

1.320,00Lei

Afişare 921 - 940 din 4141 (208 pagini)
Queries: 10, Total time: 100.115 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '6335bce9beaa9cb6b8a35f65cb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (84.162)
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('+marime' 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 (14.986)
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 920, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
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.124)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=184417'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
7 (0.131)
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.122)
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.122)
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.122)
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