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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


VOBLER RAPALA X-RAP S
Exclusiv online!

VOBLER RAPALA X-RAP S

xr08 s
Livrare 48-72 ore

57,84Lei

VOBLER RAPALA X RAP POP 7CM S
Exclusiv online!

VOBLER RAPALA X RAP POP 7CM S

xrp07 s
Livrare 48-72 ore

61,92Lei

VOBLER RAPALA X-RAP COUNTDOWN 7CM / 10GR S
Exclusiv online!

VOBLER RAPALA X-RAP COUNTDOWN 7CM / 10GR S

xrcd07 s
Livrare 48-72 ore

57,84Lei

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S
Exclusiv online!

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S

xrcd05 s
Livrare 48-72 ore

54,79Lei

VOBLER RAPALA X-RAP S
Exclusiv online!

VOBLER RAPALA X-RAP S

xr10 s
Livrare 48-72 ore

61,92Lei

Vobler Rapala X-Rap 6cm/4gr. S

Vobler Rapala X-Rap 6cm/4gr. S

xr06 s
Livrare imediată!

52,86Lei

Momitor Lestat Feeder Guru X-Change Cage Marime S 2buc/blister 40G Si 50G

Momitor Lestat Feeder Guru X-Change Cage Marime S 2buc/blister 40G Si 50G

gad08
Livrare imediată!

24,39Lei

VOBLER RAPALA X-RAP P
Exclusiv online!

VOBLER RAPALA X-RAP P

xr08 p
Livrare 48-72 ore

57,84Lei

Lanseta Salmo THRILL SEEKER 270cm 5-21g

Lanseta Salmo THRILL SEEKER 270cm 5-21g

qrd008
Livrare imediată!

431,07Lei

BATERIE NGT ALCALINA 12V-LRV 08

BATERIE NGT ALCALINA 12V-LRV 08

ngt-b-lrv08-5pc
Livrare imediată!

6,07Lei

Kryston MONTURA KRYSTON D-STIFF RIG INCOGNITO 18lb 8
Exclusiv online!

Kryston MONTURA KRYSTON D-STIFF RIG INCOGNITO 18lb 8

krds8
Livrare 48-72 ore

23,27Lei

CARLIGE JAXON LEGATE SUMATO CHIKA NR 8 0,16 MM
Exclusiv online!

CARLIGE JAXON LEGATE SUMATO CHIKA NR 8 0,16 MM

hy-sra08
Livrare 48-72 ore

9,14Lei

Carlige Legate PB Kd Rig, 20lbs, nr.8, 1buc/pac -18%

Carlige Legate PB Kd Rig, 20lbs, nr.8, 1buc/pac

kdr08
Livrare imediată!

18,50Lei(-18%) 15,13Lei

VOBLER RAPALA X-RAP
Exclusiv online!

VOBLER RAPALA X-RAP

xr10 g
Livrare 48-72 ore

61,92Lei

Carlige Legate Jaxon Method Feeder FD Nr.8, 0.22mm, 30cm

Carlige Legate Jaxon Method Feeder FD Nr.8, 0.22mm, 30cm

hy-mfd08
Livrare imediată!

12,18Lei

Vobler Rapala X-Rap Culoare P 10cm 13g

Vobler Rapala X-Rap Culoare P 10cm 13g

xr10 p
Livrare imediată!

61,92Lei

Vobler Rapala X-Rap CountDown 7cm 10g G -27%

Vobler Rapala X-Rap CountDown 7cm 10g G

xrcd07 g
Stoc epuizat

57,84Lei(-27%) 42,35Lei

Lanseta GURU Aventus Distance Feeder Rod, 3.30m/11ft, 70g, 2+3seg

Lanseta GURU Aventus Distance Feeder Rod, 3.30m/11ft, 70g, 2+3seg

grd058
Stoc epuizat

2.995,50Lei

GEANTA SPINNING JAXON TEAM 6 CUTII 47x30x27CM -20%

GEANTA SPINNING JAXON TEAM 6 CUTII 47x30x27CM

uj-xtx08
Stoc epuizat

438,23Lei(-20%) 350,90Lei

Vobler Swimy Jerk 70 mm 17 g D08 -26%

Vobler Swimy Jerk 70 mm 17 g D08

835swplf500170-d08
Stoc epuizat

31,45Lei(-26%) 23,15Lei

Afişare 1 - 20 din 20 (1 pagini)
Queries: 12, Total time: 2.120 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '83baa253b022a0986c4b442532'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.129)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.146)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("10198", "2", "1000", "117", "1", "47.800000000000", "1"),("31292", "2", "1000", "117", "1", "51.170000000000", "2"),("31280", "2", "1000", "117", "1", "47.800000000000", "3"),("31273", "2", "1000", "117", "1", "45.280000000000", "4"),("10189", "2", "1000", "117", "1", "51.170000000000", "5"),("10246", "2", "1003", "117", "1", "43.690000000000", "6"),("77893", "2", "1005", "160", "1", "20.160000000000", "7"),("10206", "2", "1000", "117", "1", "47.800000000000", "8"),("112890", "1", "1001", "185", "1", "356.260000000000", "9"),("59509", "2", "10", "287", "1", "5.020000000000", "10"),("106814", "1", "1000", "217", "1", "19.230000000000", "11"),("39774", "2", "1000", "42", "1", "7.550000000000", "12"),("239796", "2", "4", "95", "1", "12.500000000000", "13"),("10188", "2", "1000", "117", "1", "51.170000000000", "14"),("40801", "2", "1005", "42", "1", "10.070000000000", "15"),("99765", "2", "1001", "117", "1", "51.170000000000", "16"),("124103", "2", "0", "117", "1", "35.000000000000", "17"),("239543", "1", "0", "160", "1", "2475.620000000000", "18"),("91318", "2", "0", "42", "1", "290.000000000000", "19"),("71202", "2", "0", "454", "1", "19.130000000000", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.117)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
6 (0.280)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.115)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=10206'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
8 (0.209)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
9 (0.095)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
10 (0.085)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
11 (0.636)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
12 (0.114)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37