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


Barca Pneumatica JRC Extreme Boat, 330cm

Barca Pneumatica JRC Extreme Boat, 330cm

1390057
Livrare imediată!

4.999,95Lei

Barca Gonflabila Abu Garcia Beast Bellyboat,150x112x60cm
Exclusiv online!

Barca Gonflabila Abu Garcia Beast Bellyboat,150x112x60cm

1523895
Livrare 7-14 zile

2.024,96Lei

Punte Gonflabila Nash Boat Life Inflatable Rib 240 Air Deck
Exclusiv online!

Punte Gonflabila Nash Boat Life Inflatable Rib 240 Air Deck

t0804
Livrare 7-14 zile

686,00Lei

Barca Gonflabila Berkley TEC Belly Boat Pulse XCD

Barca Gonflabila Berkley TEC Belly Boat Pulse XCD

1377097
Livrare imediată!

889,00Lei

Perna Gonflabila pentru Calatorii si Camping Coghlans C2135

Perna Gonflabila pentru Calatorii si Camping Coghlans C2135

c2135
Livrare imediată!

85,00Lei

Barca Pneumatica Nash Life Inflatable Boat, 280cm
Exclusiv online!

Barca Pneumatica Nash Life Inflatable Boat, 280cm

t0807
Livrare 7-14 zile

4.899,96Lei

Saltea Gonflabila Bushmen Air Mat Camp +, 195x57x5cm
Exclusiv online!

Saltea Gonflabila Bushmen Air Mat Camp +, 195x57x5cm

5902194521215
Livrare 24-48 ore

329,00Lei

Barca Pneumatica Zeck Tusker 2.0 Podea Aluminiu, 265x171cm
Exclusiv online!

Barca Pneumatica Zeck Tusker 2.0 Podea Aluminiu, 265x171cm

150105180266
Livrare 48-72 ore

5.228,25Lei

Barca Pneumatica Zeck Hopper 2.0, 220x162cm
Exclusiv online!

Barca Pneumatica Zeck Hopper 2.0, 220x162cm

150105180219
Livrare 48-72 ore

3.758,73Lei

Podina Gonflabila Barca Zeck Pentru Tusker 2.0, 2.65m
Exclusiv online!

Podina Gonflabila Barca Zeck Pentru Tusker 2.0, 2.65m

150205180267
Livrare 48-72 ore

1.186,94Lei

Barca Pneumatica Nash Life Inflatable Boat, 240cm
Exclusiv online!

Barca Pneumatica Nash Life Inflatable Boat, 240cm

t0806
Livrare 7-14 zile

3.723,95Lei

Barca Pneumatica Zeck Tusker 2.0 Podea PVC Heavy Duty, 265x171cm
Exclusiv online!

Barca Pneumatica Zeck Tusker 2.0 Podea PVC Heavy Duty, 265x171cm

150105180265
Livrare 48-72 ore

5.228,25Lei

Barca Zeck Tusker 2.0 Luftboden Podea Heavy Duty PVC, 320x171cm
Exclusiv online!

Barca Zeck Tusker 2.0 Luftboden Podea Heavy Duty PVC, 320x171cm

150105180320
Livrare 48-72 ore

5.787,79Lei

Marker DAM Madcat Gonflabil Tubeless Buoy, 33x13cm

Marker DAM Madcat Gonflabil Tubeless Buoy, 33x13cm

a.mad.56840
Livrare imediată!

173,67Lei

Suport, Lanseta, Zeck, Pentru, Barca, Gonflabila,, Black, 150205180004, Suporturi Pescuit din Barca, Suporturi Pescuit din Barca Zeck, Suporturi Zeck, Pescuit Zeck, din Zeck, Barca Zeck, Zeck
Suport Sonar Zeck Pentru Barca Gonflabila
Exclusiv online!

Suport Sonar Zeck Pentru Barca Gonflabila

150205180005
Livrare 48-72 ore

76,67Lei

Barca Pneumatica Zeck Tusker 2.0 Podea Aluminiu, 320x171cm
Exclusiv online!

Barca Pneumatica Zeck Tusker 2.0 Podea Aluminiu, 320x171cm

150105180321
Livrare 48-72 ore

5.787,79Lei

Barca Zeck Tusker 2.0 Luftboden Podea Heavy Duty PVC, 290x171cm
Exclusiv online!

Barca Zeck Tusker 2.0 Luftboden Podea Heavy Duty PVC, 290x171cm

150105180288
Livrare 48-72 ore

5.490,96Lei

Kit Zeck Reparatie Barca Gonflabila+Belly Boat
Exclusiv online!

Kit Zeck Reparatie Barca Gonflabila+Belly Boat

150205180204
Livrare 48-72 ore

52,54Lei

Podina Gonflabila Barca Zeck Pentru Tusker 2.0, 2.90m
Exclusiv online!

Podina Gonflabila Barca Zeck Pentru Tusker 2.0, 2.90m

150205180286
Livrare 48-72 ore

1.261,15Lei

Afişare 21 - 40 din 57 (3 pagini)
Queries: 10, Total time: 167.070 ms [By time] [By id] [By file]
1 (0.222)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec83a605df5935eda0a80da88f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.226)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (164.839)
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 = '2' AND (pd.tag LIKE "%gonflabil%") 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.121)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.439)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.211)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.108)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.096)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (0.704)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.104)
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