• 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

ALL Products in Category (No Pagination):

IN STOCK: 86 | OUT OF STOCK: 0 | First In-Stock at position: 1 | Total Products: 86
Position ID SKU Name Stock Status
1 14 254107820000 Wall Shelf Bracket Decorative Cast Iron Brace Orna IN STOCK
2 15 254107820020 Wall Shelf Bracket Brace With Plant Hanger Flower IN STOCK
3 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK
4 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK
5 18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK
6 19 254107820008 Wall Shelf Bracket Large Fleur De Lis Cast Iron Br IN STOCK
7 23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis Verdigris C IN STOCK
8 27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 IN STOCK
9 28 254107820022 Wall Shelf Bracket Brown Cast Iron Brace Custom Sh IN STOCK
10 29 254107820012 Decorative Shelf Bracket Ornate Leaf Brace Rust Br IN STOCK
11 33 254007820008 Hummingbird Wall Shelf Bracket Cast Iron Brace Cra IN STOCK
12 770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK
13 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK
14 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK
15 792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK
16 793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK
17 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK
18 846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK
19 849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK
20 879 286280138492 Women's Sterling Chelsea Boots Zip Up Ankle Bootie IN STOCK
... products 21 to 66 hidden ...
67 1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK
68 1823 829800250004 Longaberger Traditions Handle Tie Collectible Acce IN STOCK
69 1868 198507820002 Flamingo Welcome Plaque Brown Cast Iron Beach Them IN STOCK
70 1872 272207820000 Large Rolling Plant Caddy Fleur De Lis IN STOCK
71 1873 273607820000 Decorative Cast Iron Rooster Trivet Kitchen Decor IN STOCK
72 1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK
73 1875 284109859464 Disney’s Baby Mickey Mouse Wall Border ABC Nurse IN STOCK
74 2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK
75 2053 286367593981 New England Patriots Rawlings Cooler Tote Holds 30 IN STOCK
76 2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK
77 2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK
78 2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK
79 2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK
80 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK
81 2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK
82 2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK
83 2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK
84 2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK
85 2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK
86 2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK

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 86

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Brown Remove This Item
  2. Insole Material Memory Foam Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 2 items
  2. Doorbells 2 items
  3. Wall Hooks 1 item
  4. Stepping Stones 6 items
  5. Trivets 2 items
  6. Signs 10 items
Set Includes
  1. 1 Shelf Bracket 9 items
  2. Kickplate / toe kick 66 items
  3. Shelf Brackets 2 items
  4. Wall Mounted Hose Hanger 8 items
Outsole Material
  1. EVA 11 items
  2. Leather & Rubber 3 items
  3. Suede 72 items
Accents
  1. Buckle 42 items
  2. Elastic 1 item
  3. Floral Pattern 2 items
  4. Flower 6 items
  5. Heel Strep 8 items
  6. Logo 10 items
  7. Thick Laces 17 items
  8. Zipper 1 item
Calf Width
  1. Regular 85 items
Platform Height
  1. 1.25 in 85 items
Shape
  1. Butterfly 1 item
  2. Foot Print 69 items
  3. J Hook 3 items
  4. Triangle 11 items
  5. Turtle 1 item
Item Weight
  1. 1 lb 1 item
  2. 1.5 lb 2 items
  3. 1.5 lbs 3 items
  4. 2 lb 5 items
  5. 2 lbs 1 item
  6. 3 lbs 2 items
  7. 4.5 lb 2 items
  8. 5.875000 69 items
Finish
  1. Distressed Brown 2 items
  2. Glossy 4 items
  3. Matt 17 items
  4. Painted 62 items
Product Line
  1. BearPaw 72 items
  2. Junie 14 items
Room
  1. Any 11 items
  2. Any Room 74 items
Personalized
  1. No 85 items
Mounting
  1. Wall 1 item
  2. Wall Mounted 84 items
Indoor Outdoor
  1. Indoor & Outdoor 80 items
  2. Outdoor 5 items
Suitable For
  1. Coats, Towels, Hats 74 items
  2. Custom Shelves 1 item
  3. Shelves 9 items
  4. Wall Shelf, Mail Box Mount 1 item
Subject
  1. American Flag 4 items
  2. Barbies 5 items
  3. Beer 1 item
  4. Boxer Dog 3 items
  5. Butterfly 1 item
  6. Close The Gate 8 items
  7. Coffee 4 items
  8. Cows 4 items
  9. Dachshund 2 items
  10. Darts 1 item
  11. Dog 3 items
  12. Dora The Explorer 4 items
  13. Fire & Rescue 10 items
  14. Foot Print 3 items
  15. Frog 2 items
  16. Snail 6 items
  17. Turtle 1 item
  18. Unicorns 1 item
  19. Video Games 1 item
  20. Welcome 17 items
  21. Wine 3 items
  22. You Need A Drink 1 item
Assembly Required
  1. No 80 items
  2. Yes 5 items
Hook Style
  1. Traditional 85 items
Shoe Shaft Style
  1. Ankle 43 items
  2. Low Top 43 items
