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ă:

Conuri Fox Edges Camo Slik Lead Clip Tail Rubbers Nr.10

cac810

Livrare imediată!

22,46Lei

Conuri FOX Edges Naturals Power Grip Naked Line Tail Rubbers Nr.7, 10buc/pac

cac844

Livrare imediată!

17,96Lei

Opritoare Silicon Germina Stopper Stick Rubber, Marimea S, 30buc/plic

asr-1311-s

Livrare imediată!

4,40Lei

Exclusiv online!

Pantaloni Blaser Striker SL Rubber Maro, Marime 52

bl.122040.152.1.52

Livrare 24-48 ore

1.015,18Lei

Exclusiv online!

Pantaloni, Blaser, Striker, SL, Rubber, Maro,, Marime, 54, bl.122040.152.1.54, Imbracaminte, Imbracaminte Blaser, Blaser

bl.122040.152.1.54

Livrare 24-48 ore

1.015,18Lei

Conuri Fox Edges Camo Safety Lead Clip Tail Rubbers Nr.7

cac808

Livrare imediată!

22,46Lei

Conuri Fox Edges Naturals Power Grip Tail Rubbers Nr.7, 10buc/pac

cac842

Livrare imediată!

22,46Lei

Exclusiv online!

Lanseta Penn Conflict TaiRubber Casting Rod MH, 25lbs, 2.06m, 1seg

1530405

Livrare 7-14 zile

637,46Lei

Exclusiv online!

Opritoare Silicon Germina Stopper Olive Rubber, Marimea S, 30buc/plic

aor-1311-s

Livrare 48-72 ore

4,40Lei

Exclusiv online!

Lanseta Penn Conflict XR TaiRubber Rod MH, 80g, 1.98m, 1seg

1544301

Livrare 7-14 zile

637,46Lei

Exclusiv online!

Pantaloni, Blaser, Striker, SL, Rubber, Maro,, Marime, 48, bl.122040.152.1.48, Imbracaminte, Imbracaminte Blaser, Blaser

bl.122040.152.1.48

Livrare 24-48 ore

1.015,18Lei

Exclusiv online!

Bile Cauciuc Zfish Rubber Bead, 6mm, 10buc/plic

ZF-2490

Livrare 48-72ore

5,80Lei

Exclusiv online!

Con Plumb Pierdut Trakker Tail Rubbers, Kaki, 10buc/plic

228230

Livrare 7-14 zile

19,94Lei

Exclusiv online!

Minciog Carp Zoom Hanzo Classic Rubber Spinning, 40x50x134cm

cz3138

Livrare 48-72 ore

82,00Lei

STOPER-OVAL TRABUCCO RUBBER STOPPER MARIME SSSS 9BUC/PLIC

101-65-500

Livrare imediată!

10,00Lei

Exclusiv online!

Bile Cauciuc Zfish Rubber Bead, 4mm, 10buc/plic

ZF-2389

Livrare 48-72ore

5,80Lei

Exclusiv online!

Bile Cauciuc Zfish Rubber Bead, 8mm, 10buc/plic

ZF-2391

Livrare 48-72ore

5,80Lei

Exclusiv online!

Con Carp Spirit Anti Tangle Lead Clip Tail Rubber, Camo, 10buc/plic

acs010412

Livrare 48-72ore

19,00Lei

-13%

Ochelari De Soare Polaroid PLD 8411 9CA RC Rubber, 63mm, Black Sport

4942106

Livrare imediată!

195,40Lei(-13%) 169,90Lei

-30%

Con Fox Clips Plumb Pierdut Grip Naked Line Tail Rubbers S

cac686

Livrare imediată!

22,50Lei(-30%) 15,76Lei

Afişare 41 - 60 din 183 (10 pagini)

Queries: 13, Total time: 768.566 ms [By time] [By id] [By file]

1 (0.276)

SELECT data
FROM `oc_session`
WHERE session_id = '43296c1a7d75133ab3b94ff8ca'

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

2 (0.302)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.173)

SELECT `trigger`, `action`
FROM oc_event

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

4 (354.215)

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 = '0' AND (pd.tag LIKE "%rubber%") 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 40, 20

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

5 (0.128)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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

6 (0.120)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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

7 (0.118)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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

8 (0.116)

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

9 (0.145)

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 = '0' AND (pd.tag LIKE "%rubber%") 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:1014

10 (412.620)

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 = '0' AND (pd.tag LIKE "%rubber%") 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' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

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

11 (0.139)

SELECT *
FROM oc_platforma_promovari

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

12 (0.102)

SELECT *
FROM oc_platforma_promovari

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

13 (0.112)

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

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare