SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'products' AND categoryid = 0 AND manufacturerid = 0 LIMIT 1
Filter
Merk
Prijs
t/m
Alle Categorieën
26 - 34 van 34
Sorteer op:
object(stdClass)#171 (46) {
["id"]=>
string(2) "18"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "24"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "118_426"
["price"]=>
string(6) "229.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(36) "SCHNEIDER amarone wijdte C - 118_426"
["keyname"]=>
string(16) "amarone-wijdte-c"
["label"]=>
string(0) ""
["path"]=>
string(27) "/dames/instappers-trotteurs"
["manufacturer_id"]=>
string(4) "1330"
["manufacturer_name"]=>
string(10) "Schneider "
["manufacturer_keyname"]=>
string(9) "schneider"
["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) "229.95"
}
Schneider SCHNEIDER amarone wijdte C - 118_426€ 229,95
object(stdClass)#175 (46) {
["id"]=>
string(2) "54"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "76"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(9) "2733_NERO"
["price"]=>
string(5) "69.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) "DEVELAB First Step - 2733_NERO"
["keyname"]=>
string(10) "first-step"
["label"]=>
string(0) ""
["path"]=>
string(26) "/jongens/molieres-sneakers"
["manufacturer_id"]=>
string(2) "29"
["manufacturer_name"]=>
string(7) "DEVELAB"
["manufacturer_keyname"]=>
string(7) "develab"
["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(5) "69.95"
}
DEVELABDEVELAB First Step - 2733_NERO€ 69,95
object(stdClass)#171 (46) {
["id"]=>
string(2) "70"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "98"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "0031643"
["price"]=>
string(6) "119.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(26) "TWINS Wijdte 3.5 - 0031643"
["keyname"]=>
string(9) "wijdte-35"
["label"]=>
string(0) ""
["path"]=>
string(22) "/meisjes/laarzen-boots"
["manufacturer_id"]=>
string(2) "30"
["manufacturer_name"]=>
string(5) "TWINS"
["manufacturer_keyname"]=>
string(5) "twins"
["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) "119.95"
}
TWINSTWINS Wijdte 3.5 - 0031643vanaf € 119,95
object(stdClass)#175 (46) {
["id"]=>
string(2) "35"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "50"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "233_437"
["price"]=>
string(6) "229.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(28) "SCHNEIDER wijdte C - 233_437"
["keyname"]=>
string(8) "wijdte-c"
["label"]=>
string(0) ""
["path"]=>
string(31) "/dames/klittenband-bandschoenen"
["manufacturer_id"]=>
string(4) "1330"
["manufacturer_name"]=>
string(10) "Schneider "
["manufacturer_keyname"]=>
string(9) "schneider"
["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) "229.95"
}
Schneider SCHNEIDER wijdte C - 233_437€ 229,95
object(stdClass)#171 (46) {
["id"]=>
string(2) "41"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "59"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(4) "7000"
["price"]=>
string(6) "214.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(9) "KOPS 7000"
["keyname"]=>
string(4) "7000"
["label"]=>
string(0) ""
["path"]=>
string(17) "/heren/instappers"
["manufacturer_id"]=>
string(2) "38"
["manufacturer_name"]=>
string(4) "Kops"
["manufacturer_keyname"]=>
string(4) "kops"
["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) "214.95"
}
KopsKOPS 7000€ 214,95
object(stdClass)#175 (46) {
["id"]=>
string(2) "46"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "67"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(11) "7050 verona"
["price"]=>
string(6) "229.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(27) "KOPS wijdte G - 7050 verona"
["keyname"]=>
string(8) "wijdte-g"
["label"]=>
string(0) ""
["path"]=>
string(15) "/heren/molieres"
["manufacturer_id"]=>
string(2) "38"
["manufacturer_name"]=>
string(4) "Kops"
["manufacturer_keyname"]=>
string(4) "kops"
["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) "229.95"
}
KopsKOPS wijdte G - 7050 verona€ 229,95
object(stdClass)#171 (46) {
["id"]=>
string(1) "1"
["children"]=>
string(1) "0"
["photoid"]=>
string(1) "1"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(5) "20598"
["price"]=>
string(5) "89.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(28) "TIMBERLAND zz K band - 20598"
["keyname"]=>
string(9) "zz-k-band"
["label"]=>
string(0) ""
["path"]=>
string(22) "/heren/muilen-slippers"
["manufacturer_id"]=>
string(1) "1"
["manufacturer_name"]=>
string(10) "Timberland"
["manufacturer_keyname"]=>
string(10) "timberland"
["discount_type"]=>
string(8) "relative"
["discount_value"]=>
string(5) "30.00"
["discount_color"]=>
string(0) ""
["discount_label"]=>
string(6) "Outlet"
["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"]=>
string(8) "relative"
["value"]=>
string(5) "30.00"
["price_lowest"]=>
string(5) "59.95"
}
TimberlandTIMBERLAND zz K band - 20598€ 89,95€ 59,95
object(stdClass)#175 (46) {
["id"]=>
string(2) "25"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "33"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(16) "OLOWAHU 6840_LBG"
["price"]=>
string(5) "34.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(28) "TEVA FLIP - OLOWAHU 6840_LBG"
["keyname"]=>
string(4) "flip"
["label"]=>
string(0) ""
["path"]=>
string(22) "/dames/muilen-slippers"
["manufacturer_id"]=>
string(2) "36"
["manufacturer_name"]=>
string(4) "Teva"
["manufacturer_keyname"]=>
string(4) "teva"
["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(5) "34.95"
}
TevaTEVA FLIP - OLOWAHU 6840_LBG€ 34,95
object(stdClass)#171 (46) {
["id"]=>
string(2) "20"
["children"]=>
string(1) "0"
["photoid"]=>
string(2) "28"
["serial_number"]=>
string(0) ""
["article_number"]=>
string(7) "172_426"
["price"]=>
string(6) "229.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(28) "SCHNEIDER wijdte C - 172_426"
["keyname"]=>
string(8) "wijdte-c"
["label"]=>
string(0) ""
["path"]=>
string(27) "/dames/instappers-trotteurs"
["manufacturer_id"]=>
string(4) "1330"
["manufacturer_name"]=>
string(10) "Schneider "
["manufacturer_keyname"]=>
string(9) "schneider"
["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) "229.95"
}
Schneider SCHNEIDER wijdte C - 172_426€ 229,95