• 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: 78 | OUT OF STOCK: 0 | First In-Stock at position: 1 | Total Products: 78
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 18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK
4 19 254107820008 Wall Shelf Bracket Large Fleur De Lis Cast Iron Br IN STOCK
5 23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis Verdigris C IN STOCK
6 27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 IN STOCK
7 846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK
8 849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK
9 879 286280138492 Women's Sterling Chelsea Boots Zip Up Ankle Bootie IN STOCK
10 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK
11 951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK
12 953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK
13 1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK
14 1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK
15 1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK
16 1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK
17 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK
18 1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK
19 1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK
20 1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK
... products 21 to 58 hidden ...
59 1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK
60 1823 829800250004 Longaberger Traditions Handle Tie Collectible Acce IN STOCK
61 1868 198507820002 Flamingo Welcome Plaque Brown Cast Iron Beach Them IN STOCK
62 1872 272207820000 Large Rolling Plant Caddy Fleur De Lis IN STOCK
63 1873 273607820000 Decorative Cast Iron Rooster Trivet Kitchen Decor IN STOCK
64 1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK
65 1875 284109859464 Disney’s Baby Mickey Mouse Wall Border ABC Nurse IN STOCK
66 2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK
67 2053 286367593981 New England Patriots Rawlings Cooler Tote Holds 30 IN STOCK
68 2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK
69 2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK
70 2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK
71 2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK
72 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK
73 2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK
74 2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK
75 2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK
76 2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK
77 2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK
78 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 78

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Brown Remove This Item
  2. Heel Height High (3-3.9 in) 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 3 items
  5. Signs 10 items
Set Includes
  1. 1 Shelf Bracket 5 items
  2. Kickplate / toe kick 68 items
  3. Shelf Brackets 1 item
  4. Wall Mounted Hose Hanger 3 items
Outsole Material
  1. EVA 3 items
  2. Suede 75 items
Accents
  1. big girls 3 items
  2. Buckle 42 items
  3. Elastic 1 item
  4. Floral Pattern 2 items
  5. Flower 6 items
  6. Logo 7 items
  7. Thick Laces 17 items
  8. wool lining 3 items
  9. Zipper 1 item
Calf Width
  1. Regular 77 items
Platform Height
  1. 1.25 in 77 items
Shape
  1. Foot Print 71 items
  2. Triangle 6 items
Item Weight
  1. 1 lb 1 item
  2. 2 lb 3 items
  3. 3 lbs 2 items
  4. 5.875000 71 items
Finish
  1. Distressed Brown 2 items
  2. Glossy 4 items
  3. Matt 17 items
  4. Painted 54 items
Product Line
  1. BearPaw 75 items
  2. Junie 3 items
Room
  1. Any 6 items
  2. Any Room 71 items
Personalized
  1. No 77 items
Mounting
  1. Wall Mounted 77 items
Indoor Outdoor
  1. Indoor & Outdoor 77 items
Suitable For
  1. Coats, Towels, Hats 71 items
  2. Shelves 5 items
  3. Wall Shelf, Mail Box Mount 1 item
Subject
  1. American Flag 4 items
  2. Barbies 5 items
  3. Beer 1 item
  4. Close The Gate 5 items
  5. Coffee 4 items
  6. Cows 4 items
  7. Dachshund 2 items
  8. Darts 1 item
  9. Dog 3 items
  10. Dora The Explorer 4 items
  11. Fire & Rescue 10 items
  12. Foot Print 5 items
  13. Snail 6 items
  14. Unicorns 1 item
  15. Video Games 1 item
  16. Welcome 17 items
  17. Wine 3 items
  18. You Need A Drink 1 item
Assembly Required
  1. No 74 items
  2. Yes 3 items
Hook Style
  1. Traditional 77 items
Shoe Shaft Style
  1. Ankle 46 items
  2. Low Top 32 items
