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

Produse ce potrivesc criteriilor de căutare


AGRAFA MAVER MV-R STEEL NR.8 100kg 10buc/plic
Exclusiv online!

AGRAFA MAVER MV-R STEEL NR.8 100kg 10buc/plic

01569008
Livrare 48-72 ore

7,50Lei

CARLIGE OFFSET ENERGOTEAM WIZARD CHEBU JIG Nr.1/0 7g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD CHEBU JIG Nr.1/0 7g 3BUC/PLIC

59361070
Livrare 24-48 ore

10,92Lei

CARLIGE OFFSET ENERGOTEAM WIZARD EDGE PRO JIG Nr.4 1g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD EDGE PRO JIG Nr.4 1g 3BUC/PLIC

59369040
Livrare 24-48 ore

9,48Lei

CARLIGE OFFSET ENERGOTEAM WIZARD EDGE PRO JIG Nr.4 3g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD EDGE PRO JIG Nr.4 3g 3BUC/PLIC

59369030
Livrare 24-48 ore

9,48Lei

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.6 1g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.6 1g 3BUC/PLIC

59373010
Livrare 24-48 ore

9,48Lei

Jig Lucky John Goliat Junior Nr.8/0 12g 3buc/plic
Exclusiv online!

Jig Lucky John Goliat Junior Nr.8/0 12g 3buc/plic

ljgj080-0120
Livrare 48-72ore

23,00Lei

Jig Lucky John Goliat Junior Nr.8/0 16g 3buc/plic
Exclusiv online!

Jig Lucky John Goliat Junior Nr.8/0 16g 3buc/plic

ljgj080-0160
Livrare 48-72ore

27,00Lei

Shad Relax Kopyto Laminat 6.2cm 132 4buc/plic

Shad Relax Kopyto Laminat 6.2cm 132 4buc/plic

bls25-l132-b
Livrare imediată!

9,00Lei

Shad Relax Kopyto Standard 7.5cm S061 4buc/plic

Shad Relax Kopyto Standard 7.5cm S061 4buc/plic

bls3-s061-b
Livrare imediată!

11,00Lei

TWISTER RELAX STANDARD 4CM 8buc/plic TS350

TWISTER RELAX STANDARD 4CM 8buc/plic TS350

vr1-ts350-b
Livrare imediată!

7,00Lei

TWISTER RELAX STANDARD 4CM 8buc/plic TS510
Exclusiv online!

TWISTER RELAX STANDARD 4CM 8buc/plic TS510

vr1-ts510-b
Livrare 48-72ore

6,00Lei

SHAD RELAX BASS STANDARD BLISTER 8.5CM 4BUC/PLIC S013-B
Exclusiv online!

SHAD RELAX BASS STANDARD BLISTER 8.5CM 4BUC/PLIC S013-B

bas3-s013-b
Livrare 48-72ore

10,00Lei

Shad Relax King Shad Laminat 10cm L008-B 4buc/plic

Shad Relax King Shad Laminat 10cm L008-B 4buc/plic

ks4-l008-b
Livrare imediată!

11,00Lei

AGRAFA MAVER MV-R NAGE STEEL S 25kg 10buc/plic
Exclusiv online!

AGRAFA MAVER MV-R NAGE STEEL S 25kg 10buc/plic

01568001
Livrare 48-72 ore

9,00Lei

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.2 2g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.2 2g 3BUC/PLIC

59372020
Livrare 24-48 ore

9,48Lei

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.6 1.5g 3BUC/PLIC
Exclusiv online!

CARLIGE OFFSET ENERGOTEAM WIZARD PRO JIG Nr.6 1.5g 3BUC/PLIC

59373015
Livrare 24-48 ore

9,48Lei

Shad Relax Kopyto 3inch Standard 7.5cm S067-B 4buc/plic

Shad Relax Kopyto 3inch Standard 7.5cm S067-B 4buc/plic

bls3-s067-b
Livrare imediată!

11,00Lei

SHAD WIZARD MINNOW-X 001 5CM 2BUC/PLIC
Exclusiv online!

SHAD WIZARD MINNOW-X 001 5CM 2BUC/PLIC

86963010
Livrare 24-48 ore

12,25Lei

TWISTER RELAX TURBO STANDARD TS447 6.5CM 5BUC/PLIC

TWISTER RELAX TURBO STANDARD TS447 6.5CM 5BUC/PLIC

trt3-ts447-b
Livrare imediată!

6,00Lei

Running Clip Orange 10buc/plic 15mm

Running Clip Orange 10buc/plic 15mm

40441ac2045
Livrare imediată!

9,62Lei

Afişare 6921 - 6940 din 10451 (523 pagini)
Queries: 10, Total time: 718.448 ms [By time] [By id] [By file]
1 (0.396)
SELECT data
FROM `oc_session`
WHERE session_id = '5e834a0fa5137b8c0ffe33fcc1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.467)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.508)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (654.937)
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 (61.497)
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 6920, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.120)
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.121)
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.121)
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.159)
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