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


SPINNERBAIT BERTILURE Shallow Killer Colorado-Salcie, 7g, Culoare Fire-Tiger

SPINNERBAIT BERTILURE Shallow Killer Colorado-Salcie, 7g, Culoare Fire-Tiger

s-03-602
Livrare imediată!

21,40Lei

Lanseta Mivardi Active Spinning 2.40m, 10-30g, 2buc
Exclusiv online!

Lanseta Mivardi Active Spinning 2.40m, 10-30g, 2buc

miv-as240
Livrare 48-72 ore

85,00Lei

SPIN JAXON PENTRU MOMEALA METHOD FEEDER 8mm 10buc/plic

SPIN JAXON PENTRU MOMEALA METHOD FEEDER 8mm 10buc/plic

ac-pc145
Livrare imediată!

7,50Lei

SPINNERBAIT BERTILURE Salcie nr.2 Salcie nr.3, 14gr,Skirt Siliconic Alb-Rosu

SPINNERBAIT BERTILURE Salcie nr.2 Salcie nr.3, 14gr,Skirt Siliconic Alb-Rosu

s-03-429
Livrare imediată!

21,40Lei

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Firetiger Gold
Exclusiv online!

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Firetiger Gold

arhkcle37
Livrare 48-72 ore

10,00Lei

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Skynet Silver
Exclusiv online!

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Skynet Silver

arhkcle35
Livrare 48-72 ore

10,00Lei

Spinnertail Biwaa Divinator, Ivory, 14cm, 22g
Exclusiv online!

Spinnertail Biwaa Divinator, Ivory, 14cm, 22g

b000304
Livrare 48-72 ore

50,00Lei

LANSETA JAXON GREY STREAM SPIN 2.80M 4-17GR
Exclusiv online!

LANSETA JAXON GREY STREAM SPIN 2.80M 4-17GR

wj-dsc28017
Livrare 48-72 ore

290,00Lei

LANSETA OKUMA SPINNING 2BUC.HELIOS SX SPIN 2,10M/8-20G
Exclusiv online!

LANSETA OKUMA SPINNING 2BUC.HELIOS SX SPIN 2,10M/8-20G

hsx-s-662ml
Livrare 48-72ore

305,10Lei

Lanseta Baracuda Comanche Spin 2702 2SEG 2.70M

Lanseta Baracuda Comanche Spin 2702 2SEG 2.70M

comanche spin 2702
Livrare imediată!

92,90Lei

MULINETA ENERGOTEAM WIZARD SAMURAI SPIN 4000

MULINETA ENERGOTEAM WIZARD SAMURAI SPIN 4000

20614400
Livrare imediată!

168,00Lei

LANSETA JAXON INTENSA GTX IMPULSE SPINNING 2.70M 10-30GR
Exclusiv online!

LANSETA JAXON INTENSA GTX IMPULSE SPINNING 2.70M 10-30GR

wj-ixs27030
Livrare 48-72 ore

220,00Lei

Chatterbait Sakura Cajun 10.5gr White Chart
Exclusiv online!

Chatterbait Sakura Cajun 10.5gr White Chart

131134saplg50163/8-jc2
Livrare 48-72 ore

32,50Lei

MULINETA PENN SPINFISHER VI 5500 6BB -31%
Exclusiv online!

MULINETA PENN SPINFISHER VI 5500 6BB

1481263
Livrare 48-72ore

840,77Lei(-31%) 577,30Lei

SPINERBAIT COLMIC QUAKE 1 1/2oz 42gr White
Exclusiv online!

SPINERBAIT COLMIC QUAKE 1 1/2oz 42gr White

arhkfm03
Livrare 48-72 ore

55,00Lei

Spinnerbait Biwaa Dogon 21g Pink Ice-Silver Blades
Exclusiv online!

Spinnerbait Biwaa Dogon 21g Pink Ice-Silver Blades

b001567
Livrare 48-72 ore

55,00Lei

Spinnertail Biwaa Divinator, Chart Red Back, 14cm, 22g -22%

Spinnertail Biwaa Divinator, Chart Red Back, 14cm, 22g

b000547
Livrare imediată!

50,00Lei(-22%) 38,90Lei

SPINNER BAIT JAXON REFLEX 2A HKG2A
Exclusiv online!

SPINNER BAIT JAXON REFLEX 2A HKG2A

bo-hkg2a
Livrare 48-72 ore

22,00Lei

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg
Exclusiv online!

Fir Monofilament Jaxon Eternum Spinning Transparent, 150m, 0.27mm, 14kg

zj-ets027a
Livrare 48-72 ore

17,50Lei

GEANTA JAXON SPINNING TEAM 6 CUTII INCLUSE 48x30x26CM
Exclusiv online!

GEANTA JAXON SPINNING TEAM 6 CUTII INCLUSE 48x30x26CM

uj-xtx04
Livrare 48-72 ore

429,99Lei

Afişare 2201 - 2220 din 5176 (259 pagini)
Queries: 6, Total time: 3,365.927 ms [By time] [By id] [By file]
1 (0.476)
SELECT data
FROM `oc_session`
WHERE session_id = '464253f40cbe0764b4eeac0519'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3,364.912)
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 = '2' AND (pd.tag LIKE "%spin%") 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.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
5 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.150)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38