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


MULINETA SPRO FUSE 2000
Exclusiv online!

MULINETA SPRO FUSE 2000

001226-00200-00000
Livrare 48-72 ore

161,99Lei

CUTIE SPRO PC CU 30 TWISTERE MICRO SHAD 5CM
Exclusiv online!

CUTIE SPRO PC CU 30 TWISTERE MICRO SHAD 5CM

004859-00200-00000
Livrare 48-72 ore

55,00Lei

Lanseta Feeder FL AQUA River Feeder 3.90M 100-200Gr 3Seg

Lanseta Feeder FL AQUA River Feeder 3.90M 100-200Gr 3Seg

3153215049542
Livrare imediată!

269,90Lei

Pavilion tip Cort FOX Social Shelter, 200x200x240cm -27%

Pavilion tip Cort FOX Social Shelter, 200x200x240cm

cum292
Livrare imediată!

2.699,96Lei(-27%) 1.983,90Lei

Cutie Spro Freestyle Dubla XL 16x9.5x5cm -20%
Exclusiv online!

Cutie Spro Freestyle Dubla XL 16x9.5x5cm

006515-04200-00000
Livrare 48-72 ore

119,50Lei(-20%) 95,60Lei

AGRAFA CU VARTEJ TRABUCCO ROLLING HOOKED SNAP NR 20 12 Kg 12BUC/PLIC
Exclusiv online!

AGRAFA CU VARTEJ TRABUCCO ROLLING HOOKED SNAP NR 20 12 Kg 12BUC/PLIC

100-66-200
Livrare 48-72 ore

11,00Lei

BENZAR MIX MAGGOT GLUE 200ml

BENZAR MIX MAGGOT GLUE 200ml

94005150
Livrare imediată!

22,00Lei

Lanseta DAM Madcat New Black Heavy Duty 2.70m 200-300gr

Lanseta DAM Madcat New Black Heavy Duty 2.70m 200-300gr

mad.70695
Livrare imediată!

321,84Lei

Maner Pluta Fuji Balsa - Lansete Musca (Fly)
Exclusiv online!

Maner Pluta Fuji Balsa - Lansete Musca (Fly)

mbf02007175
Livrare 48-72 ore

97,00Lei

MULINETA PROLOGIC C-SERIES 5000 BF 3RUL/200MX035/5,1:1 -10%

MULINETA PROLOGIC C-SERIES 5000 BF 3RUL/200MX035/5,1:1

o.pro.74716
Livrare imediată!

207,32Lei(-10%) 186,59Lei

MINCIOG CARP EXPERT LIGHT 2M 50x60x40 cm

MINCIOG CARP EXPERT LIGHT 2M 50x60x40 cm

71050200
Livrare imediată!

60,00Lei

Galeata rotunda cu capac Delphin FEEDER 17L

Galeata rotunda cu capac Delphin FEEDER 17L

920000364
Livrare imediată!

62,00Lei

ELECTROSOC POWER 200 - 200.000V

ELECTROSOC POWER 200 - 200.000V

vj.50501
Livrare imediată!

264,93Lei

AGRAFA CU VARTEJ TRABUCCO ROLLING GERMAN SNAP NR 20 10 Kg 5BUC/PLIC

AGRAFA CU VARTEJ TRABUCCO ROLLING GERMAN SNAP NR 20 10 Kg 5BUC/PLIC

100-67-200
Livrare imediată!

7,00Lei

FOARFECA PENTRU FIR TEXTIL PRESTON RIG SCISSORS

FOARFECA PENTRU FIR TEXTIL PRESTON RIG SCISSORS

p0220004
Livrare imediată!

31,46Lei

FIR TRABUCCO S FORCE XPS VELVET PRO CAST 0.20 4.13Kg 300M

FIR TRABUCCO S FORCE XPS VELVET PRO CAST 0.20 4.13Kg 300M

052-15-200
Livrare imediată!

38,00Lei

Saltea De Cantarire Wayback Cu Flotor -22%

Saltea De Cantarire Wayback Cu Flotor

5122-200
Livrare imediată!

299,00Lei(-22%) 232,89Lei

ADITIV VAN DEN EYNDE PRAF SWEET FRUIT 200gr

ADITIV VAN DEN EYNDE PRAF SWEET FRUIT 200gr

va00197
Livrare imediată!

14,00Lei

MULINETA TRABUCCO SUPERCAST XT9 2000 RD LONG CAST
Exclusiv online!

MULINETA TRABUCCO SUPERCAST XT9 2000 RD LONG CAST

031-71-200
Livrare 48-72 ore

149,00Lei

Fir Textil Varivas AVANI GT MAX POWER PLUS PE X8 200m 0.570mm 150lb / 68.04kg Orange
Exclusiv online!

Fir Textil Varivas AVANI GT MAX POWER PLUS PE X8 200m 0.570mm 150lb / 68.04kg Orange

v62200120
Livrare 48-72 ore

384,00Lei

Afişare 61 - 80 din 4356 (218 pagini)
Queries: 5, Total time: 583.235 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '5376d2c56bdac9ad2046864467'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (564.421)
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 "%200%") 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 (18.441)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.170)
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