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 300 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


Lanseta Penn Squadron III Uptide Spinning Rod H, 2.90m, 170-280g, 1+1seg
Exclusiv online!

Lanseta Penn Squadron III Uptide Spinning Rod H, 2.90m, 170-280g, 1+1seg

1558391
Livrare 7-14 zile

509,96Lei

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.60m, 80g, 3+2seg
Exclusiv online!

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.60m, 80g, 3+2seg

1558420
Livrare 7-14 zile

494,96Lei

Lanseta Tornado Team Feeder By Dome Boat Carp XH, 3.00m, 50-180g, 2+2seg

Lanseta Tornado Team Feeder By Dome Boat Carp XH, 3.00m, 50-180g, 2+2seg

1908-300
Livrare imediată!

339,00Lei

MONTURA INLINE LEADCORE FL PLUMB LONG CAST 80G CARLIG NR 4

MONTURA INLINE LEADCORE FL PLUMB LONG CAST 80G CARLIG NR 4

64-0363
Livrare imediată!

16,90Lei

Plumb Zebco Z-Sea Surf Weight, Lead Free, 80g
Exclusiv online!

Plumb Zebco Z-Sea Surf Weight, Lead Free, 80g

6079080
Livrare 14-21 zile

17,78Lei

Benzar Method Feeder Basket Arc Flat 80g

Benzar Method Feeder Basket Arc Flat 80g

58601080
Livrare imediată!

15,01Lei

Coada de Minciog Trakko New Lucky Tele 3.50m, 380g, 4seg
Exclusiv online!

Coada de Minciog Trakko New Lucky Tele 3.50m, 380g, 4seg

trtl3504
Livrare 48-72 ore

125,00Lei

Combo Spinning PENN Fierce IV Spin 4000 CMB, 2.72m, 20-80g, 2seg
Exclusiv online!

Combo Spinning PENN Fierce IV Spin 4000 CMB, 2.72m, 20-80g, 2seg

1558954
Livrare 7-14 zile

764,96Lei

Cosulet, Feeder, Water, Magic, Trapez, Basket, Extreme, 180Gr, clm216519, Cosulete Feeder, Cosulete Feeder Water Magic , Water Magic
Lanseta Carp Zoom Competition Osmium Feeder, 50-180g, 2.70m, 3+3seg
Exclusiv online!

Lanseta Carp Zoom Competition Osmium Feeder, 50-180g, 2.70m, 3+3seg

cz3077
Livrare 48-72 ore

335,00Lei

Lanseta Zeck Troy, 30-80g, 2.40m, 4seg
Exclusiv online!

Lanseta Zeck Troy, 30-80g, 2.40m, 4seg

20405200248
Livrare 48-72 ore

762,18Lei

Momitor Method Feeder DAM Detek Inline, Marime L, 80g, 1buc/pac
Exclusiv online!

Momitor Method Feeder DAM Detek Inline, Marime L, 80g, 1buc/pac

a.dam.66021
Livrare 24-48 ore

19,10Lei

Combo Spinning PENN Fierce IV Travel Spin 4000 CMB, 2.74m, 20-80g, 4seg
Exclusiv online!

Combo Spinning PENN Fierce IV Travel Spin 4000 CMB, 2.74m, 20-80g, 4seg

1558960
Livrare 7-14 zile

899,96Lei

Lanseta Carp Zoom Distant Bomb Feeder, 180g, 3.90m, 3+3seg
Exclusiv online!

Lanseta Carp Zoom Distant Bomb Feeder, 180g, 3.90m, 3+3seg

cz1691
Livrare 48-72 ore

459,99Lei

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

7253240308877
Livrare imediată!

159,90Lei

Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc -21%

Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc

1573279
Livrare imediată!

449,96Lei(-21%) 353,89Lei

Method Feeder C&B Extra Inline, 80g

Method Feeder C&B Extra Inline, 80g

6427416145615
Livrare imediată!

10,50Lei

Cosulet Feeder Konger River Feeder Standard Cu Capac, 80gr

Cosulet Feeder Konger River Feeder Standard Cu Capac, 80gr

40906702000080
Livrare imediată!

9,64Lei

Cosulet, FeederX, River, Family, 80g, plf108-80, Cosulete Feeder, Cosulete Feeder Water Magic , Water Magic
Kit Method Feeder Konger 2 Feedere 70-80gr + 1 Matrita

Kit Method Feeder Konger 2 Feedere 70-80gr + 1 Matrita

40806960002009
Livrare imediată!

40,61Lei

Afişare 141 - 160 din 665 (34 pagini)
Queries: 8, Total time: 226.554 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = 'a3cc30a8e461199cf6c0db1de5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.132)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (222.796)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%80g%") 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:698
5 (3.142)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.097)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.082)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.087)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38