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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Dispozitiv Aplicare Inel Silicon PELLET BAIT BANDER FL ALBASTRU
Exclusiv online!

Dispozitiv Aplicare Inel Silicon PELLET BAIT BANDER FL ALBASTRU

64-44264
Livrare 48-72 ore

9,90Lei

MONTURA PRO FL FUSED FLUOROCARBON LEADER HELICOPTER TUNGSTEN 30LB 1M

MONTURA PRO FL FUSED FLUOROCARBON LEADER HELICOPTER TUNGSTEN 30LB 1M

64-66037
Livrare imediată!

25,89Lei

CLESTE SERTIZAT PRO FL CU BRIDE 0.6MM 0.7MM 0.9MM ROSU

CLESTE SERTIZAT PRO FL CU BRIDE 0.6MM 0.7MM 0.9MM ROSU

64-65696
Livrare imediată!

64,90Lei

CLESTE SERTIZAT PRO FL CU BRIDE 0.6MM 0.8MM SI KNOT PULLER ORANGE

CLESTE SERTIZAT PRO FL CU BRIDE 0.6MM 0.8MM SI KNOT PULLER ORANGE

64-65689
Livrare imediată!

59,90Lei

Dispozitiv Aplicare Inel Silicon PELLET BAIT BANDER FL Verde
Exclusiv online!

Dispozitiv Aplicare Inel Silicon PELLET BAIT BANDER FL Verde

6-65634
Livrare 48-72 ore

14,90Lei

MASA MONTURI CRAP FL BIVVY TABLE BLACK

MASA MONTURI CRAP FL BIVVY TABLE BLACK

fl-01
Livrare imediată!

169,90Lei

MASA MONTURI CRAP FL CU TAVITA BIVVY TABLE GREEN

MASA MONTURI CRAP FL CU TAVITA BIVVY TABLE GREEN

fl-07
Livrare imediată!

219,90Lei

MONTURA PRO FL FUSED FLUOROCARBON LEADER Plumb Pierdut TUNGSTEN 30LB 1M

MONTURA PRO FL FUSED FLUOROCARBON LEADER Plumb Pierdut TUNGSTEN 30LB 1M

64-66020
Livrare imediată!

25,89Lei

PREDUCEA PRO FL 5MM

PREDUCEA PRO FL 5MM

64-66082
Livrare imediată!

10,90Lei

PREDUCEA PRO FL 7MM

PREDUCEA PRO FL 7MM

64-66099
Livrare imediată!

18,90Lei

SET 4 MONTURI PRO FL HELICOPTER LEADCORE 75CM

SET 4 MONTURI PRO FL HELICOPTER LEADCORE 75CM

64-48590
Livrare imediată!

21,90Lei

Mulineta FL XT 14000 BLACK EDITION

Mulineta FL XT 14000 BLACK EDITION

4149205127177
Livrare imediată!

333,20Lei

Lanseta Crap FL Strategist 3.90M/3.75Lbs/2Seg

Lanseta Crap FL Strategist 3.90M/3.75Lbs/2Seg

7777124
Livrare imediată!

339,90Lei

Lanseta FL Ultra Team 3.90M 3.75Lbs 2Seg

Lanseta FL Ultra Team 3.90M 3.75Lbs 2Seg

5811670306119
Livrare imediată!

239,90Lei

Mulineta FL XT 14000

Mulineta FL XT 14000

4262191935240
Livrare imediată!

329,90Lei

Mulineta FL YF 10000 (Rezerva 9000)

Mulineta FL YF 10000 (Rezerva 9000)

5961650005645
Livrare imediată!

291,60Lei

Lanseta Crap Strategist 3.60M/3.75Lbs/2Seg

Lanseta Crap Strategist 3.60M/3.75Lbs/2Seg

7777122
Livrare imediată!

319,90Lei

Lanseta Fl Warrior 3.90M 3.75Lbs 2Seg

Lanseta Fl Warrior 3.90M 3.75Lbs 2Seg

7262196676282
Livrare imediată!

359,90Lei

Mulineta Fl strategist sfl saibe carbon 9000 (tambur rezerva 8000)

Mulineta Fl strategist sfl saibe carbon 9000 (tambur rezerva 8000)

7691745201925
Livrare imediată!

324,91Lei

Lanseta FL Strategist FORCE PLUS 3.90m, 4.25lbs, 3seg

Lanseta FL Strategist FORCE PLUS 3.90m, 4.25lbs, 3seg

10606-390
Livrare imediată!

317,04Lei

Afişare 221 - 240 din 381 (20 pagini)
Queries: 5, Total time: 542.033 ms [By time] [By id] [By file]
1 (0.163)
SELECT data
FROM `oc_session`
WHERE session_id = '6c1c0f6291894d2e46545fbb4b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (539.810)
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 (pd.tag LIKE "%crap%fl.%") 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 (1.820)
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 220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
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