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

Nieuwe producten

1 - 10 van 10
Sorteer op:
BERGSTEIN K130001_330110330 - Rainboot_RED regenla
object(stdClass)#190 (46) { ["id"]=> string(4) "2428" ["children"]=> string(1) "0" ["photoid"]=> string(4) "3535" ["serial_number"]=> string(0) "" ["article_number"]=> string(20) "Rainboot_RED regenla" ["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(50) "BERGSTEIN K130001_330110330 - Rainboot_RED regenla" ["keyname"]=> string(17) "k130001_330110330" ["label"]=> string(0) "" ["path"]=> string(22) "/kinderen/regenlaarzen" ["manufacturer_id"]=> string(4) "1356" ["manufacturer_name"]=> string(9) "BERGSTEIN" ["manufacturer_keyname"]=> string(9) "bergstein" ["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" }
BERGSTEINBERGSTEIN K130001_330110330 - Rainboot_RED regenla
€ 34,95
BERGSTEIN K130001_330110330 - Rainboot_RED regenlaars
object(stdClass)#185 (46) { ["id"]=> string(4) "1339" ["children"]=> string(1) "0" ["photoid"]=> string(4) "2059" ["serial_number"]=> string(0) "" ["article_number"]=> string(23) "Rainboot_RED regenlaars" ["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(53) "BERGSTEIN K130001_330110330 - Rainboot_RED regenlaars" ["keyname"]=> string(17) "k130001_330110330" ["label"]=> string(0) "" ["path"]=> string(22) "/kinderen/regenlaarzen" ["manufacturer_id"]=> string(4) "1356" ["manufacturer_name"]=> string(9) "BERGSTEIN" ["manufacturer_keyname"]=> string(9) "bergstein" ["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" }
BERGSTEINBERGSTEIN K130001_330110330 - Rainboot_RED regenlaars
€ 34,95
BERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars
object(stdClass)#190 (46) { ["id"]=> string(4) "1354" ["children"]=> string(1) "0" ["photoid"]=> string(4) "2071" ["serial_number"]=> string(0) "" ["article_number"]=> string(29) "Rainboot_DARKBLUE_ regenlaars" ["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(59) "BERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars" ["keyname"]=> string(17) "k130001_966110966" ["label"]=> string(0) "" ["path"]=> string(22) "/kinderen/regenlaarzen" ["manufacturer_id"]=> string(4) "1356" ["manufacturer_name"]=> string(9) "BERGSTEIN" ["manufacturer_keyname"]=> string(9) "bergstein" ["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" }
BERGSTEINBERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars
€ 34,95
BERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars
object(stdClass)#185 (46) { ["id"]=> string(4) "1359" ["children"]=> string(1) "0" ["photoid"]=> string(4) "2075" ["serial_number"]=> string(0) "" ["article_number"]=> string(29) "Rainboot_DARKBLUE_ regenlaars" ["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(59) "BERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars" ["keyname"]=> string(17) "k130001_966110966" ["label"]=> string(0) "" ["path"]=> string(22) "/kinderen/regenlaarzen" ["manufacturer_id"]=> string(4) "1356" ["manufacturer_name"]=> string(9) "BERGSTEIN" ["manufacturer_keyname"]=> string(9) "bergstein" ["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" }
BERGSTEINBERGSTEIN K130001_966110966 - Rainboot_DARKBLUE_ regenlaars
€ 34,95
BERGSTEIN X431001_830110830 - Winterboot_Yellow
object(stdClass)#190 (46) { ["id"]=> string(4) "1363" ["children"]=> string(1) "0" ["photoid"]=> string(4) "2079" ["serial_number"]=> string(0) "" ["article_number"]=> string(17) "Winterboot_Yellow" ["price"]=> string(5) "39.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(47) "BERGSTEIN X431001_830110830 - Winterboot_Yellow" ["keyname"]=> string(17) "x431001_830110830" ["label"]=> string(0) "" ["path"]=> string(22) "/kinderen/regenlaarzen" ["manufacturer_id"]=> string(4) "1356" ["manufacturer_name"]=> string(9) "BERGSTEIN" ["manufacturer_keyname"]=> string(9) "bergstein" ["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) "39.95" }
BERGSTEINBERGSTEIN X431001_830110830 - Winterboot_Yellow
€ 39,95
ROHDE 371645_622
object(stdClass)#185 (46) { ["id"]=> string(3) "637" ["children"]=> string(1) "0" ["photoid"]=> string(3) "989" ["serial_number"]=> string(0) "" ["article_number"]=> string(10) "371645_622" ["price"]=> string(5) "24.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(16) "ROHDE 371645_622" ["keyname"]=> string(10) "371645_622" ["label"]=> string(0) "" ["path"]=> string(25) "/kinderen/kinderpantoffel" ["manufacturer_id"]=> string(4) "1970" ["manufacturer_name"]=> string(5) "ROHDE" ["manufacturer_keyname"]=> string(5) "rohde" ["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) "24.95" }
ROHDEROHDE 371645_622
€ 24,95
ROHDE 2074_55
object(stdClass)#190 (46) { ["id"]=> string(2) "73" ["children"]=> string(1) "0" ["photoid"]=> string(3) "108" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "2074_55" ["price"]=> string(5) "26.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(13) "ROHDE 2074_55" ["keyname"]=> string(7) "2074_55" ["label"]=> string(0) "" ["path"]=> string(25) "/kinderen/kinderpantoffel" ["manufacturer_id"]=> string(4) "1970" ["manufacturer_name"]=> string(5) "ROHDE" ["manufacturer_keyname"]=> string(5) "rohde" ["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) "26.50" }
ROHDEROHDE 2074_55
€ 26,50
ROHDE 2073-72
object(stdClass)#185 (46) { ["id"]=> string(2) "85" ["children"]=> string(1) "0" ["photoid"]=> string(3) "120" ["serial_number"]=> string(0) "" ["article_number"]=> string(7) "2073-72" ["price"]=> string(5) "27.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(13) "ROHDE 2073-72" ["keyname"]=> string(7) "2073-72" ["label"]=> string(0) "" ["path"]=> string(25) "/kinderen/kinderpantoffel" ["manufacturer_id"]=> string(4) "1970" ["manufacturer_name"]=> string(5) "ROHDE" ["manufacturer_keyname"]=> string(5) "rohde" ["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) "27.50" }
ROHDEROHDE 2073-72
€ 27,50
PIEDRO canvas - 75003N-04500
object(stdClass)#190 (46) { ["id"]=> string(3) "120" ["children"]=> string(1) "0" ["photoid"]=> string(3) "178" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "75003N-04500" ["price"]=> string(5) "94.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) "PIEDRO canvas - 75003N-04500" ["keyname"]=> string(6) "canvas" ["label"]=> string(0) "" ["path"]=> string(14) "/kinderen/gymp" ["manufacturer_id"]=> string(2) "45" ["manufacturer_name"]=> string(6) "PIEDRO" ["manufacturer_keyname"]=> string(6) "piedro" ["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) "94.95" }
PIEDROPIEDRO canvas - 75003N-04500
€ 94,95
PIEDRO wijdte 3 - 76041 N - 5900
object(stdClass)#185 (46) { ["id"]=> string(3) "118" ["children"]=> string(1) "0" ["photoid"]=> string(3) "174" ["serial_number"]=> string(0) "" ["article_number"]=> string(14) "76041 N - 5900" ["price"]=> string(6) "117.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(32) "PIEDRO wijdte 3 - 76041 N - 5900" ["keyname"]=> string(8) "wijdte-3" ["label"]=> string(0) "" ["path"]=> string(29) "/kinderen/halfhoog-veterboots" ["manufacturer_id"]=> string(2) "45" ["manufacturer_name"]=> string(6) "PIEDRO" ["manufacturer_keyname"]=> string(6) "piedro" ["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) "117.50" }
PIEDROPIEDRO wijdte 3 - 76041 N - 5900
€ 117,50