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


Pluta Madcat 40g Screaming Subfloat SM
Exclusiv online!

Pluta Madcat 40g Screaming Subfloat SM

a.mad.55996
Livrare 24-48 ore

35,85Lei

Pluta Monturi Somn Nevis, 12cm, 30g

Pluta Monturi Somn Nevis, 12cm, 30g

6450-012
Livrare imediată!

10,50Lei

Pluta Somn Attack Substrat 40g
Exclusiv online!

Pluta Somn Attack Substrat 40g

att-cat-s 40
Livrare 48-72 ore

11,60Lei

Pluta Zeck Propeller U-Float Solid White 30g, 1buc/pac

Pluta Zeck Propeller U-Float Solid White 30g, 1buc/pac

42205140423
Livrare imediată!

30,98Lei

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

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

42205140409
Livrare imediată!

15,23Lei

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Patriot, 250g
Exclusiv online!

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Patriot, 250g

pmbogey-250-pa
Livrare 48-72 ore

114,00Lei

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Sky, 100g
Exclusiv online!

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Sky, 100g

pmbogey-100-s
Livrare 48-72 ore

95,00Lei

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Sky, 180g
Exclusiv online!

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Sky, 180g

pmbogey-180-s
Livrare 48-72 ore

108,00Lei

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Teddy, 180g
Exclusiv online!

Teaser Mikado Clonc Teaser-Cat Territory, Bogey Teddy, 180g

pmbogey-180-t
Livrare 48-72 ore

108,00Lei

Teaser Mikado Clonc Teaser-Cat Territory, Pumpkin, 250g
Exclusiv online!

Teaser Mikado Clonc Teaser-Cat Territory, Pumpkin, 250g

pmbogey-250-p
Livrare 48-72 ore

114,00Lei

Teaser Zeck Clonk Rattle Teaser 60g, Negru -23%

Teaser Zeck Clonk Rattle Teaser 60g, Negru

1309150038
Livrare imediată!

91,25Lei(-23%) 69,90Lei

Varnis Siliconic Carp Zoom Catfish Rig Protector, 3x6mm, 50cm, 3buc/plic
Exclusiv online!

Varnis Siliconic Carp Zoom Catfish Rig Protector, 3x6mm, 50cm, 3buc/plic

cz2810
Livrare 48-72 ore

15,01Lei

Ancora BKK Spear-21 UVO, Nr.1/0, 5buc/pac

Ancora BKK Spear-21 UVO, Nr.1/0, 5buc/pac

6939067088741
Livrare imediată!

39,00Lei

Ancora Tripla Mustad Titan Steel 5X, Nr.1/0, 6buc/pac
Exclusiv online!

Ancora Tripla Mustad Titan Steel 5X, Nr.1/0, 6buc/pac

m.jl75npts.01
Livrare 24-48 ore

48,36Lei

Carlig Fudo Octopus SH BULK, Nr. 5/0, 1000buc/pac
Exclusiv online!

Carlig Fudo Octopus SH BULK, Nr. 5/0, 1000buc/pac

7001-5/0-b
Livrare 48-72ore

2.062,00Lei

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.7/0
Exclusiv online!

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.7/0

1210021077170
Livrare 48-72 ore

37,68Lei

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.8/0
Exclusiv online!

Carlig Owner Amaz 10771 2x-Strong Gun Black Super Kue Nr.8/0

1210021077180
Livrare 48-72 ore

48,84Lei

Carlig Owner Amaz 11493 Aki Hook Nr.7/0, 6buc/pac

Carlig Owner Amaz 11493 Aki Hook Nr.7/0, 6buc/pac

1210025170-171
Livrare imediată!

27,38Lei

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.9/0, 5buc/pac

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.9/0, 5buc/pac

1210025174-191
Livrare imediată!

39,44Lei

Clonc Zfish Cat Fish Clonk, 40cm
Exclusiv online!

Clonc Zfish Cat Fish Clonk, 40cm

ZF-9766
Livrare 48-72ore

49,62Lei

Afişare 1781 - 1800 din 2568 (129 pagini)
Queries: 7, Total time: 67.572 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '4e1bc7465a0834b3091944a41f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (56.715)
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.265)
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 1780, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.140)
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.124)
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.118)
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