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


MONTURA Climax CULT CATFISH JIG FIREBALL 190gr Ancora 4/0 Natural
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 190gr Ancora 4/0 Natural

9910-00021-190
Livrare 48-72 ore

78,00Lei

LANSETA SPORTEX TOP CAT BOJE 305 200-500gr
Exclusiv online!

LANSETA SPORTEX TOP CAT BOJE 305 200-500gr

tw3029
Livrare 48-72 ore

1.670,00Lei

MULINETA OKUMA DISTANCE SURF ARENA 6000

MULINETA OKUMA DISTANCE SURF ARENA 6000

dsa-60
Livrare imediată!

341,10Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 230gr Ancora 4/0 Red -25%

MONTURA Climax CULT CATFISH JIG FIREBALL 230gr Ancora 4/0 Red

9910-00022-230
Livrare imediată!

94,00Lei(-25%) 70,90Lei

Lanseta Spro Monster Cat 2.70m 80-300g 2SEG -24%

Lanseta Spro Monster Cat 2.70m 80-300g 2SEG

002998-00270-00000
Livrare imediată!

353,00Lei(-24%) 266,91Lei

Pluta Culisanta Somn Black Cat Darter U-Float 7.5cm 7gr Neon Yellow
Exclusiv online!

Pluta Culisanta Somn Black Cat Darter U-Float 7.5cm 7gr Neon Yellow

5604002
Livrare 7-14 zile

31,29Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 190gr Ancora 4/0 Red
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 190gr Ancora 4/0 Red

9910-00022-190
Livrare 48-72 ore

78,00Lei

Vobler Somn Vertical Jig Madcat Vibratix Fluo Pink UV 14cm 130g

Vobler Somn Vertical Jig Madcat Vibratix Fluo Pink UV 14cm 130g

13183170802
Livrare imediată!

71,59Lei

Fir monofilament DAM Tectan Superior Soft Leader 0.45mm 18.1kg 100m

Fir monofilament DAM Tectan Superior Soft Leader 0.45mm 18.1kg 100m

11010966197
Livrare imediată!

31,57Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 60gr Ancora 2 Natural
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 60gr Ancora 2 Natural

9910-00021-060
Livrare 48-72 ore

41,00Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 90gr Ancora 2/0 Natural
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 90gr Ancora 2/0 Natural

9910-00021-090
Livrare 48-72 ore

51,00Lei

Pluta DAM Madcat Subfloat Adjusta Marime M, 11.5cm, 40g

Pluta DAM Madcat Subfloat Adjusta Marime M, 11.5cm, 40g

a.mad.55987
Livrare imediată!

18,16Lei

Fir Madcat Spliceable Leader 25m 1.00mm 110kg 250Lbs
Exclusiv online!

Fir Madcat Spliceable Leader 25m 1.00mm 110kg 250Lbs

a.mad.56657
Livrare 24-48 ore

62,70Lei

LANSETA SPORTEX TOP CAT SPIN 250 60-120gr
Exclusiv online!

LANSETA SPORTEX TOP CAT SPIN 250 60-120gr

tw2506
Livrare 48-72 ore

1.200,00Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 30gr Ancora 4 Natural
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 30gr Ancora 4 Natural

9910-00021-030
Livrare 48-72 ore

33,00Lei

Mulineta Alcedo First Run 6504

Mulineta Alcedo First Run 6504

first run 6504
Livrare imediată!

130,55Lei

Pluta Madcat Subfloat 9.5cm, 20g

Pluta Madcat Subfloat 9.5cm, 20g

a.mad.7589020
Livrare imediată!

15,37Lei

Mulineta Okuma Tomcat Baitfeeder 18000 -11%

Mulineta Okuma Tomcat Baitfeeder 18000

tcbf-18000
Livrare imediată!

404,10Lei(-11%) 359,00Lei

MONTURA Climax CULT CATFISH JIG FIREBALL 150gr Ancora 3/0 Red
Exclusiv online!

MONTURA Climax CULT CATFISH JIG FIREBALL 150gr Ancora 3/0 Red

9910-00022-150
Livrare 48-72 ore

67,00Lei

Fir monofilament DAM Tectan Superior Soft Leader 0.35mm 13.6kg 100m

Fir monofilament DAM Tectan Superior Soft Leader 0.35mm 13.6kg 100m

11010966196
Livrare imediată!

29,12Lei

Afişare 1361 - 1380 din 2566 (129 pagini)
Queries: 5, Total time: 68.686 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '73321541cf32c1f3e70bd789f8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.650)
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 (13.660)
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 1360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.128)
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