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


DEGORJOR GENLOG TWO SIDE SML-MICRO

DEGORJOR GENLOG TWO SIDE SML-MICRO

gad-2ssm
Stoc epuizat

4,80Lei

OPRITOARE MOSTIRO GUMA SOFT MARIMEA XL

OPRITOARE MOSTIRO GUMA SOFT MARIMEA XL

4054
Livrare imediată!

2,00Lei

Carlige VMC 9290 nr.10

Carlige VMC 9290 nr.10

9290 bz10
Livrare imediată!

11,00Lei

Juvelnic Nevis Concurs 2.00m

Juvelnic Nevis Concurs 2.00m

4236-200
Livrare imediată!

90,00Lei

Carlige Owner Chinu 50345, Nr.1, 8buc/plic -24%

Carlige Owner Chinu 50345, Nr.1, 8buc/plic

5034504
Livrare imediată!

10,41Lei(-24%) 7,90Lei

VARTEJ CU CARABINA MAVER UNIVERSAL NR 22

VARTEJ CU CARABINA MAVER UNIVERSAL NR 22

1515022
Livrare imediată!

6,00Lei

VIDRAX PLUTA BALSA MODEL057,2,00G

VIDRAX PLUTA BALSA MODEL057,2,00G

a1.v057.020
Livrare imediată!

4,03Lei

CARLIGE GAMAKATSU LS-1810B NR 8 BR 25BUC/PL

CARLIGE GAMAKATSU LS-1810B NR 8 BR 25BUC/PL

gk.146548.8
Livrare imediată!

17,01Lei

CARLIGE MAVER MATCH THIS MT3 F/BARBLESS NR 10
Exclusiv online!

CARLIGE MAVER MATCH THIS MT3 F/BARBLESS NR 10

g810
Livrare 48-72 ore

10,00Lei

WAGLER JAXON AF 4+2GR

WAGLER JAXON AF 4+2GR

sf-af420
Livrare imediată!

13,99Lei

CARLIGE HAYABUSA AKK106R NR.16
Exclusiv online!

CARLIGE HAYABUSA AKK106R NR.16

7101
Livrare 48-72 ore

6,60Lei

CARLIGE KAMASAN B512 NR 18/10BUC
Exclusiv online!

CARLIGE KAMASAN B512 NR 18/10BUC

khpb512018
Livrare 48-72 ore

9,50Lei

PLUMBI ALICE MAVER SUPER SOFT Nr 8 refill
Exclusiv online!

PLUMBI ALICE MAVER SUPER SOFT Nr 8 refill

k617
Livrare 48-72 ore

11,00Lei

PLUTA MAVER CAORLE 4.0GR PORT STARLET 4.5MM
Exclusiv online!

PLUTA MAVER CAORLE 4.0GR PORT STARLET 4.5MM

7905400
Livrare 48-72 ore

10,50Lei

Carlig Owner Mosquito Hook 5177 Nr.4 10buc/plic

Carlig Owner Mosquito Hook 5177 Nr.4 10buc/plic

5177008
Livrare imediată!

11,73Lei

CARLIGE FUDO UMI TANAGO BN 2601 NR 12 18BUC/PLIC
Exclusiv online!

CARLIGE FUDO UMI TANAGO BN 2601 NR 12 18BUC/PLIC

2601-12
Livrare 48-72ore

10,00Lei

Plumb Culisant Arrow Hexagon, 80g

Plumb Culisant Arrow Hexagon, 80g

a3.p80
Livrare imediată!

5,81Lei

CARLIGE HAYABUSA AKK106R NR.12

CARLIGE HAYABUSA AKK106R NR.12

7103
Livrare imediată!

6,60Lei

Juvelnic EnergoTeam 3 inele diam 30cm PT-33

Juvelnic EnergoTeam 3 inele diam 30cm PT-33

72100003
Livrare imediată!

16,01Lei

PLUTA BALSA MOSTIRO DIANA A 0.80GR
Exclusiv online!

PLUTA BALSA MOSTIRO DIANA A 0.80GR

2420720108000
Livrare 48-72 ore

3,50Lei

Afişare 2521 - 2540 din 7266 (364 pagini)
Queries: 6, Total time: 197.410 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '81ce207f414bff9dd47dfa5740'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (161.997)
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('+stationar' 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 (34.932)
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 2520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.158)
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.111)
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