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


Lingura Rattling Zeck Cat Seeker 60g Green 9cm
Exclusiv online!

Lingura Rattling Zeck Cat Seeker 60g Green 9cm

130805150060
Livrare 48-72 ore

55,57Lei

Manusa Black Cat Landing Glove

Manusa Black Cat Landing Glove

9392003
Livrare imediată!

80,55Lei

Manusa Black Cat Landing Glove, Large

Manusa Black Cat Landing Glove, Large

9392002
Livrare imediată!

80,55Lei

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac
Exclusiv online!

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac

120406865100001
Livrare 48-72 ore

38,31Lei

Opritor Cat Spirit VIF XL, Nr.20, 10buc/pac
Exclusiv online!

Opritor Cat Spirit VIF XL, Nr.20, 10buc/pac

rg6000039
Livrare 48-72ore

21,75Lei

Opritor Plutitor Cat Spirit Super, Nr.10, 10buc/pac
Exclusiv online!

Opritor Plutitor Cat Spirit Super, Nr.10, 10buc/pac

rg6000036
Livrare 48-72ore

18,00Lei

Pluta Somn Attack Substrat 60g

Pluta Somn Attack Substrat 60g

att-cat-s 60
Livrare imediată!

14,49Lei

Super Opritor Cat Spirit Silicon, Transparent, 20buc/pac
Exclusiv online!

Super Opritor Cat Spirit Silicon, Transparent, 20buc/pac

rg6000043
Livrare 48-72ore

22,50Lei

Caciula Black Cat Led Lancer Beanie

Caciula Black Cat Led Lancer Beanie

9788100
Livrare imediată!

53,78Lei

Varga Baracuda Wild Cat, 60-100g, 3m, 3seg

Varga Baracuda Wild Cat, 60-100g, 3m, 3seg

undita 3m
Livrare imediată!

23,90Lei

Varga Baracuda Wild Cat, 60-100g, 4m, 4seg

Varga Baracuda Wild Cat, 60-100g, 4m, 4seg

undita 4m
Livrare imediată!

29,90Lei

Lanseta Black Cat Solid Bank 100-500g 2,90m -44%

Lanseta Black Cat Solid Bank 100-500g 2,90m

16499290
Stoc epuizat

899,78Lei(-44%) 499,90Lei

Agrafa Vartej Black Cat 85mm Breaking Line Connector

Agrafa Vartej Black Cat 85mm Breaking Line Connector

6278001
Stoc epuizat

22,28Lei

Avertizor Black Cat Bite Alarm 2, 1buc -34%

Avertizor Black Cat Bite Alarm 2, 1buc

6802001
Stoc epuizat

269,78Lei(-34%) 178,90Lei

Lanterna cap Black Cat Night Vision 1500 black/green

Lanterna cap Black Cat Night Vision 1500 black/green

9896002
Stoc epuizat

107,78Lei

Shad Madcat Pelagic Cat Lure 21cm Firetiger UV 100g

Shad Madcat Pelagic Cat Lure 21cm Firetiger UV 100g

13013170478
Stoc epuizat

42,69Lei

Shad Madcat Pelagic Cat Lure Satl N Pepper Sinking 21cm 100 gr

Shad Madcat Pelagic Cat Lure Satl N Pepper Sinking 21cm 100 gr

13013170479
Stoc epuizat

42,64Lei

Shad Madcat Pelagic Cat Lure Smelt Sinking 21cm 100 gr -20%

Shad Madcat Pelagic Cat Lure Smelt Sinking 21cm 100 gr

13013170477
Stoc epuizat

42,64Lei(-20%) 33,90Lei

Vobler Zeck Cat Pointer, Grey Fire, 8cm, 27gr

Vobler Zeck Cat Pointer, Grey Fire, 8cm, 27gr

130205150414
Stoc epuizat

77,86Lei

Lanseta Mikado Cat Territory Vertical 1.80m 100-200g 1SEG

Lanseta Mikado Cat Territory Vertical 1.80m 100-200g 1SEG

waa464-180
Stoc epuizat

432,01Lei

Afişare 421 - 440 din 547 (28 pagini)
Queries: 11, Total time: 16.052 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'ce80220f3348aa05271fc6c816'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (13.067)
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('+cat' 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 (2.291)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.075)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRESTON INOVATION INDISPONIBIL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.071)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.079)
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