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


CICADA RIBCHE LURES RIB 1 SHAD 5.5CM 20GR RED HEAD SFC

CICADA RIBCHE LURES RIB 1 SHAD 5.5CM 20GR RED HEAD SFC

rib-1421
Stoc epuizat

20,00Lei

FIR TEXTIL BERKLEY NEW FIRELINE BRAID BICOLOR 028MM/29,4KG/110M

FIR TEXTIL BERKLEY NEW FIRELINE BRAID BICOLOR 028MM/29,4KG/110M

p.1312420
Stoc epuizat

149,49Lei

Lanseta Browning Black Magic CFX Feeder MD 3.60m 120gr

Lanseta Browning Black Magic CFX Feeder MD 3.60m 120gr

12207361
Stoc epuizat

269,78Lei

Mulineta DAM Quick 2 2000 FD -27%

Mulineta DAM Quick 2 2000 FD

3020956966
Stoc epuizat

165,96Lei(-27%) 121,90Lei

Set aragaz Coleman Fyrelite Start + C300 Performance

Set aragaz Coleman Fyrelite Start + C300 Performance

2000031528
Stoc epuizat

170,00Lei

Set Naluci Savage Gear Cannibal XS 20buc/set

Set Naluci Savage Gear Cannibal XS 20buc/set

f1.sg.57613
Stoc epuizat

51,69Lei

HUSA LANSETE Baracuda B39 Lungime 205cm

HUSA LANSETE Baracuda B39 Lungime 205cm

b39 geanta
Stoc epuizat

118,45Lei

Vartej Rapid Preston Quick Change Swivels Medium

Vartej Rapid Preston Quick Change Swivels Medium

p0220016
Stoc epuizat

13,46Lei

Combo Lineaeffe Vigor Top Pike 2 Lansete + 2 Mulinete + Accesorii

Combo Lineaeffe Vigor Top Pike 2 Lansete + 2 Mulinete + Accesorii

l.2015342
Stoc epuizat

555,94Lei

MULINETA KAMASAKI SUPER FD3000

MULINETA KAMASAKI SUPER FD3000

20102300
Stoc epuizat

52,00Lei

PELETE HALIBUT CRESTA 4.5MM 800GR

PELETE HALIBUT CRESTA 4.5MM 800GR

008981-00203-00000
Stoc epuizat

26,50Lei

BOILIES STICKY BAITS KRILL 1KG 20MM

BOILIES STICKY BAITS KRILL 1KG 20MM

sks20
Stoc epuizat

65,00Lei

CAP MINCIOG JAXON NYLON 20MM 45x55CM MODEL 2

CAP MINCIOG JAXON NYLON 20MM 45x55CM MODEL 2

pz-lxf5545
Stoc epuizat

80,00Lei

FAINA DE PESTE ARROW LT999 ADAOS PT. NADA 200G

FAINA DE PESTE ARROW LT999 ADAOS PT. NADA 200G

a0.p.faina.02
Stoc epuizat

11,98Lei

PB CHAMELEON 25LB 20M FIR MONTURI EXTREME SOFT CHA25

PB CHAMELEON 25LB 20M FIR MONTURI EXTREME SOFT CHA25

pb10102
Stoc epuizat

58,00Lei

SCAUN CARP SPIRIT COMPACT

SCAUN CARP SPIRIT COMPACT

522001360
Stoc epuizat

139,00Lei

LANSETA COLMIC KIRA M1 MATCH 4.20M 25GR

LANSETA COLMIC KIRA M1 MATCH 4.20M 25GR

cbki01a
Stoc epuizat

915,00Lei

Spargator Boilies K-Karp XTR

Spargator Boilies K-Karp XTR

190-71-200
Stoc epuizat

125,00Lei

Tableta fitoplankton Hookbaits 120g, Original

Tableta fitoplankton Hookbaits 120g, Original

923013
Stoc epuizat

9,90Lei

FIR KRYSTON QUICKSILVER GOLD COATED SHOCK LEADER 20m 35lb Gravel Brown
Afişare 16661 - 16680 din 19323 (967 pagini)
Queries: 8, Total time: 817.470 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'e688cfd0bf934ea1d5943b1821'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (729.902)
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 (pd.tag LIKE "%20%") 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 (86.842)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 16660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"OVIDIUS DOCTOR FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.106)
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
8 (0.168)
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