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


Carlig Delphin HKD Double NR.6 -48%

Carlig Delphin HKD Double NR.6

622410006
Livrare imediată!

20,00Lei(-48%) 10,31Lei

CARLIG OWNER 50098 Nr.1 Auriu Semirotund -23%

CARLIG OWNER 50098 Nr.1 Auriu Semirotund

5009803
Livrare imediată!

10,25Lei(-23%) 7,90Lei

Carlig Owner Chinta 50340 Nr 10

Carlig Owner Chinta 50340 Nr 10

5034007
Livrare imediată!

11,89Lei

Carlig Owner OH SSW 5115 Nr.2
Exclusiv online!

Carlig Owner OH SSW 5115 Nr.2

5115008
Livrare 48-72 ore

12,99Lei

Carlig Owner 53883 Iseama Nr.10

Carlig Owner 53883 Iseama Nr.10

5388314
Livrare imediată!

10,90Lei

Carlig Delphin HKD Feeder SMUTER NR.6

Carlig Delphin HKD Feeder SMUTER NR.6

622060006
Livrare imediată!

12,00Lei

CARLIG MUSTAD FEEDER CU OCHET MU15 BR Nr.16

CARLIG MUSTAD FEEDER CU OCHET MU15 BR Nr.16

m.60343npbr.16
Livrare imediată!

7,57Lei

Jig Jaxon cu carlig Owner Big Game carlig nr 6/0 14GR 3/PLIC -20%

Jig Jaxon cu carlig Owner Big Game carlig nr 6/0 14GR 3/PLIC

gj-og6/014bc
Livrare imediată!

25,00Lei(-20%) 19,90Lei

CARLIG GAMAKATSU FORJ. TRATAT LS-5314N NI 10B/PL NR.12

CARLIG GAMAKATSU FORJ. TRATAT LS-5314N NI 10B/PL NR.12

gk.146631.12
Livrare imediată!

12,89Lei

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou -26%

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou

5106001
Livrare imediată!

18,75Lei(-26%) 13,90Lei

Pelete Flotante Rameau 6/8/10mm Picant Portocaliu -17%
Exclusiv online!

Pelete Flotante Rameau 6/8/10mm Picant Portocaliu

ara040007
Livrare 48-72ore

23,00Lei(-17%) 19,00Lei

JIG FUDO 9GR CARLIG NR 4/0 7BUC

JIG FUDO 9GR CARLIG NR 4/0 7BUC

jfb-4/0-009
Livrare imediată!

15,01Lei

Pelete Gaurite Mivardi Rapid Classic Halibut, 16mm, 10kg
Exclusiv online!

Pelete Gaurite Mivardi Rapid Classic Halibut, 16mm, 10kg

m-rapecha10016
Livrare 48-72 ore

179,00Lei

JIG FUDO 7GR CARLIG NR 7/0 5BUC

JIG FUDO 7GR CARLIG NR 7/0 5BUC

jfb-7/0-007
Livrare imediată!

15,01Lei

Carlig Owner CF-3 No.12/0
Exclusiv online!

Carlig Owner CF-3 No.12/0

12100256966-120
Livrare 48-72 ore

27,91Lei

Carlig Delphin HKD Feeder FULER NR.10 -64%

Carlig Delphin HKD Feeder FULER NR.10

622040010
Livrare imediată!

11,00Lei(-64%) 4,00Lei

Pelete Flotante Rameau 6/8/10mm Vanilie Alb -17%
Exclusiv online!

Pelete Flotante Rameau 6/8/10mm Vanilie Alb

ara040004
Livrare 48-72ore

23,00Lei(-17%) 19,00Lei

Carlig Owner Pint Hook 53117 Nr 2
Exclusiv online!

Carlig Owner Pint Hook 53117 Nr 2

5311702
Livrare 48-72 ore

10,25Lei

Carlig Owner Pint-S 51789 Nr 8

Carlig Owner Pint-S 51789 Nr 8

5178903
Livrare imediată!

11,89Lei

Carlig Owner Nr.6 Carp DRig
Exclusiv online!

Carlig Owner Nr.6 Carp DRig

565596
Livrare 48-72 ore

28,24Lei

Afişare 1121 - 1140 din 2481 (125 pagini)
Queries: 7, Total time: 58.548 ms [By time] [By id] [By file]
1 (0.141)
SELECT data
FROM `oc_session`
WHERE session_id = '7d70a6ef2b3d8680d8c94e3a37'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (49.193)
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 (MATCH(pd.tag) AGAINST('+carlig' IN BOOLEAN MODE)) 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 (8.726)
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 1120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
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.125)
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
7 (0.120)
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