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


Exclusiv online!

13,49Lei

Exclusiv online!

24,54Lei

8,50Lei

40,00Lei(-15%) 34,00Lei

Fir Madcat 8 Braid G2 0.35mm 270m Main Line

6093803039
Livrare imediată!

195,17Lei

Exclusiv online!

8,78Lei

19,00Lei

103,99Lei

Exclusiv online!

METHOD FEEDER GURU HYBRID IN LINE PELLET 35G

a.gu.gpf35
Livrare 24-48 ore

18,54Lei

16,87Lei

68,00Lei

Rig Crap DAM No.2 20Lb Tactix Line Aligner Rig

12020956750
Livrare imediată!

14,86Lei

Fir P-LINE FLOROCLEAR 2000 M 0.28 MM CLEAR

750187728
Livrare imediată!

103,99Lei

27,00Lei(-25%) 20,30Lei

Exclusiv online!

19,00Lei(-21%) 15,01Lei

Exclusiv online!

24,54Lei

Exclusiv online!

18,04Lei

Fir P-Line Voltage UV GURAD 0.35 MM 2000m

750188858
Livrare imediată!

115,00Lei

Fir P-LINE FLOROCLEAR 1000 M 0.36MM Clear

750187635
Livrare imediată!

76,01Lei

Costum Termic Norfin Cosy Line Black XL

3007104-xl
Livrare imediată!

195,01Lei

Afişare 601 - 620 din 1284 (65 pagini)
Queries: 5, Total time: 47.738 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '4816fab8a9d4745106a0e68411'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (47.278)
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('+line' 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:725
4 (0.164)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.099)
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