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

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`, `stock_status`.`stock_status` AS `is_salable` 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_status` ON e.entity_id = stock_status.product_id AND stock_status.website_id = 0 ORDER BY `stock_status`.`stock_status` DESC

First 20 Products (Stock Status Check):

IN STOCK: 30 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
2 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
3 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
4 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK (1)
5 12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK (1)
6 28 254107820022 Wall Shelf Bracket Brown Cast Iron Brace Custom Sh IN STOCK (1)
7 29 254107820012 Decorative Shelf Bracket Ornate Leaf Brace Rust Br IN STOCK (1)
8 30 197100410009 Wall Shelf Bracket Brace Black Cast Iron Scrolling IN STOCK (1)
9 31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
10 32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ IN STOCK (1)
11 33 254007820008 Hummingbird Wall Shelf Bracket Cast Iron Brace Cra IN STOCK (1)
12 166 273007820002 Seed Feeder Bird Bath Cast Iron Wall Mounted 9.75" IN STOCK (1)
13 167 273007820005 Hanging Heart Shaped Love Bird Feeder Or Bath 5.5" IN STOCK (1)
14 169 254007820000 Wall Shelf Bracket Decorative Cast Iron Brace Humm IN STOCK (1)
15 170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cast Iron Bra IN STOCK (1)
16 172 254107820029 Wall Shelf Bracket Brace Ornate Vine Brown Cast Ir IN STOCK (1)
17 174 254107820031 Wall Shelf Bracket Ornate Vine Distressed White Ca IN STOCK (1)
18 176 254107820004 Cast Iron Wall Shelf Bracket Brace Vine & Flower R IN STOCK (1)
19 178 254107820025 Decorative Wall Shelf Bracket Simple Vine Rust Bro IN STOCK (1)
20 179 197100410004 Wall Shelf Bracket - Ornate Pattern - Black Cast I IN STOCK (1)

Quick Fix - Add this to your theme's catalog_category_view.xml:

<referenceBlock name="category.products.list">
    <action method="setData">
        <argument name="sort_by" xsi:type="string">stock_status</argument>
    </action>
</referenceBlock>
View as Grid List

Items 1-12 of 95

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Finish Painted Remove This Item
  2. Closure Lace Up Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 9 items
  2. Garden Flags 43 items
  3. Doorbells 5 items
  4. Bird Feeders 2 items
  5. Wall Hooks 13 items
  6. Stepping Stones 1 item
Set Includes
  1. 1 Shelf Bracket 87 items
  2. Kickplate / toe kick 1 item
  3. Wall Mounted Hose Hanger 7 items
Outsole Material
  1. Leather & Rubber 6 items
  2. Rubber 88 items
  3. Suede 1 item
Accents
  1. Flower 1 item
  2. Logo 6 items
  3. Stripe 88 items
Calf Width
  1. Regular 95 items
Platform Height
  1. 1.25 in 95 items
Primary Color
  1. Black 2 items
  2. Blue 6 items
  3. Bronze 1 item
  4. Brown 33 items
  5. Distressed White 5 items
  6. Green 1 item
  7. Multi-Color 1 item
  8. Multicolor 8 items
  9. Rust 5 items
  10. Rust Brown 1 item
  11. Teal 32 items
Shape
  1. C Hook 2 items
  2. Foot Print 1 item
  3. J Hook 7 items
  4. S Hook 7 items
  5. Tractor 45 items
  6. Triangle 33 items
Item Weight
  1. 1 lb 6 items
  2. 1 lbs 1 item
  3. 1.5 1 item
  4. 1.5 lb 2 items
  5. 1.5 lbs 2 items
  6. 10 oz 1 item
  7. 2 lb 10 items
  8. 2 lbs 1 item
  9. 2.5 lb 19 items
  10. 2.5 lbs 1 item
  11. 3 lb 2 items
  12. 3 Oz 11 items
  13. 4 Oz 13 items
  14. 5 oz 20 items
  15. 5.875000 1 item
  16. 6 oz 2 items
  17. 9 Oz 9 Oz 1 item
  18. 9 oz 1 item
Product Line
  1. BearPaw 1 item
  2. Junie 6 items
  3. Troy 88 items
Room
  1. Any 86 items
  2. Any Room 5 items
  3. Bathroom 4 items
Personalized
  1. No 90 items
  2. Yes 5 items
Mounting
  1. Hanging 13 items
  2. Wall 1 item
  3. Wall Mount 1 item
  4. Wall Mounted 80 items
Indoor Outdoor
  1. Indoor & Outdoor 84 items
  2. Outdoor 11 items
Suitable For
  1. Birds 19 items
  2. Coat 4 items
  3. Coats, Towels, Hats 3 items
  4. Custom Shelves 5 items
  5. Hanging Planters 1 item
  6. Home 47 items
  7. Keys 1 item
  8. Plants 5 items
  9. Plants, Bird Feeders, Windchimes 1 item
  10. Shelves 7 items
  11. Wind Chimes 2 items
