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


Shad ZFISH Wormy 9.5cm, C2, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C2, 4buc/pac

ZF-3209-C2
Livrare 48-72ore

15,74Lei

Shad ZFISH Wormy 9.5cm, C3, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C3, 4buc/pac

ZF-3308-C3
Livrare 48-72ore

15,74Lei

Shad ZFISH Wormy 9.5cm, C4, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C4, 4buc/pac

ZF-3407-C4
Livrare 48-72ore

15,74Lei

Shad ZFISH Wormy 9.5cm, C6, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C6, 4buc/pac

ZF-3605-C6
Livrare 48-72ore

15,74Lei

Shad ZFISH Wormy 9.5cm, C7, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C7, 4buc/pac

ZF-3704-C7
Livrare 48-72ore

15,74Lei

Shad ZFISH Wormy 9.5cm, C8, 4buc/pac
Exclusiv online!

Shad ZFISH Wormy 9.5cm, C8, 4buc/pac

ZF-3803-C8
Livrare 48-72ore

15,74Lei

Lanseta Zeck Cherry-Stick 2.50m, 5-18g, 2seg
Exclusiv online!

Lanseta Zeck Cherry-Stick 2.50m, 5-18g, 2seg

20405200251
Livrare 48-72 ore

712,77Lei

Opritoare Zeck pentru U-Floats Leads 3.7mm, 0.95cm, 25buc/pac

Opritoare Zeck pentru U-Floats Leads 3.7mm, 0.95cm, 25buc/pac

41505120045
Livrare imediată!

19,64Lei

Bile Antisoc Zeck Soft Bead 11.5mm, 10buc/pac
Exclusiv online!

Bile Antisoc Zeck Soft Bead 11.5mm, 10buc/pac

41505120003
Livrare 48-72 ore

9,64Lei

Lanseta Zeck Evo Cat Spin, 2.40m, 100g, 2seg
Exclusiv online!

Lanseta Zeck Evo Cat Spin, 2.40m, 100g, 2seg

20305100242
Livrare 48-72 ore

1.016,56Lei

Lanseta Zeck Pro-Cat Boat, 2.40m, 300g, 2seg -26%

Lanseta Zeck Pro-Cat Boat, 2.40m, 300g, 2seg

20305100240
Livrare imediată!

866,15Lei(-26%) 641,90Lei

Plute Zeck Leader Float Black, 2g, 2buc/pac

Plute Zeck Leader Float Black, 2g, 2buc/pac

42205140402
Livrare imediată!

20,38Lei

Plute Zeck Leader Float Green, 1g, 2buc/pac

Plute Zeck Leader Float Green, 1g, 2buc/pac

42205140405
Livrare imediată!

26,23Lei

Baliza Zeck Cat Buoy Red

Baliza Zeck Cat Buoy Red

42105180035
Livrare imediată!

178,81Lei

Blinker Zeck 80gr Jorg Octo Spoon White
Exclusiv online!

Blinker Zeck 80gr Jorg Octo Spoon White

130405150070
Livrare 48-72 ore

70,51Lei

Fir Textil Inaintas Zeck Silent Leader Verde 0.9mm, 68kg, 20m
Exclusiv online!

Fir Textil Inaintas Zeck Silent Leader Verde 0.9mm, 68kg, 20m

110405130009
Livrare 48-72 ore

50,72Lei

Lanseta Zeck Cherry-Stick, 2.10m, 3-12g, 2seg -26%

Lanseta Zeck Cherry-Stick, 2.10m, 3-12g, 2seg

20405200210
Livrare imediată!

611,87Lei(-26%) 452,90Lei

Lanseta Zeck Vertic & Spin, 1.90m, 40g, 2seg
Exclusiv online!

Lanseta Zeck Vertic & Spin, 1.90m, 40g, 2seg

20405200193
Livrare 48-72 ore

579,68Lei

Mulineta Zeck VR 5 Manivela Stanga

Mulineta Zeck VR 5 Manivela Stanga

30805100005
Livrare imediată!

1.274,50Lei

Pluta Zeck U-Float Solid Green, 3g, 1buc/pac

Pluta Zeck U-Float Solid Green, 3g, 1buc/pac

42205140407
Livrare imediată!

15,23Lei

Afişare 201 - 220 din 477 (24 pagini)
Queries: 11, Total time: 1,383.806 ms [By time] [By id] [By file]
1 (1.317)
SELECT data
FROM `oc_session`
WHERE session_id = '6a9ab8d24e184c4c6ead2d69e9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.235)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,379.229)
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 "%zeck%") 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:724
4 (2.221)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.087)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.083)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.177)
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