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


Geanta Accesorii Zfish Waterproof Storage Medium, Green
Exclusiv online!

Geanta Accesorii Zfish Waterproof Storage Medium, Green

ZF-7973
Livrare 48-72ore

89,45Lei

Geanta Aqua Products Black Series Carryall, Small, Green, 31x38x58cm
Exclusiv online!

Geanta Aqua Products Black Series Carryall, Small, Green, 31x38x58cm

404103
Livrare 7-14 zile

499,95Lei

Geanta Aqua Products Carryall DPM, Small, Camo, 31x38x58cm
Exclusiv online!

Geanta Aqua Products Carryall DPM, Small, Camo, 31x38x58cm

405710
Livrare 7-14 zile

524,94Lei

Geanta Cattara Tip Buzunar, Universal Molle Army, TT13869, 17x11x6cm
Exclusiv online!

Geanta Cattara Tip Buzunar, Universal Molle Army, TT13869, 17x11x6cm

tt13869
Livrare 24-48 ore

50,00Lei

Geanta Cattara Tip Buzunar, Universal Molle Olive, TT13870, 17x11x6cm
Exclusiv online!

Geanta Cattara Tip Buzunar, Universal Molle Olive, TT13870, 17x11x6cm

tt13870
Livrare 24-48 ore

50,00Lei

Geanta Impermeabila Zeck L Tackle Container Pro Catfish, 40x26x25cm
Exclusiv online!

Geanta Impermeabila Zeck L Tackle Container Pro Catfish, 40x26x25cm

90405160020
Livrare 48-72 ore

424,16Lei

Geanta Juvelnic Nytro Sublime Net Tray Bag, 70x18x59cm
Exclusiv online!

Geanta Juvelnic Nytro Sublime Net Tray Bag, 70x18x59cm

22400036
Livrare 48-72 ore

304,72Lei

Geanta Laterala Zeck Pentru Barca Gonflabila, Belly Boat
Exclusiv online!

Geanta Laterala Zeck Pentru Barca Gonflabila, Belly Boat

150205180007
Livrare 48-72 ore

128,13Lei

Geanta NGT Bait Bin Cu Manere Si Capac, 25x22cm, Verde
Exclusiv online!

Geanta NGT Bait Bin Cu Manere Si Capac, 25x22cm, Verde

fla-baitbin-325
Livrare 48-72ore

78,65Lei

Geanta NGT Groundbait Bowl Deluxe, 30x15cm, Verde
Exclusiv online!

Geanta NGT Groundbait Bowl Deluxe, 30x15cm, Verde

fla-g/baitbowl-011
Livrare 48-72ore

45,15Lei

Geanta NGT Groundbait Bowl, 30x15cm, Verde
Exclusiv online!

Geanta NGT Groundbait Bowl, 30x15cm, Verde

fla-g/baitbowl-011-ind
Livrare 48-72ore

45,15Lei

Geanta Nytro Sublime Long Essentials Bag, 59.4L, 90x33x20cm
Exclusiv online!

Geanta Nytro Sublime Long Essentials Bag, 59.4L, 90x33x20cm

22400034
Livrare 48-72 ore

355,60Lei

Geanta Pentru Cutite Victorinox Cutlery Roll Bag, 8 Locuri, Negru
Exclusiv online!

Geanta Pentru Cutite Victorinox Cutlery Roll Bag, 8 Locuri, Negru

7.4011.47
Livrare 48-72ore

175,00Lei

Geanta Pentru Cutite Victorinox Small Cutlery Roll Bag, Nylon, 56cm, Gri
Exclusiv online!

Geanta Pentru Cutite Victorinox Small Cutlery Roll Bag, Nylon, 56cm, Gri

7.4010.56
Livrare 48-72ore

355,00Lei

Set Dinsmores Combo 2 Juvelnice + Geanta Transport, 2buc/pac
Exclusiv online!

Set Dinsmores Combo 2 Juvelnice + Geanta Transport, 2buc/pac

dsfq12
Livrare 48-72 ore

325,00Lei

FREZA ENERGOTEAM COPCA 13CM CU GEANTA CAMOU
Exclusiv online!

FREZA ENERGOTEAM COPCA 13CM CU GEANTA CAMOU

80400100
Livrare 24-48 ore

235,00Lei

Geanta NGT Picnic Deluxe Cutlery Set, 23x10x23cm

Geanta NGT Picnic Deluxe Cutlery Set, 23x10x23cm

ngt-fla-cutlery-109
Livrare imediată!

196,00Lei

Geanta Ngt Jumbo Insulated Green Carryall 709-L 83X35X35 CM

Geanta Ngt Jumbo Insulated Green Carryall 709-L 83X35X35 CM

ngt-fla-carryall-709-l
Livrare imediată!

249,00Lei

GEANTA TRAKKO PT MULINETE M19C 33X13X23CM

GEANTA TRAKKO PT MULINETE M19C 33X13X23CM

m19-c
Livrare imediată!

175,00Lei

GEANTA NGT SESSION CARRYALL 800 / 75 x 35 x 37CM

GEANTA NGT SESSION CARRYALL 800 / 75 x 35 x 37CM

ngt-fla-carryall-800
Livrare imediată!

139,99Lei

Afişare 241 - 260 din 1038 (52 pagini)
Queries: 10, Total time: 28.051 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'bec4423d412e6cb9cfc283de12'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.152)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (26.881)
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('+geanta' 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 (0.156)
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
5 (0.133)
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.126)
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.123)
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
8 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.128)
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