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


CARLIGE VARIVAS FLY 2410V 2X FINE DEEP WIDE WET NR 10 MICRO BARB
Exclusiv online!

CARLIGE VARIVAS FLY 2410V 2X FINE DEEP WIDE WET NR 10 MICRO BARB

vcv241010
Livrare 48-72 ore

26,00Lei

CARLIGE CARP ZOOM CARP CLASSIC nr.10

CARLIGE CARP ZOOM CARP CLASSIC nr.10

cz4695
Livrare imediată!

5,00Lei

Carlige Gamakatsu 2011F Nr.3, 25buc/pac

Carlige Gamakatsu 2011F Nr.3, 25buc/pac

gk.146555.3
Livrare imediată!

20,60Lei

Carlig Owner Cp 51481 Negru Rotund Nr 3 - 14buc/plic

Carlig Owner Cp 51481 Negru Rotund Nr 3 - 14buc/plic

5148106
Livrare imediată!

12,88Lei

MONTURA GURU SPEEDSTOP QM1 CARLIG NR.16, 017MM, 10CM, 8BUC/PAC -21%

MONTURA GURU SPEEDSTOP QM1 CARLIG NR.16, 017MM, 10CM, 8BUC/PAC

a.gu.grr028
Livrare imediată!

23,92Lei(-21%) 18,90Lei

CARLIGE COLMIC NUCLEAR MR300 NR 12

CARLIGE COLMIC NUCLEAR MR300 NR 12

am0612
Livrare imediată!

24,00Lei

Carlig Owner 50921 Crom Tija Lunga Anou Nr 12 - 11buc/plic

Carlig Owner 50921 Crom Tija Lunga Anou Nr 12 - 11buc/plic

5092102
Livrare imediată!

10,41Lei

Carlige Owner Cut Chinu 50339 Negru nr 6 - 15buc/plic

Carlige Owner Cut Chinu 50339 Negru nr 6 - 15buc/plic

5033909
Livrare imediată!

12,88Lei

Carlige Montate Zebco No.1/0 Z-Sea Shore Rig No.7

Carlige Montate Zebco No.1/0 Z-Sea Shore Rig No.7

4299021
Livrare imediată!

13,28Lei

Carlige Gamakatsu Offset 1/0 Stoper BL

Carlige Gamakatsu Offset 1/0 Stoper BL

gk.185015.01
Livrare imediată!

23,51Lei

Aligner PB Products X - Stiff Curved Gravel 8buc/plic weed

Aligner PB Products X - Stiff Curved Gravel 8buc/plic weed

pb20612
Livrare imediată!

22,00Lei

CARLIGE GAMAKATSU G-CARP HUMP BACK 10BUC/PL nr 4

CARLIGE GAMAKATSU G-CARP HUMP BACK 10BUC/PL nr 4

185030-00400-00000
Livrare imediată!

24,00Lei

Carlige Legate Browning Braid Feeder Leader Method Boilie Needle Nr.8, 0.12mm, 10cm, 6.40kg, 3buc/plic

Carlige Legate Browning Braid Feeder Leader Method Boilie Needle Nr.8, 0.12mm, 10cm, 6.40kg, 3buc/plic

4721112
Livrare imediată!

13,28Lei

Carlig Owner 50286 Rosu Tija Lunga Nr 9 - 15buc/plic

Carlig Owner 50286 Rosu Tija Lunga Nr 9 - 15buc/plic

5028607
Livrare imediată!

10,41Lei

CARLIGE COLMIC NUCLEAR B900 NR 16

CARLIGE COLMIC NUCLEAR B900 NR 16

amc16
Livrare imediată!

20,50Lei

INELE MONTURI CARP ZOOM ROTUNDE 3.1 MM NEGRU MAT

INELE MONTURI CARP ZOOM ROTUNDE 3.1 MM NEGRU MAT

cz1748
Livrare imediată!

13,99Lei

Carlig Owner CUT CHINU Auriu 50328 nr 1/0 - 10buc/plic -28%

Carlig Owner CUT CHINU Auriu 50328 nr 1/0 - 10buc/plic

5032803
Livrare imediată!

11,50Lei(-28%) 8,25Lei

Carlige Gamakatsu Worm 31 Nr.2/0 6bucati/plic

Carlige Gamakatsu Worm 31 Nr.2/0 6bucati/plic

worm-31-200
Livrare imediată!

15,40Lei

Carlig Owner Cp 50674 Argintiu Patrat Nr 5 - 15buc/pac
Exclusiv online!

Carlig Owner Cp 50674 Argintiu Patrat Nr 5 - 15buc/pac

5067403
Livrare 48-72 ore

13,05Lei

CARLIGE COLMIC NUCLEAR MR66 NR 6
Exclusiv online!

CARLIGE COLMIC NUCLEAR MR66 NR 6

am0360
Livrare 48-72 ore

27,50Lei

Afişare 2861 - 2880 din 9668 (484 pagini)
Queries: 5, Total time: 658.021 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = 'f3ec1ac21caa4dfea429c3a564'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (621.876)
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 (pd.tag LIKE "%carlige%") 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:724
4 (35.846)
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 2860, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.100)
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