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

Produse ce potrivesc criteriilor de căutare


Suport Minciog JACKALL T-Connection Timon Net Stand
Exclusiv online!

Suport Minciog JACKALL T-Connection Timon Net Stand

a6.ja.807260472
Livrare 24-48 ore

350,40Lei

Minciog Shimano TX Extreme Landing Net 185cm -5%

Minciog Shimano TX Extreme Landing Net 185cm

txelnp42
Livrare imediată!

721,22Lei(-5%) 685,00Lei

Flotor Minciog Nash Net Float Camo Large

Flotor Minciog Nash Net Float Camo Large

t3586
Livrare imediată!

77,99Lei

Flotor Minciog Nash Subterfuge Net Float Small -22%

Flotor Minciog Nash Subterfuge Net Float Small

t3619
Livrare imediată!

68,98Lei(-22%) 54,01Lei

Flotor Minciog Nash Net Float Camo Small -20%

Flotor Minciog Nash Net Float Camo Small

t3585
Livrare imediată!

63,99Lei(-20%) 50,90Lei

Flotor Minciog Nash Subterfuge Net Float Camo Large -21%

Flotor Minciog Nash Subterfuge Net Float Camo Large

t3620
Livrare imediată!

82,99Lei(-21%) 65,60Lei

MANER MINCIOG TRABUCCO DREAM TEAM NET*FAST CARP NET 3,20m

MANER MINCIOG TRABUCCO DREAM TEAM NET*FAST CARP NET 3,20m

081-06-320
Stoc epuizat

299,00Lei

MANER MINCIOG TRAKKO LUCHY TELE NET HANDLE 4 TRONSOANE 3.50M

MANER MINCIOG TRAKKO LUCHY TELE NET HANDLE 4 TRONSOANE 3.50M

tr3504
Stoc epuizat

165,01Lei

Minciog Fox Explorer Landing Net 42 Telescopic 6 Handle

Minciog Fox Explorer Landing Net 42 Telescopic 6 Handle

cln052
Stoc epuizat

536,70Lei

Bac Maver IT MV-R Maggot Net 12cm

Bac Maver IT MV-R Maggot Net 12cm

1083003
Stoc epuizat

61,00Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m -25%

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m

cln056
Stoc epuizat

1.403,95Lei(-25%) 1.052,96Lei

Bac Maver IT MV-R Maggot Net 18cm

Bac Maver IT MV-R Maggot Net 18cm

1083005
Stoc epuizat

93,00Lei

Bac Maver IT MV-R Maggot Net 8cm

Bac Maver IT MV-R Maggot Net 8cm

1083001
Stoc epuizat

72,00Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m -25%

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 1.80m

cln055
Stoc epuizat

1.237,46Lei(-25%) 928,09Lei

Bac Maver IT MV-R Maggot Net 10cm

Bac Maver IT MV-R Maggot Net 10cm

1083002
Stoc epuizat

49,00Lei

MANER MINCIOG TRABUCCO SPECTRUM COMPETITION NET 4.7M

MANER MINCIOG TRABUCCO SPECTRUM COMPETITION NET 4.7M

081-03-470
Stoc epuizat

650,00Lei

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

k0380002
Stoc epuizat

177,08Lei

Bac Maver IT MV-R Maggot Net 14 cm

Bac Maver IT MV-R Maggot Net 14 cm

1083004
Stoc epuizat

83,00Lei

Halau DAM Umbrella Net Nylon 100x100x15cm 6mm 50cm

Halau DAM Umbrella Net Nylon 100x100x15cm 6mm 50cm

5060965911
Stoc epuizat

72,44Lei

MANER MINCIOG TRABUCCO SPECTRUM PERFORMANCE NET 4.6M

MANER MINCIOG TRABUCCO SPECTRUM PERFORMANCE NET 4.6M

081-04-460
Stoc epuizat

540,00Lei

Afişare 241 - 260 din 432 (22 pagini)
Queries: 6, Total time: 12.165 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = 'eb8caf1d1b3408b2f1e9e789df'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (9.771)
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('+net' 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.896)
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 240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
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.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