• 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: 33 | OUT OF STOCK: 0 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 289 273007820004 Plant Hanger Bird Bath Feeder Cast Iron Hanging Fl IN STOCK (1)
2 290 272607820004 Decorative Plant Hanger Cast Iron Flower Basket Ho IN STOCK (1)
3 291 255707820021 Pixie Fairy Cast Iron Plant Hanger Verdigirs 9" De IN STOCK (1)
4 292 110102740002 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
5 293 255707820002 Decorative Plant Hanger Ornate Victorian Cast Iron IN STOCK (1)
6 294 255707820000 Plant Hanger Decorative Hummingbird Cast Iron Flow IN STOCK (1)
7 295 255707820003 Hummingbird Plant Hanger Flower Hook Decorative Ve IN STOCK (1)
8 297 272607820010 Plant Hanger Vine Brown Flower Basket Pot Hook Hol IN STOCK (1)
9 298 255707820016 Love Birds Cast Iron Decorative Plant Hanger Flowe IN STOCK (1)
10 299 255707820017 Birds In Tree Decorative Plant Hanger Cast Iron Fl IN STOCK (1)
11 300 272607820001 Rustic Cast Iron Plant Hanger Bracket Floral Desig IN STOCK (1)
12 301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie Fairy Rus IN STOCK (1)
13 302 263907820000 Cast Iron S Style Plant Hook Flower Hanger Dragonf IN STOCK (1)
14 303 110100410004 Decorative Chickadee Bird Design Cast Iron Plant H IN STOCK (1)
15 304 255707820006 Decorative Watering Can Cast Iron Plant Hanger Hoo IN STOCK (1)
16 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron Hooks 10.25 IN STOCK (1)
17 308 820107820011 Garden Hose Holder Frogs On Lily Pads Cast Iron Ha IN STOCK (1)
18 309 820107820008 Welcome Garden Hose Holder Reel Butterflies & Flow IN STOCK (1)
19 310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
20 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
21 312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
22 313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
23 314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
24 315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
25 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
26 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
27 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
28 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iron Decorati IN STOCK (1)
29 321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK (1)
30 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
31 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wide Verdigr IN STOCK (1)
32 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard IN STOCK (1)
33 781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic 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 33

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Shape J Hook Remove This Item
  2. Finish Matte Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 16 items
  2. Hose Holders 16 items
  3. Trivets 1 item
Set Includes
  1. 1 Shelf Bracket 16 items
  2. Wall Mounted Hose Hanger 17 items
Outsole Material
  1. EVA 1 item
  2. Rubber 32 items
Accents
  1. Heel Strep 1 item
  2. Stripe 32 items
Calf Width
  1. Regular 33 items
Platform Height
  1. 1.25 in 33 items
Primary Color
  1. Black 1 item
  2. Brown 20 items
  3. Green 5 items
  4. Multi-Color 1 item
  5. Rust Brown 4 items
  6. Verdigris 2 items
Item Weight
  1. 0.937500 1 item
  2. 1 lb 2 items
  3. 1.5 lb 1 item
  4. 1.5 lbs 2 items
  5. 13 oz 1 item
  6. 14 Oz 2 items
  7. 2 lbs 3 items
  8. 2.937500 1 item
  9. 3 lb 4 items
  10. 3 lbs 4 items
  11. 3.062500 1 item
  12. 3.312500 1 item
  13. 3.812500 1 item
  14. 4 lb 2 items
  15. 4 lbs 2 items
  16. 5 lb 4 items
  17. 5 lbs 1 item
Product Line
  1. Junie 1 item
  2. Troy 32 items
Room
  1. Any 32 items
  2. Any Room 1 item
Personalized
  1. No 33 items
Mounting
  1. Stake 2 items
  2. Wall Mounted 31 items
Indoor Outdoor
  1. Indoor & Outdoor 11 items
  2. Outdoor 22 items
Suitable For
  1. Coats, Towels, Hats 1 item
  2. Hanging Flower Baskets 3 items
  3. Hanging Plants 1 item
  4. Plants 20 items
  5. Plants, Bird Feeder, Windchime 1 item
  6. Plants, Bird Feeders, Windchimes 2 items
  7. Plants, Windchimes, Bird Feeders 5 items
Subject
  1. Boxer Dog 33 items
Assembly Required
  1. No 33 items
Hook Style
  1. Monkey Tails 17 items
  2. Traditional 16 items
Shoe Shaft Style
  1. Low Top 33 items
Manufacturer
  1. Flag Emotes 33 items
Color
  1. Black 2 items
  2. Brown 22 items
  3. Green 4 items
  4. Light Green 1 item
  5. Multi-Color 1 item
  6. Verdigris 3 items
Us Shoe Size
  1. 13 32 items
  2. L 9-10 1 item
Department
  1. Adults 32 items
  2. Women 1 item
Occasion
  1. All Occasions 1 item
  2. Bereavement 32 items
Lining Material
  1. Polyester 1 item
  2. Textile 32 items
Style
  1. Antique Style 27 items
  2. Hummingbird 1 item
  3. Nautical 1 item
  4. Traditional 1 item
  5. Victorian Style 2 items
  6. Western 1 item
Heel Height
  1. 2.75 in 32 items
  2. Flat (Under 1 in) 1 item
Upper Material
  1. Polyester 1 item
  2. Synthetic 32 items
Price
  1. $0.00 - $9.99 5 items
  2. $10.00 - $19.99 17 items
  3. $20.00 and above 11 items
Toe Shape
  1. Round Toe 33 items
Closure
  1. Lace Up 32 items
  2. Slip On 1 item
Heel Style
  1. Block 1 item
  2. Stiletto 32 items
Theme
  1. Farmhouse 32 items
  2. Nautical 1 item
Shoe Width
  1. Standard 33 items
Insole Material
  1. Foam 32 items
  2. Memory Foam 1 item
Fabric Type
  1. Knit 32 items
  2. Shearling 1 item
Season
  1. Fall 1 item
  2. Fall, Spring, Summer, Winter 32 items
  3. Winter 1 item
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.