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


Mulineta DAM Quick 5 4000 FD

Mulineta DAM Quick 5 4000 FD

3020956937
Livrare imediată!

406,24Lei

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 025MM/17,5KG/110M -22%

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 025MM/17,5KG/110M

p.1308659
Livrare imediată!

79,49Lei(-22%) 61,90Lei

FIR TRABUCCO S-FORCE XPS SURF CASTING 300mt-0,20mm

FIR TRABUCCO S-FORCE XPS SURF CASTING 300mt-0,20mm

053-47-200
Livrare imediată!

41,00Lei

FIR MONOFILAMENT CARBOTEX DSC 040MM/20,6KG/300M
Exclusiv online!

FIR MONOFILAMENT CARBOTEX DSC 040MM/20,6KG/300M

e.4900.040
Livrare 24-48 ore

31,09Lei

SAC SPRO C-TEC PTR PASTRAT PESTELE M 85X105 CM
Exclusiv online!

SAC SPRO C-TEC PTR PASTRAT PESTELE M 85X105 CM

003241-00200-00000
Livrare 48-72 ore

70,00Lei

Lanterna Frontala Led Lenser H19R Core Reincarcabila 3500 Lumeni 200 Metri

Lanterna Frontala Led Lenser H19R Core Reincarcabila 3500 Lumeni 200 Metri

a8.z502124
Livrare imediată!

1.142,26Lei

Carlige Gamakatsu 3020f 25BUC/PLIC nr 6

Carlige Gamakatsu 3020f 25BUC/PLIC nr 6

gk.146567.6
Livrare imediată!

20,47Lei

CRACAN JAXON TELE VARF CUI 70-125CM

CRACAN JAXON TELE VARF CUI 70-125CM

pz-stb120
Livrare imediată!

28,00Lei

Carlig Owner CUT CHINU Auriu 50328 nr 6 - 20buc/plic

Carlig Owner CUT CHINU Auriu 50328 nr 6 - 20buc/plic

5032809
Livrare imediată!

12,88Lei

PALETA NADIT MARE JAXON CU MANER 120CM

PALETA NADIT MARE JAXON CU MANER 120CM

ac-pc051b
Livrare imediată!

175,00Lei

Zebco Bank Stick stainless steel 75cm

Zebco Bank Stick stainless steel 75cm

8200010
Livrare imediată!

31,29Lei

FIR TRABUCCO T-FORCE XPS POWER PLUS 50m/0,12,mm

FIR TRABUCCO T-FORCE XPS POWER PLUS 50m/0,12,mm

053-83-120
Livrare imediată!

26,00Lei

Juvelnic Energo Team 3 Cercuri BASIC 30 70CM

Juvelnic Energo Team 3 Cercuri BASIC 30 70CM

72090330
Livrare imediată!

12,00Lei

Fir Monofilament Carp Spirit Riga Mortis Lo-Vis Green Chod Hooklink 20m, 15lbs, 6.80kg -28%

Fir Monofilament Carp Spirit Riga Mortis Lo-Vis Green Chod Hooklink 20m, 15lbs, 6.80kg

acs640053
Livrare imediată!

39,00Lei(-28%) 27,91Lei

FIR MAVER SMART M1 300m 0.190mm -30%
Exclusiv online!

FIR MAVER SMART M1 300m 0.190mm

692019
Livrare 48-72 ore

31,00Lei(-30%) 21,71Lei

Dip Crafty Catcher Hookbait Fast Food Crab Meat Sea Salt 200ml -30%

Dip Crafty Catcher Hookbait Fast Food Crab Meat Sea Salt 200ml

v00413
Livrare imediată!

27,50Lei(-30%) 19,19Lei

Z-JIG COLMIC 20gr
Exclusiv online!

Z-JIG COLMIC 20gr

amhkah02
Livrare 48-72 ore

29,00Lei

AGRAFA SAVAGE NEEDLE EGG SNAPS L 50KG, 20BUC -23%

AGRAFA SAVAGE NEEDLE EGG SNAPS L 50KG, 20BUC

a7.sg.54921
Livrare imediată!

11,53Lei(-23%) 8,90Lei

FIR COLMIC SEAGUAR SOFT FLUOROCARBON 50M 0.205mm -40%
Exclusiv online!

FIR COLMIC SEAGUAR SOFT FLUOROCARBON 50M 0.205mm

nysf020
Livrare 48-72 ore

69,00Lei(-40%) 41,40Lei

PB ANTI TANGLE SLEEVES SILT-NAMOL

PB ANTI TANGLE SLEEVES SILT-NAMOL

pb20161
Livrare imediată!

29,90Lei

Afişare 5561 - 5580 din 19323 (967 pagini)
Queries: 5, Total time: 1,050.025 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = 'e425642502554a634d41253e1b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (956.649)
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 (pd.tag LIKE "%20%") 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 (93.028)
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 5560, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
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