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


Rezerva Plasa Solubila PVA Webcast PVA Refill Wide, 37mm x 5m

Rezerva Plasa Solubila PVA Webcast PVA Refill Wide, 37mm x 5m

t8668
Livrare imediată!

36,00Lei

Geanta din Plasa Sonik 5kg SK-Tek Air Dry Bag, Large, 26x14x26cm
Exclusiv online!

Geanta din Plasa Sonik 5kg SK-Tek Air Dry Bag, Large, 26x14x26cm

sktadbl
Livrare 48-72 ore

83,72Lei

Kit Plasa Solubila + Tija Compresie Carp Academy 4 Season, 5m, 22mm
Exclusiv online!

Kit Plasa Solubila + Tija Compresie Carp Academy 4 Season, 5m, 22mm

6408-122
Livrare 48-72 ore

47,50Lei

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Narrow, 23mm x 4m

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Narrow, 23mm x 4m

t8664
Livrare imediată!

72,00Lei

Plasa Anti Insecte 360° Ticket to the Moon Neagra, 300x130cm
Exclusiv online!

Plasa Anti Insecte 360° Ticket to the Moon Neagra, 300x130cm

tmnet07
Livrare 24-48 ore

275,00Lei

Rezerva Carp Academy Plasa Solubila PVA 4 Season, 22mm, 5m
Exclusiv online!

Rezerva Carp Academy Plasa Solubila PVA 4 Season, 22mm, 5m

6408-022
Livrare 48-72 ore

34,61Lei

Kit Plasa Solubila + Tija Compresie Nash Webcast PVA System Wide, 37mm x 7m

Kit Plasa Solubila + Tija Compresie Nash Webcast PVA System Wide, 37mm x 7m

t8662
Livrare imediată!

67,50Lei

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Wide, 37mm x 4m -43%

Kit Plasa Solubila + Tija Compresie Nash Webcast Ultra Weave PVA Wide, 37mm x 4m

t8665
Livrare imediată!

79,00Lei(-43%) 44,90Lei

Rezerva Carp Academy Plasa Solubila PVA 4 Season, 34mm, 5m
Exclusiv online!

Rezerva Carp Academy Plasa Solubila PVA 4 Season, 34mm, 5m

6408-034
Livrare 48-72 ore

44,60Lei

Rezerva Plasa Solubila PVA Webcast Ultra Weave PVA Super Narrow, 18mm x 3m -39%

Rezerva Plasa Solubila PVA Webcast Ultra Weave PVA Super Narrow, 18mm x 3m

t8669
Livrare imediată!

43,99Lei(-39%) 26,91Lei

Kit NGT Wide Plasa Solubila cu Presa PVA Mesh 7m

Kit NGT Wide Plasa Solubila cu Presa PVA Mesh 7m

ngt-fpva-tube-w-7m
Livrare imediată!

45,01Lei

Plasa Anti Tantari Coghlans Hiker
Exclusiv online!

Plasa Anti Tantari Coghlans Hiker

c9775
Livrare 24-48 ore

121,00Lei

Plasa Antiinsecte pentru Hamac Desert Bushmen
Exclusiv online!

Plasa Antiinsecte pentru Hamac Desert Bushmen

5902194520928
Livrare 24-48 ore

255,01Lei

Plasa Anti Insecte Bushmen Vagabond
Exclusiv online!

Plasa Anti Insecte Bushmen Vagabond

5902194521284
Livrare 24-48 ore

199,00Lei

Plasa Anti Tantari Coghlans pentru Caruciorul de Copii
Exclusiv online!

Plasa Anti Tantari Coghlans pentru Caruciorul de Copii

c9915
Livrare 24-48 ore

30,00Lei

Plasa Rezerva Minciog Reinforced III, 117x117x117cm

Plasa Rezerva Minciog Reinforced III, 117x117x117cm

5941944264026
Livrare imediată!

69,00Lei

CAP MINCIOG PRO FL PLASA CAMO CU MANER 40X50CM

CAP MINCIOG PRO FL PLASA CAMO CU MANER 40X50CM

bw5040m
Livrare imediată!

70,90Lei

CAP MINCIOG PRO FL PLASA CAMO CU MANER 50X60CM

CAP MINCIOG PRO FL PLASA CAMO CU MANER 50X60CM

bw6050m
Livrare imediată!

80,90Lei

CAP MINCIOG PRO FL PLASA CAMO CU MANER 60X70CM

CAP MINCIOG PRO FL PLASA CAMO CU MANER 60X70CM

bw7060m
Livrare imediată!

91,90Lei

Kit Carp Spirit Plasa Solubila PVA Tub, 7m, 14mm
Exclusiv online!

Kit Carp Spirit Plasa Solubila PVA Tub, 7m, 14mm

acs010423
Livrare 48-72ore

53,00Lei

Afişare 181 - 200 din 335 (17 pagini)
Queries: 6, Total time: 9.606 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '3096fe767c5472e975b8c50341'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.125)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (7.444)
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 = '2' AND (MATCH(pd.tag) AGAINST('+plasa' 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.662)
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 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
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_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38