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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Incalzitor pentru Corp Thermopad Tip Centura

Incalzitor pentru Corp Thermopad Tip Centura

78703
Stoc epuizat

28,00Lei

Incalzitor Tip Brant Thermopad, Marime L (40-42)

Incalzitor Tip Brant Thermopad, Marime L (40-42)

78050
Stoc epuizat

18,00Lei

Plumbi Advance Tip Gemini 128g, 1buc/pac

Plumbi Advance Tip Gemini 128g, 1buc/pac

7264236564566
Stoc epuizat

17,90Lei

Incalzitor Tip Brant Thermopad, Marime S (36-39)

Incalzitor Tip Brant Thermopad, Marime S (36-39)

78040
Stoc epuizat

18,00Lei

Plumbi Advance Tip Gemini 125g, 1buc/pac

Plumbi Advance Tip Gemini 125g, 1buc/pac

8264238877816
Stoc epuizat

17,90Lei

Scaun Tapel Tip Trepied Lemn, 75cm

Scaun Tapel Tip Trepied Lemn, 75cm

ve.t732.75
Stoc epuizat

270,00Lei

Capac Protectie Inele STONFO Model B SBS Tip Saver, Size 2, Art.391

Capac Protectie Inele STONFO Model B SBS Tip Saver, Size 2, Art.391

8028651007157
Stoc epuizat

24,00Lei

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E1, Size 1, Art.153

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E1, Size 1, Art.153

8028651005436
Stoc epuizat

29,00Lei

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E2, Size 2, Art.154

Capac Protectie Inele STONFO Model E SBS Tip Saver Tipo E2, Size 2, Art.154

8028651005443
Stoc epuizat

29,00Lei

Lanseta Penn Tidal Surfcasting Multi-tip, 4.50m, 30-150g, 3+3seg

Lanseta Penn Tidal Surfcasting Multi-tip, 4.50m, 30-150g, 3+3seg

1558897
Stoc epuizat

854,96Lei

Hanger Carp Zoom CU LANT TIP CAPSULA S07 GALBEN

Hanger Carp Zoom CU LANT TIP CAPSULA S07 GALBEN

cz3146
Stoc epuizat

32,00Lei

Hanger Carp Zoom CU LANT TIP CAPSULA S07 ROSU

Hanger Carp Zoom CU LANT TIP CAPSULA S07 ROSU

cz3160
Stoc epuizat

32,00Lei

Hanger Carp Zoom CU LANT TIP CAPSULA S07 VERDE

Hanger Carp Zoom CU LANT TIP CAPSULA S07 VERDE

cz3153
Stoc epuizat

32,00Lei

Hanger Carp Zoom CU LANT TIP CAPSULA S07 ALBASTRU

Hanger Carp Zoom CU LANT TIP CAPSULA S07 ALBASTRU

cz3177
Stoc epuizat

32,00Lei

PRINDERE BLASER ZEISS TIP M INALTA

PRINDERE BLASER ZEISS TIP M INALTA

v.bl.80204371
Stoc epuizat

1.604,27Lei

Prindere Blaser Swarowski Tip M Inalta

Prindere Blaser Swarowski Tip M Inalta

v.bl.80204378
Stoc epuizat

1.728,14Lei

HUSA BLASER TIP C LODEN PT. CARABINA 105CM

HUSA BLASER TIP C LODEN PT. CARABINA 105CM

a8.bl.80405362
Stoc epuizat

1.120,68Lei

HUSA BLASER TIP A CORDURA PT.SEMIAUTOMATA 134CM

HUSA BLASER TIP A CORDURA PT.SEMIAUTOMATA 134CM

a8.bl.80405372
Stoc epuizat

369,82Lei

Suport Blaser Tip U

Suport Blaser Tip U

v.bl.80408962
Stoc epuizat

50,08Lei

Prindere Luneta Blaser Sauer 505 Swarovski Tip M

Prindere Luneta Blaser Sauer 505 Swarovski Tip M

v.sr80234623
Stoc epuizat

1.849,84Lei

Afişare 401 - 420 din 420 (21 pagini)
Queries: 7, Total time: 11.808 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'a4e559d031e0bb148babcb7613'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (9.297)
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('+tip' 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.929)
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 400, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PFA BOROS O IOAN"%' 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 '%"PFA BOROS O IOAN"%' 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