Subject
  1. Beach 1 item
  2. Bee 1 item
  3. Bereavement 3 items
  4. Bible Verse 2 items
  5. Black Lab 1 item
  6. Boxer Dog 22 items
  7. Butterfly 1 item
  8. Camping 1 item
  9. Cat 1 item
  10. Cats 1 item
  11. Christmas 3 items
  12. Close The Gate 7 items
  13. Dog 6 items
  14. Easter 1 item
  15. Fishing 1 item
  16. Fleur De Lis 2 items
  17. Home 1 item
  18. Inspiration 1 item
  19. Lake 5 items
  20. Lighthouses 1 item
  21. Sunflower 1 item
  22. United States 24 items
  23. Welcome 4 items
  24. Wine 2 items
  25. Yorkie 2 items
Assembly Required
  1. No 95 items
Hook Style
  1. Antique 59 items
  2. Horseshoe 1 item
  3. Nautical 1 item
  4. Tail 1 item
  5. Traditional 32 items
  6. Western 1 item
Shoe Shaft Style
  1. Low Top 95 items
Manufacturer
  1. Flag Emotes 65 items
  2. Import Wholesales 5 items
  3. Maddison 19 items
  4. Unos 6 items
Color
  1. Black 2 items
  2. Black, White, Red 1 item
  3. Blue 7 items
  4. Bronze 1 item
  5. Brown 42 items
  6. Green 4 items
  7. Green, Yellow 10 items
  8. Multi-Color 1 item
  9. Multicolor 14 items
  10. Teal 13 items
Us Shoe Size
  1. 13 93 items
  2. 6 1 item
  3. 9.5 1 item
Department
  1. Adult 3 items
  2. Adults 75 items
  3. Kids 1 item
  4. Women 16 items
Occasion
  1. Activewear, Casual 35 items
  2. Any 8 items
  3. Bereavement 24 items
  4. Casual, Workwear 1 item
  5. Christmas 2 items
  6. Easter 5 items
  7. Everyday 1 item
  8. Halloween 14 items
  9. Inspirational 1 item
  10. Summer 4 items
Lining Material
  1. Polyester 6 items
  2. Textile 88 items
  3. Wool 1 item
Style
  1. Antique 1 item
  2. Antique Style 19 items
  3. Butterflies 4 items
  4. Country 1 item
  5. Flat 1 item
  6. French 2 items
  7. French Country 1 item
  8. Nautical 7 items
  9. Rustic 1 item
  10. Traditional 51 items
  11. Victorian 3 items
  12. Victorian Style 1 item
  13. Vintage/Retro 1 item
  14. Western 2 items
Heel Height
  1. 2.75 in 88 items
  2. High (3-3.9 in) 1 item
  3. Mid (2-2.9 in) 6 items
Upper Material
  1. Beads 7 items
  2. Synthetic 88 items
Price
  1. $0.00 - $9.99 16 items
  2. $10.00 - $19.99 72 items
  3. $20.00 and above 7 items
Toe Shape
  1. Round Toe 89 items
  2. Square Toe 6 items
Heel Style
  1. Kitten 6 items
  2. Stiletto 89 items
Theme
  1. Animal & Birds 1 item
  2. Beach 2 items
  3. Bereavement 2 items
  4. Birds 2 items
  5. Black Lab 2 items
  6. Boxer Dog 10 items
  7. Camping 1 item
  8. Cats 2 items
  9. Chihuahua 2 items
  10. Christmas 1 item
  11. Classic 1 item
  12. College 1 item
  13. Dogs 1 item
  14. Easter 1 item
  15. Emergency Services 1 item
  16. Farmhouse 2 items
  17. Fire & Rescue 1 item
  18. Fishing 1 item
  19. Fleur De Lis 2 items
  20. Floral 4 items
  21. Flowers 1 item
  22. Golden Retriever 1 item
  23. Halloween 1 item
  24. Holiday 4 items
  25. Home 1 item
  26. Horses Horses 2 items
  27. Hummingbirds 1 item
  28. Inspirational 1 item
  29. Lighthouses 1 item
  30. Mermaids 1 item
  31. Nautical 1 item
  32. Outdoor, Sports, University, Fashion 24 items
  33. Scripture 1 item
  34. Seahorse 1 item
  35. Skeleton Key 1 item
  36. Vines 1 item
  37. Welcome 10 items
  38. Wine 1 item
  39. Yorkshire Terrier 1 item
Shoe Width
  1. Standard 94 items
  2. W 1 item
Insole Material
  1. Foam 88 items
  2. Memory Foam 7 items
Fabric Type
  1. Knit 94 items
  2. Shearling 1 item
Season
  1. Fall, Spring, Summer 6 items
  2. Fall, Spring, Summer, Winter 88 items
  3. Spring, Summer 1 item
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.