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 300 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


MULINETA SPRO SALT X BOAT 6000

MULINETA SPRO SALT X BOAT 6000

001129-00362-00000
Livrare imediată!

220,99Lei

PILKER, SPRO, CAST, X, CHROME, 7GR, , 004500-00106-00000, Pilkere, Pilkere Spro, Spro
Exclusiv online!

PILKER, SPRO, CAST, X, CHROME, 7GR, , 004500-00106-00000, Pilkere, Pilkere Spro, Spro

004500-00106-00000
Livrare 48-72 ore

15,01Lei

TAMBUR REZERVA MULINETA SPRO PASSION XTR 850FD
Exclusiv online!

TAMBUR REZERVA MULINETA SPRO PASSION XTR 850FD

001207-00850-00100
Livrare 48-72 ore

82,10Lei

LANSETA SPRO FREESTYLE SOLIDZ 1.80 TITAN X 15 GR
Exclusiv online!

LANSETA SPRO FREESTYLE SOLIDZ 1.80 TITAN X 15 GR

002929-00184-00000
Livrare 48-72 ore

348,00Lei

RUCSAC SPRO C-TEC MEGA 60X55X34 CM

RUCSAC SPRO C-TEC MEGA 60X55X34 CM

006405-00011-00000
Livrare imediată!

262,00Lei

LARVA, TROUT, MASTER, CAMOLA, RED-BK, 3.5CM, SPRO, 5BUC, , 004916-00206-00000, Voblere Sinking, Voblere Sinking Spro, Spro -24%

LARVA, TROUT, MASTER, CAMOLA, RED-BK, 3.5CM, SPRO, 5BUC, , 004916-00206-00000, Voblere Sinking, Voblere Sinking Spro, Spro

004916-00206-00000
Livrare imediată!

25,00Lei(-24%) 18,90Lei

Agrafe, Spro, Fast, Lock, Nr.1, 004554-00101-00000, Agrafe Monturi, Agrafe Monturi Spro, Spro

Agrafe, Spro, Fast, Lock, Nr.1, 004554-00101-00000, Agrafe Monturi, Agrafe Monturi Spro, Spro

004554-00101-00000
Livrare imediată!

7,50Lei

LANSETA SPRO PETRI FEEDER 3.60 250 GR 3SEG PLUS 3 VARFURI -23%

LANSETA SPRO PETRI FEEDER 3.60 250 GR 3SEG PLUS 3 VARFURI

002470-00362-00000
Livrare imediată!

514,00Lei(-23%) 395,90Lei

Jig 22 Spro Cu Carlig Gamakatsu Nr.4/0, 14g, 4buc/plic

Jig 22 Spro Cu Carlig Gamakatsu Nr.4/0, 14g, 4buc/plic

4931-400-014
Livrare imediată!

19,50Lei

LESTAJ PLUMB SPRO 7GR PTR MONTURA CHEBURASAHKA 5BUC

LESTAJ PLUMB SPRO 7GR PTR MONTURA CHEBURASAHKA 5BUC

004622-01900-00007
Livrare imediată!

12,90Lei

VARF CARBON SPRO SOLID 60 CM 2.2-08/0.7 MM

VARF CARBON SPRO SOLID 60 CM 2.2-08/0.7 MM

002502-00300-00000
Livrare imediată!

16,40Lei

Mulineta Spro Reset 1000
Exclusiv online!

Mulineta Spro Reset 1000

001183-00411-00000
Livrare 48-72 ore

167,00Lei

VARF CARBON SPRO SOLID 60 CM 2.5-09/0.8 MM

VARF CARBON SPRO SOLID 60 CM 2.5-09/0.8 MM

002502-00301-00000
Livrare imediată!

17,80Lei

AGRAFA, SPRO, DIAMOND, PENTRU, VOBLER, NR, 00, 10, BUC, 004554-00200-00000, Agrafe Rapitor, Agrafe Rapitor Spro, Spro

AGRAFA, SPRO, DIAMOND, PENTRU, VOBLER, NR, 00, 10, BUC, 004554-00200-00000, Agrafe Rapitor, Agrafe Rapitor Spro, Spro

004554-00200-00000
Livrare imediată!

5,50Lei

CAP, TWISTER, SPRO-GAMAKATSU, ROTUND, JIG, HEAD, 1/0, 7GR, 4BUC, 004931-00101-00007, Jiguri Turnate, Jiguri Turnate Spro, Spro
CUTIE SPRO HARDBAITS M 200X155X45MM

CUTIE SPRO HARDBAITS M 200X155X45MM

006515-01900-00000
Livrare imediată!

41,00Lei

AGRAFA, CU, VARTEJ, CILINDRIC, SPRO, NR, 2, 13BUC, 004620-00404-00000, Agrafe Monturi, Agrafe Monturi Spro, Agrafe Spro, Monturi Spro, Spro
EXTRACTOR SPRO ANCORA
Exclusiv online!

EXTRACTOR SPRO ANCORA

004702-00261-00000
Livrare 48-72 ore

90,00Lei

SUPORT PTR STARLETI SPRO DE PRINS PE LANSETA 2 BUC/PLIC 3.0-3.6 MM

SUPORT PTR STARLETI SPRO DE PRINS PE LANSETA 2 BUC/PLIC 3.0-3.6 MM

004759-00300-00000
Livrare imediată!

4,00Lei

SHAD SPRO USA FAT PAPA 7CM SEXY ICE BLUE 7BUC
Exclusiv online!

SHAD SPRO USA FAT PAPA 7CM SEXY ICE BLUE 7BUC

004918-01506-00000
Livrare 48-72 ore

15,20Lei

Afişare 201 - 220 din 902 (46 pagini)
Queries: 5, Total time: 207.842 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = 'dc094b5a6f24ee88fb81517593'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (203.953)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%spro%") 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:698
4 (3.577)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.109)
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