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


Suport Trakker Quicklock Butt Rest Single, Black, 4cm
Exclusiv online!

Suport Trakker Quicklock Butt Rest Single, Black, 4cm

222901
Livrare 7-14 zile

47,45Lei

Suport Zfish Mini Butt Gripp, Black
Exclusiv online!

Suport Zfish Mini Butt Gripp, Black

zf-7594
Livrare 48-72ore

7,77Lei

Suport Zfish Rubber Rod Rest Black
Exclusiv online!

Suport Zfish Rubber Rod Rest Black

zf-1581
Livrare 48-72ore

6,99Lei

Swinger Zfish ZFX Mini, Black

Swinger Zfish ZFX Mini, Black

zf-9946
Livrare imediată!

37,68Lei

Tava Laterala Quantum Cuzo Cu Parasolar, Negru

Tava Laterala Quantum Cuzo Cu Parasolar, Negru

kl-tava-black
Livrare imediată!

429,99Lei

Teaser MADCAT The Original, Black, 100g

Teaser MADCAT The Original, Black, 100g

mad.1604064
Livrare imediată!

58,24Lei

Teaser MADCAT The Original, Black, 150g

Teaser MADCAT The Original, Black, 150g

mad.1604068
Livrare imediată!

67,16Lei

Teaser MADCAT The Original, Black, 200g

Teaser MADCAT The Original, Black, 200g

mad.1604072
Livrare imediată!

71,70Lei

Tricou GURU Gradient Tee, Black, Marime 2XL
Exclusiv online!

Tricou GURU Gradient Tee, Black, Marime 2XL

a8.gu.gcl301
Livrare 24-48 ore

138,88Lei

Tricou GURU Gradient Tee, Black, Marime XL
Exclusiv online!

Tricou GURU Gradient Tee, Black, Marime XL

a8.gu.gcl300
Livrare 24-48 ore

138,88Lei

TRICOU OKUMA T-SHIRT CARP DIEM BLACK MARIME L
Exclusiv online!

TRICOU OKUMA T-SHIRT CARP DIEM BLACK MARIME L

pa01t043bl
Livrare 48-72ore

189,00Lei

Vasle Barca Zeck Black Paddle, 120cm
Exclusiv online!

Vasle Barca Zeck Black Paddle, 120cm

150205180120
Livrare 48-72 ore

104,48Lei

Vasle Barca Zeck Black Paddle, 130cm
Exclusiv online!

Vasle Barca Zeck Black Paddle, 130cm

150205180130
Livrare 48-72 ore

111,76Lei

Vasle Barca Zeck Black Paddle, 160cm
Exclusiv online!

Vasle Barca Zeck Black Paddle, 160cm

150205180160
Livrare 48-72 ore

118,95Lei

Vobler DUO Realis Jerkbait 100SP, ACC3105 Mat Black PB, 10cm, 14.5g
Exclusiv online!

Vobler DUO Realis Jerkbait 100SP, ACC3105 Mat Black PB, 10cm, 14.5g

DUO77164
Livrare 48-72 ore

72,00Lei

Vobler DUO Realis Jerkbait 100SP, GHA3138 Midnight Black II, 10cm, 14.5g -15%
Exclusiv online!

Vobler DUO Realis Jerkbait 100SP, GHA3138 Midnight Black II, 10cm, 14.5g

DUO72834
Livrare 48-72 ore

59,00Lei(-15%) 50,15Lei

Vobler DUO Realis Jerkbait 120SP, ACC3105 Mat Black PB, 12cm, 17.7g
Exclusiv online!

Vobler DUO Realis Jerkbait 120SP, ACC3105 Mat Black PB, 12cm, 17.7g

DUO69305
Livrare 48-72 ore

83,00Lei

Vobler Duo Realis Vibration 68 Apex Tune, Mat Black Tiger II, 6.8cm, 14.3g

Vobler Duo Realis Vibration 68 Apex Tune, Mat Black Tiger II, 6.8cm, 14.3g

duo74378
Livrare imediată!

69,00Lei

Mulineta FL XT 14000 BLACK EDITION

Mulineta FL XT 14000 BLACK EDITION

4149205127177
Livrare imediată!

333,20Lei

Mulineta Fl Black Tena 3000

Mulineta Fl Black Tena 3000

1421964481534
Livrare imediată!

119,06Lei

Afişare 3521 - 3540 din 4757 (238 pagini)
Queries: 8, Total time: 134.193 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = 'daf92e8f03f88b9158afd75717'
/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:428
3 (107.328)
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 (MATCH(pd.tag) AGAINST('+black' IN BOOLEAN MODE)) 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 (26.235)
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 3520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.135)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.100)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.143)
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