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

Produse ce potrivesc criteriilor de căutare


Geanta Mikado Enclave Set 1+4 25x16x12cm -25%

Geanta Mikado Enclave Set 1+4 25x16x12cm

uwf-022
Stoc epuizat

149,00Lei(-25%) 111,80Lei

Geanta Plumbi si Accesorii JRC Defender Accessory Bag Small, 12x16x8cm -40%

Geanta Plumbi si Accesorii JRC Defender Accessory Bag Small, 12x16x8cm

1445879
Stoc epuizat

54,00Lei(-40%) 32,50Lei

GEANTA PRESTON SUPERA EVA SYSTEM 10.5X41X27CM

GEANTA PRESTON SUPERA EVA SYSTEM 10.5X41X27CM

p0130094
Stoc epuizat

247,46Lei

Geanta Spinning Mitchell MX Camo M Plus 4 Tackle Stack Bag, Green Camo, 21x26x19cm
Geanta Aqua Products Barrow Bag DPM, 73x39x31cm

Geanta Aqua Products Barrow Bag DPM, 73x39x31cm

405712
Stoc epuizat

649,95Lei

Geanta EVA PB Products H2O Proof Medium BaX, 2 Compartimente, 16x11x9 cm

Geanta EVA PB Products H2O Proof Medium BaX, 2 Compartimente, 16x11x9 cm

pb50010
Stoc epuizat

124,99Lei

Geanta Mikado Enclave Thermo 37.5x29x25.5cm

Geanta Mikado Enclave Thermo 37.5x29x25.5cm

uwf-018-l
Stoc epuizat

143,00Lei

Geanta Sunset Termorezistenta L RS Termo Bag, 34x18x24cm

Geanta Sunset Termorezistenta L RS Termo Bag, 34x18x24cm

90411stslj3858
Stoc epuizat

196,33Lei

Geanta Termoizolanta Abu Garcia Beast Pro Rucksack Cooler Pouch, 40x20x10cm
Geanta de Umar Helikon Tex Essential Kitbag Molle Earth Brown Clay, 2.5L

Geanta de Umar Helikon Tex Essential Kitbag Molle Earth Brown Clay, 2.5L

tb-ekb-cd-0a0ba
Stoc epuizat

240,00Lei

Geanta Frigorifica Norfin VARDO

Geanta Frigorifica Norfin VARDO

nfl-40106
Stoc epuizat

516,00Lei

Geanta Greys Bank Bag, 50x33x26cm

Geanta Greys Bank Bag, 50x33x26cm

1436373
Stoc epuizat

764,96Lei

Geanta Juvelnic Trabucco GNT Match Team Portanassa Waterproof

Geanta Juvelnic Trabucco GNT Match Team Portanassa Waterproof

048-37-110
Stoc epuizat

190,00Lei

Geanta Korda Compac Cool XL, Como, 45x35x25cm

Geanta Korda Compac Cool XL, Como, 45x35x25cm

a8.klug124
Stoc epuizat

509,22Lei

Geanta Korda Compac Framed Carryall Small, 56x33x41cm

Geanta Korda Compac Framed Carryall Small, 56x33x41cm

a8.klug61
Stoc epuizat

671,62Lei

Geanta Mikado Enclave Carryall L 56x40x31cm

Geanta Mikado Enclave Carryall L 56x40x31cm

uwf-017-l
Stoc epuizat

291,00Lei

Geanta Mikado Enclave Hunter, 46x23.5x23cm

Geanta Mikado Enclave Hunter, 46x23.5x23cm

uwf-019
Stoc epuizat

191,99Lei

Geanta Mikado Eva Jaws Pentru Accesorii, 30x20.5x21cm

Geanta Mikado Eva Jaws Pentru Accesorii, 30x20.5x21cm

uwi-019
Stoc epuizat

244,00Lei

Geanta Nash Subterfuge Hi Protect Tech Beg, 20x28x18cm

Geanta Nash Subterfuge Hi Protect Tech Beg, 20x28x18cm

t3623
Stoc epuizat

439,99Lei

Geanta Sonik SK-Tek Carryall, Large, 70x35x32cm

Geanta Sonik SK-Tek Carryall, Large, 70x35x32cm

sktcal
Stoc epuizat

379,87Lei

Afişare 701 - 720 din 1038 (52 pagini)
Queries: 5, Total time: 27.952 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '699482f507e1f491e4af700a5a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.363)
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('+geanta' 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:737
4 (0.178)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.183)
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