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


Cort Avid Carp HQ Dual Layer Bivvy Two Man

Cort Avid Carp HQ Dual Layer Bivvy Two Man

a0530006
Stoc epuizat

1.999,90Lei

Cort Avid Carp HQ Dual Layer Bivvy - One Man -37%

Cort Avid Carp HQ Dual Layer Bivvy - One Man

a0530005
Stoc epuizat

2.656,76Lei(-37%) 1.673,39Lei

Cort JRC Defender Peak Bivvy 2-Man, 300x295x150cm -24%

Cort JRC Defender Peak Bivvy 2-Man, 300x295x150cm

1441604
Stoc epuizat

1.200,00Lei(-24%) 915,00Lei

Winterskin Jrc Defender Peak Bivvy 2 Man Wrap, 300x295x150cm

Winterskin Jrc Defender Peak Bivvy 2 Man Wrap, 300x295x150cm

1441605
Stoc epuizat

474,95Lei

Cort Avid EXO+ BIVVY 270x230x195x140cm

Cort Avid EXO+ BIVVY 270x230x195x140cm

a0530016
Stoc epuizat

2.699,96Lei

Cort Z-Fish Bivvy Comfort Dome 2 Men 250x310x150cm

Cort Z-Fish Bivvy Comfort Dome 2 Men 250x310x150cm

zf-2730
Stoc epuizat

996,01Lei

Lampa Cort Z-Fish Bite Alarm Bivvy Light

Lampa Cort Z-Fish Bite Alarm Bivvy Light

zf-3429
Stoc epuizat

129,33Lei

Winterskin Jrc Extreme TX Bivvy 2 Man Wrap

Winterskin Jrc Extreme TX Bivvy 2 Man Wrap

1377128
Stoc epuizat

1.249,95Lei

Winterskin Jrc Defender Bivvy 2-Man Wrap, 300x295x150cm -25%

Winterskin Jrc Defender Bivvy 2-Man Wrap, 300x295x150cm

1441619
Stoc epuizat

500,00Lei(-25%) 375,00Lei

Cort JRC Stealth EZ Winder Bivvy 1 Man, 270x175x140cm

Cort JRC Stealth EZ Winder Bivvy 1 Man, 270x175x140cm

1485655
Stoc epuizat

3.111,93Lei

Winterskin Jrc Stealth EZ Winder Bivvy Wrap

Winterskin Jrc Stealth EZ Winder Bivvy Wrap

1485656
Stoc epuizat

453,56Lei

Winterskin JRC Extreme TX2 2 Man Bivvy Wrap, 300x320x185cm

Winterskin JRC Extreme TX2 2 Man Bivvy Wrap, 300x320x185cm

1503041
Stoc epuizat

957,18Lei

CAPSULA INTERIOARA CORT FOX R SERIES 1 MAN BIVVY XL INNER DOME -17%

CAPSULA INTERIOARA CORT FOX R SERIES 1 MAN BIVVY XL INNER DOME

cum245
Stoc epuizat

494,96Lei(-17%) 409,04Lei

CORT FOX R-SERIES 1-MAN BIVVY XL PLUS INNER DOME KHAKI 235X295X165CM -17%

CORT FOX R-SERIES 1-MAN BIVVY XL PLUS INNER DOME KHAKI 235X295X165CM

cum243
Stoc epuizat

2.204,96Lei(-17%) 1.822,16Lei

Cuie Cort NGT Platform Bivvy Pegs, 10buc/set

Cuie Cort NGT Platform Bivvy Pegs, 10buc/set

ngt-fo-platformpegs
Stoc epuizat

35,00Lei

PAPUCI NASH Deluxe Bivvy Slippers Size 9 Nr.43

PAPUCI NASH Deluxe Bivvy Slippers Size 9 Nr.43

c5437
Stoc epuizat

145,99Lei

Masa Sonik Sk Tek Bivvy Table

Masa Sonik Sk Tek Bivvy Table

sn714166
Stoc epuizat

219,00Lei

Lampa de Cort RidgeMonkey Bivvy Light Plus 20x3.6x3.6cm -34%

Lampa de Cort RidgeMonkey Bivvy Light Plus 20x3.6x3.6cm

rm121
Stoc epuizat

215,28Lei(-34%) 142,90Lei

Cort Jrc Defender Peak Bivvy 1-Man, 270x235x140cm -24%

Cort Jrc Defender Peak Bivvy 1-Man, 270x235x140cm

1441606
Stoc epuizat

864,00Lei(-24%) 658,30Lei

Covor Aqua Products Black Series Neoprene Bivvy Mat XL, 13x6.5cm

Covor Aqua Products Black Series Neoprene Bivvy Mat XL, 13x6.5cm

410135
Stoc epuizat

249,95Lei

Afişare 121 - 140 din 144 (8 pagini)
Queries: 10, Total time: 188.890 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '27c9df8c41f53115b0079b2d63'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (187.187)
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 "%bivvy%") 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.777)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.086)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FOX INDISPONIBIL2(IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
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
9 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD INDISPONIBIL2(IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.138)
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