SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'home' AND categoryid = 0 AND manufacturerid = 0 LIMIT 1

Welkom bij Pijnenburg Schoenen

Pijnenburg Schoenen is het vertrouwde adres voor dames-, heren en kinderschoenen en gespecialiseerd in wijdtematen. Voor kwaliteit, zorgvuldigheid en service bent u bij Pijnenburg Schoenen aan het juiste adres.

Cycleur de Luxe
CYCLEUR DE LUXE Tsunami - CDLW 241206 Tsunami_Pink Dragonfir
object(stdClass)#171 (46) { ["id"]=> string(4) "5214" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6232" ["serial_number"]=> string(0) "" ["article_number"]=> string(34) "CDLW 241206 Tsunami_Pink Dragonfir" ["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(60) "CYCLEUR DE LUXE Tsunami - CDLW 241206 Tsunami_Pink Dragonfir" ["keyname"]=> string(7) "tsunami" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(1) "2" ["manufacturer_name"]=> string(15) "CYCLEUR DE LUXE" ["manufacturer_keyname"]=> string(15) "cycleur-de-luxe" ["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" }
CYCLEUR DE LUXECYCLEUR DE LUXE Tsunami - CDLW 241206 Tsunami_Pink Dragonfir
€ 149,95
CYCLEUR DE LUXE Azalea - CDLW 241935 Azalea_Endless Sky
object(stdClass)#176 (46) { ["id"]=> string(4) "5227" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6244" ["serial_number"]=> string(0) "" ["article_number"]=> string(30) "CDLW 241935 Azalea_Endless Sky" ["price"]=> string(5) "99.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(55) "CYCLEUR DE LUXE Azalea - CDLW 241935 Azalea_Endless Sky" ["keyname"]=> string(6) "azalea" ["label"]=> string(0) "" ["path"]=> string(22) "/dames/muilen-slippers" ["manufacturer_id"]=> string(1) "2" ["manufacturer_name"]=> string(15) "CYCLEUR DE LUXE" ["manufacturer_keyname"]=> string(15) "cycleur-de-luxe" ["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) "99.95" }
CYCLEUR DE LUXECYCLEUR DE LUXE Azalea - CDLW 241935 Azalea_Endless Sky
€ 99,95
CYCLEUR DE LUXE Azalea - CDLW 241931 Azalea_Ibis Rose
object(stdClass)#178 (46) { ["id"]=> string(4) "5217" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6236" ["serial_number"]=> string(0) "" ["article_number"]=> string(28) "CDLW 241931 Azalea_Ibis Rose" ["price"]=> string(5) "99.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) "CYCLEUR DE LUXE Azalea - CDLW 241931 Azalea_Ibis Rose" ["keyname"]=> string(6) "azalea" ["label"]=> string(0) "" ["path"]=> string(22) "/dames/muilen-slippers" ["manufacturer_id"]=> string(1) "2" ["manufacturer_name"]=> string(15) "CYCLEUR DE LUXE" ["manufacturer_keyname"]=> string(15) "cycleur-de-luxe" ["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) "99.95" }
CYCLEUR DE LUXECYCLEUR DE LUXE Azalea - CDLW 241931 Azalea_Ibis Rose
€ 99,95
CYCLEUR DE LUXE Tsunami - CDLW 241208 Tsunami_Acient Water
object(stdClass)#180 (46) { ["id"]=> string(4) "5192" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6216" ["serial_number"]=> string(0) "" ["article_number"]=> string(32) "CDLW 241208 Tsunami_Acient Water" ["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(58) "CYCLEUR DE LUXE Tsunami - CDLW 241208 Tsunami_Acient Water" ["keyname"]=> string(7) "tsunami" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(1) "2" ["manufacturer_name"]=> string(15) "CYCLEUR DE LUXE" ["manufacturer_keyname"]=> string(15) "cycleur-de-luxe" ["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" }
CYCLEUR DE LUXECYCLEUR DE LUXE Tsunami - CDLW 241208 Tsunami_Acient Water
€ 149,95
CYCLEUR DE LUXE CIPRESSA - CDLW 241160_CIPRESSA_
object(stdClass)#182 (46) { ["id"]=> string(4) "5081" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6136" ["serial_number"]=> string(0) "" ["article_number"]=> string(21) "CDLW 241160_CIPRESSA_" ["price"]=> string(6) "139.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(48) "CYCLEUR DE LUXE CIPRESSA - CDLW 241160_CIPRESSA_" ["keyname"]=> string(8) "cipressa" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(1) "2" ["manufacturer_name"]=> string(15) "CYCLEUR DE LUXE" ["manufacturer_keyname"]=> string(15) "cycleur-de-luxe" ["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) "139.95" }
CYCLEUR DE LUXECYCLEUR DE LUXE CIPRESSA - CDLW 241160_CIPRESSA_
€ 139,95
AQA
AQA SHOES Velvet Optic white - A8295_A11B76
object(stdClass)#175 (46) { ["id"]=> string(4) "3599" ["children"]=> string(1) "0" ["photoid"]=> string(4) "4852" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8295_A11B76" ["price"]=> string(6) "159.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(43) "AQA SHOES Velvet Optic white - A8295_A11B76" ["keyname"]=> string(18) "velvet-optic-white" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "159.95" }
AQA SHOESAQA SHOES Velvet Optic white - A8295_A11B76
€ 159,95
AQA SHOES Valencia - A8536_A11B56
object(stdClass)#187 (46) { ["id"]=> string(4) "5128" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6172" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8536_A11B56" ["price"]=> string(6) "139.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) "AQA SHOES Valencia - A8536_A11B56" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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) "139.95" }
AQA SHOESAQA SHOES Valencia - A8536_A11B56
€ 139,95
AQA SHOES Velours Sughero - A8550_A53_Western
object(stdClass)#189 (46) { ["id"]=> string(4) "5086" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6140" ["serial_number"]=> string(0) "" ["article_number"]=> string(17) "A8550_A53_Western" ["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(45) "AQA SHOES Velours Sughero - A8550_A53_Western" ["keyname"]=> string(15) "velours-sughero" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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" }
AQA SHOESAQA SHOES Velours Sughero - A8550_A53_Western
€ 149,95
AQA SHOES Valencia - A8537_A75B80
object(stdClass)#191 (46) { ["id"]=> string(4) "5134" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6176" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8537_A75B80" ["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) "AQA SHOES Valencia - A8537_A75B80" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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" }
AQA SHOESAQA SHOES Valencia - A8537_A75B80
€ 149,95
AQA SHOES Valencia - A8537_A76B79
object(stdClass)#193 (46) { ["id"]=> string(4) "5140" ["children"]=> string(1) "0" ["photoid"]=> string(4) "6180" ["serial_number"]=> string(0) "" ["article_number"]=> string(12) "A8537_A76B79" ["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) "AQA SHOES Valencia - A8537_A76B79" ["keyname"]=> string(8) "valencia" ["label"]=> string(0) "" ["path"]=> string(15) "/dames/molieres" ["manufacturer_id"]=> string(4) "1978" ["manufacturer_name"]=> string(9) "AQA SHOES" ["manufacturer_keyname"]=> string(9) "aqa-shoes" ["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" }
AQA SHOESAQA SHOES Valencia - A8537_A76B79
€ 149,95