• 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 911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
2 14 254107820000 Wall Shelf Bracket Decorative Cast Iron Brace Orna IN STOCK (1)
3 15 254107820020 Wall Shelf Bracket Brace With Plant Hanger Flower IN STOCK (1)
4 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
5 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
6 18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK (1)
7 25 254007820010 Wall Shelf Bracket Cast Iron Brace Fleur De Lis Di IN STOCK (1)
8 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK (1)
9 27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 IN STOCK (1)
10 760 286251207844 Dearfoams Women's Shearling Scuff Slippers Chestnu IN STOCK (1)
11 762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
12 764 276816918998 Dearfoams Men's Shearling Side Stitch Moc Slippers IN STOCK (1)
13 770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
14 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
15 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
16 775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
17 776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
18 777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
19 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
20 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc 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 137

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Finish Painted Remove This Item
  2. Fabric Type Shearling Remove This Item
Clear All
Shopping Options
Category
  1. Hose Holders 1 item
  2. Garden Flags 6 items
  3. Doorbells 2 items
  4. Stepping Stones 7 items
  5. Trivets 8 items
  6. Signs 10 items
Set Includes
  1. 1 Shelf Bracket 6 items
  2. Kickplate / toe kick 110 items
  3. Shelf Brackets 2 items
  4. Wall Mounted Hose Hanger 19 items
Outsole Material
  1. EVA 18 items
  2. Rubber 2 items
  3. Suede 117 items
Accents
  1. big girls 6 items
  2. Buckle 78 items
  3. Floral Pattern 2 items
  4. Flower 10 items
  5. Heel Strep 18 items
  6. Studded 2 items
  7. Thick Laces 19 items
  8. Tie Strap 1 item
  9. wool lining 6 items
  10. Zipper 1 item
Calf Width
  1. Regular 137 items
Platform Height
  1. 1.25 in 137 items
Primary Color
  1. Beige 18 items
  2. Black 24 items
  3. Brown 64 items
  4. Cream 1 item
  5. Distressed Brown 1 item
  6. Distressed White 1 item
  7. Multicolor 6 items
  8. Navy Blue 2 items
  9. Silver 4 items
  10. Tan 1 item
  11. White 11 items
  12. White, Black 1 item
  13. Yellow 3 items
Shape
  1. Butterfly 1 item
  2. Foot Print 114 items
  3. J Hook 12 items
  4. Triangle 8 items
  5. Turtle 2 items
Item Weight
  1. 1 lb 1 item
  2. 1.5 lb 1 item
  3. 1.5 lbs 13 items
  4. 2 lb 2 items
  5. 2 lbs 1 item
  6. 3 lbs 2 items
  7. 4.5 lb 3 items
  8. 5.875000 114 items
Product Line
  1. BearPaw 117 items
  2. Junie 20 items
Room
  1. Any 8 items
  2. Any Room 129 items
Personalized
  1. No 137 items
Mounting
  1. Wall Mounted 137 items
Indoor Outdoor
  1. Indoor & Outdoor 122 items
  2. Outdoor 15 items
Suitable For
  1. Coats, Towels, Hats 129 items
  2. Shelves 8 items
Subject
  1. American Flag 5 items
  2. Barbies 5 items
  3. Beware Of Dog 3 items
  4. Boxer Dog 12 items
  5. Butterfly 1 item
  6. Child Safety 2 items
  7. Close The Gate 49 items
  8. Coffee 6 items
  9. Cows 3 items
  10. Dog 2 items
  11. Dora The Explorer 4 items
  12. Fall 2 items
  13. Fire & Rescue 2 items
  14. Foot Print 9 items
  15. Frog 2 items
  16. Princess 1 item
  17. Snail 7 items
  18. Turtle 2 items
  19. Unicorns 2 items
  20. Welcome 18 items
Assembly Required
  1. No 132 items
  2. Yes 5 items
Hook Style
  1. Traditional 137 items
Shoe Shaft Style
  1. Ankle 88 items
  2. Low Top 49 items
Manufacturer
  1. Allegra K 2 items
  2. Amazon 1 item
  3. Apple 1 item
  4. Baby Einstein 1 item
  5. Brewster 2 items
  6. BRIELLE 1 item
  7. Cracker Jack 8 items
  8. CyberPower 2 items
  9. Dearfoams 4 items
  10. Devin 1 item
  11. Disney 1 item
  12. Dr. Scholl's 1 item
  13. Fitbit 2 items
  14. Flag Emotes 51 items
  15. Floortex 1 item
  16. Funko 2 items
  17. Hasbro 1 item
  18. Heyday 1 item
  19. Holiday Home 2 items
  20. Import Wholesales 15 items
  21. Intex 1 item
  22. Issa 2 items
  23. JBL 1 item
  24. Joshua 1 item
  25. Journee Collection 1 item
  26. Kev 2 items
  27. Maryanne 4 items
  28. McFarlane Toys 2 items
  29. Metra 2 items
  30. Misty 1 item
  31. Mr. Sandman 1 item
  32. Otterbox 2 items
  33. Playtex Baby 1 item
  34. Rawlings 1 item
  35. Rocketfish 2 items
  36. Rubie's 1 item
  37. Sahara 1 item
  38. Sanus 3 items
  39. Seagram's 1 item
  40. Simpli Home 1 item
  41. Unknown 2 items
  42. Victrola 2 items
  43. WWE 1 item
  44. Yardbird 1 item
