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


Manusi Delphin Atak Free XL

Manusi Delphin Atak Free XL

750001052
Livrare imediată!

72,00Lei

Lanseta Shimano Poison Adrena Cast 172H 2.18m/12-42g -19%

Lanseta Shimano Poison Adrena Cast 172H 2.18m/12-42g

18padrn172h
Livrare imediată!

1.800,01Lei(-19%) 1.462,00Lei

Maner Minciog Garbolino Express Carp Telenet 3.00m

Maner Minciog Garbolino Express Carp Telenet 3.00m

50230gomnj6044300-3
Livrare imediată!

106,79Lei

Manson Ronnie Rig Fox 10/buc Plic

Manson Ronnie Rig Fox 10/buc Plic

cac788
Livrare imediată!

21,40Lei

CROSETA Pro Line GLOW IN THE DARK SNOWMAN NEEDLE

CROSETA Pro Line GLOW IN THE DARK SNOWMAN NEEDLE

pl2655
Livrare imediată!

25,00Lei

BLUZA FOX RAGE CU MANECA LUNGA MARL MARIME XL -24%

BLUZA FOX RAGE CU MANECA LUNGA MARL MARIME XL

npr288
Livrare imediată!

111,78Lei(-24%) 84,89Lei

Mulineta Okuma Carbonite V2 Match 40MSDH maner dublu
Exclusiv online!

Mulineta Okuma Carbonite V2 Match 40MSDH maner dublu

cbv-40msdh
Livrare 48-72ore

224,10Lei

Maner Minciog Garbolino Trooper Telenet 3.20m

Maner Minciog Garbolino Trooper Telenet 3.20m

50230gomnj6013320-3
Livrare imediată!

74,68Lei

Dumbells Genlog Method Feeder, 6mm, Mango Peach
Exclusiv online!

Dumbells Genlog Method Feeder, 6mm, Mango Peach

dmf0607
Livrare 48-72 ore

25,00Lei

Maner Minciog Garbolino Express Put Over Net 3m

Maner Minciog Garbolino Express Put Over Net 3m

50230gomnj6053300-3
Livrare imediată!

116,83Lei

Maner Minciog Garbolino Express Put Over Net 2m
Exclusiv online!

Maner Minciog Garbolino Express Put Over Net 2m

50230gomnj6053200-2
Livrare 48-72 ore

89,23Lei

, Vobler, Rapala, BX, Skitter, Frog, 5.5cm/13g,, culoare, Toman, bxsf05 tmn, Voblere Floating, Voblere Floating Rapala, Rapala
Exclusiv online!

, Vobler, Rapala, BX, Skitter, Frog, 5.5cm/13g,, culoare, Toman, bxsf05 tmn, Voblere Floating, Voblere Floating Rapala, Rapala

bxsf05 tmn
Livrare 48-72ore

62,00Lei

Maner Minciog Garbolino Express Put Over Net 4m

Maner Minciog Garbolino Express Put Over Net 4m

50230gomnj6053400-4
Livrare imediată!

132,46Lei

LANTERNA TFX PROPUS 1200, 1200 LUMENI LI-ION + CABLU USB
Exclusiv online!

LANTERNA TFX PROPUS 1200, 1200 LUMENI LI-ION + CABLU USB

a8.z502555
Livrare 24-48 ore

445,80Lei

Nada CPK Bagman Sticky Mix Sweet 800g

Nada CPK Bagman Sticky Mix Sweet 800g

1000606
Livrare imediată!

25,00Lei

Mulineta Trabucco Mantis FDX 6500

Mulineta Trabucco Mantis FDX 6500

034-82-650
Livrare imediată!

199,00Lei

MANUSI GAMAKATSU CU DEGETE TAIATE MARIME XXL
Exclusiv online!

MANUSI GAMAKATSU CU DEGETE TAIATE MARIME XXL

a8.gk.7239.210
Livrare 24-48 ore

79,19Lei

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL
Exclusiv online!

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL

a8.sg.76464
Livrare 24-48 ore

71,05Lei

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.XL -30%
Exclusiv online!

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.XL

a8.sg.76485
Livrare 24-48 ore

92,53Lei(-30%) 64,77Lei

MANUSI SAVAGE GEAR MANUSI SOFTSHELL GREY MAR.l
Exclusiv online!

MANUSI SAVAGE GEAR MANUSI SOFTSHELL GREY MAR.l

a8.sg.76460
Livrare 24-48 ore

123,09Lei

Afişare 121 - 140 din 2458 (123 pagini)
Queries: 7, Total time: 312.964 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '7f033f47a6d58c0098c4c9cbf7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.235)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (302.150)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%man%") 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:698
4 (10.026)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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
6 (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
7 (0.141)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38