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


Combo Pat + Sac de Dormit Nash Indulgence All Season Sleep System SS4 Wide, 212x96x38cm
Patura Bushmen Thermo Blanket 2x1.4m

Patura Bushmen Thermo Blanket 2x1.4m

5902194521260
Stoc epuizat

280,00Lei

Sac De Dormit Delphin ATRA 180x 80Cm

Sac De Dormit Delphin ATRA 180x 80Cm

410096020
Stoc epuizat

217,00Lei

PATURA FOX VRS2 CAMO SLEEPING BAG COVER -20%

PATURA FOX VRS2 CAMO SLEEPING BAG COVER

csb058
Stoc epuizat

456,19Lei(-20%) 364,95Lei

PATURA FOX VRS3 CAMO THERMAL BAG COVER -20%

PATURA FOX VRS3 CAMO THERMAL BAG COVER

csb062
Stoc epuizat

585,00Lei(-20%) 468,00Lei

Combo Pat Pescuit Plus Sac de Dormit Fox Duralite 5 Season System 202x78cm -14%

Combo Pat Pescuit Plus Sac de Dormit Fox Duralite 5 Season System 202x78cm

cbc099
Stoc epuizat

2.384,96Lei(-14%) 2.049,75Lei

Sac de dormit Trakker Big Snooze Plus Compact

Sac de dormit Trakker Big Snooze Plus Compact

208105
Stoc epuizat

449,95Lei

Sac de dormit Delphin Fortix 220x90cm -20%

Sac de dormit Delphin Fortix 220x90cm

101003003
Stoc epuizat

457,00Lei(-20%) 366,00Lei

Patura Jrc Rova Sleeping Bag Cover Wide 225x171cm -40%

Patura Jrc Rova Sleeping Bag Cover Wide 225x171cm

1537843
Stoc epuizat

339,99Lei(-40%) 202,30Lei

Sac de Dormit DD Hammocks Scarba

Sac de Dormit DD Hammocks Scarba

707273931580
Stoc epuizat

395,00Lei

Sac de Dormit Coleman Lotus XL, 220x100cm

Sac de Dormit Coleman Lotus XL, 220x100cm

2000038691
Stoc epuizat

350,00Lei

Sac de Dormit pentru Copii Coleman Frisco Mummy, 167,5x66cm

Sac de Dormit pentru Copii Coleman Frisco Mummy, 167,5x66cm

2000015576
Stoc epuizat

250,00Lei

Sac de Dormit Coleman Heaton Peak Comfort 220 - 220 x 100 cm

Sac de Dormit Coleman Heaton Peak Comfort 220 - 220 x 100 cm

2000020999
Stoc epuizat

440,00Lei

Sac de Dormit DD Hammocks Jura 2 Camo

Sac de Dormit DD Hammocks Jura 2 Camo

707273932310
Stoc epuizat

510,00Lei

Sac de Dormit DD Hammocks Jura 2 Olive Green

Sac de Dormit DD Hammocks Jura 2 Olive Green

705422506207
Stoc epuizat

495,00Lei

Patura Trakker Levelite Oval MF-HDR Cover, 245x150cm

Patura Trakker Levelite Oval MF-HDR Cover, 245x150cm

208312
Stoc epuizat

699,95Lei

Patura Trakker Levelite Oval MF-HDR Wide Cover, 245x165cm

Patura Trakker Levelite Oval MF-HDR Wide Cover, 245x165cm

208314
Stoc epuizat

749,95Lei

Sac de Dormit DD Hammocks Jura 2 XL Camo

Sac de Dormit DD Hammocks Jura 2 XL Camo

707273932327
Stoc epuizat

535,00Lei

Sac de Dormit DD Hammocks Jura 2 XL Olive Green

Sac de Dormit DD Hammocks Jura 2 XL Olive Green

705422506214
Stoc epuizat

525,00Lei

Sac De Dormit Zfish Sleeping Everest 5 Season, Kaki, 210x90x10cm

Sac De Dormit Zfish Sleeping Everest 5 Season, Kaki, 210x90x10cm

ZF-2728
Stoc epuizat

756,94Lei

Afişare 81 - 100 din 100 (5 pagini)
Queries: 6, Total time: 185.657 ms [By time] [By id] [By file]
1 (0.068)
SELECT data
FROM `oc_session`
WHERE session_id = 'c0541887daf6ec8f7a67bf9338'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.062)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (184.245)
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 = '0' AND (pd.tag LIKE "%dormit%") 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.989)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.154)
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.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38