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 THE ONE STIFFY CHOD RIG HOOKLINK 0.50MM 20M

FIR MONOFILAMENT THE ONE STIFFY CHOD RIG HOOKLINK 0.50MM 20M

31703050
Stoc epuizat

39,00Lei

FIR CARP ZOOM SERIA EXTREME BUSA-SILVER CARP 250m 0.40mm Transparent

FIR CARP ZOOM SERIA EXTREME BUSA-SILVER CARP 250m 0.40mm Transparent

cz2163
Stoc epuizat

12,50Lei

FIR MONOFILAMENT ENERGOTEAM EXCALIBUR CARP FLUO ORANGE 0.35MM 3000M

FIR MONOFILAMENT ENERGOTEAM EXCALIBUR CARP FLUO ORANGE 0.35MM 3000M

34060935
Stoc epuizat

157,00Lei

Fir Carp Expert UV 300m 0.20mm

Fir Carp Expert UV 300m 0.20mm

30119020
Stoc epuizat

19,00Lei

Fir Monofilament Nevis Mistral Fluo Green 300m 0.20mm

Fir Monofilament Nevis Mistral Fluo Green 300m 0.20mm

3232-320
Stoc epuizat

27,00Lei

FIR ENERGO TEAM SPECIALIST CARP 0.18 MM 300M

FIR ENERGO TEAM SPECIALIST CARP 0.18 MM 300M

33200018
Stoc epuizat

8,50Lei

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.20MM

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.20MM

34060020
Stoc epuizat

16,01Lei

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.35mm 20.3lbs

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.35mm 20.3lbs

500623035
Stoc epuizat

43,99Lei

Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.30mm 15.9lbs

Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.30mm 15.9lbs

500623430
Stoc epuizat

87,00Lei

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.40mm 25.3lbs

Fir Delphin FIN Carp ARMADA 300m Camuflaj 0.40mm 25.3lbs

500623040
Stoc epuizat

49,00Lei

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.30mm

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.30mm

34055030
Stoc epuizat

18,00Lei

Fir Carp Expert UV 300m 0.30mm

Fir Carp Expert UV 300m 0.30mm

30119030
Stoc epuizat

20,00Lei

FIR NASH MONOFILAMENT BULLET GREEN, 0.37mm, 15lb/6.80kg

FIR NASH MONOFILAMENT BULLET GREEN, 0.37mm, 15lb/6.80kg

t2802
Stoc epuizat

115,99Lei

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.18MM

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.18MM

34060018
Stoc epuizat

16,01Lei

Fir Monofilament EnergoTeam Kamasaki Super XXL 04 0.45mm 500m

Fir Monofilament EnergoTeam Kamasaki Super XXL 04 0.45mm 500m

30009445
Stoc epuizat

38,40Lei

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.22mm

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.22mm

34055022
Stoc epuizat

18,00Lei

Fir Carp Expert Boilie Special Multicolor 0.45mm 150m

Fir Carp Expert Boilie Special Multicolor 0.45mm 150m

30125745
Stoc epuizat

15,01Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.26mm 5.70kg Fluo Pink -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.26mm 5.70kg Fluo Pink

cz6995
Stoc epuizat

65,00Lei(-25%) 48,80Lei

Fir Quantum Salsa Rosu Transparent 0.35mm, 275m

Fir Quantum Salsa Rosu Transparent 0.35mm, 275m

2611135
Stoc epuizat

44,78Lei

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

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

750186615
Stoc epuizat

67,00Lei

Afişare 1701 - 1720 din 1889 (95 pagini)
Queries: 7, Total time: 56.089 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = 'e705e2de56163791afb3767d8e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (55.451)
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.135)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.101)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.089)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"P-LINE EUROPE S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.125)
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