• Sign In
Toggle Nav
My Cart
Search
Advanced Search
  • Compare Products
Menu
Account

Home & Garden

InstockProductsFirst Debug

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`, MAX(stock.stock_status) AS `stock_status` 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'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id GROUP BY `e`.`entity_id` ORDER BY `stock`.`stock_status` DESC

ORDER BY Clauses:

stock.stock_status DESC

Stock Distribution (Total: 45 products):

Stock Status "0": 30 products

Stock Status "1": 15 products

Product Samples:

Pos ID SKU Name Stock
1 4 254107820015 Decorative Shelf Bracket Ornate Lattice 0 (OUT OF STOCK)
2 3 273654971490 Wall Shelf Bracket Horse Brace Crafting 0 (OUT OF STOCK)
3 9 254107820013 Ornate Lattice Shelf Bracket Brown Cast 0 (OUT OF STOCK)
4 11 254000410000 Wall Shelf Bracket Bird Brace Craft Cast 0 (OUT OF STOCK)
5 13 254407820000 Western Decorative Wall Shelf Bracket Br 0 (OUT OF STOCK)
6 20 283337722831 Fleur De Lis Wall Shelf Bracket Cast Iro 0 (OUT OF STOCK)
7 21 283344114097 Nautical Shelf Bracket Ship Anchor Custo 0 (OUT OF STOCK)
8 12 254207820000 Nautical Shelf Bracket Clamshell Beach S 1 (IN STOCK)
9 14 254107820000 Wall Shelf Bracket Decorative Cast Iron 1 (IN STOCK)
10 15 254107820020 Wall Shelf Bracket Brace With Plant Hang 1 (IN STOCK)
11 18 254107820017 Decorative Cast Iron Wall Shelf Bracket 1 (IN STOCK)
12 19 254107820008 Wall Shelf Bracket Large Fleur De Lis Ca 1 (IN STOCK)
13 23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis V 1 (IN STOCK)
14 25 254007820010 Wall Shelf Bracket Cast Iron Brace Fleur 1 (IN STOCK)
15 27 254107820028 Wall Shelf Bracket Distressed Brown Orna 1 (IN STOCK)
16 166 273007820002 Seed Feeder Bird Bath Cast Iron Wall Mou 0 (OUT OF STOCK)
17 167 273007820005 Hanging Heart Shaped Love Bird Feeder Or 0 (OUT OF STOCK)
18 174 254107820031 Wall Shelf Bracket Ornate Vine Distresse 0 (OUT OF STOCK)
19 178 254107820025 Decorative Wall Shelf Bracket Simple Vin 0 (OUT OF STOCK)
20 179 197100410004 Wall Shelf Bracket - Ornate Pattern - Bl 0 (OUT OF STOCK)
21 183 254107820019 Shelf Bracket Brace For Custom Shelving 0 (OUT OF STOCK)
22 186 019700410031 Cast Iron Wall Hook Verdigris Seahorse 5 0 (OUT OF STOCK)
23 188 019707820012 Decorative Coat Hook Victorian Ornate Do 0 (OUT OF STOCK)
24 190 019707820005 Wall Hook Coat Rack Victorian Skeleton K 0 (OUT OF STOCK)
25 191 019707820010 Decorative Triple Wall Hook Cast Iron Co 0 (OUT OF STOCK)
26 198 930907820006 Cast Iron Dinner Bell Love Birds Distres 0 (OUT OF STOCK)
27 200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign 0 (OUT OF STOCK)
28 201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbe 0 (OUT OF STOCK)
29 203 930907820005 Cast Iron Dinner Bell Butterfly Floral V 0 (OUT OF STOCK)
30 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast I 1 (IN STOCK)
31 6 254107820011 Decorative Shelf Bracket Flower Leaf Bra 1 (IN STOCK)
32 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iro 1 (IN STOCK)
33 8 254107820010 Decorative Cast Iron Wall Shelf Bracket 1 (IN STOCK)
34 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brac 1 (IN STOCK)
35 169 254007820000 Wall Shelf Bracket Decorative Cast Iron 0 (OUT OF STOCK)
36 22 254107820005 Wall Shelf Bracket Cast Iron Shelves Bra 1 (IN STOCK)
37 26 254107820027 Wall Shelf Bracket Distressed White Orna 1 (IN STOCK)
38 184 254107820026 Cast Iron Wall Shelf Bracket Brace Colum 0 (OUT OF STOCK)
39 170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cas 0 (OUT OF STOCK)
40 172 254107820029 Wall Shelf Bracket Brace Ornate Vine Bro 0 (OUT OF STOCK)
41 176 254107820004 Cast Iron Wall Shelf Bracket Brace Vine 0 (OUT OF STOCK)
42 193 019707820013 Double Wall Hook Decorative Antique Styl 0 (OUT OF STOCK)
43 192 019707820021 Cast Iron Wall Hook Rack Tropical Fish & 0 (OUT OF STOCK)
44 182 254107820018 Decorative Shelf Bracket - Hexagon Latti 0 (OUT OF STOCK)
45 181 254107820016 Decorative Shelf Bracket - Ornate Lattic 0 (OUT OF STOCK)
View as Grid List

Items 1-12 of 45

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Shape Triangle Remove This Item
  2. Heel Style Stiletto Remove This Item
Clear All
Shopping Options
Category
  1. Doorbells 4 items
  2. Bird Feeders 2 items
  3. Wall Hooks 6 items
Set Includes
  1. 1 Shelf Bracket 43 items
  2. Shelf Bracket 1 item
  3. Shelf Brackets 1 item
Outsole Material
  1. Rubber 35 items
  2. Suede 10 items
Accents
  1. Buckle 9 items
  2. Stripe 35 items
  3. Thick Laces 1 item
Calf Width
  1. Regular 45 items
Platform Height
  1. 1.25 in 45 items
Primary Color
  1. Brown 31 items
  2. Distressed White 6 items
  3. Multi-Color 1 item
  4. Rust 5 items
  5. Rust Brown 1 item
  6. White 1 item
Item Weight
  1. 1 lb 6 items
  2. 1.5 1 item
  3. 1.5 lb 2 items
  4. 1.5 lbs 4 items
  5. 2 lb 11 items
  6. 2 lbs 2 items
  7. 2.5 lb 14 items
  8. 3 lb 1 item
  9. 3 lbs 2 items
  10. 3lbs. 1 item
  11. 6 oz 1 item
Finish
  1. Distressed 5 items
  2. Distressed Brown 3 items
  3. Painted 37 items
Product Line
  1. BearPaw 10 items
  2. Troy 35 items
Room
  1. Any 44 items
  2. Kitchen 1 item
Personalized
  1. No 45 items
Mounting
  1. Hanging 13 items
  2. Wall Mount 1 item
  3. Wall Mounted 31 items
Indoor Outdoor
  1. Indoor & Outdoor 36 items
  2. Outdoor 9 items
Suitable For
  1. Birds 19 items
  2. Custom Shelves 1 item
  3. Home 3 items
  4. Shelf 3 items
  5. Shelves 17 items
  6. Shelves, Mail Box Mounts 1 item
  7. Wall Shelf, Mail Box Mount 1 item
Subject
  1. Beer 1 item
  2. Boxer Dog 11 items
  3. Close The Gate 1 item
  4. Cows 6 items
  5. United States 23 items
  6. Welcome 2 items
  7. You Need A Drink 1 item
Assembly Required
  1. No 41 items
  2. Yes 4 items
Hook Style
  1. Antique 7 items
  2. Monkey Tails 2 items
  3. Traditional 36 items
Shoe Shaft Style
  1. Ankle 9 items
  2. Low Top 36 items
Manufacturer
  1. Flag Emotes 17 items
  2. Holiday Home 2 items
  3. Import Wholesales 7 items
  4. Maddison 19 items
Color
  1. Black 1 item
  2. Brown 37 items
  3. Green 3 items
  4. Multi-Color 1 item
  5. Verdigris 1 item
  6. White 2 items
Us Shoe Size
  1. 13 35 items
  2. 4 1 item
  3. 6 9 items
Department
  1. Adults 30 items
  2. Women 15 items
Occasion
  1. Activewear, Casual 24 items
  2. Bereavement 12 items
  3. Christmas 9 items
Lining Material
  1. Textile 35 items
  2. Wool 10 items
Style
  1. Antique 1 item
  2. Antique Style 20 items
  3. French Country 5 items
  4. Nautical 3 items
  5. Rustic 1 item
  6. Traditional 3 items
  7. Victorian 8 items
  8. Victorian Style 2 items
  9. Vintage/Retro 1 item
  10. Western 1 item
Heel Height
  1. 2.75 in 35 items
  2. High (3-3.9 in) 10 items
Upper Material
  1. Faux Suede 1 item
  2. Synthetic 44 items
Price
  1. $0.00 - $9.99 6 items
  2. $10.00 - $19.99 35 items
  3. $20.00 and above 4 items
Toe Shape
  1. Round Toe 45 items
Closure
  1. Lace Up 35 items
  2. Pull On 1 item
  3. Slip On 9 items
Theme
  1. Birds 1 item
  2. Fleur De Lis 7 items
  3. Floral 4 items
  4. Horses 2 items
  5. Lattice 1 item
  6. Nautical 2 items
  7. Outdoor, Sports, University, Fashion 23 items
  8. Star 1 item
  9. Vintage 4 items
Shoe Width
  1. Medium 9 items
  2. Standard 36 items
Insole Material
  1. Foam 35 items
  2. Memory Foam 10 items
Fabric Type
  1. Knit 35 items
  2. Shearling 10 items
Season
  1. Fall, Spring, Summer, Winter 36 items
  2. Spring, Summer 9 items
Compare Products
  1. Remove This Item
Compare
Clear All
You have no items to compare.
My Wish List
Last Added Items
  1. Add to Cart
    Remove This Item
Go to Wish List
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.