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

Produse ce potrivesc criteriilor de căutare


Minciog Zfish Telescopic Select Landing Net, 190cm

Minciog Zfish Telescopic Select Landing Net, 190cm

zf-2366
Livrare imediată!

79,52Lei

Minciog 3 Tronsoane Aluminiu 80

Minciog 3 Tronsoane Aluminiu 80

7777047
Livrare imediată!

65,60Lei

Minciog FL 3 Tronsoane Aluminiu 60

Minciog FL 3 Tronsoane Aluminiu 60

7777045
Livrare imediată!

50,00Lei

Minciog FL 3 Tronsoane Aluminiu 70

Minciog FL 3 Tronsoane Aluminiu 70

7777046
Livrare imediată!

69,90Lei

Minciog FL Strategist 200 Coada 2 Segmente Carbon 2M Deschidere 1M

Minciog FL Strategist 200 Coada 2 Segmente Carbon 2M Deschidere 1M

5153213883467
Stoc epuizat

239,90Lei

Minciog FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

Minciog FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

4153212542182
Stoc epuizat

199,90Lei

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

2153218229492
Stoc epuizat

249,90Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m -25%

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m

cln056
Stoc epuizat

1.403,95Lei(-25%) 1.052,96Lei

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

cz5935
Stoc epuizat

241,00Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m -25%

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m

cln055
Stoc epuizat

1.237,46Lei(-25%) 928,09Lei

Minciog Maver Gummy Arm 50x40cm

Minciog Maver Gummy Arm 50x40cm

1979001
Stoc epuizat

254,01Lei

Minciog Mikado Intro Carp Net 1.80m -26%

Minciog Mikado Intro Carp Net 1.80m

s14-20-105181
Stoc epuizat

168,00Lei(-26%) 125,00Lei

Minciog Zebco Wide Mesh Telescopic Landing Net 2.00m -34%

Minciog Zebco Wide Mesh Telescopic Landing Net 2.00m

7027200
Stoc epuizat

69,54Lei(-34%) 46,17Lei

Minciog Delphin OMINI Quick, 215cm, 65x60cm, 2seg

Minciog Delphin OMINI Quick, 215cm, 65x60cm, 2seg

101003286
Stoc epuizat

153,50Lei

Minciog Zebco Metal Power Landing Net 1.75m

Minciog Zebco Metal Power Landing Net 1.75m

7081175
Stoc epuizat

116,06Lei

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm, 2seg

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm, 2seg

htln06
Stoc epuizat

419,00Lei

Minciog Rod Hutchinson DMX , 107cm

Minciog Rod Hutchinson DMX , 107cm

htln01
Stoc epuizat

740,00Lei

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm

Minciog Rod Hutchinson Sceptre, Verde Oliv, 107cm

htln05
Stoc epuizat

390,00Lei

Minciog cu Maner Telescopic Delphin OMEGA Carp

Minciog cu Maner Telescopic Delphin OMEGA Carp

101002849
Stoc epuizat

150,00Lei

MINCIOG LINEAEFFE 3,00M D100X100CM

MINCIOG LINEAEFFE 3,00M D100X100CM

a2.m6101860
Stoc epuizat

157,59Lei

Afişare 161 - 180 din 230 (12 pagini)
Queries: 10, Total time: 14.571 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = '081909e40e316b693025de0bfa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.243)
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('+mincioguri +complete +feeder' 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 (0.171)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (1.111)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.350)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.077)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.091)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (2.200)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.078)
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