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


Buzz Bar Carp Academy Triangle 3 Posturi 38cm

Buzz Bar Carp Academy Triangle 3 Posturi 38cm

6227-604
Livrare imediată!

30,80Lei

Buzz, Bar, Carp, Academy, Premium, 38cm, 3, Posturi, 6125-338, Buzz-Bari, Buzz-Bari Carp Academy, Carp Academy
Picior Suplimentar Pat Carp Zoom 27-38cm
Exclusiv online!

Picior Suplimentar Pat Carp Zoom 27-38cm

cz3383
Livrare 48-72 ore

63,00Lei

Lighean Genlog Orange 38cm Cu Suport
Exclusiv online!

Lighean Genlog Orange 38cm Cu Suport

gbh-01-kpl
Livrare 48-72 ore

112,00Lei

Juvelnic Baracuda 3810 diametru 38cm

Juvelnic Baracuda 3810 diametru 38cm

juvelnic sarma circular 38cm
Livrare imediată!

36,34Lei

GEANTA SPINNING JAXON X TEAM 57x40x38CM
Exclusiv online!

GEANTA SPINNING JAXON X TEAM 57x40x38CM

uj-xab05
Livrare 48-72 ore

359,00Lei

GEANTA FOX COOLER FOOD BAG TWO MAN 55X41X38CM
Exclusiv online!

GEANTA FOX COOLER FOOD BAG TWO MAN 55X41X38CM

clu371
Livrare 7-14 zile

539,95Lei

MINCIOG COLMIC HERAKLES TROUT AREA 43 X 38CM
Exclusiv online!

MINCIOG COLMIC HERAKLES TROUT AREA 43 X 38CM

guhan08
Livrare 48-72 ore

96,00Lei

Juvelnic Baracuda circular 3870 70x38cm

Juvelnic Baracuda circular 3870 70x38cm

juvelnic 3870 d 38cm h 70cm
Livrare imediată!

72,30Lei

MONTURA, GURU, BAYONETS, QM1, CARLIG, NR.14, 0.19MM, 38CM, 8BUC/PLIC, a.gu.grr047, Carlige Legate Stationar, Carlige Legate Stationar Guru, Guru
Cap Minciog Garbolino Floating Scoop 42x38cm

Cap Minciog Garbolino Floating Scoop 42x38cm

50330gomnj6450-42x38
Livrare imediată!

88,87Lei

GEANTA PROLOGIC AVENGER CARRYALL S CAMO 37X34X38CM

GEANTA PROLOGIC AVENGER CARRYALL S CAMO 37X34X38CM

a8.pro.65060
Livrare imediată!

277,66Lei

Sita Delphin ATOMA RoundMESH 38cm 4mm -34%

Sita Delphin ATOMA RoundMESH 38cm 4mm

101002104
Livrare imediată!

83,00Lei(-34%) 55,00Lei

Carlige, Legate, Guru, Bayonets, QM1,, Carlig, Nr.12,, 0.22mm,, 38cm,, 8buc/pac, a.gu.grr207, Carlige Legate Feeder, Carlige Legate Feeder Guru, Carlige Guru, Legate Guru, Feeder Guru, Guru
Masa Monturi Fox 2 Tier Bivvy Table 57x38cm

Masa Monturi Fox 2 Tier Bivvy Table 57x38cm

cac867
Livrare imediată!

314,96Lei

Pat Nash Indulgence HD40 8 Legs Sleep System Wide Camo, 212x 96x38cm
Exclusiv online!

Pat Nash Indulgence HD40 8 Legs Sleep System Wide Camo, 212x 96x38cm

t9552
Livrare 7-14 zile

2.253,96Lei

Carlige, Legate, Guru, Bayonets, QM1,, Carlig, Nr.10,, 0.19mm,, 38cm,, 8buc/pac, a.gu.grr145, Carlige Legate Feeder, Carlige Legate Feeder Guru, Carlige Guru, Legate Guru, Feeder Guru, Guru
Carlige Legate Guru Bayonets, Carlig Nr.10, 0.19mm, 38cm, 8buc/pac
Exclusiv online!

Carlige Legate Guru Bayonets, Carlig Nr.10, 0.19mm, 38cm, 8buc/pac

a.gu.grr221
Livrare 24-48 ore

24,50Lei

Pat, Nash, Indulgence, HD40, 8, Legs, Sleep, System, Camo,, 212x83x38cm, t9551, Paturi, Paturi Nash, Paturi Nash, Nash
Exclusiv online!

Pat, Nash, Indulgence, HD40, 8, Legs, Sleep, System, Camo,, 212x83x38cm, t9551, Paturi, Paturi Nash, Paturi Nash, Nash

t9551
Livrare 7-14 zile

2.106,95Lei

Carlige, Legate, Guru, Bayonets, QM1,, Carlig, Nr.12,, 0.19mm,, 38cm,, 8buc/pac, a.gu.grr146, Carlige Legate Feeder, Carlige Legate Feeder Guru, Carlige Guru, Legate Guru, Feeder Guru, Guru
Afişare 21 - 40 din 58 (3 pagini)
Queries: 10, Total time: 212.450 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = 'c04761e84a58f0384d5f6bda3a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (210.223)
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 "%38cm%") 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 (0.129)
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:1561
5 (0.517)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.274)
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:1209
7 (0.121)
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:1231
8 (0.111)
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:996
9 (0.709)
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:910
10 (0.121)
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