SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 0 AND manufacturerid = 80 LIMIT 1
Filter

Nieuwe producten Hassia

1 - 5 van 5
Sorteer op:
HASSIA Turin H - 4_306924_3200
object(stdClass)#172 (46) { ["id"]=> string(3) "592" ["children"]=> string(1) "0" ["photoid"]=> string(3) "933" ["serial_number"]=> string(0) "" ["article_number"]=> string(13) "4_306924_3200" ["price"]=> string(6) "189.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(30) "HASSIA Turin H - 4_306924_3200" ["keyname"]=> string(7) "turin-h" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(2) "80" ["manufacturer_name"]=> string(6) "Hassia" ["manufacturer_keyname"]=> string(6) "hassia" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "189.95" }
HassiaHASSIA Turin H - 4_306924_3200
€ 189,95
HASSIA Piazenca G - 4_301688_0100
object(stdClass)#167 (46) { ["id"]=> string(3) "588" ["children"]=> string(1) "0" ["photoid"]=> string(3) "925" ["serial_number"]=> string(0) "" ["article_number"]=> string(13) "4_301688_0100" ["price"]=> string(6) "149.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(33) "HASSIA Piazenca G - 4_301688_0100" ["keyname"]=> string(10) "piazenca-g" ["label"]=> string(0) "" ["path"]=> string(27) "/dames/instappers-trotteurs" ["manufacturer_id"]=> string(2) "80" ["manufacturer_name"]=> string(6) "Hassia" ["manufacturer_keyname"]=> string(6) "hassia" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "149.95" }
HassiaHASSIA Piazenca G - 4_301688_0100
€ 149,95
HASSIA Piazenca G - 3_301653_3000
object(stdClass)#172 (46) { ["id"]=> string(3) "447" ["children"]=> string(1) "0" ["photoid"]=> string(3) "701" ["serial_number"]=> string(0) "" ["article_number"]=> string(13) "3_301653_3000" ["price"]=> string(6) "149.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(33) "HASSIA Piazenca G - 3_301653_3000" ["keyname"]=> string(10) "piazenca-g" ["label"]=> string(0) "" ["path"]=> string(27) "/dames/instappers-trotteurs" ["manufacturer_id"]=> string(2) "80" ["manufacturer_name"]=> string(6) "Hassia" ["manufacturer_keyname"]=> string(6) "hassia" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "149.95" }
HassiaHASSIA Piazenca G - 3_301653_3000
€ 149,95
HASSIA metallizzard J - 303333_0100
object(stdClass)#167 (46) { ["id"]=> string(3) "377" ["children"]=> string(1) "0" ["photoid"]=> string(3) "581" ["serial_number"]=> string(0) "" ["article_number"]=> string(11) "303333_0100" ["price"]=> string(6) "149.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(35) "HASSIA metallizzard J - 303333_0100" ["keyname"]=> string(14) "metallizzard-j" ["label"]=> string(0) "" ["path"]=> string(24) "/dames/pumps-ballerina-s" ["manufacturer_id"]=> string(2) "80" ["manufacturer_name"]=> string(6) "Hassia" ["manufacturer_keyname"]=> string(6) "hassia" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "149.95" }
HassiaHASSIA metallizzard J - 303333_0100
€ 149,95
HASSIA wijdte H - 1-301431_0400
object(stdClass)#172 (46) { ["id"]=> string(3) "278" ["children"]=> string(1) "0" ["photoid"]=> string(3) "404" ["serial_number"]=> string(0) "" ["article_number"]=> string(13) "1-301431_0400" ["price"]=> string(6) "174.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(31) "HASSIA wijdte H - 1-301431_0400" ["keyname"]=> string(8) "wijdte-h" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(2) "80" ["manufacturer_name"]=> string(6) "Hassia" ["manufacturer_keyname"]=> string(6) "hassia" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "174.95" }
HassiaHASSIA wijdte H - 1-301431_0400
€ 174,95