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


INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 40 SIC
Exclusiv online!

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 40 SIC

81014140
Livrare 24-48 ore

20,00Lei

Carlig Owner 5114 Mutu Light Circle Nr.6/0

Carlig Owner 5114 Mutu Light Circle Nr.6/0

5114008
Livrare imediată!

18,75Lei

PRASTIE COLMIC SPECTRA LIGHT SOFT POUCH 2 Elastic 3mm
Exclusiv online!

PRASTIE COLMIC SPECTRA LIGHT SOFT POUCH 2 Elastic 3mm

fncq011
Livrare 48-72ore

51,00Lei

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 30 SIC

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 30 SIC

81014130
Livrare imediată!

14,49Lei

CARP EXPERT PRASTIE VIERMUSI LIGHT 2
Exclusiv online!

CARP EXPERT PRASTIE VIERMUSI LIGHT 2

80253037
Livrare 24-48 ore

19,00Lei

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 6 SIC
Exclusiv online!

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 6 SIC

81023106
Livrare 24-48 ore

5,50Lei

VOBLER RAPALA ULTRA LIGHT SHAD 4CM / 3GR GDAU
Exclusiv online!

VOBLER RAPALA ULTRA LIGHT SHAD 4CM / 3GR GDAU

uls04 gdau
Livrare 48-72ore

42,00Lei

Carlig Owner 5114 Mutu Light Circle Nr.4/0

Carlig Owner 5114 Mutu Light Circle Nr.4/0

5114010
Livrare imediată!

18,75Lei

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 25 SIC

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 25 SIC

81014125
Livrare imediată!

11,50Lei

Carlig Owner 4105 Nr.2 Mosquito Light
Exclusiv online!

Carlig Owner 4105 Nr.2 Mosquito Light

410510
Livrare 48-72 ore

12,22Lei

Tija Guru Interschimbabila cu Elastic Alb Guru X-Safe Speed Stems Light 2buc/blister 7cm
Exclusiv online!

Tija Guru Interschimbabila cu Elastic Alb Guru X-Safe Speed Stems Light 2buc/blister 7cm

a.gu.gxqm
Livrare 24-48 ore

23,21Lei

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 50 SIC

INEL ENERGOTEAM 2 PICIOARE UVSIG LIGHT 50 SIC

81014150
Livrare imediată!

45,01Lei

Vobler Rapala Ultra Light Shad 4cm 3gr CH
Exclusiv online!

Vobler Rapala Ultra Light Shad 4cm 3gr CH

uls04 ch
Livrare 48-72ore

42,00Lei

Vobler Rapala Ultra Light Shad 4cm/3gr. G
Exclusiv online!

Vobler Rapala Ultra Light Shad 4cm/3gr. G

uls04 g
Livrare 48-72ore

42,00Lei

Lanseta Nevis Nitro Spin Ultra Light 2.10m
Exclusiv online!

Lanseta Nevis Nitro Spin Ultra Light 2.10m

1434-210
Livrare 48-72 ore

168,00Lei

Lanseta Nevis Nitro Spin Ultra Light 1.80m
Exclusiv online!

Lanseta Nevis Nitro Spin Ultra Light 1.80m

1434-180
Livrare 48-72 ore

146,00Lei

VOBLER RAPALA SD ULTRA LIGHT MINNOW
Exclusiv online!

VOBLER RAPALA SD ULTRA LIGHT MINNOW

ulm04 sd
Livrare 48-72ore

42,00Lei

Lanseta Zebco Great White GWC Light Pilk 2.40m 150gr

Lanseta Zebco Great White GWC Light Pilk 2.40m 150gr

13094240
Livrare imediată!

211,28Lei

Carlige Owner Mutu Light Wire 5114, Nr.6, 10buc/plic -26%

Carlige Owner Mutu Light Wire 5114, Nr.6, 10buc/plic

5114006
Livrare imediată!

18,75Lei(-26%) 13,90Lei

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 12 SIC
Exclusiv online!

Inel EnergoTeam Bolognese GUN-SSFSIG LIGHT 12 SIC

81023112
Livrare 24-48 ore

7,00Lei

Afişare 241 - 260 din 905 (46 pagini)
Queries: 10, Total time: 28.382 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = 'adf272ed24090b159c018650f0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (23.280)
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('+light' 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 (4.103)
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 240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.140)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.131)
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