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 300 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


SAIBE FOX BLACK LABEL LEATHER WASHERS 4BUC/SET -23%

SAIBE FOX BLACK LABEL LEATHER WASHERS 4BUC/SET

cbb006
Livrare imediată!

26,97Lei(-23%) 20,85Lei

Carlige BOMB D SHOT OFFS WORM 5buc nr 2/0

Carlige BOMB D SHOT OFFS WORM 5buc nr 2/0

622801006
Livrare imediată!

15,01Lei

CLOPOTEL DUBLU JAXON 15MM 10 BUC/PLIC

CLOPOTEL DUBLU JAXON 15MM 10 BUC/PLIC

ad-dc2151
Livrare imediată!

17,01Lei

FIR, TRABUCCO, T, FORCE, CARP, ENDURO, 600M, 0.350, MM, 15.80, Kg, 053-12-350, Fire Monofilament Crap, Fire Monofilament Crap Trabucco, Trabucco
CLOPOTEL JAXON CROCODIL 18MM 10 BUC/PLIC

CLOPOTEL JAXON CROCODIL 18MM 10 BUC/PLIC

ad-bl1811
Livrare imediată!

20,00Lei

CAP MINCIOG TRABUCCO GNT BLACK EDITION HEAD CAUCIUCAT 50X40X30

CAP MINCIOG TRABUCCO GNT BLACK EDITION HEAD CAUCIUCAT 50X40X30

083-67-410
Livrare imediată!

85,00Lei

MOMITOR ARROW LESTAT CULISANT CU TIJA 38GR 2BUC/PL

MOMITOR ARROW LESTAT CULISANT CU TIJA 38GR 2BUC/PL

a3.port.cul8
Livrare imediată!

12,50Lei

TAMBUR DE REZERVA MULINETA TRABUCCO MAXXIS SK 8000 SPARE SPOOL
Exclusiv online!

TAMBUR DE REZERVA MULINETA TRABUCCO MAXXIS SK 8000 SPARE SPOOL

032-75-801
Livrare 48-72 ore

39,01Lei

BRAT TRABUCCO XPS CLAMP-ON ES POLE ARMS
Exclusiv online!

BRAT TRABUCCO XPS CLAMP-ON ES POLE ARMS

086-19-080
Livrare 48-72 ore

85,00Lei

Conuri Fox Naked Line Tail Rubbers Camo, Nr.10, 10buc/pac

Conuri Fox Naked Line Tail Rubbers Camo, Nr.10, 10buc/pac

cac777
Livrare imediată!

17,96Lei

CARLIGE VMC 7053 BLACK NICKEL 10BUC/PLIC NUMARUL 4

CARLIGE VMC 7053 BLACK NICKEL 10BUC/PLIC NUMARUL 4

7053 bn4
Livrare imediată!

18,00Lei

Agrafa cu Vartej Trabucco Power Swivel Nr.16, 12buc/pac

Agrafa cu Vartej Trabucco Power Swivel Nr.16, 12buc/pac

100-62-160
Livrare imediată!

8,00Lei

Opritoare Carp Spirit Rig Ring Stop 10buc/plic Kaki

Opritoare Carp Spirit Rig Ring Stop 10buc/plic Kaki

acs010177
Livrare imediată!

10,00Lei

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 3/0 7buc/plic
Exclusiv online!

Varivas CARLIGE OFFSET NOGALES LIMITED EDITION HEAVY CLASS NR 3/0 7buc/plic

vc97hmh3/0
Livrare 48-72 ore

17,01Lei

BRAT TRABUCCO GENIUS
Exclusiv online!

BRAT TRABUCCO GENIUS

116-10-055
Livrare 48-72 ore

39,00Lei

CARLIGE VMC 7052 BLACK NICKEL 10BUC/PLIC NUMARUL 4

CARLIGE VMC 7052 BLACK NICKEL 10BUC/PLIC NUMARUL 4

7052 bn4
Livrare imediată!

18,00Lei

Baterii alcaline Duracell Basic AAK4 LR06 4 buc

Baterii alcaline Duracell Basic AAK4 LR06 4 buc

5000394076952
Livrare imediată!

20,00Lei

CARLIGE, LEGATE, TRABUCCO, AKURA, PENTRU, BIBAN, SI, SALAU, Nr06x0.25mm, 10BUC/PLIC, 027-15-060, Carlige Legate Stationar, Carlige Legate Stationar Trabucco, Trabucco
BRIDE TRABUCCO SLEEVES TUBES NR 0.75 10BUC/PLIC

BRIDE TRABUCCO SLEEVES TUBES NR 0.75 10BUC/PLIC

100-44-075
Livrare imediată!

3,90Lei

Agrafa cu Vartej Trabucco Power Swivel Nr.14, 12buc/pac

Agrafa cu Vartej Trabucco Power Swivel Nr.14, 12buc/pac

100-62-140
Livrare imediată!

8,00Lei

Afişare 301 - 320 din 22976 (1149 pagini)
Queries: 5, Total time: 562.769 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = '82f3bf2e8512197e5dd1f30934'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (475.474)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%buc%") 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:698
4 (86.931)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.157)
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