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


Vobler Rapture Pro Thoki 8cm 14g GB
Exclusiv online!

Vobler Rapture Pro Thoki 8cm 14g GB

180-09-510
Livrare 48-72 ore

23,00Lei

CORT PROLOGIC AVENGER 65 -25%

CORT PROLOGIC AVENGER 65

a8.pro.72683
Livrare imediată!

1.474,90Lei(-25%) 1.099,00Lei

Vobler Rapture Pro Ryoko Crank 4.5cm 4g NEP
Exclusiv online!

Vobler Rapture Pro Ryoko Crank 4.5cm 4g NEP

180-10-173
Livrare 48-72 ore

28,00Lei

SALTEA DE CANTARIRE PRO LINE XTREME FLOATING CAMOU

SALTEA DE CANTARIRE PRO LINE XTREME FLOATING CAMOU

pl13147
Livrare imediată!

385,00Lei

Pilker Spro Zocker Zilver 40g
Exclusiv online!

Pilker Spro Zocker Zilver 40g

004693-00041-00000
Livrare 48-72 ore

12,99Lei

HUSA MARSHAL TIP-BUTT CU BANDA 12 13 ft
Exclusiv online!

HUSA MARSHAL TIP-BUTT CU BANDA 12 13 ft

cz4075
Livrare 48-72 ore

57,00Lei

LANSETA PROLOGIC C-SERIES 3.60M 3.00LBS 3SEG
Exclusiv online!

LANSETA PROLOGIC C-SERIES 3.60M 3.00LBS 3SEG

o.pro.72630
Livrare 24-48 ore

350,10Lei

CAP TWISTER SPRO-GAMAKATSU ROTUND JIG 23 1/0 5 GR 4BUC

CAP TWISTER SPRO-GAMAKATSU ROTUND JIG 23 1/0 5 GR 4BUC

004931-00101-00005
Livrare imediată!

13,20Lei

Husa Sportex PROTECTIE VARF LANSETE HARDSHELL Medium
Exclusiv online!

Husa Sportex PROTECTIE VARF LANSETE HARDSHELL Medium

s300714
Livrare 48-72 ore

26,00Lei

Cap Suport Lanseta Prologic Negru L 3BUC/PLIC

Cap Suport Lanseta Prologic Negru L 3BUC/PLIC

a6.pro.72698
Livrare imediată!

27,48Lei

Costum Norfin Termic Overall Pro marime XXL
Exclusiv online!

Costum Norfin Termic Overall Pro marime XXL

3049005-xxl
Livrare 48-72ore

260,00Lei

Fir Struna Daiwa Prorex 7x7 5m 9.5kg -20%
Exclusiv online!

Fir Struna Daiwa Prorex 7x7 5m 9.5kg

a7.17925.510
Livrare 24-48 ore

35,02Lei(-20%) 28,11Lei

Protectie Varf + Banda Fixare Lanseta Lucky John
Exclusiv online!

Protectie Varf + Banda Fixare Lanseta Lucky John

lj263
Livrare 48-72ore

35,00Lei

Costum Norfin Termic Overall Pro marime M

Costum Norfin Termic Overall Pro marime M

3049002-m
Livrare imediată!

260,00Lei

DEGETAR PROLOGIC NEOPREN PT CASTING ONESIZE GREEN/BLACK

DEGETAR PROLOGIC NEOPREN PT CASTING ONESIZE GREEN/BLACK

a8.pro.76651
Livrare imediată!

48,33Lei

Stopper Silicon Spro Freestyle 10buc/plic -30%

Stopper Silicon Spro Freestyle 10buc/plic

004589-00610-00000
Livrare imediată!

8,40Lei(-30%) 5,90Lei

LANSETA SPINNING DAIWA 2BUC. PROREX LTD 2.25M, 5-21G, 2seg -20%
Exclusiv online!

LANSETA SPINNING DAIWA 2BUC. PROREX LTD 2.25M, 5-21G, 2seg

d.11200.225
Livrare 24-48 ore

823,04Lei(-20%) 658,43Lei

LANSETA PROLOGIC C6 INSPIRE FC ALL ROUNDER 3.60M 3.25LBS 2SEG -40%
Exclusiv online!

LANSETA PROLOGIC C6 INSPIRE FC ALL ROUNDER 3.60M 3.25LBS 2SEG

o.pro.64092
Livrare 24-48 ore

1.757,09Lei(-40%) 1.054,24Lei

BANDA CARPZOOM FIXARE LANSETE SILICON 20cm

BANDA CARPZOOM FIXARE LANSETE SILICON 20cm

cz5591
Livrare imediată!

23,00Lei

Shad Spro Gutsbait UV 110 11cm SALT AND PEPPER

Shad Spro Gutsbait UV 110 11cm SALT AND PEPPER

004663-00404-00000
Livrare imediată!

25,00Lei

Afişare 4081 - 4100 din 7177 (359 pagini)
Queries: 8, Total time: 668.952 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = '3053424704a84a59ecdfef7906'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (639.686)
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 "%pro%") 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 (28.488)
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 4080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.169)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=112573'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
6 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.137)
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