+7-981-149-16-30 Санкт-Петербург
Ваша корзина пуста

Каталог

Apple

Apple

select s.productID, s.name, s.Price, s.enabled, t.filename FROM cnjh_products AS s LEFT JOIN cnjh_product_pictures AS t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE (s.categoryID='' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) ORDER BY s.date_added DESC LIMIT 3
 
iphone 6s plus 64gb Silver
iphone 6s plus 64gb Silver
 
48 699р.
Детали
 
 
iphone 6s plus 64gb Rose Gold
iphone 6s plus 64gb Rose Gold
 
48 699р.
Детали
 
 
iphone 6s plus 32gb Silver
iphone 6s plus 32gb Silver
 
47 399р.
Детали