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





Merk
Prijs
t/m
Nieuwe producten
1 - 5 van 5
Sorteer op:

object(stdClass)#144 (46) {
["id"]=>
string(4) "6609"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "8494"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(8) "SK872547"
["price"]=>
string(5) "14.99"
["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(15) "Bokashi Starter"
["keyname"]=>
string(15) "bokashi-starter"
["label"]=>
string(0) ""
["path"]=>
string(21) "/keuken/compostemmers"
["manufacturer_id"]=>
string(2) "65"
["manufacturer_name"]=>
string(7) "Bokashi"
["manufacturer_keyname"]=>
string(7) "bokashi"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["icons"]=>
NULL
["unit_single"]=>
string(4) "Stuk"
["unit_multi"]=>
string(5) "Stuks"
["unit_label"]=>
string(0) ""
["unit_suffix"]=>
string(0) ""
["unit_display"]=>
string(1) "1"
["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(20) "Maximaal 5 werkdagen"
["status_label"]=>
string(0) ""
["button"]=>
string(0) ""
["status_url"]=>
string(0) ""
["type"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(5) "14.99"
}
BokashiBokashi Starter

object(stdClass)#148 (46) {
["id"]=>
string(4) "6606"
["children"]=>
string(1) "2"
["photoid"]=>
string(4) "8480"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(8) "SK322726"
["price"]=>
string(5) "21.99"
["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(21) "Bokashi Organko Daily"
["keyname"]=>
string(21) "bokashi-organko-daily"
["label"]=>
string(0) ""
["path"]=>
string(21) "/keuken/compostemmers"
["manufacturer_id"]=>
string(2) "65"
["manufacturer_name"]=>
string(7) "Bokashi"
["manufacturer_keyname"]=>
string(7) "bokashi"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["icons"]=>
NULL
["unit_single"]=>
string(4) "Stuk"
["unit_multi"]=>
string(5) "Stuks"
["unit_label"]=>
string(0) ""
["unit_suffix"]=>
string(0) ""
["unit_display"]=>
string(1) "1"
["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(16) "Direct leverbaar"
["status_label"]=>
string(0) ""
["button"]=>
string(0) ""
["status_url"]=>
string(0) ""
["type"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(5) "21.99"
}
BokashiBokashi Organko Daily€ 21,99

object(stdClass)#144 (46) {
["id"]=>
string(4) "6602"
["children"]=>
string(1) "4"
["photoid"]=>
string(4) "8470"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(8) "SK878358"
["price"]=>
string(5) "79.00"
["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(17) "Bokashi Organko 2"
["keyname"]=>
string(17) "bokashi-organko-2"
["label"]=>
string(0) ""
["path"]=>
string(21) "/keuken/compostemmers"
["manufacturer_id"]=>
string(2) "65"
["manufacturer_name"]=>
string(7) "Bokashi"
["manufacturer_keyname"]=>
string(7) "bokashi"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["icons"]=>
NULL
["unit_single"]=>
string(4) "Stuk"
["unit_multi"]=>
string(5) "Stuks"
["unit_label"]=>
string(0) ""
["unit_suffix"]=>
string(0) ""
["unit_display"]=>
string(1) "1"
["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(16) "Direct leverbaar"
["status_label"]=>
string(0) ""
["button"]=>
string(0) ""
["status_url"]=>
string(0) ""
["type"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(5) "79.00"
}
BokashiBokashi Organko 2€ 79,00
50% KORTING

object(stdClass)#148 (46) {
["id"]=>
string(4) "6383"
["children"]=>
string(1) "0"
["photoid"]=>
string(4) "7735"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "352.044"
["price"]=>
string(5) "14.99"
["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) "Ichendorf Tumbler Green Butterfly"
["keyname"]=>
string(33) "ichendorf-tumbler-green-butterfly"
["label"]=>
string(0) ""
["path"]=>
string(16) "/keuken/glaswerk"
["manufacturer_id"]=>
string(2) "63"
["manufacturer_name"]=>
string(9) "Ichendorf"
["manufacturer_keyname"]=>
string(9) "ichendorf"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["icons"]=>
NULL
["unit_single"]=>
string(4) "Stuk"
["unit_multi"]=>
string(5) "Stuks"
["unit_label"]=>
string(0) ""
["unit_suffix"]=>
string(0) ""
["unit_display"]=>
string(1) "1"
["promo_name"]=>
string(10) "Uitverkoop"
["promo_keyname"]=>
string(10) "uitverkoop"
["promo_label"]=>
string(11) "50% KORTING"
["promo_color"]=>
string(6) "ff6200"
["catalog"]=>
string(1) "1"
["orderable"]=>
string(1) "1"
["show_price"]=>
string(1) "1"
["status"]=>
string(16) "Direct leverbaar"
["status_label"]=>
string(0) ""
["button"]=>
string(0) ""
["status_url"]=>
string(0) ""
["type"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(5) "14.99"
}
IchendorfIchendorf Tumbler Green Butterfly

object(stdClass)#144 (46) {
["id"]=>
string(3) "808"
["children"]=>
string(1) "4"
["photoid"]=>
string(4) "1231"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(13) "8112211315000"
["price"]=>
string(5) "13.50"
["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) "Elho Brussels Kruiden all-in-1"
["keyname"]=>
string(30) "elho-brussels-kruiden-all-in-1"
["label"]=>
string(0) ""
["path"]=>
string(21) "/keuken/kruidenpotten"
["manufacturer_id"]=>
string(1) "1"
["manufacturer_name"]=>
string(4) "Elho"
["manufacturer_keyname"]=>
string(4) "elho"
["discount_type"]=>
NULL
["discount_value"]=>
NULL
["discount_color"]=>
NULL
["discount_label"]=>
NULL
["icons"]=>
NULL
["unit_single"]=>
string(4) "Stuk"
["unit_multi"]=>
string(5) "Stuks"
["unit_label"]=>
string(0) ""
["unit_suffix"]=>
string(0) ""
["unit_display"]=>
string(1) "1"
["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(16) "Direct leverbaar"
["status_label"]=>
string(0) ""
["button"]=>
string(0) ""
["status_url"]=>
string(0) ""
["type"]=>
NULL
["value"]=>
NULL
["price_lowest"]=>
string(5) "13.50"
}
ElhoElho Brussels Kruiden all-in-1€ 13,50