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


MONTURA PLUMB PIERDUT KORDA MINI HELI SAFE GREEN

MONTURA PLUMB PIERDUT KORDA MINI HELI SAFE GREEN

a.khdgs
Livrare imediată!

37,13Lei

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g
Exclusiv online!

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g

a0.s44783
Livrare 24-48 ore

30,59Lei

Momitor CARP HUNTER FLAT METHOD MINI 35G
Exclusiv online!

Momitor CARP HUNTER FLAT METHOD MINI 35G

79661235
Livrare 24-48 ore

10,00Lei

Vobler Rapala Mini Fat Rap, Culoare CBN, 3cm, 4g
Exclusiv online!

Vobler Rapala Mini Fat Rap, Culoare CBN, 3cm, 4g

mfr03 cbn
Livrare 48-72ore

42,99Lei

Momitor Lestat Feeder Guru X CHANGE MINI 15G 20G
Exclusiv online!

Momitor Lestat Feeder Guru X CHANGE MINI 15G 20G

a.gu.gad19
Livrare 24-48 ore

23,00Lei

Lampa EnergoTeam Outdoor Mini Camping 200 Lumeni

Lampa EnergoTeam Outdoor Mini Camping 200 Lumeni

74991020
Livrare imediată!

27,36Lei

SHAD NOMURA MINI 5.5CM 2G 5BUC/PLIC -30%
Exclusiv online!

SHAD NOMURA MINI 5.5CM 2G 5BUC/PLIC

f1.nm.73707005
Livrare 24-48 ore

38,23Lei(-30%) 26,76Lei

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g
Exclusiv online!

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g

f3.d15208.009
Livrare 24-48 ore

44,84Lei

PROLOGIC KIT K1 MINI HANGER INDICATOR 5 CULORI

PROLOGIC KIT K1 MINI HANGER INDICATOR 5 CULORI

a.pro.65018
Livrare imediată!

287,49Lei

Paleta Nadire Delphin Dumper Full Mini 15x9cm

Paleta Nadire Delphin Dumper Full Mini 15x9cm

101001476
Livrare imediată!

29,00Lei

Momitor Guru Method Feeder In-Line Extra Distance Hybrid Super Mini 20g
Exclusiv online!

Momitor Guru Method Feeder In-Line Extra Distance Hybrid Super Mini 20g

a.gu.gfd001
Livrare 24-48 ore

18,54Lei

Momitor CARP HUNTER FLAT METHOD MINI 25G
Exclusiv online!

Momitor CARP HUNTER FLAT METHOD MINI 25G

79661225
Livrare 24-48 ore

9,00Lei

Vobler Rapala Mini Fat Rap, Culoare GAU, 3cm, 4g
Exclusiv online!

Vobler Rapala Mini Fat Rap, Culoare GAU, 3cm, 4g

mfr03 gau
Livrare 48-72ore

42,99Lei

SHAD NOMURA MINI REAL PULSE 5CM 0.7G TIGER BACK 5BUC/PLIC
Exclusiv online!

SHAD NOMURA MINI REAL PULSE 5CM 0.7G TIGER BACK 5BUC/PLIC

f1.nm.73407605
Livrare 24-48 ore

37,04Lei

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2G Argint+cap albastru

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2G Argint+cap albastru

pmid1pa
Livrare imediată!

9,90Lei

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2.5G Argint+cap albastru

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2.5G Argint+cap albastru

pmid2pa
Livrare imediată!

10,81Lei

LINGURA ROTATIVA MAPSO LUKRIS MINI FLY D-OR 2g

LINGURA ROTATIVA MAPSO LUKRIS MINI FLY D-OR 2g

pmifd1or
Livrare imediată!

17,50Lei

Shad Rapture Mini Minnow Shad Tail 4.5cm 6buc/plic Hot Silver

Shad Rapture Mini Minnow Shad Tail 4.5cm 6buc/plic Hot Silver

187-99-071
Livrare imediată!

25,00Lei

Cleste pentru Sertizat Korda Mini Krimp Tool
Exclusiv online!

Cleste pentru Sertizat Korda Mini Krimp Tool

a.kkts
Livrare 24-48 ore

87,95Lei

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2G Argint+cap negru

LINGURA ROTATIVA MAPSO LUKRIS MINI D 2G Argint+cap negru

pmid1pn
Livrare imediată!

9,90Lei

Afişare 281 - 300 din 561 (29 pagini)
Queries: 6, Total time: 14.942 ms [By time] [By id] [By file]
1 (0.157)
SELECT data
FROM `oc_session`
WHERE session_id = 'db9d7565be631021af96bf4c93'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (14.262)
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 = '2' AND (MATCH(pd.tag) AGAINST('+mini' 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.150)
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
5 (0.130)
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.130)
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