$storeId = Mage::app()->getStore()->getStoreId();

Mage::getResourceModel(‘catalog/product’)->getAttributeRawValue($_product->getId(), ‘my_attribute_code’, $storeId );