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


Minciog crap Delphin Symbol 90x90cm 1.8m

Minciog crap Delphin Symbol 90x90cm 1.8m

101001500
Livrare imediată!

307,00Lei

Cap Minciog Garbolino Latex Match 45x35cm

Cap Minciog Garbolino Latex Match 45x35cm

50330gomnj6415-45x35
Livrare imediată!

93,22Lei

Minciog Nevis Telescopic 2.50m 60x55cm Cauciucat
Exclusiv online!

Minciog Nevis Telescopic 2.50m 60x55cm Cauciucat

4245-215
Livrare 48-72 ore

150,00Lei

MINCIOG SAVAGE GEAR TELE FOLDING L 65X50X60CM 98-161CM -23%

MINCIOG SAVAGE GEAR TELE FOLDING L 65X50X60CM 98-161CM

a2.sg.71101
Livrare imediată!

325,91Lei(-23%) 250,90Lei

Husa minciog Avid Carp Net and Sling Stink Bag XL 139x19cm

Husa minciog Avid Carp Net and Sling Stink Bag XL 139x19cm

a0430048
Livrare imediată!

94,46Lei

Minciog DAM Base-X Landing Net 2seg, 50x50x40cm, 1.50m

Minciog DAM Base-X Landing Net 2seg, 50x50x40cm, 1.50m

a2.dam.60830
Livrare imediată!

84,34Lei

Cap Minciog Garbolino Latex Match 50x40cm

Cap Minciog Garbolino Latex Match 50x40cm

50330gomnj6415-50x40
Livrare imediată!

101,58Lei

CAP MINCIOG TRABUCCO AIRTEK SPECIALIST HEAD CAMOU RUBBER 50X60X40CM

CAP MINCIOG TRABUCCO AIRTEK SPECIALIST HEAD CAMOU RUBBER 50X60X40CM

083-68-720
Livrare imediată!

77,00Lei

MINCIOG LINEAEFFE TELESCOPIC Cap Rotund 2.60m 60cm -30%
Exclusiv online!

MINCIOG LINEAEFFE TELESCOPIC Cap Rotund 2.60m 60cm

a2.m6101655
Livrare 24-48 ore

122,53Lei(-30%) 85,78Lei

Minciog Pliabil Savage Gear M 52x45x43cm 64CM

Minciog Pliabil Savage Gear M 52x45x43cm 64CM

a2.sg.71111
Livrare imediată!

170,71Lei

Minciog Berkley URBN Flip Net 60x46x40cm

Minciog Berkley URBN Flip Net 60x46x40cm

1530312
Livrare imediată!

254,96Lei

MINCIOG LINEAEFFE TELESCOPIC SPEEDY 50X57CM 2.50M -30%
Exclusiv online!

MINCIOG LINEAEFFE TELESCOPIC SPEEDY 50X57CM 2.50M

a2.m6102325
Livrare 24-48 ore

104,23Lei(-30%) 72,96Lei

Minciog Abu Garcia Folding Net Rubber 50x65x40 -21%

Minciog Abu Garcia Folding Net Rubber 50x65x40

1516967
Livrare imediată!

269,96Lei(-21%) 212,90Lei

CAP MINCIOG TRABUCCO PRO NET TX PVC MESH 50X45X40CM
Exclusiv online!

CAP MINCIOG TRABUCCO PRO NET TX PVC MESH 50X45X40CM

083-66-840
Livrare 48-72 ore

39,00Lei

Plasa Minciog Delphin SYMBOL 100x100

Plasa Minciog Delphin SYMBOL 100x100

101001628
Livrare imediată!

75,01Lei

Cap Minciog Reiva 40x35 Cauciucat
Exclusiv online!

Cap Minciog Reiva 40x35 Cauciucat

4263-040
Livrare 48-72 ore

93,00Lei

Cap Minciog Reiva 45x40 Cauciucat
Exclusiv online!

Cap Minciog Reiva 45x40 Cauciucat

4263-045
Livrare 48-72 ore

106,01Lei

CAP MINCIOG TRABUCCO GNT MATCH CAUCIUCAT METHOD NET 38X45X30CM

CAP MINCIOG TRABUCCO GNT MATCH CAUCIUCAT METHOD NET 38X45X30CM

083-69-010
Livrare imediată!

75,01Lei

Minciog DAM Base-X Landing Net 40x40x30cm 1.00m
Exclusiv online!

Minciog DAM Base-X Landing Net 40x40x30cm 1.00m

5010960828
Livrare 48-72 ore

75,01Lei

Minciog Telescopic DAM Ontario V2 Nylon Folding Net 50x50x40cm, 6mm
Exclusiv online!

Minciog Telescopic DAM Ontario V2 Nylon Folding Net 50x50x40cm, 6mm

a2.dam.65465
Livrare 24-48 ore

84,34Lei

Afişare 781 - 800 din 1357 (68 pagini)
Queries: 5, Total time: 60.661 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '0a68edc4bb97415d0e41da1e4d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (50.706)
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('+minciog' 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.608)
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 780, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.157)
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