Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Fir, Monofilament, Claumar, Invisiline, 0.28mm, 11.50Kg, 1200M, clm235251, Fire Monofilament Crap, Fire Monofilament Crap Claumar, Fire Claumar, Monofilament Claumar, Crap Claumar, Claumar

clm235251

Livrare imediată!

90,50Lei

Nada Claumar Special Fructe Rosu 1KG

clm0525

Livrare imediată!

12,89Lei

Mulineta Fl Strategist Tx 14000 Silver

5252205151239

Livrare imediată!

449,80Lei

Lanseta FL Eternity Tele Carp 3.60m

3153171525289

Livrare imediată!

139,90Lei

Geanta Mulinete FL 4 Compartimente

5258203346875

Livrare imediată!

99,90Lei

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

c.27.8525211

Livrare imediată!

149,32Lei

Tambur De Rezerva Nevis Black Carp LCS 6000

2525-560-01

Livrare imediată!

39,90Lei

Micropelete 220Baits Big Fish Carp 2mm, 800g

5242214545259

Livrare imediată!

29,00Lei

Exclusiv online!

Jacheta, Prologic, Bank, Bound, Insulated, XL, a8.pro.64525, Geci si Jachete, Geci si Jachete Prologic, Prologic

a8.pro.64525

Livrare 24-48 ore

397,58Lei

Pasta Berkley PowerBait Sinking Glitter Chartreuse

1525285

Livrare imediată!

31,46Lei

Pasta Berkley PowerBait Sinking Glitter Sunshine Yellow

1525281

Livrare imediată!

31,46Lei

-56%

KNOT PULLER JRC CONTACT

1554525

Livrare imediată!

15,70Lei(-56%) 6,85Lei

-16%

Mulineta Abu Garcia Carabus AG SX 2000

1525864

Livrare imediată!

382,50Lei(-16%) 320,00Lei

-30%

Mulineta Abu Garcia Carabus AG SX 1000

1525863

Livrare imediată!

339,99Lei(-30%) 239,25Lei

Exclusiv online!

Struna Otel Orange 18kg 25cm 0.41mm Steel Leader 2buc/plic

41441p194525

Livrare 48-72 ore

11,10Lei

LANSETA PRO FL FALCONS FEEDER 3.60M 180G

5253249033215

Livrare imediată!

156,90Lei

Exclusiv online!

Lanseta Daiwa Ballistic X Spin 2.10m, 20-60g, 2seg

d.11525.212

Livrare 24-48 ore

553,20Lei

Exclusiv online!

Combo Abu Garcia Carabus Delicate AG Spinning UL, 0.8-4g, 1.80m, 2seg

1525849

Livrare 7-14 zile

854,96Lei

Exclusiv online!

Lansetele JRC Rova Rod, 2.75lbs, 2.70m, 2seg

1525579

Livrare 7-14 zile

359,96Lei

Pasta Flotanta 4 x Berkley Powerbait Trout Season Pack, Winter (Iarna)

1525297

Livrare imediată!

107,96Lei

Afişare 1 - 20 din 544 (28 pagini)

Queries: 10, Total time: 1,482.798 ms [By time] [By id] [By file]

1 (0.130)

SELECT data
FROM `oc_session`
WHERE session_id = '8854a511c3205fc300c5d114c2'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.119)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.115)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (450.760)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%525%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

5 (400.084)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%525%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.222)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%525%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1005

7 (631.047)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%525%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:917

8 (0.114)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.105)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.102)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare