• 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 = 1 ORDER BY `stock_status`.`stock_status` DESC

First 10 Products (Stock Status Check):

ID SKU Name Stock Status
308 820107820011 Garden Hose Holder Frogs On Lily Pads Cast Iron Ha IN STOCK (1)
309 820107820008 Welcome Garden Hose Holder Reel Butterflies & Flow IN STOCK (1)
310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi 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-10 of 55

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Set Includes Wall Mounted Hose Hanger Remove This Item
  2. Calf Width Regular Remove This Item
Clear All
Shopping Options
Category
  1. Hose Holders 16 items
  2. Wall Hooks 7 items
  3. Stepping Stones 9 items
  4. Trivets 9 items
Outsole Material
  1. EVA 22 items
  2. Man Made 1 item
  3. Rubber 28 items
  4. Suede 4 items
Accents
  1. big girls 1 item
  2. Embroidered 1 item
  3. Floral Pattern 2 items
  4. Heel 2 items
  5. Heel Strep 23 items
  6. Silver Toe 3 items
  7. Stripe 23 items
  8. wool lining 1 item
  9. Zipper 2 items
Platform Height
  1. 1.25 in 54 items
  2. 1.5 in 1 item
Primary Color
  1. Black 16 items
  2. Brown 30 items
  3. Cream 1 item
  4. Distressed Brown 2 items
  5. Gray 1 item
  6. Green 2 items
  7. Verdigris 2 items
  8. White 1 item
Shape
  1. Butterfly 1 item
  2. Foot Print 4 items
  3. Frog 5 items
  4. J Hook 43 items
  5. Turtle 2 items
Item Weight
  1. 1 lb 1 item
  2. 1.5 lbs 21 items
  3. 10 oz 1 item
  4. 13 oz 1 item
  5. 14 Oz 2 items
  6. 3 lb 2 items
  7. 3 lbs 1 item
  8. 3.812500 1 item
  9. 4 lb 2 items
  10. 4 lbs 2 items
  11. 4.5 lb 3 items
  12. 5 lb 5 items
  13. 5 lbs 1 item
  14. 5 oz 1 item
  15. 5.875000 4 items
  16. 6 lbs 4 items
  17. 6 oz 1 item
  18. 9 Oz 9 Oz 1 item
  19. 9 oz 1 item
Finish
  1. Matte 22 items
  2. Painted 33 items
Product Line
  1. BearPaw 1 item
  2. Junie 27 items
  3. Troy 27 items
Room
  1. Any 16 items
  2. Any Room 36 items
  3. Bathroom 3 items
Personalized
  1. No 55 items
Mounting
  1. Stake 2 items
  2. Wall Mounted 53 items
Indoor Outdoor
  1. Indoor & Outdoor 9 items
  2. Outdoor 46 items
Suitable For
  1. Coat 4 items
  2. Coats, Towels, Hats 34 items
  3. Keys 1 item
  4. Plants 16 items
Subject
  1. Boxer Dog 43 items
  2. Butterfly 1 item
  3. Foot Print 4 items
  4. Frog 5 items
  5. Turtle 2 items
Assembly Required
  1. No 55 items
Hook Style
  1. Horseshoe 1 item
  2. Monkey Tails 16 items
  3. Nautical 1 item
  4. Tail 1 item
  5. Traditional 35 items
  6. Western 1 item
Shoe Shaft Style
  1. Ankle 7 items
  2. Low Top 48 items
Manufacturer
  1. Carla 3 items
  2. Dearfoams 2 items
  3. Flag Emotes 41 items
  4. Issa 2 items
  5. Kendra 1 item
  6. Kev 3 items
  7. Maryanne 1 item
  8. Shaun 1 item
  9. Sienna 1 item
Color
  1. Black 7 items
  2. Black, White, Red 1 item
  3. Bronze 1 item
  4. Brown 27 items
  5. Cream 2 items
  6. Gray 2 items
  7. Green 3 items
  8. Honey Brown 1 item
  9. Light Green 1 item
  10. Multi-Color 1 item
  11. Taupe 1 item
  12. Verdigris 6 items
  13. White 2 items
