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


Boilies Fish Pro Carp, Porumb Dulce, 20mm, 5Kg

Boilies Fish Pro Carp, Porumb Dulce, 20mm, 5Kg

bpc-p205
Stoc epuizat

103,99Lei

Boilies Senzor Dipuit pentru Carlig, X-Ploziv, 16-18mm, 200g

Boilies Senzor Dipuit pentru Carlig, X-Ploziv, 16-18mm, 200g

6425968543279
Stoc epuizat

26,00Lei

Boilies Tare de Nadit CPK High Attract, Fish & Garlic Spicy, 800g, 20mm
Buton pentru Gratarele Campingaz Classic Seria 3&4, Set 2 Bucati

Buton pentru Gratarele Campingaz Classic Seria 3&4, Set 2 Bucati

5010002162
Stoc epuizat

65,00Lei

Cutie pentru Momeala Daiwa D-Box SD Smoke, 21.7x16.4x9.0cm

Cutie pentru Momeala Daiwa D-Box SD Smoke, 21.7x16.4x9.0cm

d.14310.010
Stoc epuizat

51,56Lei

Geanta Plumbi FL 24x15x7cm

Geanta Plumbi FL 24x15x7cm

6193210350479
Stoc epuizat

41,40Lei

Husa pentru 1 Lanseta + Mulineta Daiwa 128cm

Husa pentru 1 Lanseta + Mulineta Daiwa 128cm

d.15812.240
Stoc epuizat

111,99Lei

Inele Elastice pentru Momeala Delphin BaitFIX, Marime L, 10mm, 30buc/pac

Inele Elastice pentru Momeala Delphin BaitFIX, Marime L, 10mm, 30buc/pac

101003089
Stoc epuizat

8,00Lei

Inele Elastice pentru Momeala Delphin BaitFIX, Marime M, 7mm, 30buc/pac

Inele Elastice pentru Momeala Delphin BaitFIX, Marime M, 7mm, 30buc/pac

101003088
Stoc epuizat

8,00Lei

MOMITOR CU PLACA FL Fara Tija Pentru Apa Curgatoare 120g

MOMITOR CU PLACA FL Fara Tija Pentru Apa Curgatoare 120g

2192350289704
Stoc epuizat

10,90Lei

Patura pentru Picnic Coghlans

Patura pentru Picnic Coghlans

c1966
Stoc epuizat

86,00Lei

Pelete Mivardi Classic Red Halibut, 20mm, 10kg

Pelete Mivardi Classic Red Halibut, 20mm, 10kg

m-rapecrha10020
Stoc epuizat

179,00Lei

Penar Pentru Riguri JRC Defender Rig Wallet , 21x26x5cm

Penar Pentru Riguri JRC Defender Rig Wallet , 21x26x5cm

1445878
Stoc epuizat

112,36Lei

Plasa Antiinsecte pentru Hamac Jungle Bushmen

Plasa Antiinsecte pentru Hamac Jungle Bushmen

5902194520836
Stoc epuizat

255,01Lei

Plumb Dropshot Delphin Bomb, 14gr, 5buc/pac -21%

Plumb Dropshot Delphin Bomb, 14gr, 5buc/pac

965925014
Stoc epuizat

16,01Lei(-21%) 12,60Lei

Punga pentru Filtru de Apa Sawyer 2litri

Punga pentru Filtru de Apa Sawyer 2litri

sp114
Stoc epuizat

75,01Lei

Roci de Lava Vulcanica pentru Gratar Campingaz

Roci de Lava Vulcanica pentru Gratar Campingaz

205637
Stoc epuizat

52,00Lei

Rola Delphin De Inlocuire Pentru Scaunu, Universala, 2buc/set

Rola Delphin De Inlocuire Pentru Scaunu, Universala, 2buc/set

101004198
Stoc epuizat

11,00Lei

Tronson Nr.3 Pentru Bologneza Trabucco Energhia Race-x Competition Bolo

Tronson Nr.3 Pentru Bologneza Trabucco Energhia Race-x Competition Bolo

121-13-350-r03
Stoc epuizat

149,50Lei

Varf Pentru Lanseta Rapture City Game Street S692l 2052

Varf Pentru Lanseta Rapture City Game Street S692l 2052

125-01-100-r01
Stoc epuizat

151,06Lei

Afişare 4941 - 4960 din 5141 (258 pagini)
Queries: 8, Total time: 119.597 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = 'daef8ef11dd70bbe2d5d99a3e0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.136)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (118.705)
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('+pentru' 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
5 (0.151)
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
6 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' 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 '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.137)
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