Manufacturer
  1. Amazon 1 item
  2. Brewster 2 items
  3. Cracker Jack 8 items
  4. CyberPower 1 item
  5. Dearfoams 1 item
  6. Disney 1 item
  7. Flag Emotes 31 items
  8. Floortex 1 item
  9. Holiday Home 2 items
  10. Import Wholesales 19 items
  11. Intex 1 item
  12. Issa 2 items
  13. Longaberger 1 item
  14. Persephone 1 item
  15. Rawlings 1 item
  16. Rubie's 1 item
  17. Sahara 1 item
  18. Sanus 1 item
  19. Simpli Home 1 item
  20. Sony Legacy 1 item
  21. Unknown 1 item
  22. Unos 3 items
  23. Victrola 1 item
  24. Withit 2 items
  25. Yardbird 1 item
Color
  1. Beige 2 items
  2. Black 13 items
  3. Brown 47 items
  4. Clear 1 item
  5. Cream 1 item
  6. Gray 1 item
  7. Green 6 items
  8. Multicolor 1 item
  9. Red 6 items
  10. Red, Black 1 item
  11. Teal 2 items
  12. Verdigris 2 items
  13. White 3 items
Us Shoe Size
  1. 10 1 item
  2. 13 3 items
  3. 4 16 items
  4. 6 42 items
  5. 7.5 10 items
  6. 8 1 item
  7. 9 2 items
  8. Kids 4-5 3 items
  9. L 9-10 8 items
Department
  1. Adult 29 items
  2. Adults 22 items
  3. Adults, Kids, Teens 2 items
  4. Kids 1 item
  5. Unisex Adults 2 items
  6. Unisex Kids 3 items
  7. Women 27 items
Occasion
  1. Activewear 9 items
  2. Activewear, Casual 9 items
  3. All Occasions 6 items
  4. Any 7 items
  5. Business 2 items
  6. Casual 5 items
  7. Casual, Workwear 6 items
  8. Christmas 12 items
  9. Easter 22 items
  10. Fall 1 item
  11. Formal 2 items
  12. Formal, Party/Cocktail, Travel, Wedding 3 items
  13. Party/Cocktail 2 items
  14. Summer 6 items
  15. Travel 3 items
  16. Wedding 2 items
  17. Workwear 1 item
Lining Material
  1. Polyester 14 items
  2. Wool 72 items
Style
  1. Antique 1 item
  2. Antique Style 6 items
  3. Beach 1 item
  4. Bootie 1 item
  5. Classic Rock, Hard Rock 10 items
  6. Complete Outfit 1 item
  7. Country 4 items
  8. Decorative 2 items
  9. Firefighting 1 item
  10. Flats and Slip Ons 3 items
  11. French Country 3 items
  12. Kid's 1 item
  13. Long Sleeve 8 items
  14. Mule 2 items
  15. Nautical 19 items
  16. Novelty 1 item
  17. Rustic 2 items
  18. Rustic/Primitive 6 items
  19. Slide 1 item
  20. Slip-On 2 items
  21. Strappy 1 item
  22. Traditional 4 items
  23. Victorian 3 items
  24. Victorian Style 2 items
  25. Vintage/Retro 1 item
Heel Height
  1. Flat (Under 1 in) 8 items
  2. High (3-3.9 in) 75 items
  3. Mid (2-2.9 in) 3 items
Upper Material
  1. 100% Nylon 3 items
  2. Beads 6 items
  3. Faux Leather 1 item
  4. Faux Suede 17 items
  5. Lace Mesh 2 items
  6. Not Available 1 item
  7. Polyester 8 items
  8. Synthetic 48 items
Price
  1. $0.00 - $99.99 85 items
  2. $100.00 and above 1 item
Toe Shape
  1. Pointed Toe 3 items
  2. Round Toe 80 items
  3. Square Toe 3 items
Closure
  1. Lace Up 10 items
  2. Pull On 17 items
  3. Slip On 58 items
  4. Zip 1 item
Heel Style
  1. Block 8 items
  2. Kitten 3 items
  3. Stiletto 75 items
Theme
  1. Animals 1 item
  2. Bar & Club 1 item
  3. Bar & Club, Humor, Novelty 2 items
  4. Barbie 5 items
  5. Beach 1 item
  6. Butterflies 2 items
  7. Cartoons 4 items
  8. Chickens 2 items
  9. Close The Gate 2 items
  10. Coffee 1 item
  11. College 6 items
  12. DC Super Heroes 9 items
  13. Dogs 2 items
  14. Firefighting 10 items
  15. Fleur De Lis 9 items
  16. Floral 1 item
  17. Flower 2 items
  18. French Bulldog 1 item
  19. Gothic 1 item
  20. Halloween 1 item
  21. Holiday 3 items
  22. Hummingbirds 1 item
  23. Love & Hearts 1 item
  24. Man Cave 1 item
  25. Owl 1 item
  26. Rhinestones 1 item
  27. Skull 3 items
  28. Sports 1 item
  29. Squirrel 1 item
  30. Turtles 1 item
  31. Unicorns 1 item
  32. United States 1 item
  33. Video Games 1 item
  34. Vines 1 item
  35. Vintage 3 items
  36. Welcome 2 items
Shoe Width
  1. Medium 42 items
  2. Standard 38 items
  3. W 6 items
Fabric Type
  1. Knit 3 items
  2. Shearling 83 items
Season
  1. Fall 9 items
  2. Fall, Spring, Summer 10 items
  3. Fall, Spring, Summer, Winter 17 items
  4. Spring 3 items
  5. Spring, Summer 48 items
  6. Summer 3 items
  7. Winter 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.