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

Produse ce potrivesc criteriilor de căutare


HUSA RIGIDA TRAKKO 1.30MT 2 COMPARTIMENTE
Exclusiv online!

HUSA RIGIDA TRAKKO 1.30MT 2 COMPARTIMENTE

trakko hard 1,3m/2
Livrare 48-72 ore

235,00Lei

Husa Rigida Lansete Sportex III Grey, 3 Compartimente, 125cm -21%

Husa Rigida Lansete Sportex III Grey, 3 Compartimente, 125cm

s303128
Livrare imediată!

620,00Lei(-21%) 491,90Lei

VARF CARBON RIGID JAXON 6.0X900MM

VARF CARBON RIGID JAXON 6.0X900MM

ak-swb60900
Livrare imediată!

30,00Lei

HUSA RIGIDA TRAKKO PENTRU 3 LANSETE L 160CM
Exclusiv online!

HUSA RIGIDA TRAKKO PENTRU 3 LANSETE L 160CM

trakko hard 1,6m/3
Livrare 48-72 ore

335,00Lei

ANTI TANGLE MOSTIRO RIGID CU LEAD CLIP 3 BUC

ANTI TANGLE MOSTIRO RIGID CU LEAD CLIP 3 BUC

4074
Livrare imediată!

5,70Lei

HUSA CARP ZOOM RIGIDA DUBLA 140cm

HUSA CARP ZOOM RIGIDA DUBLA 140cm

cz0664
Livrare imediată!

198,00Lei

PB, SKINLESS, 25LB, 20M, GRAVEL-FIR, FORFAC, CU, CAMASA, RIGIDA, PB10052, Fire Monturi Crap, Fire Monturi Crap PB Products, Fire PB Products, Monturi PB Products, Crap PB Products, PB Products
TUB PATRAT JAXON 155CM 5.00CmX7.00Cm
Exclusiv online!

TUB PATRAT JAXON 155CM 5.00CmX7.00Cm

aj-tu5070155r
Livrare 48-72 ore

79,00Lei

CAPAC REZERVA TUB OVAL 50MM JAXON

CAPAC REZERVA TUB OVAL 50MM JAXON

aj-tu50v
Livrare imediată!

4,00Lei

PB, SKINLESS, 15LB, 20M, WEED-FIR, FORFAC, CU, CAMASA, RIGIDA, PB10060, Fire Monturi Crap, Fire Monturi Crap PB Products, Fire PB Products, Monturi PB Products, Crap PB Products, PB Products
PB SKINLESS 15LB 20M GRAVEL-FIR FORFAC CU CAMASA RIGIDA -28%

PB SKINLESS 15LB 20M GRAVEL-FIR FORFAC CU CAMASA RIGIDA

skg15
Livrare imediată!

73,90Lei(-28%) 52,90Lei

Husa Lansete Rigida Sportex Grey, 1 Compartiment, 145cm -20%
Exclusiv online!

Husa Lansete Rigida Sportex Grey, 1 Compartiment, 145cm

s301148
Livrare 48-72 ore

330,00Lei(-20%) 264,00Lei

HUSA RIGIDA SPORTEX LANSETE II 2 COMPARTIMENTE 150CM GREY

HUSA RIGIDA SPORTEX LANSETE II 2 COMPARTIMENTE 150CM GREY

s302158
Livrare imediată!

499,00Lei

Husa Tub Lineaeffe Adventure L=120cm / D=7.5cm
Exclusiv online!

Husa Tub Lineaeffe Adventure L=120cm / D=7.5cm

a8.6535012
Livrare 24-48 ore

108,02Lei

Varf Maver Carbon Rigid 6.0-1.6mm/115cm
Exclusiv online!

Varf Maver Carbon Rigid 6.0-1.6mm/115cm

2120002
Livrare 48-72 ore

31,00Lei

BORSETA FOX CAMOLITE RIGID LEAD & BITS

BORSETA FOX CAMOLITE RIGID LEAD & BITS

clu312
Livrare imediată!

170,96Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 75x6.3cm
Exclusiv online!

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 75x6.3cm

uj-xar6375
Livrare 48-72 ore

137,00Lei

CUTIE NGT RIGIDA PENTRU ACCESORII BIT XPR CU INCHIDERE MAGNETICA, 14 COMPARTIMENTE, 12X10X3.5CM

CUTIE NGT RIGIDA PENTRU ACCESORII BIT XPR CU INCHIDERE MAGNETICA, 14 COMPARTIMENTE, 12X10X3.5CM

ngt-ftb-bit-xpr
Livrare imediată!

16,51Lei

HUSA Sportex RIGIDA LANSETE II 2 COMPARTIMENTE 125CM Grey

HUSA Sportex RIGIDA LANSETE II 2 COMPARTIMENTE 125CM Grey

s302128
Livrare imediată!

440,00Lei

PENAR RIGID MIVARDI

PENAR RIGID MIVARDI

m-caboxhld
Livrare imediată!

65,00Lei

Afişare 61 - 80 din 279 (14 pagini)
Queries: 8, Total time: 212.785 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '34018c89f0eafe24f44e3c260b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.140)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (210.445)
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 = '0' AND (pd.tag LIKE "%rigid%") 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
5 (1.744)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.074)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.071)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38