Soup Stock Tokyo

Notice (8): Undefined variable: eat_home_flg [APP/View/Store/list.ctp, line 161]
Notice (8): Undefined variable: ohs_flg [APP/View/Store/list.ctp, line 161]
Notice (8): Undefined variable: eat_home_flg [APP/View/Store/list.ctp, line 171]
Notice (8): Undefined variable: ohs_flg [APP/View/Store/list.ctp, line 183]

お店をさがす

Notice (8): Undefined variable: eat_home_flg [APP/View/Store/list.ctp, line 211]
Notice (8): Undefined variable: ohs_flg [APP/View/Store/list.ctp, line 226]
Notice (8): Undefined variable: eat_home_flg [APP/View/Store/list.ctp, line 232]
Notice (8): Undefined variable: ohs_flg [APP/View/Store/list.ctp, line 232]

Soup Stock Tokyo

宮城県

店舗名 営業時間 住所

S-PALII店(仙台)

平日 07:00-21:00 土 09:00-21:00 日・祝 09:00-21:00

〒980-8477

宮城県仙台市青葉区中央1-1-1 S-PALII 2F

完熟トマトの雫とモッツァレラのOKAYU(おかゆ)

おだし東京 Soup Stock Tokyo

採用情報

Eメールニュースのご登録

ポイントカードについて

(default) 1 query took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MStore`.*, `MProduct`.* FROM `sst_003_db`.`m_store` AS `MStore` LEFT JOIN `sst_003_db`.`p_store_product` AS `PStoreProduct` ON (`PStoreProduct`.`store_cd` = `MStore`.`store_cd` AND `PStoreProduct`.`delete_flg` = '0') LEFT JOIN `sst_003_db`.`m_product` AS `MProduct` ON (`MProduct`.`product_cd` = `PStoreProduct`.`product_cd` AND `MProduct`.`delete_flg` = '0') WHERE `MStore`.`delete_flg` = '0' AND `MStore`.`city` = '宮城県' ORDER BY `MStore`.`sort` asc, `MStore`.`city` asc220