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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Carlige Guru Eyed Barbless, 10buc/plic NR.22
Exclusiv online!

Carlige Guru Eyed Barbless, 10buc/plic NR.22

gu.gf1e22
Livrare 24-48 ore

13,90Lei

Carlige Maver IT KATANA SERIA MATCH KM5 Nickel Top Maggot Nr.14 15buc/plic

Carlige Maver IT KATANA SERIA MATCH KM5 Nickel Top Maggot Nr.14 15buc/plic

km05a014
Livrare imediată!

16,01Lei

MONTURA POLE POSITION SAFETY LEADCLIP PENTRU PLUMB PIERDUT WEED 3BUC/PLIC

MONTURA POLE POSITION SAFETY LEADCLIP PENTRU PLUMB PIERDUT WEED 3BUC/PLIC

008035-00014-00000
Livrare imediată!

51,00Lei

ANCORE ENERGOTEAM KAMASAKI NR.2/0 3buc/plic
Exclusiv online!

ANCORE ENERGOTEAM KAMASAKI NR.2/0 3buc/plic

49700200
Livrare 24-48 ore

8,20Lei

JIG HEAD L And K FISH HEAD 2/0 9g 2buc/plic
Exclusiv online!

JIG HEAD L And K FISH HEAD 2/0 9g 2buc/plic

59102530
Livrare 24-48 ore

12,50Lei

Shad Relax Kopyto Standard, 7.5cm, S083, 4buc/plic
Exclusiv online!

Shad Relax Kopyto Standard, 7.5cm, S083, 4buc/plic

bls3-s083-b
Livrare 48-72ore

11,00Lei

Carlige Mivardi M-125, 10buc/plic Nr.8

Carlige Mivardi M-125, 10buc/plic Nr.8

m-hm1258
Livrare imediată!

8,00Lei

Carlige Mivardi Yamatsu Chinu, 10buc/plic Nr. 2/0
Exclusiv online!

Carlige Mivardi Yamatsu Chinu, 10buc/plic Nr. 2/0

m-hchri02
Livrare 48-72 ore

8,00Lei

JIG ENERGOTEAM WIZARD CAP TWISTWER MASTER Nr.2/0 15g 3buc/plic

JIG ENERGOTEAM WIZARD CAP TWISTWER MASTER Nr.2/0 15g 3buc/plic

59300215
Livrare imediată!

6,50Lei

Carlige legate DAM Detek Method Pellet Band Rig 8buc/plic Nr.8 -24%

Carlige legate DAM Detek Method Pellet Band Rig 8buc/plic Nr.8

12030970437
Livrare imediată!

15,64Lei(-24%) 11,90Lei

Shad Relax Kopyto 7.5cm Tricolor TC047 10Buc/Plic

Shad Relax Kopyto 7.5cm Tricolor TC047 10Buc/Plic

bls3-tc047
Livrare imediată!

15,01Lei

ANCORE ENERGOTEAM WIZARD GRIZZLY 954M-1 3X BRONZ NR.6 5buc/plic

ANCORE ENERGOTEAM WIZARD GRIZZLY 954M-1 3X BRONZ NR.6 5buc/plic

49954006
Livrare imediată!

12,50Lei

Shad Relax King Shad 3inch Laminat 7.5cm RKS3-L053 10 buc/plic
Exclusiv online!

Shad Relax King Shad 3inch Laminat 7.5cm RKS3-L053 10 buc/plic

ks3-l053
Livrare 48-72ore

24,00Lei

Shad Storm Tock Minnow Culoare Shiner 10cm 12g 4buc/plic

Shad Storm Tock Minnow Culoare Shiner 10cm 12g 4buc/plic

tom04 sh
Livrare imediată!

25,00Lei

Carlige Mivardi Yamatsu Aji Feeder, 10buc/plic Nr.18
Exclusiv online!

Carlige Mivardi Yamatsu Aji Feeder, 10buc/plic Nr.18

m-hajfl18
Livrare 48-72 ore

7,00Lei

CARLIGE TRABUCCO AKURA 7535 NR 16 15BUC/PLIC

CARLIGE TRABUCCO AKURA 7535 NR 16 15BUC/PLIC

025-60-160
Livrare imediată!

7,00Lei

Shad Relax Kopyto Laminated, 7.5cm, L485, 4buc/plic
Exclusiv online!

Shad Relax Kopyto Laminated, 7.5cm, L485, 4buc/plic

bls3-l485-b
Livrare 48-72ore

11,00Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/RED HEAD 4BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/RED HEAD 4BUC/PLIC

f1.sg.63797
Livrare imediată!

16,34Lei

Ancore Gamakatsu 13R Red Nr.6 10buc/plic
Exclusiv online!

Ancore Gamakatsu 13R Red Nr.6 10buc/plic

gk.146873.6
Livrare 24-48 ore

47,95Lei

Shad 4Predators Slim Shad Floating 9 CM S002 Culoare Pearl White 5 buc/plic

Shad 4Predators Slim Shad Floating 9 CM S002 Culoare Pearl White 5 buc/plic

4p-ss9-s002
Livrare imediată!

10,00Lei

Afişare 4441 - 4460 din 10454 (523 pagini)
Queries: 9, Total time: 765.375 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '92c3c3c0084b31173183a9e823'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (714.708)
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 "%buc/plic%") 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
5 (49.836)
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 4440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.162)
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.127)
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.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
9 (0.130)
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