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


CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

a4.sg.76776
Livrare imediată!

46,80Lei

Cutie Plano DEEP STOW ADJ DIVIDERS CLEAR 2378000 -10%

Cutie Plano DEEP STOW ADJ DIVIDERS CLEAR 2378000

pmc2378000
Livrare imediată!

89,50Lei(-10%) 80,55Lei

CUTIE TRAKKO ACCESORII MB9314 28X19X5CM orange-transparentt universala

CUTIE TRAKKO ACCESORII MB9314 28X19X5CM orange-transparentt universala

mb9314or
Livrare imediată!

29,00Lei

CUTIE TRAKKO ACCESORII MB9308 28x20x5cm

CUTIE TRAKKO ACCESORII MB9308 28x20x5cm

mb9308
Livrare imediată!

29,00Lei

Cutie Plano Worm StowAway 3700 23X35.5X7CM -37%

Cutie Plano Worm StowAway 3700 23X35.5X7CM

pmc371610
Livrare imediată!

76,10Lei(-37%) 47,90Lei

CUTIE TRABUCCO PENTRU MOMEALA BAIT BOX 500G

CUTIE TRABUCCO PENTRU MOMEALA BAIT BOX 500G

111-23-050
Livrare imediată!

15,01Lei

CUTIE PLANO PLA1313 STORAGE BOX CLR P WHT LATCH 35.6cm x 30.5cm x 33cm -44%

CUTIE PLANO PLA1313 STORAGE BOX CLR P WHT LATCH 35.6cm x 30.5cm x 33cm

pla1313
Livrare imediată!

104,51Lei(-44%) 58,91Lei

Cutie Momeala Eva Team Feeder By Dome Fara Capac 17x11x8cm
Exclusiv online!

Cutie Momeala Eva Team Feeder By Dome Fara Capac 17x11x8cm

5305-006
Livrare 48-72 ore

40,00Lei

SET CUTII SAVAGE GEAR PT.NALUCI 16,1X9,1X3,1CM 3BUC

SET CUTII SAVAGE GEAR PT.NALUCI 16,1X9,1X3,1CM 3BUC

a4.sg.74230
Livrare imediată!

70,58Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM -20%
Exclusiv online!

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM

a4.sg.74224
Livrare 24-48 ore

49,18Lei(-20%) 39,34Lei

CUTIE SAVAGE NR.5B PT.NALUCI 35,5X23X5CM

CUTIE SAVAGE NR.5B PT.NALUCI 35,5X23X5CM

a4.sg.74225
Livrare imediată!

51,27Lei

Cutie Plano 360710 ProLatch 3600 Size Open Compartments Stowaway Boxes Clear 27.3x18.4x4.44cm -10%

Cutie Plano 360710 ProLatch 3600 Size Open Compartments Stowaway Boxes Clear 27.3x18.4x4.44cm

pmc360710
Livrare imediată!

54,50Lei(-10%) 49,05Lei

CUTIE TRABUCCO PENTRU MOMEALA BAIT BOX 1000G

CUTIE TRABUCCO PENTRU MOMEALA BAIT BOX 1000G

111-23-100
Livrare imediată!

19,00Lei

CUTIE KORDA COMPAC ORGANISER
Exclusiv online!

CUTIE KORDA COMPAC ORGANISER

a8.klug73
Livrare 24-48 ore

138,88Lei

Cutie Plano Worm StowAway 3600 28X19X6.4CM -43%

Cutie Plano Worm StowAway 3600 28X19X6.4CM

pmc361610
Livrare imediată!

59,50Lei(-43%) 33,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

a4.sg.76774
Livrare imediată!

36,40Lei

CUTIE JACKALL 2800D TACKLE M BLACK -20%
Exclusiv online!

CUTIE JACKALL 2800D TACKLE M BLACK

a4.ja.807196931
Livrare 24-48 ore

107,42Lei(-20%) 85,94Lei

SET CUTII SAVAGE GEAR PT.NALUCI 10.5X6.8X2.6CM 3BUC
Exclusiv online!

SET CUTII SAVAGE GEAR PT.NALUCI 10.5X6.8X2.6CM 3BUC

a4.sg.74228
Livrare 24-48 ore

28,43Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6D 36X22.5X5CM
Exclusiv online!

CUTIE SAVAGE GEAR PT.NALUCI TIP 6D 36X22.5X5CM

a4.sg.76779
Livrare 24-48 ore

58,91Lei

SET 4 CUTII MOMEALA TEAM FEEDER BY DOME EVA
Exclusiv online!

SET 4 CUTII MOMEALA TEAM FEEDER BY DOME EVA

5305-017
Livrare 48-72 ore

215,00Lei

Afişare 581 - 600 din 1124 (57 pagini)
Queries: 10, Total time: 35.875 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '867175a2da0356cd5f3ac722f1'
/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:428
3 (21.913)
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('+cutii' 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.153)
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.087)
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 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.986)
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.114)
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.257)
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.062)
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.121)
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