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


TRABUCCO SAB. PATERNOSTER ROSU-SET 5 CARLIGE #06
Exclusiv online!

TRABUCCO SAB. PATERNOSTER ROSU-SET 5 CARLIGE #06

183-15-110
Livrare 48-72 ore

9,83Lei

Alune Tigrate artificiale Enterprise Tackle Pop-Up Tiger Nut 5buc/plic

Alune Tigrate artificiale Enterprise Tackle Pop-Up Tiger Nut 5buc/plic

et30
Livrare imediată!

18,00Lei

Broasca Savage Gear Hop Walker Gill 5.5cm 15g
Exclusiv online!

Broasca Savage Gear Hop Walker Gill 5.5cm 15g

f1.sg.77437
Livrare 24-48 ore

44,03Lei

BROASCA SAVAGE GEAR HOP POPPER FROG GILL 5.5CM 15G
Exclusiv online!

BROASCA SAVAGE GEAR HOP POPPER FROG GILL 5.5CM 15G

f1.sg.77441
Livrare 24-48 ore

44,03Lei

BROASCA SAVAGE GEAR HOP POPPER FROG BLACK 5.5CM 15G
Exclusiv online!

BROASCA SAVAGE GEAR HOP POPPER FROG BLACK 5.5CM 15G

f1.sg.77439
Livrare 24-48 ore

44,03Lei

Tehnopufi Color TM-241 EXTRA Anason

Tehnopufi Color TM-241 EXTRA Anason

79490002
Livrare imediată!

4,00Lei

Viermi Artificiali Enterprise Tackle Imitation Maggots, Neon Blue 20buc/plic

Viermi Artificiali Enterprise Tackle Imitation Maggots, Neon Blue 20buc/plic

200315
Livrare imediată!

17,01Lei

Teaser Dam Madcat The Original, Green, 200g

Teaser Dam Madcat The Original, Green, 200g

mad.1604071
Livrare imediată!

71,70Lei

Technopufi Color TM-241 MAXI Porumb Dulce

Technopufi Color TM-241 MAXI Porumb Dulce

79486047
Livrare imediată!

4,00Lei

BILUTE FLOTANTE PRO FL Rosu FLUORESCENT 8MM 20BUC

BILUTE FLOTANTE PRO FL Rosu FLUORESCENT 8MM 20BUC

64-48224
Livrare imediată!

6,50Lei

Coada De Schimb Abu Garcia McMio Spare Tail, Gold Glitter, 6.9cm
Exclusiv online!

Coada De Schimb Abu Garcia McMio Spare Tail, Gold Glitter, 6.9cm

1550153
Livrare 7-14 zile

47,96Lei

Larve Diferite Culori Baracuda set 20buc

Larve Diferite Culori Baracuda set 20buc

set 20 larve diferite culori blister
Livrare imediată!

7,90Lei

TEASER PRO FL 180G CULOARE 03

TEASER PRO FL 180G CULOARE 03

2212245231721
Livrare imediată!

53,90Lei

Coada De Schimb Abu Garcia McMio Small Spare Tail, Gold Glitter, 9.2cm
Exclusiv online!

Coada De Schimb Abu Garcia McMio Small Spare Tail, Gold Glitter, 9.2cm

1550133
Livrare 7-14 zile

51,96Lei

Teaser Black Cat Real Worm, Yellow, 80g
Exclusiv online!

Teaser Black Cat Real Worm, Yellow, 80g

6244080
Livrare 7-14 zile

109,50Lei

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 9.2cm
Exclusiv online!

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 9.2cm

1550132
Livrare 7-14 zile

51,96Lei

Teaser Black Cat Real Worm, Yellow, 160g
Exclusiv online!

Teaser Black Cat Real Worm, Yellow, 160g

6244160
Livrare 7-14 zile

124,50Lei

TEASER PRO FL 100G CULOARE 03

TEASER PRO FL 100G CULOARE 03

4212244024919
Livrare imediată!

47,90Lei

Broasca Zebco Top Frog, Tree Frog, 19g, 6.5cm

Broasca Zebco Top Frog, Tree Frog, 19g, 6.5cm

3507003
Livrare imediată!

28,70Lei

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 7.2cm
Exclusiv online!

Coada De Schimb Abu Garcia McMio Small Spare Tail, Silver Glitter, 7.2cm

1550134
Livrare 7-14 zile

47,96Lei

Afişare 461 - 480 din 836 (42 pagini)
Queries: 4, Total time: 19.820 ms [By time] [By id] [By file]
1 (0.170)
SELECT data
FROM `oc_session`
WHERE session_id = '370f6ca5160023a27babb0a517'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.353)
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 (0.181)
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