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


Set Naluci Savage Gear Cannibal XS 20buc/set

Set Naluci Savage Gear Cannibal XS 20buc/set

f1.sg.57613
Stoc epuizat

51,69Lei

CUTIE NALUCI JAXON 33X23X7cm

CUTIE NALUCI JAXON 33X23X7cm

rh-157
Stoc epuizat

97,00Lei

Mormasca Shark EM002021 Argintiu Phospho 0.50gr Carlig nr 10

Mormasca Shark EM002021 Argintiu Phospho 0.50gr Carlig nr 10

803em00210050021
Stoc epuizat

15,92Lei

LEST PT. NALUCI STRIKE PRO POWER DOT FOSFO M -20%

LEST PT. NALUCI STRIKE PRO POWER DOT FOSFO M

sp.ad001m.glo
Stoc epuizat

16,96Lei(-20%) 13,57Lei

Madcat DAM Inline Rattler Perch 110 g

Madcat DAM Inline Rattler Perch 110 g

80952206
Stoc epuizat

71,90Lei

GEANTA ACCESORII FOX RAGE CARRYALL PLUS 6 CUTII PENTRU NALUCI LARGE

GEANTA ACCESORII FOX RAGE CARRYALL PLUS 6 CUTII PENTRU NALUCI LARGE

nlu056
Stoc epuizat

587,94Lei

MORMISTE JAXON WOLFRAM KB05 G 0.5 cm

MORMISTE JAXON WOLFRAM KB05 G 0.5 cm

mw-kb05g
Stoc epuizat

77,00Lei

CUTIE SPRO PTR NALUCI 10X20X3-6 COMPARTIMENTE

CUTIE SPRO PTR NALUCI 10X20X3-6 COMPARTIMENTE

006516-00000-0000012
Stoc epuizat

16,60Lei

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

Portofel Naluci Moi Delphin Dravec Mini

Portofel Naluci Moi Delphin Dravec Mini

420220100
Stoc epuizat

41,00Lei

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

Spirala Spro Softbite 5.4cm, 6buc/pac

Spirala Spro Softbite 5.4cm, 6buc/pac

004628-00108-00000
Stoc epuizat

14,90Lei

CUTIE CORMORAN PT NALUCI 2 FETE 14 COMPARTIMENTE 20X12,5X3,5CM

CUTIE CORMORAN PT NALUCI 2 FETE 14 COMPARTIMENTE 20X12,5X3,5CM

a4.66.11016
Stoc epuizat

25,14Lei

Cutie Savage Gear pentru naluci model 3A 186x103x34mm

Cutie Savage Gear pentru naluci model 3A 186x103x34mm

a4.sg.42668
Stoc epuizat

27,00Lei

COADA DE REZERVA VOBLER RAPALA X-RAP PETO SPARE TAIL CULOARE OG 3BUC/BLISTER
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

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

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

Vierme Owner Shiver Tail 115mm 13 Oxblood Red

Vierme Owner Shiver Tail 115mm 13 Oxblood Red

1301375597-13
Stoc epuizat

19,42Lei

Afişare 621 - 640 din 819 (41 pagini)
Queries: 6, Total time: 18.622 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = '4fca7dc1292dc33b84350afc36'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.128)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.877)
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('+naluci' 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 (0.201)
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.124)
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
6 (0.142)
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