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


Fir Textil Reiva Silent Fluo Green, 135m, 0.21mm, 15.7kg
Exclusiv online!

Fir Textil Reiva Silent Fluo Green, 135m, 0.21mm, 15.7kg

3270-021
Livrare 48-72 ore

69,00Lei

Pensea Reiva Curbata Inox, 20cm
Exclusiv online!

Pensea Reiva Curbata Inox, 20cm

8430-006
Livrare 48-72 ore

30,90Lei

Penseta Reiva Curbata 15cm

Penseta Reiva Curbata 15cm

8430-001
Livrare imediată!

21,40Lei

Cutie Accesorii Spinning Reiva 20.5x14.5x2.7cm
Exclusiv online!

Cutie Accesorii Spinning Reiva 20.5x14.5x2.7cm

4541-004
Livrare 48-72 ore

29,00Lei

Fir Textil Reiva Silent Fluo Green, 135m, 0.15mm, 10.40kg -21%
Exclusiv online!

Fir Textil Reiva Silent Fluo Green, 135m, 0.15mm, 10.40kg

3270-015
Livrare 48-72 ore

69,90Lei(-21%) 55,00Lei

Pensea Reiva Curbata Inox, 15cm
Exclusiv online!

Pensea Reiva Curbata Inox, 15cm

8430-004
Livrare 48-72 ore

21,40Lei

Pensea Reiva Curbata Inox, 18cm
Exclusiv online!

Pensea Reiva Curbata Inox, 18cm

8430-005
Livrare 48-72 ore

26,80Lei

Penseta Reiva Curbata 18cm

Penseta Reiva Curbata 18cm

8430-002
Livrare imediată!

26,80Lei

Penseta Reiva Curbata 20cm

Penseta Reiva Curbata 20cm

8430-003
Livrare imediată!

30,90Lei

Fir Textil Reiva Silent Fluo Green, 135m, 0.13mm, 8.50kg -21%
Exclusiv online!

Fir Textil Reiva Silent Fluo Green, 135m, 0.13mm, 8.50kg

3270-013
Livrare 48-72 ore

69,90Lei(-21%) 55,00Lei

Bluza UV Reiva, Marime L

Bluza UV Reiva, Marime L

8841-003
Stoc epuizat

89,00Lei

Bluza UV Reiva, Marime M

Bluza UV Reiva, Marime M

8841-002
Stoc epuizat

89,00Lei

Bluza UV Reiva, Marime XL

Bluza UV Reiva, Marime XL

8841-004
Stoc epuizat

89,00Lei

LANSETA REIVA FINEMASTER 2.44M 7-28g 2seg

LANSETA REIVA FINEMASTER 2.44M 7-28g 2seg

1441-240
Stoc epuizat

549,99Lei

Lingurita Oscilanta Powerflex Reiva ASP 15g Auriu

Lingurita Oscilanta Powerflex Reiva ASP 15g Auriu

9920-302
Stoc epuizat

11,60Lei

SPINNERBAIT REIVA POWERFLEX 28GR R

SPINNERBAIT REIVA POWERFLEX 28GR R

9921-501
Stoc epuizat

24,50Lei

Lingurita Oscilanta Powerflex ASP Auriu 25g

Lingurita Oscilanta Powerflex ASP Auriu 25g

9920-502
Stoc epuizat

13,70Lei

Lanseta Reiva Steam 210MH 10-30g 2seg

Lanseta Reiva Steam 210MH 10-30g 2seg

1438-213
Stoc epuizat

338,00Lei

Geanta Impermeabila Spinning Reiva + 3 Cutii, 25x30x15cm

Geanta Impermeabila Spinning Reiva + 3 Cutii, 25x30x15cm

5220-016
Stoc epuizat

296,00Lei

Struna Reiva Wolfram 1x19, 25cm, 0.40mm, 2buc/plic

Struna Reiva Wolfram 1x19, 25cm, 0.40mm, 2buc/plic

8527-140
Stoc epuizat

7,90Lei

Afişare 141 - 160 din 194 (10 pagini)
Queries: 10, Total time: 201.724 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '0634ffcbb1dabe9e366509cb78'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (198.188)
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 = '3' AND (pd.tag LIKE "%reiva%") 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 (0.168)
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.995)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.234)
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:1209
7 (0.092)
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:1231
8 (0.092)
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:996
9 (1.706)
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:910
10 (0.087)
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