Color
  1. Beige 12 items
  2. Black 25 items
  3. Bronze 1 item
  4. Brown 41 items
  5. Clear 1 item
  6. Cream 2 items
  7. Gray 4 items
  8. Green 5 items
  9. Multi-Color 1 item
  10. Multicolor 6 items
  11. Navy Blue 2 items
  12. Pink 3 items
  13. Red 6 items
  14. Red, Black 1 item
  15. Silver 2 items
  16. Tan 1 item
  17. Teal 2 items
  18. Verdigris 3 items
  19. White 15 items
  20. White, Black 1 item
  21. Yellow 3 items
Us Shoe Size
  1. 10 4 items
  2. 11 1 item
  3. 13 1 item
  4. 4 24 items
  5. 5 1 item
  6. 6 53 items
  7. 7.5 2 items
  8. 8 3 items
  9. 8.5 6 items
  10. 8.5 WD 1 item
  11. 9 2 items
  12. 9 W 1 item
  13. 9.5 3 items
  14. Kids 2-3 3 items
  15. Kids 4-5 5 items
  16. L 9-10 15 items
  17. W 9.5-10.5 11 items
  18. XL 11-12 1 item
Department
  1. Adult 28 items
  2. Adults 25 items
  3. Adults, Kids, Teens 2 items
  4. Girls 9 items
  5. Kids 1 item
  6. Men 2 items
  7. Unisex Adults 1 item
  8. Unisex Kids 5 items
  9. Women 64 items
Occasion
  1. Activewear 11 items
  2. Activewear, Casual 5 items
  3. All Occasions 11 items
  4. Any 19 items
  5. Business 2 items
  6. Business, Casual, Formal, Party/Cocktail, Travel, Wedding 1 item
  7. Business, Casual, Party/Cocktail, Wedding 1 item
  8. Casual 13 items
  9. Casual, Travel 1 item
  10. Casual, Workwear 12 items
  11. Christmas 6 items
  12. Easter 18 items
  13. Fall 4 items
  14. Formal 2 items
  15. Formal, Party/Cocktail, Travel, Wedding 35 items
  16. Party/Cocktail 2 items
  17. Travel 5 items
  18. Wedding 2 items
Lining Material
  1. Polyester 18 items
  2. Shearling 2 items
  3. Wool 117 items
Style
  1. Antique 11 items
  2. Antique Style 5 items
  3. Beach 1 item
  4. Bootie 7 items
  5. Complete Outfit 1 item
  6. Country 6 items
  7. Decorative 2 items
  8. Flat 2 items
  9. Flats and Slip Ons 5 items
  10. French Country 4 items
  11. Heels 1 item
  12. Kid's 1 item
  13. Long Sleeve 8 items
  14. Moccasin 1 item
  15. Mule 3 items
  16. Nautical 38 items
  17. Not Available 1 item
  18. Rustic 1 item
  19. Slide 7 items
  20. Slingback 2 items
  21. Slip-On 6 items
  22. Sneaker 1 item
  23. Strappy 10 items
  24. T-Strap 2 items
  25. Traditional 4 items
  26. Victorian 3 items
  27. Victorian Style 2 items
  28. Vintage/Retro 2 items
Heel Height
  1. Flat (Under 1 in) 18 items
  2. High (3-3.9 in) 119 items
Upper Material
  1. 100% Nylon 5 items
  2. 100% Polyester 1 item
  3. Beads 6 items
  4. Faux Leather 6 items
  5. Faux Leather upper; Rubber sole 2 items
  6. Faux Suede 20 items
  7. Lace Mesh 2 items
  8. Leather 1 item
  9. Man Made Material 2 items
  10. Not Available 17 items
  11. Polyester 16 items
  12. Suede 7 items
  13. Synthetic 52 items
Price
  1. $0.00 - $99.99 136 items
  2. $100.00 and above 1 item
Toe Shape
  1. Pointed Toe 2 items
  2. Round Toe 135 items
Closure
  1. Lace Up 1 item
  2. Pull On 25 items
  3. Slip On 109 items
  4. Tie 1 item
  5. Zip 1 item
Heel Style
  1. Block 18 items
  2. Stiletto 119 items
Theme
  1. Animals 2 items
  2. Barbie 5 items
  3. Beach 1 item
  4. Beware Of Dog 1 item
  5. Butterflies 2 items
  6. Cartoons 4 items
  7. Chickens 2 items
  8. Children 1 item
  9. Classic 1 item
  10. Close The Gate 6 items
  11. Coffee 3 items
  12. College 14 items
  13. Comics, Television 2 items
  14. Compfort 1 item
  15. Cooking 1 item
  16. DC Super Heroes 9 items
  17. Developmental Activities 2 items
  18. Disney, Cartoons, Princesses/Fairies 1 item
  19. Emergency Services 1 item
  20. Equestrian 1 item
  21. Fall 1 item
  22. Firefighting 2 items
  23. Fish 1 item
  24. Fleur De Lis 9 items
  25. Flower 2 items
  26. Halloween 2 items
  27. Holiday 3 items
  28. Humor 1 item
  29. Love & Hearts 1 item
  30. Nautical 15 items
  31. Outdoor 6 items
  32. Owl 4 items
  33. Racing 1 item
  34. Rhinestones 15 items
  35. Skull 3 items
  36. Squirrel 1 item
  37. Teapot 1 item
  38. Turtle 1 item
  39. Turtles 1 item
  40. Unicorns 2 items
  41. United States 2 items
  42. Vintage 3 items
Shoe Width
  1. Medium 79 items
  2. Standard 45 items
  3. W 12 items
  4. WD 1 item
Insole Material
  1. Memory Foam 129 items
  2. Shearling 2 items
  3. Wool 6 items
Season
  1. Fall 24 items
  2. Fall, Spring, Summer, Winter 20 items
  3. Spring 10 items
  4. Spring, Summer 91 items
  5. Summer 3 items
  6. Winter 24 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.