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


Suport Sonik Stanz Cauciuc Tip U Rod Grip, S
Exclusiv online!

Suport Sonik Stanz Cauciuc Tip U Rod Grip, S

hc0045
Livrare 48-72 ore

14,86Lei

Tub Nytro Sublime Tip Tube, 77x9x5cm

Tub Nytro Sublime Tip Tube, 77x9x5cm

22400031
Livrare imediată!

155,27Lei

Clipsuri Tip Ancora C2071 Coghlans
Exclusiv online!

Clipsuri Tip Ancora C2071 Coghlans

c2071
Livrare 24-48 ore

62,00Lei

Opritor Boilies Carp Expert Tip Umbreluta Advanced Short, Transparent
Exclusiv online!

Opritor Boilies Carp Expert Tip Umbreluta Advanced Short, Transparent

79630361
Livrare 24-48 ore

4,08Lei

Suport Sonik Stanz Cauciuc Tip U Rod Grip, L
Exclusiv online!

Suport Sonik Stanz Cauciuc Tip U Rod Grip, L

hc0047
Livrare 48-72 ore

14,86Lei

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E1, Size 1, Art.153
Exclusiv online!

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E1, Size 1, Art.153

8028651005436
Livrare 48-72 ore

29,00Lei

Lanseta Penn Tidal Surfcasting Multi-tip, 4.50m, 30-150g, 3+3seg
Exclusiv online!

Lanseta Penn Tidal Surfcasting Multi-tip, 4.50m, 30-150g, 3+3seg

1558897
Livrare 7-14 zile

854,96Lei

Sac de Dormit Tip Mumie Coleman Silverton 150
Exclusiv online!

Sac de Dormit Tip Mumie Coleman Silverton 150

2000017868
Livrare 24-48 ore

399,00Lei

Valigeta Energofish Fishing Box Tip.333, 45x24x23cm

Valigeta Energofish Fishing Box Tip.333, 45x24x23cm

75077333
Livrare imediată!

137,04Lei

PLUMB ENERGO TEAM TIP TIGARA CU TUB 80G

PLUMB ENERGO TEAM TIP TIGARA CU TUB 80G

52728080
Livrare imediată!

9,00Lei

Vartej Triplu Nevis Tip T NR.8

Vartej Triplu Nevis Tip T NR.8

5552-008
Livrare imediată!

4,40Lei

Vartej Triplu Nevis Tip T NR.6

Vartej Triplu Nevis Tip T NR.6

5552-006
Livrare imediată!

5,20Lei

Vartej Triplu Nevis Tip T NR.12

Vartej Triplu Nevis Tip T NR.12

5552-012
Livrare imediată!

4,40Lei

PRINDERE SAUER 303 LUNETA ZEISS TIP M
Exclusiv online!

PRINDERE SAUER 303 LUNETA ZEISS TIP M

v.srjp2800018
Livrare 24-48 ore

1.981,84Lei

PRINDERE SAUER 303 LUNETA ZEISS TIP M 02
Exclusiv online!

PRINDERE SAUER 303 LUNETA ZEISS TIP M 02

v.sr790201.02
Livrare 24-48 ore

1.981,84Lei

CUTIE TRANSPORT BLASER TIP C PENTRU R8 82X45X9CM
Exclusiv online!

CUTIE TRANSPORT BLASER TIP C PENTRU R8 82X45X9CM

a8.bl.80400549
Livrare 24-48 ore

2.723,24Lei

CUREA ARROW SINTETICA TIP B1 NEAGRA MAR.M
Exclusiv online!

CUREA ARROW SINTETICA TIP B1 NEAGRA MAR.M

vj.curea.b1.2.m
Livrare 24-48 ore

201,94Lei

PRINDERE BROWNING NOMAD PENTRU LUNETA ZEISS TIP M
Exclusiv online!

PRINDERE BROWNING NOMAD PENTRU LUNETA ZEISS TIP M

v.bo.dfmzm1038
Livrare 24-48 ore

1.428,79Lei

CARTUSIERA ARROW PORT GLONT PIELE TIP BORSETA 10 POSTURI
Exclusiv online!

CARTUSIERA ARROW PORT GLONT PIELE TIP BORSETA 10 POSTURI

ve.p32350.20
Livrare 24-48 ore

149,90Lei

HUSA BLASER TIP C CORDURA PT.CARABINA 105CM
Exclusiv online!

HUSA BLASER TIP C CORDURA PT.CARABINA 105CM

a8.bl.80405371
Livrare 24-48 ore

414,66Lei

Afişare 261 - 280 din 420 (21 pagini)
Queries: 9, Total time: 22.774 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '9752e3ff9711be77517e7e4910'
/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 (15.581)
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('+tip' 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.215)
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 (0.930)
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
6 (0.101)
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
7 (0.199)
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
8 (5.444)
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
9 (0.114)
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