Cacher is the code snippet organizer for pro developers

<?php	
$attributeOptionId = 5; 
$attributeCode = 'brand_label';
 
$products = Mage::getModel('catalog/product')
                    ->getCollection()
                    ->addAttributeToSelect('*')
                    ->addAttributeToFilter($attributeCode, $attributeOptionId);
 
// show only enabled products
Mage::getSingleton('catalog/product_status')
            ->addVisibleFilterToCollection($products);
 
// show only visible products            
Mage::getSingleton('catalog/product_visibility')
            ->addVisibleInCatalogFilterToCollection($products);
            
/* 
foreach ($products->getItems() as $product) {
    echo 'Product Name: ' . $product->getName() . '<br>' ;
    echo 'Product Price: ' . $product->getPrice()  .  '<br>';
    echo 'Product SKU: ' . $product->getSku() . '<br>' ;
    echo 'Product URL: ' . $product->getUrlPath() . '<br>' ;
    echo 'Product Img URL: ' . $product->getImageUrl() . '<br>' ; 
    echo '==========================================<br>'; 
}
*/            
            
?>

<div class="row">
	<?php if ( count( (array)$products->getItems() ) ) : ?>
		<?php foreach ($products->getItems() as $product) : ?>

		<div class="col-md-4">
			
			<a href="<?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK) . $product->getUrlPath() ; ?>"><img src="<?php echo $product->getImageUrl() ; ?>"></a>
			<div>
				<a href="<?php echo $product->getProductUrl() ; ?>"><?php echo  $product->getName();  ?></a>
			</div>
			
		</div>
		<?php endforeach; ?>

	<?php else: ?>
		<p class="note-msg">There are no products matching the selection.</p>	
	<?php endif; ?>

</div>