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


Lingura Oscilanta 22gr 55mm DAM Effzett Standard Silver Copper -25%

Lingura Oscilanta 22gr 55mm DAM Effzett Standard Silver Copper

802095005022
Livrare imediată!

19,80Lei(-25%) 14,90Lei

LINGURITA OSCILANTA MISU GALBENA CUTA 16G
Exclusiv online!

LINGURITA OSCILANTA MISU GALBENA CUTA 16G

f3.osc.g.mc16
Livrare 24-48 ore

14,54Lei

LINGURITA OSCILANTA MISU NICHELATA MARE PARA GIGANT 17G

LINGURITA OSCILANTA MISU NICHELATA MARE PARA GIGANT 17G

f3.osc.mn.pag17
Livrare imediată!

18,83Lei

Lingura Oscilanta 6g 5.5cm Zebco Classic Spoon Gold

Lingura Oscilanta 6g 5.5cm Zebco Classic Spoon Gold

3390006
Livrare imediată!

8,78Lei

LINGURITA OSCILANTA DARA KILLER ARGINTATA SILURO 13GR
Exclusiv online!

LINGURITA OSCILANTA DARA KILLER ARGINTATA SILURO 13GR

1403200101300
Livrare 48-72 ore

19,00Lei

OSCILANTA MEPPS TIGER 26 0G

OSCILANTA MEPPS TIGER 26 0G

f.syclops3.t
Livrare imediată!

33,15Lei

LINGURITA OSCILANTA MISU ARGINTATA MARE PALEASCA KILLER 15G

LINGURITA OSCILANTA MISU ARGINTATA MARE PALEASCA KILLER 15G

f3.osc.ma.pak15
Livrare imediată!

20,49Lei

LINGURITA OSCILANTA MISU NICHELATA MARCI KILLER 13G
Exclusiv online!

LINGURITA OSCILANTA MISU NICHELATA MARCI KILLER 13G

f3.osc.n.ma13
Livrare 24-48 ore

14,54Lei

OSCILANTA MEPPS FLUO 8,0G

OSCILANTA MEPPS FLUO 8,0G

f.syclops0.fl
Livrare imediată!

24,63Lei

LINGURA OSCILANTA CU SISTEM ANTIBRADIS RAPALA 6CM RFSH
Exclusiv online!

LINGURA OSCILANTA CU SISTEM ANTIBRADIS RAPALA 6CM RFSH

rms06 rfsh
Livrare 48-72ore

34,00Lei

LINGURITA OSCILANTA MISU NICHELATA MARE FRUNZA BIG 17G
Exclusiv online!

LINGURITA OSCILANTA MISU NICHELATA MARE FRUNZA BIG 17G

f3.osc.mn.fzb17
Livrare 24-48 ore

18,83Lei

Oscilanta Madcat A-Static Turbine Spoons 90gr Firetiger

Oscilanta Madcat A-Static Turbine Spoons 90gr Firetiger

13083156879
Livrare imediată!

45,41Lei

Lingura Oscilanta 16gr 45mm DAM Effzett Standard Glitter

Lingura Oscilanta 16gr 45mm DAM Effzett Standard Glitter

8025004016
Livrare imediată!

18,69Lei

OSCILANTA MEPPS TIGER 17 0G
Exclusiv online!

OSCILANTA MEPPS TIGER 17 0G

f.syclops2.t
Livrare 24-48 ore

30,13Lei

LINGURITA OSCILANTA BERTILURE TAIFUN NR.1 LUNGIME 53 MM. CULOARE ORANGE TAIL 7 GRAME

LINGURITA OSCILANTA BERTILURE TAIFUN NR.1 LUNGIME 53 MM. CULOARE ORANGE TAIL 7 GRAME

t-01-631
Livrare imediată!

18,75Lei

Lingura Oscilanta 28g 7cm Zebco Laxus Blinker Silver

Lingura Oscilanta 28g 7cm Zebco Laxus Blinker Silver

3394007
Livrare imediată!

17,78Lei

LINGURA OSCILANTA BERTILURE LUCKY REDTAIL XXL GOLD AMPRENTA PATRATE 7.8 CM 13 GRAME

LINGURA OSCILANTA BERTILURE LUCKY REDTAIL XXL GOLD AMPRENTA PATRATE 7.8 CM 13 GRAME

l-01-591
Livrare imediată!

19,65Lei

OSCILANTA MISU GALBENA CUTA 13G
Exclusiv online!

OSCILANTA MISU GALBENA CUTA 13G

f3.osc.g.mc13
Livrare 24-48 ore

14,54Lei

Lingura Oscilanta 16g 7cm Zebco Weedy Black Silver

Lingura Oscilanta 16g 7cm Zebco Weedy Black Silver

3389216
Livrare imediată!

17,78Lei

Lingura Oscilanta 6gr 32mm Effzett Super Natural Rainbow Trout -26%

Lingura Oscilanta 6gr 32mm Effzett Super Natural Rainbow Trout

802095050106
Livrare imediată!

22,86Lei(-26%) 16,90Lei

Afişare 541 - 560 din 3081 (155 pagini)
Queries: 6, Total time: 72.831 ms [By time] [By id] [By file]
1 (0.163)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7404ff3396b3042d6f51e3da5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (61.100)
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('+oscilanta' 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 (11.175)
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 540, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
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_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38