Home & Garden

🔍 InstockProductsFirst Debug Info
        SQL Query:
        SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
    

        First 10 Products (Stock Status Check):
        
            
                ID
                SKU
                Name
                Stock Status
            

                16
                254007820004
                Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca
                
                                        IN STOCK (1)
                
            

    
Category: Home & Garden (ID: 6)
Collection Size: 1 products
Current Page: 1

ID	SKU	Name	Stock Status
16	254007820004	Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca	IN STOCK (1)

Wall Shelf Bracket Brace Fleur De Lis Verdigris Cast Iron Home Decor 8.625"
$8.00

Add to Wish List Add to Compare

Now Shopping by

Item Weight 1.5 lb Remove This Item
Fabric Type Shearling Remove This Item

Clear All

Shopping Options

Compare Products

Remove This Item

You have no items to compare.

My Wish List

Last Added Items

You have no items in your wish list.