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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Preston Measuring Sticks Piquet Pentru Masurarea Distantei de Pescuit

Preston Measuring Sticks Piquet Pentru Masurarea Distantei de Pescuit

p0030025
Livrare imediată!

134,96Lei

Piquet Juvelnic Garbolino 40cm Aluminiu

Piquet Juvelnic Garbolino 40cm Aluminiu

50505gomaj0001-400
Livrare imediată!

14,04Lei

Piquet Extra Carp 60-110cm

Piquet Extra Carp 60-110cm

ec4141-bucxxx
Livrare imediată!

59,00Lei

Piquet Carp Expert Inoxidabil S

Piquet Carp Expert Inoxidabil S

72151999
Livrare imediată!

54,00Lei

Piquet Spro C-TEC Matte Black Bankstick 50-90cm

Piquet Spro C-TEC Matte Black Bankstick 50-90cm

006540-00203-00000
Livrare imediată!

48,00Lei

Piquet din otel Delphin 50-90cm -27%

Piquet din otel Delphin 50-90cm

900032220
Stoc epuizat

15,01Lei(-27%) 11,00Lei

Piquet Spro C-TEC Matte Black Bankstick 40-70cm

Piquet Spro C-TEC Matte Black Bankstick 40-70cm

006540-00202-00000
Livrare imediată!

44,90Lei

Piquet Energo Team Basic 70cm

Piquet Energo Team Basic 70cm

72149071
Livrare imediată!

12,00Lei

Piquet Delphin C-Stick 80-130cm

Piquet Delphin C-Stick 80-130cm

900033650
Livrare imediată!

57,00Lei

PIQUET JAXON TELE 110-190CM

PIQUET JAXON TELE 110-190CM

ak-pk057
Livrare imediată!

76,01Lei

Piquet Mivardi Hardcore din Inox, 65-115cm -28%

Piquet Mivardi Hardcore din Inox, 65-115cm

m-bshc115
Livrare imediată!

189,00Lei(-28%) 135,90Lei

PIQUET TELESCOPIC CARP EXPERT 100CM

PIQUET TELESCOPIC CARP EXPERT 100CM

72150399
Livrare imediată!

35,00Lei

Piquet Energo Team Sinterizat 70cm
Exclusiv online!

Piquet Energo Team Sinterizat 70cm

72149075
Livrare 24-48 ore

12,99Lei

PIQUET LANSETA INOX TRAKKO 75 cm -43%

PIQUET LANSETA INOX TRAKKO 75 cm

tr349675
Livrare imediată!

82,00Lei(-43%) 46,65Lei

Piquet Nash Bankstick 66cm
Exclusiv online!

Piquet Nash Bankstick 66cm

t2746
Livrare 7-14 zile

130,00Lei

Suport Tubular Lansete Sert Pliant cu Piquet Metalic

Suport Tubular Lansete Sert Pliant cu Piquet Metalic

42401sevaf1651000
Livrare imediată!

10,07Lei

PIQUET SOLAR P1 TRAVEL-LITE 16 INCH BANKSTICK 40.5 CM -32%

PIQUET SOLAR P1 TRAVEL-LITE 16 INCH BANKSTICK 40.5 CM

p1tl16
Stoc epuizat

132,90Lei(-32%) 89,90Lei

Piquet din otel Delphin 40-70cm -21%

Piquet din otel Delphin 40-70cm

900032210
Stoc epuizat

13,99Lei(-21%) 11,00Lei

Piquet din otel Delphin 60-100cm -31%

Piquet din otel Delphin 60-100cm

900032230
Stoc epuizat

16,01Lei(-31%) 11,00Lei

PIQUET TELESCOPIC CARP EXPERT 80CM

PIQUET TELESCOPIC CARP EXPERT 80CM

72150380
Stoc epuizat

27,50Lei

Afişare 1 - 20 din 24 (2 pagini)
Queries: 11, Total time: 2.974 ms [By time] [By id] [By file]
1 (0.152)
SELECT data
FROM `oc_session`
WHERE session_id = '20c440ad15da877e0b2ceebeaa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1.337)
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('+piquet' 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.111)
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 (0.291)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.202)
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
8 (0.113)
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
9 (0.070)
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
10 (0.363)
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
11 (0.107)
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