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 Textil Delphin HERO 4 Galben Fluo, 0.25mm, 16.80kg, 15m

101001781

Stoc epuizat

10,00Lei

Golden Catch Quick Change Beads M, 10buc/plic

gcz-1665551

Stoc epuizat

9,50Lei

Inele Elastice pentru Momeala Delphin BaitFIX, Marime L, 10mm, 30buc/pac

101003089

Stoc epuizat

8,00Lei

Inele Elastice pentru Momeala Delphin BaitFIX, Marime M, 7mm, 30buc/pac

101003088

Stoc epuizat

8,00Lei

Lanseta Colmic Mirage S31 Wincklepicker 2.70m, 35g, 2+3seg

cami80a

Stoc epuizat

710,00Lei

Lanseta Guru X-Change Bait-Up 3.00m, 170g, 2seg

gu.grd256

Stoc epuizat

509,47Lei

Momitor Orange Method Boat 90g

4084110df690

Stoc epuizat

12,92Lei

Mulineta Okuma Tesoro 8000PA Low Speed

tsr-8000pa

Stoc epuizat

1.899,00Lei

Scaun Colmic Veteran 110 cu Spatar

pa105b

Stoc epuizat

1.500,00Lei

Tava Laterala Rive D36, XXL, 67x51cm

90810103028

Stoc epuizat

651,77Lei

Vartej Golden Catch Cu Margea Culisanta si Agrafa Feeder Snap Links, Marimea L, 10buc/plic

gcz-4565005

Stoc epuizat

6,00Lei

Cap Suport Lansete Filfishing Filex Ajustabil

4240775-2601

Stoc epuizat

16,15Lei

Carlige Drennan Sweetcorn Barbless Nr.10, 10buc/plic

hescb010

Stoc epuizat

7,00Lei

Carlige legate DAM Detek Method Push Stop 8buc/plic Nr.8, Barbless

a.dam.70462

Stoc epuizat

20,10Lei

Carlige Legate Mikado Sensual Chinu G, 70cm, Nr.10, 0.18mm, 8buc/plic

hp10024-10g-018

Stoc epuizat

11,00Lei

Carlige Mikado Method Feeder MF13, Nr.4, 10buc/plic

hmf13-04

Stoc epuizat

12,00Lei

Cosulet Preston Bullet Feeder, Medium, 40g, 1buc/plic

p0050070

Stoc epuizat

11,07Lei

-53%

Fir Monofilament Browning Black Magic Uni Reel Line, Brown, 0.23mm, 4.35kg, 610m

2388023

Stoc epuizat

34,50Lei(-53%) 16,20Lei

Fir Monofilament Filfishing Camo Feeder, 8.40kg, 0.25mm, 300m

fil6410-25

Stoc epuizat

24,00Lei

Fir Monofilament Filfishing Method Feeder, Maro, 3.95kg, 0.16mm, 300m

fil7226-16

Stoc epuizat

19,50Lei

Afişare 12061 - 12080 din 12283 (615 pagini)

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

1 (0.166)

SELECT data
FROM `oc_session`
WHERE session_id = 'd6cda30ef970835959e370ee02'

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

2 (0.133)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.120)

SELECT `trigger`, `action`
FROM oc_event

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

4 (1,693.799)

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 "%feeder%") 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 12060, 20

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

5 (0.149)

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

6 (0.149)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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 "%feeder%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1

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

7 (0.128)

SELECT COUNT(*) AS val, filter_group, filter_id
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 "%feeder%") AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1

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

8 (0.118)

SELECT *
FROM oc_platforma_promovari

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

9 (4.335)

SELECT *
FROM oc_platforma_promovari

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

10 (0.203)

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