Manufacturer
  1. Amazon 1 item
  2. Brewster 2 items
  3. Cracker Jack 8 items
  4. CyberPower 1 item
  5. Disney 1 item
  6. Flag Emotes 24 items
  7. Floortex 1 item
  8. Holiday Home 2 items
  9. Import Wholesales 20 items
  10. Intex 1 item
  11. Issa 2 items
  12. Longaberger 1 item
  13. Maryanne 1 item
  14. Mr. Sandman 1 item
  15. Persephone 1 item
  16. Rawlings 1 item
  17. Rubie's 1 item
  18. Sahara 1 item
  19. Sanus 1 item
  20. Simpli Home 1 item
  21. Sony Legacy 1 item
  22. Unknown 1 item
  23. Victrola 1 item
  24. Withit 2 items
  25. Yardbird 1 item
Color
  1. Beige 2 items
  2. Black 13 items
  3. Brown 42 items
  4. Clear 1 item
  5. Gray 1 item
  6. Green 5 items
  7. Multicolor 1 item
  8. Red 6 items
  9. Red, Black 1 item
  10. Teal 2 items
  11. Verdigris 1 item
  12. White 3 items
Us Shoe Size
  1. 10 1 item
  2. 13 1 item
  3. 4 19 items
  4. 6 41 items
  5. 7.5 10 items
  6. 8 1 item
  7. 9 2 items
  8. Kids 4-5 3 items
Department
  1. Adult 29 items
  2. Adults 17 items
  3. Adults, Kids, Teens 2 items
  4. Girls 3 items
  5. Kids 1 item
  6. Unisex Adults 2 items
  7. Unisex Kids 3 items
  8. Women 21 items
Occasion
  1. Activewear 9 items
  2. Activewear, Casual 6 items
  3. All Occasions 3 items
  4. Any 4 items
  5. Business 2 items
  6. Casual 6 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 1 item
  16. Wedding 2 items
  17. Workwear 1 item
Lining Material
  1. Polyester 3 items
  2. Wool 75 items
Style
  1. Antique 1 item
  2. Antique Style 6 items
  3. Beach 1 item
  4. Bootie 4 items
  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 2 items
  12. Kid's 1 item
  13. Long Sleeve 8 items
  14. Mule 2 items
  15. Nautical 16 items
  16. Novelty 1 item
  17. Rustic 1 item
  18. Rustic/Primitive 6 items
  19. Slip-On 2 items
  20. Strappy 1 item
  21. Victorian 3 items
  22. Victorian Style 2 items
Upper Material
  1. 100% Nylon 3 items
  2. Beads 3 items
  3. Faux Leather 1 item
  4. Faux Suede 17 items
  5. Lace Mesh 2 items
  6. Not Available 1 item
  7. Suede 3 items
  8. Synthetic 48 items
Price
  1. $0.00 - $99.99 77 items
  2. $100.00 and above 1 item
Toe Shape
  1. Pointed Toe 3 items
  2. Round Toe 75 items
Closure
  1. Lace Up 7 items
  2. Pull On 20 items
  3. Slip On 50 items
  4. Zip 1 item
Heel Style
  1. Stiletto 78 items
Theme
  1. Bar & Club 1 item
  2. Bar & Club, Humor, Novelty 2 items
  3. Barbie 5 items
  4. Beach 1 item
  5. Cartoons 4 items
  6. Chickens 2 items
  7. Close The Gate 2 items
  8. Coffee 1 item
  9. College 6 items
  10. DC Super Heroes 9 items
  11. Dogs 2 items
  12. Firefighting 10 items
  13. Fleur De Lis 7 items
  14. Flower 2 items
  15. French Bulldog 1 item
  16. Gothic 1 item
  17. Holiday 3 items
  18. Man Cave 1 item
  19. Outdoor 3 items
  20. Rhinestones 1 item
  21. Skull 3 items
  22. Sports 1 item
  23. Squirrel 1 item
  24. Turtles 1 item
  25. Unicorns 1 item
  26. United States 1 item
  27. Video Games 1 item
  28. Vintage 3 items
  29. Welcome 2 items
Shoe Width
  1. Medium 42 items
  2. Standard 30 items
  3. W 6 items
Insole Material
  1. Memory Foam 75 items
  2. Wool 3 items
Fabric Type
  1. Shearling 78 items
Season
  1. Fall 4 items
  2. Fall, Spring, Summer 7 items
  3. Fall, Spring, Summer, Winter 17 items
  4. Spring 6 items
  5. Spring, Summer 48 items
  6. Summer 3 items
  7. Winter 4 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.