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


Termos Carp Spirit Inox 1L
Exclusiv online!

Termos Carp Spirit Inox 1L

acs010170
Livrare 48-72ore

109,00Lei

COSTUM TERMO JAXON FLOATING XL
Exclusiv online!

COSTUM TERMO JAXON FLOATING XL

uj-fxsaxl
Livrare 48-72 ore

1.084,99Lei

Tub Termocontractabil Select Baits Shrink Tube 2mm

Tub Termocontractabil Select Baits Shrink Tube 2mm

sel-217994
Livrare imediată!

6,00Lei

Termos Coleman 1l

Termos Coleman 1l

204508
Livrare imediată!

145,00Lei

COSTUM TERMO JAXON GREENLAND -15C M
Exclusiv online!

COSTUM TERMO JAXON GREENLAND -15C M

uj-fxim
Livrare 48-72 ore

190,00Lei

Geanta termoizolanta Campingaz MiniMaxi, 19ltr, Pink Daisy
Exclusiv online!

Geanta termoizolanta Campingaz MiniMaxi, 19ltr, Pink Daisy

2000013689
Livrare 24-48 ore

105,01Lei

Ciorapi Jaxon Termo Gri, Marime 46
Exclusiv online!

Ciorapi Jaxon Termo Gri, Marime 46

ab-kfb46
Livrare 48-72 ore

99,00Lei

Geanta termoizolanta Campingaz Entertainer 18l

Geanta termoizolanta Campingaz Entertainer 18l

2000020151
Livrare imediată!

165,01Lei

Tub Mostiro Termocontractabil 1M negru 1,5 Mm

Tub Mostiro Termocontractabil 1M negru 1,5 Mm

2930020210015
Livrare imediată!

4,78Lei

GEANTA COLMIC FRIGO RIO SERIA RED 40x28x29cm
Exclusiv online!

GEANTA COLMIC FRIGO RIO SERIA RED 40x28x29cm

bo209
Livrare 48-72 ore

330,00Lei

Geanta termoizolanta Campingaz Entertainer 16l

Geanta termoizolanta Campingaz Entertainer 16l

2000020150
Livrare imediată!

115,00Lei

Ciorapi pentru Cizme Jaxon Termo Gri, Marime 47
Exclusiv online!

Ciorapi pentru Cizme Jaxon Termo Gri, Marime 47

ab-kfb47
Livrare 48-72 ore

99,00Lei

Ciorapi pentru Cizme Jaxon Termo Negri, Marime 46 -15%

Ciorapi pentru Cizme Jaxon Termo Negri, Marime 46

up-oc0146
Livrare imediată!

21,00Lei(-15%) 17,90Lei

TUB TERMO-RETRACTABIL KORDA S D=1,2MM/L=55MM/8BUC

TUB TERMO-RETRACTABIL KORDA S D=1,2MM/L=55MM/8BUC

a.kst12
Livrare imediată!

20,87Lei

Geanta Delphin Area COOL Carpath

Geanta Delphin Area COOL Carpath

420220210
Livrare imediată!

126,10Lei

CIZME LEMIGO -50 C EVA ARCTIC TERMO+ 875 MAR.41
Exclusiv online!

CIZME LEMIGO -50 C EVA ARCTIC TERMO+ 875 MAR.41

lx.7587500.41
Livrare 24-48 ore

235,66Lei

Geanta Campingaz termoizolanta pliabila 20ltr

Geanta Campingaz termoizolanta pliabila 20ltr

2000011724
Livrare imediată!

110,00Lei

Geanta termoizolanta Campingaz Shopping 15ltr
Exclusiv online!

Geanta termoizolanta Campingaz Shopping 15ltr

2000013686
Livrare 24-48 ore

75,01Lei

Ciorapi pentru Cizme Jaxon Termo Negri, Marime 45 -20%

Ciorapi pentru Cizme Jaxon Termo Negri, Marime 45

up-oc0145
Livrare imediată!

26,00Lei(-20%) 20,80Lei

CIORAPI LEMIGO TERMOIZOLANT PT CIZMA GRENLANDER MAR.41
Exclusiv online!

CIORAPI LEMIGO TERMOIZOLANT PT CIZMA GRENLANDER MAR.41

lx.c984901.41
Livrare 24-48 ore

53,44Lei

Afişare 81 - 100 din 419 (21 pagini)
Queries: 7, Total time: 628.894 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = 'ad70832228837c0372765123cb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (626.134)
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 (pd.tag LIKE "%termo%") 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
5 (2.196)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.139)
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.129)
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