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


MULINETA PROLOGIC Avenger XD 8000FD -10%

MULINETA PROLOGIC Avenger XD 8000FD

o.pro.74709
Livrare imediată!

359,59Lei(-10%) 323,64Lei

Mulineta Prologic Avenger XD 7000 FD -10%

Mulineta Prologic Avenger XD 7000 FD

o.pro.74708
Livrare imediată!

359,59Lei(-10%) 323,64Lei

PROLOGIC SALTEA PRIMIRE TIP CADITA AVENGER PRO CRAP 90X135CM -50%
Exclusiv online!

PROLOGIC SALTEA PRIMIRE TIP CADITA AVENGER PRO CRAP 90X135CM

a.pro.65001
Livrare 24-48 ore

368,03Lei(-50%) 184,02Lei

Saltea Primire Prologic Avenger Pro Crap 120x75cm -50%
Exclusiv online!

Saltea Primire Prologic Avenger Pro Crap 120x75cm

a.pro.65002
Livrare 24-48 ore

295,08Lei(-50%) 147,54Lei

Mulineta Prologic Avenger 6000 BF -20%

Mulineta Prologic Avenger 6000 BF

o.pro.74703
Livrare imediată!

253,89Lei(-20%) 203,11Lei

Saltea Primire Prologic Avenger Roll Up Flat Mat, 95x50cm -50%
Exclusiv online!

Saltea Primire Prologic Avenger Roll Up Flat Mat, 95x50cm

a.pro.65003
Livrare 24-48 ore

228,10Lei(-50%) 114,05Lei

MULINETA PROLOGIC AVENGER 5000 BF 5RUL/200MX035/5,2:1 -20%

MULINETA PROLOGIC AVENGER 5000 BF 5RUL/200MX035/5,2:1

o.pro.74702
Livrare imediată!

228,52Lei(-20%) 182,81Lei

MULINETA PROLOGIC AVENGER 4000 BF 5RUL/340MX025/5,2:1 -30%

MULINETA PROLOGIC AVENGER 4000 BF 5RUL/340MX025/5,2:1

o.pro.74701
Livrare imediată!

218,37Lei(-30%) 152,86Lei

MULINETA PROLOGIC AVENGER 3000 BF 5RUL/280MX025/5,1:1 -45%
Exclusiv online!

MULINETA PROLOGIC AVENGER 3000 BF 5RUL/280MX025/5,1:1

o.pro.74700
Livrare 24-48 ore

192,73Lei(-45%) 105,12Lei

Geanta Prologic Buzz-Bar Avenger L -21%

Geanta Prologic Buzz-Bar Avenger L

a8.pro.65068
Livrare imediată!

108,30Lei(-21%) 85,89Lei

GEANTA PROLOGIC AVENGER CARRYALL MAR.L

GEANTA PROLOGIC AVENGER CARRYALL MAR.L

a8.pro.65063
Livrare imediată!

349,93Lei

Geanta Accesorii Prologic Avenger M 20x10x6cm

Geanta Accesorii Prologic Avenger M 20x10x6cm

a8.pro.65070
Livrare imediată!

56,00Lei

GEANTA PROLOGIC AVENGER CARRYALL MAR.2XL

GEANTA PROLOGIC AVENGER CARRYALL MAR.2XL

a8.pro.65064
Livrare imediată!

430,23Lei

LANSETA OKUMA AVENGER CARP SPOD 3.60m, 4.5lbs, 2seg
Exclusiv online!

LANSETA OKUMA AVENGER CARP SPOD 3.60m, 4.5lbs, 2seg

av-ca-1202xh
Livrare 48-72ore

359,09Lei

COSTUM PROLOGIC AVENGER THERMAL CAMO L -23%

COSTUM PROLOGIC AVENGER THERMAL CAMO L

a8.pro.76662
Livrare imediată!

919,89Lei(-23%) 707,90Lei

COSTUM PROLOGIC AVENGER THERMAL CAMO XL -23%

COSTUM PROLOGIC AVENGER THERMAL CAMO XL

a8.pro.76663
Livrare imediată!

919,89Lei(-23%) 707,90Lei

COSTUM PROLOGIC AVENGER THERMAL CAMO M -23%

COSTUM PROLOGIC AVENGER THERMAL CAMO M

a8.pro.76661
Livrare imediată!

919,89Lei(-23%) 707,90Lei

COSTUM PROLOGIC AVENGER THERMAL CAMO XXL -23%

COSTUM PROLOGIC AVENGER THERMAL CAMO XXL

a8.pro.76664
Livrare imediată!

919,89Lei(-23%) 707,90Lei

COSTUM PROLOGIC AVENGER THERMAL CAMO XXXL

COSTUM PROLOGIC AVENGER THERMAL CAMO XXXL

a8.pro.76665
Livrare imediată!

919,89Lei

Mulineta Prologic Avenger 5000 BF SST Graph Spare Spool, 0.35mm-200m, 5.2:1, 3+1BB

Mulineta Prologic Avenger 5000 BF SST Graph Spare Spool, 0.35mm-200m, 5.2:1, 3+1BB

o.pro.76024
Livrare imediată!

228,52Lei

Afişare 1 - 20 din 86 (5 pagini)
Queries: 9, Total time: 228.792 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '54bb321c80f22c55c4c9995c58'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.138)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (227.309)
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 = '0' AND (pd.tag LIKE "%avenger%") 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
5 (0.648)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.133)
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.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38