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


Montura Mivardi Hair Rig Easy, 2buc/plic Nr.4
Exclusiv online!

Montura Mivardi Hair Rig Easy, 2buc/plic Nr.4

m-acerrcsc04
Livrare 48-72 ore

12,00Lei

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 10m 0.16mm 17kg

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 10m 0.16mm 17kg

zj-dep016c
Livrare imediată!

17,01Lei

CARLIGE LEGATE STRATEGY GAMAKATSU BASIC SUPER 2 BUC NR 2

CARLIGE LEGATE STRATEGY GAMAKATSU BASIC SUPER 2 BUC NR 2

008541-00102-00000
Livrare imediată!

13,60Lei

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Grawel Brown, 20m, 25lbs
Exclusiv online!

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Grawel Brown, 20m, 25lbs

krman4
Livrare 48-72 ore

66,00Lei

FIR TEXTIL CARP EXPERT FAST SINKING CAMOU GREEN 10M 25lbs

FIR TEXTIL CARP EXPERT FAST SINKING CAMOU GREEN 10M 25lbs

31550253
Livrare imediată!

9,00Lei

Fir textil Climax CULT CRAP SKINBRAID 15m 20lb Camou Brown
Exclusiv online!

Fir textil Climax CULT CRAP SKINBRAID 15m 20lb Camou Brown

9900-10035-020
Livrare 48-72 ore

57,00Lei

Rig Crap DAM No.2 20Lb Tactix Blow Out Rig -49%

Rig Crap DAM No.2 20Lb Tactix Blow Out Rig

12020956762
Livrare imediată!

18,06Lei(-49%) 9,22Lei

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.23 MM 26 lb/ 11.8 kg GREY

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.23 MM 26 lb/ 11.8 kg GREY

999966
Livrare imediată!

29,00Lei

Fir Textil Nevis Technology 10m 0.12mm
Exclusiv online!

Fir Textil Nevis Technology 10m 0.12mm

5304-912
Livrare 48-72 ore

12,00Lei

Rig Crap DAM No.2 20Lb Tactix Line Aligner Rig

Rig Crap DAM No.2 20Lb Tactix Line Aligner Rig

12020956750
Livrare imediată!

14,86Lei

Fir textil Kryston Synx Dark Silt 20lbs 20m
Exclusiv online!

Fir textil Kryston Synx Dark Silt 20lbs 20m

krsyx5
Livrare 48-72 ore

66,00Lei

FIR TEXTIL KAMASAKI SUPER BRAID LEADER 10M 0.30MM 26.6KG

FIR TEXTIL KAMASAKI SUPER BRAID LEADER 10M 0.30MM 26.6KG

34021030
Livrare imediată!

9,00Lei

MONTURA PB KD RIG 04

MONTURA PB KD RIG 04

pb25040
Livrare imediată!

18,50Lei

MONTURA CARP ZOOM SPINNER RIG NR.4 20LB 20CM

MONTURA CARP ZOOM SPINNER RIG NR.4 20LB 20CM

cz1067
Livrare imediată!

20,00Lei

Carlige Legate Crap Academy MAXI 20cm NR.2 4 6

Carlige Legate Crap Academy MAXI 20cm NR.2 4 6

6425-246
Livrare imediată!

5,70Lei

Fir textil Kryston Synx Brown 30lbs 20m

Fir textil Kryston Synx Brown 30lbs 20m

krsyx4
Livrare imediată!

66,00Lei

Fir Textil Carp Spirit Re-Action Camo Green 20m 20lbs 9.10kg
Exclusiv online!

Fir Textil Carp Spirit Re-Action Camo Green 20m 20lbs 9.10kg

acs640059
Livrare 48-72ore

45,01Lei

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Weed Green, 20m, 15lbs
Exclusiv online!

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Weed Green, 20m, 15lbs

krman1
Livrare 48-72 ore

66,00Lei

Fir Textil Carp Spirit Reaction Braid Camo Brown 20m 25lbs 11.30kg -20%
Exclusiv online!

Fir Textil Carp Spirit Reaction Braid Camo Brown 20m 25lbs 11.30kg

acs640064
Livrare 48-72ore

45,01Lei(-20%) 36,00Lei

Fir Textil Nevis Technology Dyneema 10m 0.25mm

Fir Textil Nevis Technology Dyneema 10m 0.25mm

5304-025
Livrare imediată!

8,40Lei

Afişare 1281 - 1300 din 2362 (119 pagini)
Queries: 6, Total time: 56.812 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '0e3f4fa59ec93bccfcde9552dd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (56.178)
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('+monturi +crap' 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.138)
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.121)
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.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