Attribute value from product id magento

<?php echo Mage::getResourceModel('catalog/product')->getAttributeRawValue($productId, 'attribute_code', $storeId); ?>

 

Share