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


Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.22mm, 150m

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.22mm, 150m

33905122
Livrare imediată!

24,00Lei

Monofilament Nevis Winner 100m 0.22mm
Exclusiv online!

Monofilament Nevis Winner 100m 0.22mm

3206-022
Livrare 48-72 ore

6,70Lei

FIR CARP ZOOM SERIA EXTREME CARP 250m 0.28mm Brown

FIR CARP ZOOM SERIA EXTREME CARP 250m 0.28mm Brown

cz2262
Livrare imediată!

12,50Lei

Fir monofilament P-Line CXX X-TRA Strong Moss Green 0.30mm/9.60kg/1000m

Fir monofilament P-Line CXX X-TRA Strong Moss Green 0.30mm/9.60kg/1000m

750186616
Livrare imediată!

68,00Lei

Monofilament Nevis Winner 100m 0.20mm

Monofilament Nevis Winner 100m 0.20mm

3206-020
Livrare imediată!

6,70Lei

FIR ENERGO TEAM SPECIALIST CARP 0.16 MM 300M

FIR ENERGO TEAM SPECIALIST CARP 0.16 MM 300M

33200016
Livrare imediată!

8,50Lei

Monofilament Nevis Endura 600m 0.25mm

Monofilament Nevis Endura 600m 0.25mm

3212-625
Livrare imediată!

35,00Lei

Monofilament Nevis Sensor Fluo 1000m 0.28mm
Exclusiv online!

Monofilament Nevis Sensor Fluo 1000m 0.28mm

3201-828
Livrare 48-72 ore

66,00Lei

Fir P-LINE FLOROCLEAR 2000 M 0.28 MM CLEAR

Fir P-LINE FLOROCLEAR 2000 M 0.28 MM CLEAR

750187728
Livrare imediată!

103,99Lei

Fir ASSO Ultra Carp Brown 0.39 mm 1000 m
Exclusiv online!

Fir ASSO Ultra Carp Brown 0.39 mm 1000 m

607080068
Livrare 48-72 ore

94,57Lei

Fir Monofilament Mivardi Royal Carp 300m 0.25mm/8.30kg

Fir Monofilament Mivardi Royal Carp 300m 0.25mm/8.30kg

miv-rc325
Livrare imediată!

36,00Lei

Fir Asso Invisilk Yellow 0.30mm 300m
Exclusiv online!

Fir Asso Invisilk Yellow 0.30mm 300m

602080095
Livrare 48-72 ore

35,70Lei

Monofilament Nevis Xenon 300m 0.35mm

Monofilament Nevis Xenon 300m 0.35mm

3211-335
Livrare imediată!

23,90Lei

Fir ASSO Ultra Carp Brown 0.32 mm 1000 m
Exclusiv online!

Fir ASSO Ultra Carp Brown 0.32 mm 1000 m

607080066
Livrare 48-72 ore

80,29Lei

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.18mm, 150m
Exclusiv online!

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.18mm, 150m

33905118
Livrare 24-48 ore

24,00Lei

FIR ENERGOTEAM EXCALIBUR CARP CAMOU 300m 0,25mm

FIR ENERGOTEAM EXCALIBUR CARP CAMOU 300m 0,25mm

34050025
Livrare imediată!

16,01Lei

Fir Monofilament EnergoTeam Kamasaki Super XXL 07 0.60mm 300m -20%

Fir Monofilament EnergoTeam Kamasaki Super XXL 07 0.60mm 300m

30009760
Livrare imediată!

35,00Lei(-20%) 28,00Lei

Fir Carp Expert Carbon 0.40mm 150m

Fir Carp Expert Carbon 0.40mm 150m

30100040
Livrare imediată!

13,99Lei

Monofilament Nevis Raptor 1000m 0.32mm

Monofilament Nevis Raptor 1000m 0.32mm

3241-132
Livrare imediată!

85,00Lei

Monofilament Nevis Winner 100m 0.35mm

Monofilament Nevis Winner 100m 0.35mm

3206-035
Livrare imediată!

6,90Lei

Afişare 1001 - 1020 din 1892 (95 pagini)
Queries: 4, Total time: 66.663 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '99760e959d9bec4a3dd3f6459c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (66.277)
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('+fire +monofilament +crap' 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.151)
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