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 300 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


VARF PLIN KAMASAKI FIBRA DE STICLA MULTICOLOR 80cm 4,5/0,8m

VARF PLIN KAMASAKI FIBRA DE STICLA MULTICOLOR 80cm 4,5/0,8m

80126245
Stoc epuizat

24,00Lei

Varf Delphin CARBON GLASS pentru LEGIA feeder II 80g Medium

Varf Delphin CARBON GLASS pentru LEGIA feeder II 80g Medium

130385039
Stoc epuizat

47,01Lei

Varf Delphin CARBON GLASS pentru LEGIA feeder II 120g Medium

Varf Delphin CARBON GLASS pentru LEGIA feeder II 120g Medium

130385042
Stoc epuizat

47,01Lei

Varf Browning Carbon Feeder Tip 1Oz 60cm

Varf Browning Carbon Feeder Tip 1Oz 60cm

2051512224031
Stoc epuizat

72,20Lei

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ Model 2

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ Model 2

c.25.2180390r
Stoc epuizat

52,17Lei

Varf Browning Black Viper II-III 1.5Oz 65cm Carbon

Varf Browning Black Viper II-III 1.5Oz 65cm Carbon

12300003
Stoc epuizat

89,79Lei

VARF LANSETA MATRIX Spare Distance Tip 4.0oz Carbon

VARF LANSETA MATRIX Spare Distance Tip 4.0oz Carbon

grd183
Stoc epuizat

157,46Lei

Varf Browning Carbon Feeder Tip 4Oz 60cm

Varf Browning Carbon Feeder Tip 4Oz 60cm

12224035
Stoc epuizat

53,78Lei

VARF JAXON FEEDER GLASS 4.2mm 50cm Soft

VARF JAXON FEEDER GLASS 4.2mm 50cm Soft

ak-sws420a
Stoc epuizat

25,00Lei

VARF DAIWA PT AQALITE FEEDER 13MHQ YELLOW -9%

VARF DAIWA PT AQALITE FEEDER 13MHQ YELLOW

d.11788.395y
Stoc epuizat

44,08Lei(-9%) 40,20Lei

VARF EnergoTeam CARBON 2 TRONSOANE TELESCOPIC 8.00mm 165 cm

VARF EnergoTeam CARBON 2 TRONSOANE TELESCOPIC 8.00mm 165 cm

80130080
Stoc epuizat

18,69Lei

VARF JAXON FEEDER GLASS 3.8mm 50cm Medium

VARF JAXON FEEDER GLASS 3.8mm 50cm Medium

ak-sws380b
Stoc epuizat

25,00Lei

SET VARF EnergoTeam Tubular CARBON 6X5DB

SET VARF EnergoTeam Tubular CARBON 6X5DB

80129099
Stoc epuizat

237,00Lei

VARF Sportex XCLUSIVE FEEDER NT MEDIUM 420 4.0oz -20%

VARF Sportex XCLUSIVE FEEDER NT MEDIUM 420 4.0oz

mf4216a3
Stoc epuizat

99,00Lei(-20%) 79,19Lei

VARF LANSETA MATRIX Spare Distance Tip 3.0oz Carbon

VARF LANSETA MATRIX Spare Distance Tip 3.0oz Carbon

grd182
Stoc epuizat

157,46Lei

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Light 63cm

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Light 63cm

150-81-001
Stoc epuizat

99,00Lei

Varf Browning Argon Quiver Tip 4.00Oz 55cm Carbon

Varf Browning Argon Quiver Tip 4.00Oz 55cm Carbon

12213006
Stoc epuizat

44,78Lei

VARF EnergoTeam CARBON 2 TRONSOANE TELESCOPIC TUB+PLIN 4.1 mm 100cm

VARF EnergoTeam CARBON 2 TRONSOANE TELESCOPIC TUB+PLIN 4.1 mm 100cm

80131041
Stoc epuizat

12,00Lei

VARF LANSETA TRABUCCO TRINIS FX FEEDER Solid Tip 4

VARF LANSETA TRABUCCO TRINIS FX FEEDER Solid Tip 4

150-71-004-indisponibil
Stoc epuizat

59,00Lei

VARF CORMORAN PENTRU FEEDER SPECILAND SRP RED 2.50OZ

VARF CORMORAN PENTRU FEEDER SPECILAND SRP RED 2.50OZ

c.25.5180r
Stoc epuizat

43,88Lei

Afişare 621 - 640 din 683 (35 pagini)
Queries: 4, Total time: 232.085 ms [By time] [By id] [By file]
1 (0.156)
SELECT data
FROM `oc_session`
WHERE session_id = '278b12f43f9f348becfad38679'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (231.704)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%varfuri%") 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:698
4 (0.122)
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