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

Produse ce potrivesc criteriilor de căutare


Papuci Ridge Monkey APEarel Dropback Sliders Marime 41-43 -27%

Papuci Ridge Monkey APEarel Dropback Sliders Marime 41-43

rm451
Livrare imediată!

136,08Lei(-27%) 99,90Lei

CAMASA BLASER TT 20 MARIME XL -30%
Exclusiv online!

CAMASA BLASER TT 20 MARIME XL

bl.121014.140.xl
Livrare 24-48 ore

532,63Lei(-30%) 372,84Lei

SALOPETA GAMAKATSU G-RAIN MARIME XXL -20%
Exclusiv online!

SALOPETA GAMAKATSU G-RAIN MARIME XXL

a8.gk.7246.1500
Livrare 24-48 ore

516,21Lei(-20%) 412,97Lei

HANORAC FOX LW BLACK/CAMO PRINT ZIP HOODY MARIME L

HANORAC FOX LW BLACK/CAMO PRINT ZIP HOODY MARIME L

cfx136
Livrare imediată!

156,50Lei

CAMASA BLASER TT 20 MARIME XXL -30%
Exclusiv online!

CAMASA BLASER TT 20 MARIME XXL

bl.121014.140.2xl
Livrare 24-48 ore

532,63Lei(-30%) 372,84Lei

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO, MARIME S -23%

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO, MARIME S

a8.kcl388
Livrare imediată!

232,31Lei(-23%) 178,90Lei

BOCANCI PROLOGIC BANK BOUND TREK MH CAMO Marime 45
Exclusiv online!

BOCANCI PROLOGIC BANK BOUND TREK MH CAMO Marime 45

a8.pro.64915
Livrare 24-48 ore

483,98Lei

Hanorac Delphin CATCH ME Kapor Marime M

Hanorac Delphin CATCH ME Kapor Marime M

101000636
Livrare imediată!

200,00Lei

PANTALON BLASER CHARGER HOSE MARIME 52
Exclusiv online!

PANTALON BLASER CHARGER HOSE MARIME 52

bl.121010.140.52
Livrare 24-48 ore

1.215,09Lei

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

BOCANCI PROLOGIC BANK BOUND TREK MH CAMO Marime 41
Exclusiv online!

BOCANCI PROLOGIC BANK BOUND TREK MH CAMO Marime 41

a8.pro.64911
Livrare 24-48 ore

461,84Lei

JACHETA BLASER TRANQUILITY CAMO MARIME XL
Exclusiv online!

JACHETA BLASER TRANQUILITY CAMO MARIME XL

bl.121008.140.xl
Livrare 24-48 ore

1.290,78Lei

Papuci Ridge Monkey APEarel Dropback Sliders Marime 39-41 -10%

Papuci Ridge Monkey APEarel Dropback Sliders Marime 39-41

rm492
Livrare imediată!

136,08Lei(-10%) 122,47Lei

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME XXL -20%
Exclusiv online!

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME XXL

a8.sg.73706
Livrare 24-48 ore

179,46Lei(-20%) 143,57Lei

PANTALON BLASER CHARGER HOSE MARIME 56
Exclusiv online!

PANTALON BLASER CHARGER HOSE MARIME 56

bl.121010.140.56
Livrare 24-48 ore

1.215,09Lei

JACHETA BLASER HERREN SUEDE MARLO MARIME 2XL
Exclusiv online!

JACHETA BLASER HERREN SUEDE MARLO MARIME 2XL

bl.121054.067.2xl
Livrare 24-48 ore

2.087,56Lei

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME M -20%
Exclusiv online!

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME M

a8.sg.73703
Livrare 24-48 ore

179,46Lei(-20%) 143,56Lei

PANTALON BLASER CHARGER HOSE MARIME 54
Exclusiv online!

PANTALON BLASER CHARGER HOSE MARIME 54

bl.121010.140.54
Livrare 24-48 ore

1.215,09Lei

JACHETA BLASER HERREN SUEDE MARLO MARIME XL
Exclusiv online!

JACHETA BLASER HERREN SUEDE MARLO MARIME XL

bl.121054.067.xl
Livrare 24-48 ore

2.087,56Lei

JACHETA FLEECE KORDA KORE POLAR, MARIME S -0%

JACHETA FLEECE KORDA KORE POLAR, MARIME S

a8.kcl322
Livrare imediată!

348,50Lei(-0%) 348,48Lei

Afişare 261 - 280 din 4145 (208 pagini)
Queries: 5, Total time: 95.925 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = 'fe7b1297242f044b77766b1c41'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (80.629)
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('+marime' 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:725
4 (14.933)
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 260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
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