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


Boilies Solubil Cu Miez Lichid Nutrigo Feed-Ex, Monster Crab, 20mm, 800g

Boilies Solubil Cu Miez Lichid Nutrigo Feed-Ex, Monster Crab, 20mm, 800g

LK-11
Livrare imediată!

79,80Lei

Boilies Solubil Cu Miez Lichid Nutrigo Feed-Ex, Porumb Dulce, 20mm, 800g

Boilies Solubil Cu Miez Lichid Nutrigo Feed-Ex, Porumb Dulce, 20mm, 800g

lk-9
Livrare imediată!

79,80Lei

ADITIV VAN DEN EYNDE LICHID BIG FISH 500ml

ADITIV VAN DEN EYNDE LICHID BIG FISH 500ml

va00186
Livrare imediată!

32,00Lei

Aditiv lichid 220 Baits Supreme Scopex & Betaina - 250ml

Aditiv lichid 220 Baits Supreme Scopex & Betaina - 250ml

5278214834772
Livrare imediată!

30,00Lei

Aditiv lichid 220 Baits Supreme Usturoi & Betaina - 250ml

Aditiv lichid 220 Baits Supreme Usturoi & Betaina - 250ml

6278214595108
Livrare imediată!

30,00Lei

Aditiv Lichid 220 Baits Supreme, Sweet Corn, 250ml

Aditiv Lichid 220 Baits Supreme, Sweet Corn, 250ml

3278214657441
Livrare imediată!

24,55Lei

Lichid Toaleta Instablue Extra 1L

Lichid Toaleta Instablue Extra 1L

2000031967
Livrare imediată!

48,00Lei

Aditiv lichid 220 Baits Supreme Choco & Orange - 250ml

Aditiv lichid 220 Baits Supreme Choco & Orange - 250ml

7278219400819
Livrare imediată!

30,00Lei

Aditiv lichid 220 Baits Supreme Squid & Tutti Frutti - 250ml

Aditiv lichid 220 Baits Supreme Squid & Tutti Frutti - 250ml

5278216848241
Livrare imediată!

30,00Lei

Atractant Lichid KORDA Goo, Honey Supreme, 115ml

Atractant Lichid KORDA Goo, Honey Supreme, 115ml

a0.goo47
Livrare imediată!

103,31Lei

Lichid Atractant Dynamite Baits Hot Crab & Krill 500ml

Lichid Atractant Dynamite Baits Hot Crab & Krill 500ml

dy1646
Livrare imediată!

55,00Lei

Aditiv Lichid Dynamite Baits Sweet Banoffi 250ml
Exclusiv online!

Aditiv Lichid Dynamite Baits Sweet Banoffi 250ml

dy1633
Livrare 48-72ore

29,00Lei

Aditiv Lichid Van Den Eynde Sweet Bream, 500ml

Aditiv Lichid Van Den Eynde Sweet Bream, 500ml

va01056
Livrare imediată!

32,00Lei

Atractant Lichid Dynamite Baits Hot Fish & GLM, 500ml
Exclusiv online!

Atractant Lichid Dynamite Baits Hot Fish & GLM, 500ml

dy1016
Livrare 48-72ore

57,00Lei

Aditiv Lichid Benzar Mix Fruit Shake, Ananas, 225ml

Aditiv Lichid Benzar Mix Fruit Shake, Ananas, 225ml

93701076
Livrare imediată!

24,00Lei

Aditiv Lichid Benzar Mix Fruit Shake, Portocala, 225ml

Aditiv Lichid Benzar Mix Fruit Shake, Portocala, 225ml

93701088
Livrare imediată!

24,00Lei

Aditiv Lichid Benzar Mix Fruit Shake, Capsuna, 225ml

Aditiv Lichid Benzar Mix Fruit Shake, Capsuna, 225ml

93701013
Livrare imediată!

24,00Lei

Lichid 220 Fluo Supreme Somon&Fruit 100 ml

Lichid 220 Fluo Supreme Somon&Fruit 100 ml

0757226060867
Livrare imediată!

28,00Lei

Aditiv Lichid Benzar Mix Fruit Shake, Mango, 225ml

Aditiv Lichid Benzar Mix Fruit Shake, Mango, 225ml

93701092
Livrare imediată!

24,00Lei

Atractant Lichid Carp Zoom R2 PVA Green Booster, Amur, 75ml

Atractant Lichid Carp Zoom R2 PVA Green Booster, Amur, 75ml

cz0892
Livrare imediată!

22,00Lei

Afişare 21 - 40 din 307 (16 pagini)
Queries: 7, Total time: 9.449 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = 'c2fee0ca5c48da4d5513c6b981'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (7.420)
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('+lichid' 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 (1.383)
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
5 (0.133)
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
6 (0.121)
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
7 (0.123)
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