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 Owner Iseama 50046 Nr 14

Carlig Owner Iseama 50046 Nr 14

5004615
Livrare imediată!

11,23Lei

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

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

gj-og6/012bc
Livrare imediată!

24,00Lei(-21%) 18,90Lei

MONTURA EnergoTeam Carp Hunter METHOD CARLIG ROUND CARP SI BAIT STING nr.14 2buc/plic
Exclusiv online!

MONTURA EnergoTeam Carp Hunter METHOD CARLIG ROUND CARP SI BAIT STING nr.14 2buc/plic

42875014
Livrare 24-48 ore

8,50Lei

CARLIG GURU SUPER MWG EYED NR.10 10BUC/PLIC

CARLIG GURU SUPER MWG EYED NR.10 10BUC/PLIC

gu.gsmwb10
Livrare imediată!

13,90Lei

CARLIG MUSTAD BR FORJAT TIJA LUNGA CURBA PT. MUSCA nr.12

CARLIG MUSTAD BR FORJAT TIJA LUNGA CURBA PT. MUSCA nr.12

m.c53s.12
Livrare imediată!

18,24Lei

Rig Carp Expert Classic Boilie Carlig Nr 2
Exclusiv online!

Rig Carp Expert Classic Boilie Carlig Nr 2

42808002
Livrare 24-48 ore

17,01Lei

Carlig Owner 50335 Nr.14 Chinta 16buc/plic

Carlig Owner 50335 Nr.14 Chinta 16buc/plic

5033510
Livrare imediată!

11,89Lei

Carlig Owner 5123 No.2 Baitholder Hook Red
Exclusiv online!

Carlig Owner 5123 No.2 Baitholder Hook Red

5123093
Livrare 48-72 ore

18,66Lei

Carlig Owner Seigo 50610 Nr.8
Exclusiv online!

Carlig Owner Seigo 50610 Nr.8

5061008
Livrare 48-72 ore

10,00Lei

Carlig Owner Pint Hook 53117 Nr 6 -23%

Carlig Owner Pint Hook 53117 Nr 6

5311706
Livrare imediată!

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

JIG FUDO 7GR CARLIG NR 1 8BUC

JIG FUDO 7GR CARLIG NR 1 8BUC

jfb-1-007
Livrare imediată!

15,01Lei

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

Carlig Owner CF-3 No.9/0

12100256966-90
Livrare 48-72 ore

33,03Lei

Jig Jaxon cu carlig Owner Big Game carlig nr 7/0 28GR 3/PLIC -19%

Jig Jaxon cu carlig Owner Big Game carlig nr 7/0 28GR 3/PLIC

gj-og7/028bc
Livrare imediată!

22,00Lei(-19%) 17,90Lei

Carlig Mustad Ultrapoint BLN, Nr.10, 10buc/pac
Exclusiv online!

Carlig Mustad Ultrapoint BLN, Nr.10, 10buc/pac

m.10549npbn.10
Livrare 24-48 ore

7,64Lei

CARLIG MUSTAD CRAP XV2 CURVED OCHI NICHEL NEGRU Nr.6

CARLIG MUSTAD CRAP XV2 CURVED OCHI NICHEL NEGRU Nr.6

m.60556nptx.6
Livrare imediată!

15,66Lei

Carlig Mustad M1522 Bleu cu Tija Lunga, 100buc/cutie Nr.6

Carlig Mustad M1522 Bleu cu Tija Lunga, 100buc/cutie Nr.6

m.1522.6
Livrare imediată!

25,20Lei

Carlig Mivardi Teflonat MTC Classic Boilie, 10buc/plic Nr.4
Exclusiv online!

Carlig Mivardi Teflonat MTC Classic Boilie, 10buc/plic Nr.4

m-acmtccb4
Livrare 48-72 ore

11,00Lei

Carlig Mustad Concurs M313, Tija Lunga, Negru/Albastru, 10buc/plic Nr.12

Carlig Mustad Concurs M313, Tija Lunga, Negru/Albastru, 10buc/plic Nr.12

m.313.12
Livrare imediată!

7,14Lei

Carlig Mustad Auriu M289H Cioc de Papagal, Nr.2, 10buc/plic
Exclusiv online!

Carlig Mustad Auriu M289H Cioc de Papagal, Nr.2, 10buc/plic

m.289h.2
Livrare 24-48 ore

7,13Lei

Carlig Mustad Auriu M289H Cioc de Papagal, Nr.6, 10buc/plic

Carlig Mustad Auriu M289H Cioc de Papagal, Nr.6, 10buc/plic

m.289h.6
Livrare imediată!

7,13Lei

Afişare 1141 - 1160 din 2470 (124 pagini)
Queries: 5, Total time: 61.409 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '976facf19b0dda34dfa9f98d86'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (51.644)
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 (9.347)
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 1140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
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