Us Shoe Size
  1. 10 1 item
  2. 13 23 items
  3. 4 1 item
  4. 6 2 items
  5. 7 1 item
  6. 7.5 2 items
  7. 8.5 1 item
  8. 9 2 items
  9. 9.5 1 item
  10. L 9-10 19 items
  11. MD 7.5-8 1 item
  12. XL 11-12 1 item
Department
  1. Adult 3 items
  2. Adults 19 items
  3. Girls 1 item
  4. Kids 1 item
  5. Men 2 items
  6. Women 29 items
Occasion
  1. All Occasions 11 items
  2. Any 6 items
  3. Bereavement 23 items
  4. Business 7 items
  5. Casual 15 items
  6. Formal 2 items
  7. Party/Cocktail 6 items
  8. Travel 10 items
  9. Wedding 2 items
  10. Workwear 1 item
Lining Material
  1. Fabric 1 item
  2. Faux Fur 1 item
  3. Polyester 25 items
  4. Shearling 2 items
  5. Textile 25 items
  6. Wool 1 item
Style
  1. ankle boots 1 item
  2. Antique 6 items
  3. Antique Style 12 items
  4. Bootie 4 items
  5. Boots 1 item
  6. Clog 1 item
  7. Moccasin 2 items
  8. Mule 2 items
  9. Nautical 14 items
  10. Slide 2 items
  11. Slip-On 1 item
  12. Traditional 2 items
  13. Victorian Style 2 items
  14. Vintage/Retro 2 items
  15. Western 3 items
Heel Height
  1. 2 in 1 item
  2. 2.75 in 25 items
  3. 3.25 in 3 items
  4. Flat (Under 1 in) 23 items
  5. High (3-3.9 in) 3 items
Upper Material
  1. Fabric 1 item
  2. Faux Leather 1 item
  3. Faux Suede 2 items
  4. Lace Mesh 2 items
  5. Leather 1 item
  6. Not Available 1 item
  7. Polyester 20 items
  8. Suede 3 items
  9. Synthetic 24 items
Price
  1. $0.00 - $9.99 15 items
  2. $10.00 - $19.99 23 items
  3. $20.00 and above 17 items
Toe Shape
  1. Almond Toe 1 item
  2. Pointed Toe 3 items
  3. Round Toe 50 items
  4. Square Toe 1 item
Closure
  1. Lace Up 23 items
  2. Pull On 2 items
  3. Slip On 27 items
  4. Zip 3 items
Heel Style
  1. Approximately 1.75 Inches Block Heel 1 item
  2. Block 28 items
  3. Stiletto 26 items
Theme
  1. 80s, 90s, City 1 item
  2. Animals 1 item
  3. Bohemian 1 item
  4. Butterflies 2 items
  5. Classic 1 item
  6. Compfort 2 items
  7. Cooking 1 item
  8. Cowgirl, Cowgirl Core, Western, Cowgirlcore, Cowgirl Couture 3 items
  9. Farmhouse 18 items
  10. Fish 1 item
  11. Flower 2 items
  12. Frog 1 item
  13. Halloween 2 items
  14. Horses Horses 2 items
  15. Love & Hearts 1 item
  16. Mermaids 1 item
  17. Nautical 5 items
  18. Outdoor 2 items
  19. Owl 4 items
  20. Seahorse 1 item
  21. Skeleton Key 1 item
  22. Teapot 1 item
  23. Turtle 1 item
Shoe Width
  1. M 1 item
  2. Medium 1 item
  3. Standard 53 items
Insole Material
  1. Foam 23 items
  2. Insole Technology 1 item
  3. Memory Foam 28 items
  4. Shearling 2 items
  5. Wool 1 item
Fabric Type
  1. Knit 30 items
  2. Shearling 25 items
Season
  1. Fall 30 items
  2. Fall, Spring, Summer, Winter 23 items
  3. Spring 10 items
  4. Summer 7 items
  5. Winter 27 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.