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


Carlige Fudo Soi With Ring (Soiw-Bn) Nr.8/0 Bulk 1000
Exclusiv online!

Carlige Fudo Soi With Ring (Soiw-Bn) Nr.8/0 Bulk 1000

3401-8/0-bulk
Livrare 48-72ore

1.445,01Lei

Clips Momeala Zeck Baitfish Clip Hair Rig 15mm, 5buc/pac

Clips Momeala Zeck Baitfish Clip Hair Rig 15mm, 5buc/pac

41605110231
Livrare imediată!

21,87Lei

Fir Monofilament Energo Team Wizard Cat Mono XL Catfish Transparent, 1.00mm, 61.50kg, 150m
Exclusiv online!

Fir Monofilament Energo Team Wizard Cat Mono XL Catfish Transparent, 1.00mm, 61.50kg, 150m

33320099
Livrare 24-48 ore

75,36Lei

Fir Monofilament Konger Team Catfish Grey 0.50mm, 16.9kg, 250m
Exclusiv online!

Fir Monofilament Konger Team Catfish Grey 0.50mm, 16.9kg, 250m

110306214003050
Livrare 48-72 ore

21,41Lei

Fir Textil Delphin BOXER Verde, 0.60mm, 52.60kg, 1100m

Fir Textil Delphin BOXER Verde, 0.60mm, 52.60kg, 1100m

101000480
Livrare imediată!

287,00Lei

Fir Textil Nevis Powercat 4XFluo 200m, 0.40mm, 38kg

Fir Textil Nevis Powercat 4XFluo 200m, 0.40mm, 38kg

3238-040
Livrare imediată!

43,30Lei

Lanseta Zeck Cat-Attack Stone, 2.80m, 320g, 2seg -26%

Lanseta Zeck Cat-Attack Stone, 2.80m, 320g, 2seg

20305100279
Livrare imediată!

815,00Lei(-26%) 603,90Lei

Lanseta Zeck Pro-Cat Short and Soft, 2.80m, 300g, 2seg -26%

Lanseta Zeck Pro-Cat Short and Soft, 2.80m, 300g, 2seg

20305100280
Livrare imediată!

1.016,95Lei(-26%) 752,90Lei

Lingura Rattling Zeck Cat Seeker 110g Black 9cm
Exclusiv online!

Lingura Rattling Zeck Cat Seeker 110g Black 9cm

130805150019
Livrare 48-72 ore

65,76Lei

Lingura Rattling Zeck Vertical Jig 120g Black
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 120g Black

130805150011
Livrare 48-72 ore

81,06Lei

Lingura Rattling Zeck Vertical Jig 120g White
Exclusiv online!

Lingura Rattling Zeck Vertical Jig 120g White

130805150015
Livrare 48-72 ore

81,06Lei

Montura Somn Jaxon Bongo Clonk Teaser Vertical C 140g
Exclusiv online!

Montura Somn Jaxon Bongo Clonk Teaser Vertical C 140g

bs-cf140c
Livrare 48-72 ore

119,00Lei

Opritor PREZATOR Z Catzoom Rubber Beads Stopper, 3buc/pac

Opritor PREZATOR Z Catzoom Rubber Beads Stopper, 3buc/pac

cz2858
Livrare imediată!

8,00Lei

Pluta Culisanta Zeck Propeller U-Float Solid Black, 40g, 1buc/pac

Pluta Culisanta Zeck Propeller U-Float Solid Black, 40g, 1buc/pac

42205140041
Livrare imediată!

30,83Lei

Pluta Culisanta Zeck U-Float Solid Black, 10g, 1buc/pac

Pluta Culisanta Zeck U-Float Solid Black, 10g, 1buc/pac

42205140010
Livrare imediată!

11,14Lei

Pluta Culisanta Zeck U-Float Solid Black, 15g, 1buc/pac

Pluta Culisanta Zeck U-Float Solid Black, 15g, 1buc/pac

42205140105
Livrare imediată!

11,14Lei

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

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

42205140104
Livrare imediată!

11,14Lei

Pluta Culisanta Zeck U-Float Solid Black, 5g, 1buc/pac

Pluta Culisanta Zeck U-Float Solid Black, 5g, 1buc/pac

42205140005
Livrare imediată!

11,14Lei

Pluta Culisanta Zeck U-Float Solid White, 5g, 1buc/pac

Pluta Culisanta Zeck U-Float Solid White, 5g, 1buc/pac

42205140107
Livrare imediată!

10,10Lei

Pluta Inline Zeck Float Verde-Negru 300g

Pluta Inline Zeck Float Verde-Negru 300g

42205140301
Livrare imediată!

81,87Lei

Afişare 1761 - 1780 din 2568 (129 pagini)
Queries: 6, Total time: 72.910 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'c0633db54a51dd5e0d457d9318'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (62.050)
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('+somn' 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 (10.385)
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 1760, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.112)
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.145)
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