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


Lampa Cort Carp Zoom Comet Reincarcabila, 500 Lumeni
Exclusiv online!

Lampa Cort Carp Zoom Comet Reincarcabila, 500 Lumeni

cz1899
Livrare 48-72 ore

189,00Lei

Lampa Cort Trakker Nitelife Bivvy Light 150

Lampa Cort Trakker Nitelife Bivvy Light 150

221507
Livrare imediată!

174,95Lei

Scut Vapori Nash Titan Hide XL Vapour Shield
Exclusiv online!

Scut Vapori Nash Titan Hide XL Vapour Shield

t4306
Livrare 7-14 zile

172,99Lei

Winterskin Nash Bank Life Blockhouse Camo Pro Overwrap

Winterskin Nash Bank Life Blockhouse Camo Pro Overwrap

t1153
Livrare imediată!

1.669,99Lei

Cort, 3-4, Persoane, DD, Hammocks, Tipi, Olive, Green, 707273931641, Corturi Camping, Corturi Camping DD Hammocks, DD Hammocks
Exclusiv online!

Cort, 3-4, Persoane, DD, Hammocks, Tipi, Olive, Green, 707273931641, Corturi Camping, Corturi Camping DD Hammocks, DD Hammocks

707273931641
Livrare 24-48 ore

1.174,99Lei

Cort Coleman 2176907 Cobra 2
Exclusiv online!

Cort Coleman 2176907 Cobra 2

2176907
Livrare 24-48 ore

1.150,00Lei

Cort Coleman Spruce Falls 4
Exclusiv online!

Cort Coleman Spruce Falls 4

2000030283
Livrare 24-48 ore

2.848,00Lei

Cuie, de, Ancorare, Ultra, Usoare, Bushmen, , 5902194521468, Cuie Cort, Cuie Cort Bushmen, Cuie Bushmen, Cort Bushmen, Bushmen
Exclusiv online!

Cuie, de, Ancorare, Ultra, Usoare, Bushmen, , 5902194521468, Cuie Cort, Cuie Cort Bushmen, Cuie Bushmen, Cort Bushmen, Bushmen

5902194521468
Livrare 24-48 ore

39,00Lei

Extractor Cuie Cort Coghlans
Exclusiv online!

Extractor Cuie Cort Coghlans

c715
Livrare 24-48 ore

20,00Lei

Lampa Cort DAM Fishing Light 4AA

Lampa Cort DAM Fishing Light 4AA

a8.dam.55984
Livrare imediată!

40,91Lei

Lampa, Cort, Delphin, Aura,, 500, Lumeni,, 18.5x9.5cm, , 900013018, Lampi si Felinare, Lampi si Felinare Delphin, Lampi Delphin, Felinare Delphin, Delphin -41%
Winterskin Cort Prologic C-Series Bivvy 1 Persoana

Winterskin Cort Prologic C-Series Bivvy 1 Persoana

a8.pro.72818
Livrare imediată!

616,56Lei

Capsula, , Fox, Retreat, Brolly, System, Inner, Dome, cum337, Corturi Pescuit, Corturi Pescuit Fox, Corturi Fox, Pescuit Fox, Fox
Exclusiv online!

Capsula, , Fox, Retreat, Brolly, System, Inner, Dome, cum337, Corturi Pescuit, Corturi Pescuit Fox, Corturi Fox, Pescuit Fox, Fox

cum337
Livrare 7-14 zile

1.034,95Lei

Cort Coleman Polygon 5
Exclusiv online!

Cort Coleman Polygon 5

2000038700
Livrare 24-48 ore

1.581,00Lei

Cort Cort Coleman Cortes 3 Albastru
Exclusiv online!

Cort Cort Coleman Cortes 3 Albastru

2000035209
Livrare 24-48 ore

770,00Lei

Cort, Prologic, , Bivvy, 1, pers, Plus, Overwrap, 260X240X145cm, a8.pro.72787, Corturi Pescuit, Corturi Pescuit Prologic, Prologic
Exclusiv online!

Cort, Prologic, , Bivvy, 1, pers, Plus, Overwrap, 260X240X145cm, a8.pro.72787, Corturi Pescuit, Corturi Pescuit Prologic, Prologic

a8.pro.72787
Livrare 24-48 ore

1.472,90Lei

Cuie Cort Lungi Coghlans pentru Sol Tare

Cuie Cort Lungi Coghlans pentru Sol Tare

c8312
Livrare imediată!

37,00Lei

Lampa Cort Trakker Nitelife Bivvy Light + Remote 200

Lampa Cort Trakker Nitelife Bivvy Light + Remote 200

221515
Livrare imediată!

299,95Lei

Lampa de Cort Tandem Baits Evos -32%

Lampa de Cort Tandem Baits Evos

00519
Livrare imediată!

47,20Lei(-32%) 31,90Lei

Pavilion Coleman Event Shelter XL cu Pereti Inclusi, 4.53 x 4.53m
Exclusiv online!

Pavilion Coleman Event Shelter XL cu Pereti Inclusi, 4.53 x 4.53m

2000038534
Livrare 24-48 ore

2.150,00Lei

Afişare 361 - 380 din 527 (27 pagini)
Queries: 5, Total time: 220.592 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '452d75aae1cca0702f5481ac7e'
/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:427
3 (217.817)
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 "%cort%") 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
4 (2.413)
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 360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.133)
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