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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Saltea de primire Delphin cu laterale DuoMAT XXL 80x140 / 45x100x20 -29%

Saltea de primire Delphin cu laterale DuoMAT XXL 80x140 / 45x100x20

101001505
Livrare imediată!

304,00Lei(-29%) 215,00Lei

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.XXL
Exclusiv online!

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.XXL

a8.kcl428
Livrare 24-48 ore

632,16Lei

HANORAC PROLOGIC CARPIO ZIP ARMY GREEN MARIME XXL
Exclusiv online!

HANORAC PROLOGIC CARPIO ZIP ARMY GREEN MARIME XXL

a8.pro.73759
Livrare 24-48 ore

246,78Lei

Tricou Matrix LW Polo Shirt XXL -26%

Tricou Matrix LW Polo Shirt XXL

gpr238
Livrare imediată!

107,31Lei(-26%) 79,90Lei

VESTA KORDA KORE FLEECE OLIVE MAR.XXL
Exclusiv online!

VESTA KORDA KORE FLEECE OLIVE MAR.XXL

a8.kcl598
Livrare 24-48 ore

209,11Lei

SALOPETA GAMAKATSU SOFTSHELL MARIME XXL -20%
Exclusiv online!

SALOPETA GAMAKATSU SOFTSHELL MARIME XXL

a8.gk.7254.1500
Livrare 24-48 ore

528,82Lei(-20%) 423,06Lei

Hanorac Nash Lightweight Hoody, Marime XXL

Hanorac Nash Lightweight Hoody, Marime XXL

c5694
Livrare imediată!

209,99Lei

PANTALON KORDA LITE JOGGER OLIVE MAR.XXL -18%

PANTALON KORDA LITE JOGGER OLIVE MAR.XXL

a8.kcl434
Livrare imediată!

232,30Lei(-18%) 189,90Lei

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO MARIME XXL

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO MARIME XXL

a8.kcl392
Livrare imediată!

232,31Lei

JACHETA KORDA KORE THERMOLITE Negru MAR.XXL
Exclusiv online!

JACHETA KORDA KORE THERMOLITE Negru MAR.XXL

a8.kcl470
Livrare 24-48 ore

708,79Lei

Tava Laterala Garbolino XXL cu 2 Bacuri Rectangulare si Cort
Exclusiv online!

Tava Laterala Garbolino XXL cu 2 Bacuri Rectangulare si Cort

995040002
Livrare 48-72 ore

912,31Lei

Manusi Cultiva Cold Block Negre XXL
Exclusiv online!

Manusi Cultiva Cold Block Negre XXL

810379897-5
Livrare 48-72 ore

220,23Lei

Manusi Cultiva Quick Jigging Casting Blue XXL
Exclusiv online!

Manusi Cultiva Quick Jigging Casting Blue XXL

810379919-150
Livrare 48-72 ore

161,49Lei

BLUZA CPK CU PROTECTIE UV Camo Marime XXL

BLUZA CPK CU PROTECTIE UV Camo Marime XXL

1000653
Livrare imediată!

130,00Lei

BLUZA DAIWA D-VEC LS WHITE MARIME XXL
Exclusiv online!

BLUZA DAIWA D-VEC LS WHITE MARIME XXL

d.18206.150
Livrare 24-48 ore

190,69Lei

BLUZA CPK CU PROTECTIE UV Marime XXL

BLUZA CPK CU PROTECTIE UV Marime XXL

1000174
Livrare imediată!

115,00Lei

TRICOU FOX RAGE LIMITED EDITION PIKE T-SHIRT BLACK MAR XXL -30%

TRICOU FOX RAGE LIMITED EDITION PIKE T-SHIRT BLACK MAR XXL

npr402
Livrare imediată!

139,96Lei(-30%) 97,97Lei

Tricou Delphin ICWT XXL

Tricou Delphin ICWT XXL

101001866
Livrare imediată!

82,00Lei

Pantaloni Lungi Avid Carp Distortion Joggers XXL
Exclusiv online!

Pantaloni Lungi Avid Carp Distortion Joggers XXL

a0620132
Livrare 7-14 zile

157,46Lei

TRICOU KORDA LIGHT KAMO MAR.XXL

TRICOU KORDA LIGHT KAMO MAR.XXL

a8.kcl356
Livrare imediată!

148,65Lei

Afişare 41 - 60 din 682 (35 pagini)
Queries: 5, Total time: 21.530 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = 'd68b7cb17ec8da1029ea45b37b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.280)
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('+xxl' 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 (2.904)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.096)
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