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


Mormasca Shark EM003036 Argintiu Phospho 0.50gr Carlig nr 10

Mormasca Shark EM003036 Argintiu Phospho 0.50gr Carlig nr 10

803em00310050036
Stoc epuizat

13,38Lei

Benzar Jelly Baits Maggot Fluo -20%

Benzar Jelly Baits Maggot Fluo

79475078
Stoc epuizat

13,60Lei(-20%) 10,88Lei

Mormasca Shark EM003030 Galben Phospho 0.35gr Carlig nr 10

Mormasca Shark EM003030 Galben Phospho 0.35gr Carlig nr 10

803em00310035030
Stoc epuizat

13,38Lei

Mormasca Shark EM003037 Argintiu Phospho 0.65gr Carlig nr 10

Mormasca Shark EM003037 Argintiu Phospho 0.65gr Carlig nr 10

803em00310065037
Stoc epuizat

13,38Lei

Rezerva coada Biwaa Strout 16cm Red and Smoke 2 buc

Rezerva coada Biwaa Strout 16cm Red and Smoke 2 buc

b000724
Stoc epuizat

28,00Lei

Rezerva coada Biwaa Seven 15cm Red and Smoke 2 buc

Rezerva coada Biwaa Seven 15cm Red and Smoke 2 buc

b000721
Stoc epuizat

28,00Lei

Spirala Spro Softbite 5.4cm, 6buc/pac

Spirala Spro Softbite 5.4cm, 6buc/pac

004628-00108-00000
Stoc epuizat

14,90Lei

Rezerva coada Biwaa Strout 14cm Red and Smoke 2 buc

Rezerva coada Biwaa Strout 14cm Red and Smoke 2 buc

b000723
Stoc epuizat

28,00Lei

PELLETE CRESTA ARTICIFCIALE RED 39 BUC

PELLETE CRESTA ARTICIFCIALE RED 39 BUC

004714-00602-00000
Stoc epuizat

9,00Lei

Rezerva coada Biwaa Seven 13cm Red and Smoke 2 buc

Rezerva coada Biwaa Seven 13cm Red and Smoke 2 buc

b000720
Stoc epuizat

28,00Lei

Viermisori De Silicon Carp Expert Mini Roz Capsuna

Viermisori De Silicon Carp Expert Mini Roz Capsuna

79400313
Stoc epuizat

5,50Lei

COADA DE REZERVA VOBLER RAPALA X-RAP PETO SPARE TAIL CULOARE OG 3BUC/BLISTER
LIBELULE ARTIFICIALE BERKLEY GULP ALIVE LARGE -24%

LIBELULE ARTIFICIALE BERKLEY GULP ALIVE LARGE

1236977
Stoc epuizat

45,01Lei(-24%) 34,00Lei

Mormasca Shark EM010108 Verde Rosu Phospho 1.50gr Carlig nr 6

Mormasca Shark EM010108 Verde Rosu Phospho 1.50gr Carlig nr 6

803em01006150108
Stoc epuizat

13,38Lei

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR B

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR B

bt-fr06b
Stoc epuizat

31,00Lei

Viermi artificiali Enterprise Tackle Imitation Maggots - White

Viermi artificiali Enterprise Tackle Imitation Maggots - White

et18mw
Stoc epuizat

14,49Lei

LEST PT. NALUCI STRIKE PRO POWER DOT ROSU S -20%

LEST PT. NALUCI STRIKE PRO POWER DOT ROSU S

sp.ad001s.red
Stoc epuizat

21,60Lei(-20%) 17,28Lei

Aluna Tigrata Nevis Dipuita Fluo Galben Verde Usturoi

Aluna Tigrata Nevis Dipuita Fluo Galben Verde Usturoi

9611-002
Stoc epuizat

7,20Lei

Codite Oscilante Stiuca Bertilure Red, Size L, 15buc/pac

Codite Oscilante Stiuca Bertilure Red, Size L, 15buc/pac

a-06-202
Stoc epuizat

7,10Lei

Broasca Zebco Top Frog 65mm 19gr Pool Frog

Broasca Zebco Top Frog 65mm 19gr Pool Frog

3103302
Stoc epuizat

44,78Lei

Afişare 681 - 700 din 836 (42 pagini)
Queries: 8, Total time: 24.250 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = '0a6f7da2a124484daccc33d7d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.698)
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('+artificiale' 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 (3.781)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.152)
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
6 (0.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"SENZOR PLANET NOU"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PF GERMAN EUGEN"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.129)
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