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

Produse ce potrivesc criteriilor de căutare


Umbrela Patrata Garbolino PVC Inclinatie 45, 70x70cm
Exclusiv online!

Umbrela Patrata Garbolino PVC Inclinatie 45, 70x70cm

90130gomel3015
Livrare 48-72 ore

257,36Lei

Umbrela Rive Aqua Parasol Diam. 2.10m
Exclusiv online!

Umbrela Rive Aqua Parasol Diam. 2.10m

90110340520
Livrare 48-72 ore

664,54Lei

Adapost Tip Umbrela Korum Progress Graphite Brolly 140x210cm
Exclusiv online!

Adapost Tip Umbrela Korum Progress Graphite Brolly 140x210cm

k0370008
Livrare 7-14 zile

539,96Lei

Umbrela Garbolino Essential, 2.5m, Black
Exclusiv online!

Umbrela Garbolino Essential, 2.5m, Black

90130gomeg3300-250
Livrare 48-72 ore

556,38Lei

Umbrela NGT Green, 2.20m
Exclusiv online!

Umbrela NGT Green, 2.20m

ngt-fbb-brolly-45-grn
Livrare 48-72 ore

140,00Lei

Umbrela Mivardi Easy + cort impermeabil - M-AUSE220
Exclusiv online!

Umbrela Mivardi Easy + cort impermeabil - M-AUSE220

m-ause220
Livrare 48-72 ore

387,00Lei

Umbrela Matrix Space Brolly 250cm -21%

Umbrela Matrix Space Brolly 250cm

gum007
Livrare imediată!

562,50Lei(-21%) 447,00Lei

Umbrela Cort Nevis 2.5m
Exclusiv online!

Umbrela Cort Nevis 2.5m

7509-251
Livrare 48-72 ore

316,00Lei

Umbrela PVC Carp Expert, 220cm

Umbrela PVC Carp Expert, 220cm

73749225
Livrare imediată!

164,53Lei

Umbrela Nevis 2.2m

Umbrela Nevis 2.2m

7509-220
Livrare imediată!

203,00Lei

Umbrela cu Paravan Carp Expert, 220cm
Exclusiv online!

Umbrela cu Paravan Carp Expert, 220cm

73749226
Livrare 24-48 ore

233,04Lei

Umbrela cu Paravan Carp Expert, 250cm

Umbrela cu Paravan Carp Expert, 250cm

73749256
Livrare imediată!

274,21Lei

Umbrela Mikado Cu Aparatoare 360 Mosquito Net, 250cm
Exclusiv online!

Umbrela Mikado Cu Aparatoare 360 Mosquito Net, 250cm

is14-p003
Livrare 48-72 ore

559,00Lei

Umbrela PVC Carp Expert, 250cm
Exclusiv online!

Umbrela PVC Carp Expert, 250cm

73749255
Livrare 24-48 ore

191,89Lei

Umbrela Zfish Cu Pereti Laterali Royal Full Cover, 250cm
Exclusiv online!

Umbrela Zfish Cu Pereti Laterali Royal Full Cover, 250cm

ZF-2550
Livrare 48-72ore

398,30Lei

Umbrela Serie Walter Protectie Nada Bait Brolly, Grey, 83x83cm

Umbrela Serie Walter Protectie Nada Bait Brolly, Grey, 83x83cm

sw6-703
Livrare imediată!

238,06Lei

Umbrela FL 3.00M Camuflaj Inchidere Totala

Umbrela FL 3.00M Camuflaj Inchidere Totala

5296210946381
Livrare imediată!

549,80Lei

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm -31%

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm

sharpumb01
Stoc epuizat

700,01Lei(-31%) 485,00Lei

Umbrelă cu Perete Lateral Delphin THUNDER FullWALL -26%

Umbrelă cu Perete Lateral Delphin THUNDER FullWALL

101003317
Stoc epuizat

369,99Lei(-26%) 275,20Lei

Umbrela NuFish Nylon Economi NFU050, 115cm

Umbrela NuFish Nylon Economi NFU050, 115cm

5035305800401
Stoc epuizat

180,00Lei

Afişare 1 - 20 din 28 (2 pagini)
Queries: 12, Total time: 558.075 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = 'cce14f53b8d69b4fdae4488897'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (556.096)
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 (pd.tag LIKE "%umbrele%pescuit%/%camping%") 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 (0.163)
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.403)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.155)
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.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.239)
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:1248
9 (0.120)
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:1270
10 (0.103)
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:1035
11 (0.386)
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:949
12 (0.118)
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