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


Broasca Savage Gear 3D Walk Frog, Culoare 62033, 5.5cm, 14g -20%
Exclusiv online!

Broasca Savage Gear 3D Walk Frog, Culoare 62033, 5.5cm, 14g

f1.sg.62033
Livrare 24-48 ore

43,92Lei(-20%) 35,13Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE HLW 8CM 13G
Exclusiv online!

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE HLW 8CM 13G

xrts08 hlw
Livrare 48-72ore

54,00Lei

Lingurita Oscilanta Bertilure DOLI NR.1 Culoare Gold Lungime 60 mm. 9 gr

Lingurita Oscilanta Bertilure DOLI NR.1 Culoare Gold Lungime 60 mm. 9 gr

d-01-134
Livrare imediată!

14,30Lei

SHAD MANNS 4.5CM Culoare P 15BUC/PLIC

SHAD MANNS 4.5CM Culoare P 15BUC/PLIC

88010105
Livrare imediată!

11,00Lei

Shad Storm 360GT Searchbait Minnow Culoare VT-18J 9cm 7g 3buc/blister
Exclusiv online!

Shad Storm 360GT Searchbait Minnow Culoare VT-18J 9cm 7g 3buc/blister

sbm35 vt-18j
Livrare 48-72ore

19,00Lei

SHAD MANNS 10CM Culoare FCHBB 4BUC/PLIC

SHAD MANNS 10CM Culoare FCHBB 4BUC/PLIC

88010461
Livrare imediată!

11,00Lei

SHAD MANNS 4.5CM Culoare MCHBB 10BUC/PLIC

SHAD MANNS 4.5CM Culoare MCHBB 10BUC/PLIC

88010161
Livrare imediată!

11,00Lei

Shad Biwaa Warax 7.5cm culoare Cinnamon
Exclusiv online!

Shad Biwaa Warax 7.5cm culoare Cinnamon

b001130
Livrare 48-72 ore

26,00Lei

LINGURITA OSCILANTA BERTILURE LINX XXL LUNGIME 78 MM. CULOARE NICKEL 16 GRAME

LINGURITA OSCILANTA BERTILURE LINX XXL LUNGIME 78 MM. CULOARE NICKEL 16 GRAME

l-01-577
Livrare imediată!

18,75Lei

Lingurita Oscilanta Rapala Rattlin' Minnow Spoon, Culoare HFCGR, 8cm, 16g

Lingurita Oscilanta Rapala Rattlin' Minnow Spoon, Culoare HFCGR, 8cm, 16g

rmsr08 hfcgr
Livrare imediată!

45,01Lei

Shad Biwaa Kapsiz 12,7cm, culoare 202 Limetreuse
Exclusiv online!

Shad Biwaa Kapsiz 12,7cm, culoare 202 Limetreuse

b001588
Livrare 48-72 ore

26,00Lei

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE AURORA GOLD
Exclusiv online!

SHAD BIWAA DIVINATOR MINI 9.5cm 9gr CULOARE AURORA GOLD

b000969
Livrare 48-72 ore

37,00Lei

SHAD LK KICK 5CM CULOARE 053

SHAD LK KICK 5CM CULOARE 053

87052053
Livrare imediată!

12,99Lei

Shad Biwaa Divinator S 13cm culoare Silver
Exclusiv online!

Shad Biwaa Divinator S 13cm culoare Silver

b000226
Livrare 48-72 ore

37,00Lei

Lingurita Oscilanta Bertilure BANANA NR.3 Lungime 70 mm. Culoare Cupru 6.5 gr

Lingurita Oscilanta Bertilure BANANA NR.3 Lungime 70 mm. Culoare Cupru 6.5 gr

b-01-061
Livrare imediată!

16,10Lei

Lingurita Oscilanta Bertilure AUSTRIA NR.2 Lungime 45 mm. Culoare Nickel 6 gr.

Lingurita Oscilanta Bertilure AUSTRIA NR.2 Lungime 45 mm. Culoare Nickel 6 gr.

a-01-025
Livrare imediată!

15,20Lei

LINGURITA OSCILANTA BERTILURE LINX XXL LUNGIME 78 MM. CULOARE SILVER 13 GRAME

LINGURITA OSCILANTA BERTILURE LINX XXL LUNGIME 78 MM. CULOARE SILVER 13 GRAME

l-01-572
Livrare imediată!

18,75Lei

SHAD BIG HAMMER SWIMBAIT HPS30002 CULOARE 02 7.5CM -33%

SHAD BIG HAMMER SWIMBAIT HPS30002 CULOARE 02 7.5CM

hps30002
Livrare imediată!

24,00Lei(-33%) 16,07Lei

LINGURITA OSCILANTA BERTILURE TAIFUN NR.1 LUNGIME 53 MM. CULOARE CUPRU 9 GRAME

LINGURITA OSCILANTA BERTILURE TAIFUN NR.1 LUNGIME 53 MM. CULOARE CUPRU 9 GRAME

t-01-400
Livrare imediată!

16,10Lei

Shad Biwaa Divinator S 13cm culoare Roach
Exclusiv online!

Shad Biwaa Divinator S 13cm culoare Roach

b000586
Livrare 48-72 ore

37,00Lei

Afişare 881 - 900 din 2607 (131 pagini)
Queries: 6, Total time: 93.868 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = 'fe0d6e36b9dd49d8bab6617be4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (93.274)
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('+culoare' 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.157)
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.136)
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.135)
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