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

Produse ce potrivesc criteriilor de căutare


Pantaloni Nash Combats Regular XXL -37%

Pantaloni Nash Combats Regular XXL

c2093
Livrare imediată!

317,00Lei(-37%) 199,90Lei

Pelerina, Impermeabila, Carp, Zoom,, Marime, XXXL, cz7213, Pelerine si Costume Ploaie, Pelerine si Costume Ploaie Carp Zoom, Pelerine Carp Zoom, Costume Carp Zoom, Ploaie Carp Zoom, Carp Zoom -20%
BOILIES, CPK, XXL, SOLUBIL, 1KG, 20MM, 999003, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

BOILIES, CPK, XXL, SOLUBIL, 1KG, 20MM, 999003, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

999003
Livrare imediată!

57,00Lei

GEACA JAXON ALASKA CU POLAR DETASABIL XXL -30%
Exclusiv online!

GEACA JAXON ALASKA CU POLAR DETASABIL XXL

uj-fxbbxxl
Livrare 48-72 ore

458,99Lei(-30%) 321,00Lei

GEACA JAXON EXTREME COLD III XXL
Exclusiv online!

GEACA JAXON EXTREME COLD III XXL

uj-fxlaxxl
Livrare 48-72 ore

592,00Lei

COSTUM TERMO JAXON GREENLAND -30C XXL -30%
Exclusiv online!

COSTUM TERMO JAXON GREENLAND -30C XXL

uj-fxnxxl
Livrare 48-72 ore

235,00Lei(-30%) 165,01Lei

BOILIES, CPK, TARE, XXL, 1KG, 16MM, 999202, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

BOILIES, CPK, TARE, XXL, 1KG, 16MM, 999202, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

999202
Livrare imediată!

57,00Lei

COSTUM PLOAIE JAXON VERDE XXXL -22%

COSTUM PLOAIE JAXON VERDE XXXL

uj-akpxxxl
Livrare imediată!

167,00Lei(-22%) 130,90Lei

GEACA COLMIC SOFTSHELL GRI/ALBASTRU XXXL -30%
Exclusiv online!

GEACA COLMIC SOFTSHELL GRI/ALBASTRU XXXL

abg005f
Livrare 48-72 ore

421,00Lei(-30%) 294,00Lei

PANTALONI JAXON EXTREME COLD III XXL
Exclusiv online!

PANTALONI JAXON EXTREME COLD III XXL

uj-fxlbxxl
Livrare 48-72 ore

484,00Lei

PORUMB CARP ZOOM XXL MAMMOTH 220ML AROMA VANILIE

PORUMB CARP ZOOM XXL MAMMOTH 220ML AROMA VANILIE

cz2335
Livrare imediată!

19,00Lei

COSTUM IMPERMEABIL PROLOGIC HIGHGRADE THERMO MARIMEA XXL -20%

COSTUM IMPERMEABIL PROLOGIC HIGHGRADE THERMO MARIMEA XXL

a8.pro.55627
Livrare imediată!

766,73Lei(-20%) 613,30Lei

Minciog Carp Zoom Gamma XXL 2 Sec. 100x100x280cm

Minciog Carp Zoom Gamma XXL 2 Sec. 100x100x280cm

cz1406
Livrare imediată!

227,00Lei

JACHETA, PROLOGIC, LITEPRO, THERMO, MARIMEA, XXL, a8.pro.51550, Geci si Jachete, Geci si Jachete Prologic, Prologic
Exclusiv online!

JACHETA, PROLOGIC, LITEPRO, THERMO, MARIMEA, XXL, a8.pro.51550, Geci si Jachete, Geci si Jachete Prologic, Prologic

a8.pro.51550
Livrare 24-48 ore

483,98Lei

Bluza Carp Zoom Predator Z Oplus marime XXL
Exclusiv online!

Bluza Carp Zoom Predator Z Oplus marime XXL

cz4342
Livrare 48-72 ore

147,00Lei

GEACA JAXON ALASKA XXL -30%
Exclusiv online!

GEACA JAXON ALASKA XXL

uj-fxbaxxl
Livrare 48-72 ore

311,99Lei(-30%) 218,00Lei

Masa Fox XXL Session Table

Masa Fox XXL Session Table

cac752
Livrare imediată!

854,96Lei

Husa Mulineta Carp Academy XXL 26x21x12 Cm

Husa Mulineta Carp Academy XXL 26x21x12 Cm

5204-003
Livrare imediată!

64,00Lei

BOILIES, CPK, XXL, TARE, 1KG, 20MM, 999001, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

BOILIES, CPK, XXL, TARE, 1KG, 20MM, 999001, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

999001
Livrare imediată!

50,00Lei

PANTALONI JAXON ALASKA XXL -30%
Exclusiv online!

PANTALONI JAXON ALASKA XXL

uj-fxbcxxl
Livrare 48-72 ore

251,99Lei(-30%) 176,00Lei

Afişare 221 - 240 din 955 (48 pagini)
Queries: 6, Total time: 194.284 ms [By time] [By id] [By file]
1 (0.483)
SELECT data
FROM `oc_session`
WHERE session_id = 'e2ae296e78bd4fd698a56c7bf4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.113)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (189.402)
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 "%xxl%") 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 (4.063)
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 220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.128)
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