• 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` 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'))

First 20 Products (Stock Status Check):

IN STOCK: 31 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 2 273707820000 Ornate Heart Shelf Bracket Decorative Rust Brown C IN STOCK (1)
2 262 272607820007 Blooming Flower S Style Plant Hook Cast Iron Flowe IN STOCK (1)
3 263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf IN STOCK (1)
4 267 255707820013 Bluejay S Style Plant Hook Cast Iron Flower Basket IN STOCK (1)
5 273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK (1)
6 274 272607820006 Rose Flower Bloom S Style Plant Hook Cast Iron Flo IN STOCK (1)
7 275 019707820011 Triple Wall Hook For Coat Hat & Scarf Or Bath Towe IN STOCK (1)
8 276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho IN STOCK (1)
9 279 255700410004 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
10 280 273007820000 Decorative Rooster Plant Hanger Flower Hook Colorf IN STOCK (1)
11 281 273107820003 Cast Iron Plant Hanger Basket Hook Ornate Fleur De IN STOCK (1)
12 294 255707820000 Plant Hanger Decorative Hummingbird Cast Iron Flow IN STOCK (1)
13 295 255707820003 Hummingbird Plant Hanger Flower Hook Decorative Ve IN STOCK (1)
14 304 255707820006 Decorative Watering Can Cast Iron Plant Hanger Hoo IN STOCK (1)
15 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron Hooks 10.25 IN STOCK (1)
16 308 820107820011 Garden Hose Holder Frogs On Lily Pads Cast Iron Ha IN STOCK (1)
17 309 820107820008 Welcome Garden Hose Holder Reel Butterflies & Flow IN STOCK (1)
18 310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
19 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
20 312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
21 313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
22 314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
23 315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
24 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
25 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
26 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
27 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iron Decorati IN STOCK (1)
28 321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK (1)
29 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
30 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wide Verdigr IN STOCK (1)
31 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard 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 31

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Suitable For Plants Remove This Item
  2. Us Shoe Size 13 Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 14 items
  2. Hose Holders 16 items
Set Includes
  1. 1 Shelf Bracket 15 items
  2. Wall Mounted Hose Hanger 16 items
Outsole Material
  1. Rubber 31 items
Accents
  1. Stripe 31 items
Calf Width
  1. Regular 31 items
Platform Height
  1. 1.25 in 31 items
Primary Color
  1. Brown 23 items
  2. Green 2 items
  3. Multi Colored 2 items
  4. Rust Brown 2 items
  5. Verdigris 2 items
Shape
  1. J Hook 21 items
  2. S Hook 10 items
Item Weight
  1. 1 lb 2 items
  2. 1.5 lb 1 item
  3. 1.5 lbs 5 items
  4. 13 oz 1 item
  5. 14 Oz 2 items
  6. 2 lb 1 item
  7. 2.5 lb 3 items
  8. 3 lb 4 items
  9. 3 lbs 1 item
  10. 3.062500 1 item
  11. 3.812500 1 item
  12. 4 lb 2 items
  13. 4 lbs 2 items
  14. 5 lb 4 items
  15. 5 lbs 1 item
Finish
  1. Distressed 1 item
  2. Matte 25 items
  3. Painted 5 items
Product Line
  1. Troy 31 items
Room
  1. Any 31 items
Personalized
  1. No 31 items
Mounting
  1. Stake 2 items
  2. Wall Mounted 29 items
Indoor Outdoor
  1. Indoor & Outdoor 12 items
  2. Outdoor 19 items
Subject
  1. Boxer Dog 31 items
Assembly Required
  1. No 31 items
Hook Style
  1. Antique 5 items
  2. Monkey Tails 18 items
  3. Traditional 8 items
Shoe Shaft Style
  1. Low Top 31 items
Manufacturer
  1. Flag Emotes 31 items
Color
  1. Black 2 items
  2. Brown 25 items
  3. Green 1 item
  4. Verdigris 3 items
Department
  1. Adults 31 items
Occasion
  1. Bereavement 31 items
Lining Material
  1. Textile 31 items
Style
  1. Antique 1 item
  2. Antique Style 17 items
  3. Butterflies 2 items
  4. Farm 1 item
  5. Hummingbird 1 item
  6. Traditional 4 items
  7. Victorian 2 items
  8. Victorian Style 2 items
  9. Western 1 item
Heel Height
  1. 2.75 in 31 items
Upper Material
  1. Synthetic 31 items
Price
  1. $0.00 - $9.99 6 items
  2. $10.00 - $19.99 14 items
  3. $20.00 and above 11 items
Toe Shape
  1. Round Toe 31 items
Closure
  1. Lace Up 31 items
Heel Style
  1. Stiletto 31 items
Theme
  1. Boxer Dog 5 items
  2. Farmhouse 25 items
  3. Heart 1 item
Shoe Width
  1. Standard 31 items
Insole Material
  1. Foam 31 items
Fabric Type
  1. Knit 31 items
Season
  1. Fall, Spring, Summer, Winter 31 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.