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 Mivardi Termoizolanta Cool Bag XXL

Geanta Mivardi Termoizolanta Cool Bag XXL

m-tmcbxxl
Livrare imediată!

159,00Lei

Geanta Mulinete Rapture LMF Reel Case 6 Comps

Geanta Mulinete Rapture LMF Reel Case 6 Comps

048-80-050
Livrare imediată!

125,00Lei

Geanta Nevis Spining Cu 4 Cuti 39x22x22cm

Geanta Nevis Spining Cu 4 Cuti 39x22x22cm

5252-001
Livrare imediată!

213,00Lei

Geanta Carp Zoom Multi Fishing Camou 57x27x31cm
Exclusiv online!

Geanta Carp Zoom Multi Fishing Camou 57x27x31cm

cz7053
Livrare 48-72 ore

239,00Lei

GEANTA COLMIC LION M
Exclusiv online!

GEANTA COLMIC LION M

boxeva307b
Livrare 48-72 ore

145,00Lei

GEANTA JAXON FISHING TEAM 52x30x32CM
Exclusiv online!

GEANTA JAXON FISHING TEAM 52x30x32CM

uj-xta08
Livrare 48-72 ore

130,00Lei

Geanta Colmic Wallaby Ground Bait 2
Exclusiv online!

Geanta Colmic Wallaby Ground Bait 2

boxeva313b
Livrare 48-72 ore

70,00Lei

GEANTA FOX COOLER FOOD BAG TWO MAN 55X41X38CM
Exclusiv online!

GEANTA FOX COOLER FOOD BAG TWO MAN 55X41X38CM

clu371
Livrare 7-14 zile

539,95Lei

Set Campingaz ustensile pentru gratar in geanta din material textil

Set Campingaz ustensile pentru gratar in geanta din material textil

205829
Livrare imediată!

119,00Lei

Geanta Colmic Cefalo 27x24cm
Exclusiv online!

Geanta Colmic Cefalo 27x24cm

boxeva305
Livrare 48-72 ore

85,00Lei

GEANTA PESCAR JAXON CARRYLALL 68x35x33CM
Exclusiv online!

GEANTA PESCAR JAXON CARRYLALL 68x35x33CM

uj-xta14
Livrare 48-72 ore

440,00Lei

Set Geanta TF Pentru Momeala EVA 5buc 36x23cm

Set Geanta TF Pentru Momeala EVA 5buc 36x23cm

5305-001
Livrare imediată!

203,00Lei

Geanta Korda pentru Accesorii Compac 200 XLarge, 28x20x10cm

Geanta Korda pentru Accesorii Compac 200 XLarge, 28x20x10cm

a4.klug04
Livrare imediată!

116,13Lei

HUSA LANSETE Baracuda B4 Lungime 1.60M 3 compartimente

HUSA LANSETE Baracuda B4 Lungime 1.60M 3 compartimente

b4 - geanta
Livrare imediată!

98,90Lei

GEANTA WIZARD PREDATOR MAX SPINNING BAG 43x24x24cm
Exclusiv online!

GEANTA WIZARD PREDATOR MAX SPINNING BAG 43x24x24cm

72137100
Livrare 24-48 ore

150,00Lei

Geanta Spinning Reiva Rezistenta La Apa 40x24x25cm
Exclusiv online!

Geanta Spinning Reiva Rezistenta La Apa 40x24x25cm

5220-013
Livrare 48-72 ore

127,00Lei

GEANTA JAXON SPINNING TEAM 4 CUTII 50*31*24CM
Exclusiv online!

GEANTA JAXON SPINNING TEAM 4 CUTII 50*31*24CM

uj-xtx10
Livrare 48-72 ore

419,00Lei

GEANTA JAXON JUVELNIC EVA 60*50*13CM
Exclusiv online!

GEANTA JAXON JUVELNIC EVA 60*50*13CM

re-104
Livrare 48-72 ore

287,00Lei

GEANTA JAXON FISHING TEAM 43x23x27CM

GEANTA JAXON FISHING TEAM 43x23x27CM

uj-xaa03
Livrare imediată!

99,00Lei

Geanta Colmic Superior Class Lisabona L
Exclusiv online!

Geanta Colmic Superior Class Lisabona L

bo1001c
Livrare 48-72 ore

339,99Lei

Afişare 461 - 480 din 1040 (52 pagini)
Queries: 10, Total time: 40.348 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '6c9c429b15b0e21ac07f94410a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (25.531)
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 (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.214)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (4.402)
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 460, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (1.119)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.117)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.246)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (8.361)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.123)
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