• 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: 121 | OUT OF STOCK: 1 | 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 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
3 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
4 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br IN STOCK (1)
5 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
6 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK (1)
7 12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK (1)
8 22 254107820005 Wall Shelf Bracket Cast Iron Shelves Brace Ornate IN STOCK (1)
9 190 019707820005 Wall Hook Coat Rack Victorian Skeleton Key Style 3 IN STOCK (1)
10 191 019707820010 Decorative Triple Wall Hook Cast Iron Coat Hat Sca IN STOCK (1)
11 192 019707820021 Cast Iron Wall Hook Rack Tropical Fish & Coral Dec IN STOCK (1)
12 193 019707820013 Double Wall Hook Decorative Antique Style Coat & H IN STOCK (1)
13 198 930907820006 Cast Iron Dinner Bell Love Birds Distressed Brown IN STOCK (1)
14 200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign Outdoor D IN STOCK (1)
15 201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbell Porch D IN STOCK (1)
16 203 930907820005 Cast Iron Dinner Bell Butterfly Floral Vine Doorbe IN STOCK (1)
17 204 930907820004 Cast Iron Dinner Bell Green Farm Tractor Colorful IN STOCK (1)
18 205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
19 215 273207820009 Golden Retriever Garden Flag Emotes Beware Of Dog IN STOCK (1)
20 217 273207820006 White Chihuahua Puppy Beware Of Dog Double Sided F IN STOCK (1)
21 218 273207820007 Dark Brown Chihuahua Beware Of Dog Funny Pet Doub IN STOCK (1)
22 219 272907820014 Double Sided Garden Flag Emotes Welcome To The Nut IN STOCK (1)
23 220 272907820008 Welcome Garden Flag Yellow Butterfly Double Sided IN STOCK (1)
24 221 272907820006 Welcome Garden Flag Pink Dogwood Tree Double Sided IN STOCK (1)
25 222 273207820004 Yorkie Garden Flag Beware Of Dog Yard Decor Funny IN STOCK (1)
26 223 273807820001 Firefighting Garden Flag Fire & Rescue Double Side IN STOCK (1)
27 224 272907820009 Welcome Garden Flag Sunflower Floral Double Sided IN STOCK (1)
28 225 273207820001 Custom Dog Garden Flag Personalized Pet Photo & Na IN STOCK (1)
29 226 273507820001 Welcome To The Lake Garden Flag Cabin Double Sided IN STOCK (1)
30 227 273807820000 Fire & Rescue Garden Flag Firemans Cross Firefight IN STOCK (1)
31 228 272907820004 Welcome Garden Flag Yellow Tulips Double Sided Yar IN STOCK (1)
32 229 273607820003 Halloween Garden Flag Trick Or Treat Double Sided IN STOCK (1)
33 230 272907820007 Welcome Friends Garden Flag Orange Flower Yard Dec IN STOCK (1)
34 231 272907820010 Welcome Garden Flag Floral Decor Orange Green Flow IN STOCK (1)
35 232 272907820011 Bible Verse Garden Flag Deuteronomy 31:6 Be Strong IN STOCK (1)
36 233 272907820000 Welcome Garden Flag Monarch Butterfly Double Sided IN STOCK (1)
37 234 272907820002 WTF Where's The Fish Garden Flag Double Sided Yard IN STOCK (1)
38 235 272707820000 Beach Life Rocks Garden Flag Live Laugh Love Doubl IN STOCK (1)
39 236 272807820001 Welcome Garden Flag Lighthouse Yard Banner Beach D IN STOCK (1)
40 237 272807820004 Custom Pet Bereavement Garden Flag Emotes Forever IN STOCK (1)
41 238 273607820001 Happy Halloween Garden Flag Witches Trick Or Treat IN STOCK (1)
42 239 273207820002 Garden Flag Wine A Bit Funny Drinking Yard Banner IN STOCK (1)
43 240 272907820003 Welcome Garden Flag Purple & White Tulips Double S IN STOCK (1)
44 241 272807820003 Fleur De Lis Garden Flag Emotes Double Sided Welco IN STOCK (1)
45 242 273707820001 Happy Easter Garden Flag Wreath Bunny Eggs Double IN STOCK (1)
46 243 273207820010 Funny Dog Garden Flag Beware Of Dog Black Lab Labr IN STOCK (1)
47 244 273207820003 Cat Garden Flag Spoiled Cats Live Here Double Side IN STOCK (1)
48 245 272807820000 Beach Life Garden Flag Colorful Shells Double Side IN STOCK (1)
49 246 272907820001 Bible Verse Garden Flag Psalm 62:5 My Soul Double IN STOCK (1)
50 247 274007820001 Merry Christmas Garden Flag Winter Double Sided Ya IN STOCK (1)
51 248 273607820002 Halloween Garden Flag Happy Haunting Trick Or Trea IN STOCK (1)
52 249 272907820005 Welcome Garden Flag Pink Flowers Yard Banner Decor IN STOCK (1)
53 250 273207820000 Funny Cat Garden Flag Beware Of Cat Double Sided Y IN STOCK (1)
54 251 273207820011 Funny Black Lab Puppy Garden Flag Beware Of Dog Do IN STOCK (1)
55 252 272907820013 He Is Risen Garden Flag Easter Yard Banner Double IN STOCK (1)
56 253 272907820018 Home Is Where The Heart Is Floral Garden Flag Emot IN STOCK (1)
57 254 274107820003 Happy Campers Garden Flag Double Sided Camping Yar IN STOCK (1)
58 255 272907820012 Inspirational Garden Flag Psalm 34:4 I Sought The IN STOCK (1)
59 256 274007820002 Merry Christmas Garden Flag Flannel Evergreen Tree IN STOCK (1)
60 257 272807820002 Bereavement Garden Flag Forever Loved Heart In Sky IN STOCK (1)
61 258 273207820014 Funny Boxer Garden Flag Beware Of Dog Double Sided IN STOCK (1)
62 260 272607820000 Oak Tree Leaf & Acorn Plant Hanger Decorative Cast IN STOCK (1)
63 261 273107820000 Fleur De Lis Plant Hanger Ornate Cast Iron flower IN STOCK (1)
64 262 272607820007 Blooming Flower S Style Plant Hook Cast Iron Flowe IN STOCK (1)
65 263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf IN STOCK (1)
66 264 255707820015 Decorative Plant Hanger Chickadee Bird Brown Cast IN STOCK (1)
67 265 255707820010 Large Plant Hanger Basket Hook Hummingbird & Flowe IN STOCK (1)
68 266 110102740003 Green Hummingbird Large Plant Hanger Cast Iron Flo IN STOCK (1)
69 267 255707820013 Bluejay S Style Plant Hook Cast Iron Flower Basket IN STOCK (1)
70 268 255707820011 Butterfly Plant Hanger Bracket Flower Pot Basket H IN STOCK (1)
71 269 255707820009 Cast Iron S Style Plant Hook Colorful Bird Flower IN STOCK (1)
72 270 255707820019 Cast Iron Plant Hanger Hook Butterflies & Sunflowe IN STOCK (1)
73 271 272607820009 Decorative Plant Hanger Curly Vine Brown Cast Iron IN STOCK (1)
74 272 272607820002 Plant Hanger Hanging Pot Flower Basket Hook Grape IN STOCK (1)
75 273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK (1)
76 274 272607820006 Rose Flower Bloom S Style Plant Hook Cast Iron Flo IN STOCK (1)
77 275 019707820011 Triple Wall Hook For Coat Hat & Scarf Or Bath Towe IN STOCK (1)
78 276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho IN STOCK (1)
79 277 255707820001 Decorative Horse Head Plant Hanger Cast Iron flowe IN STOCK (1)
80 279 255700410004 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
81 280 273007820000 Decorative Rooster Plant Hanger Flower Hook Colorf IN STOCK (1)
82 281 273107820003 Cast Iron Plant Hanger Basket Hook Ornate Fleur De IN STOCK (1)
83 282 255700410002 Cast Iron Plant Hanger Ornate Pattern 10" Long Yar IN STOCK (1)
84 284 255707820020 Plant Hanger Chickadee Bird Cast Iron Flower Baske IN STOCK (1)
85 285 255707820012 Hummingbird S Style Plant Hook Cast Iron Flower Ba IN STOCK (1)
86 286 273007820001 Crowing Rooster Cast Iron Plant Hanger Farm Flower IN STOCK (1)
87 287 255707820007 Cast Iron S Style Plant Hook Hummingbird flower ba IN STOCK (1)
88 289 273007820004 Plant Hanger Bird Bath Feeder Cast Iron Hanging Fl IN STOCK (1)
89 290 272607820004 Decorative Plant Hanger Cast Iron Flower Basket Ho IN STOCK (1)
90 291 255707820021 Pixie Fairy Cast Iron Plant Hanger Verdigirs 9" De IN STOCK (1)
91 292 110102740002 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
92 293 255707820002 Decorative Plant Hanger Ornate Victorian Cast Iron IN STOCK (1)
93 294 255707820000 Plant Hanger Decorative Hummingbird Cast Iron Flow IN STOCK (1)
94 295 255707820003 Hummingbird Plant Hanger Flower Hook Decorative Ve IN STOCK (1)
95 297 272607820010 Plant Hanger Vine Brown Flower Basket Pot Hook Hol IN STOCK (1)
96 298 255707820016 Love Birds Cast Iron Decorative Plant Hanger Flowe IN STOCK (1)
97 299 255707820017 Birds In Tree Decorative Plant Hanger Cast Iron Fl IN STOCK (1)
98 300 272607820001 Rustic Cast Iron Plant Hanger Bracket Floral Desig IN STOCK (1)
99 301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie Fairy Rus IN STOCK (1)
100 302 263907820000 Cast Iron S Style Plant Hook Flower Hanger Dragonf IN STOCK (1)
101 303 110100410004 Decorative Chickadee Bird Design Cast Iron Plant H IN STOCK (1)
102 304 255707820006 Decorative Watering Can Cast Iron Plant Hanger Hoo IN STOCK (1)
103 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron Hooks 10.25 IN STOCK (1)
104 308 820107820011 Garden Hose Holder Frogs On Lily Pads Cast Iron Ha IN STOCK (1)
105 309 820107820008 Welcome Garden Hose Holder Reel Butterflies & Flow IN STOCK (1)
106 310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
107 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
108 312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
109 313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
110 314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
111 315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
112 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
113 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
114 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
115 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iron Decorati IN STOCK (1)
116 321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK (1)
117 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
118 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wide Verdigr IN STOCK (1)
119 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard IN STOCK (1)
120 328 019707820009 Horse Head Western Wall Hook Rust Brown Cast Iron IN STOCK (1)
121 334 019707820018 Horse Head Horseshoe Western Double Wall Hook Rust IN STOCK (1)
122 335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cast Iron Hoo 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 122

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Product Line Troy Remove This Item
  2. Department Adults Remove This Item
Clear All
Shopping Options
Category
  1. Plant Hangers 42 items
  2. Hose Holders 16 items
  3. Garden Flags 43 items
  4. Doorbells 6 items
  5. Wall Hooks 7 items
Set Includes
  1. 1 Shelf Bracket 96 items
  2. Wall Mounted Hose Hanger 19 items
Outsole Material
  1. Rubber 122 items
Accents
  1. Stripe 122 items
Calf Width
  1. Regular 115 items
Platform Height
  1. 1.25 in 115 items
Primary Color
  1. Blue 6 items
  2. Bronze 1 item
  3. Brown 59 items
  4. Distressed White 2 items
  5. Green 6 items
  6. Multi Colored 2 items
  7. Multi-Color 2 items
  8. Multicolor 6 items
  9. Rust Brown 4 items
  10. Teal 32 items
  11. Verdigris 2 items
Shape
  1. C Hook 2 items
  2. J Hook 36 items
  3. S Hook 17 items
  4. Tractor 45 items
  5. Triangle 15 items
Item Weight
  1. 0.937500 1 item
  2. 1 lb 13 items
  3. 1 lbs 1 item
  4. 1.5 1 item
  5. 1.5 lb 3 items
  6. 1.5 lbs 7 items
  7. 13 oz 1 item
  8. 14 Oz 2 items
  9. 2 lb 7 items
  10. 2 lbs 4 items
  11. 2.5 lb 6 items
  12. 2.5 lbs 1 item
  13. 2.937500 1 item
  14. 3 lb 5 items
  15. 3 lbs 4 items
  16. 3 Oz 11 items
  17. 3.062500 1 item
  18. 3.312500 1 item
  19. 3.812500 1 item
  20. 3lbs. 1 item
  21. 4 lb 2 items
  22. 4 lbs 2 items
  23. 4 Oz 13 items
  24. 5 lb 4 items
  25. 5 lbs 1 item
  26. 5 oz 19 items
  27. 9 Oz 9 Oz 1 item
  28. 9 oz 1 item
Finish
  1. Distressed 3 items
  2. Distressed Brown 1 item
  3. Matte 42 items
  4. Painted 69 items
Room
  1. Any 111 items
  2. Any Room 3 items
  3. Kitchen 1 item
Personalized
  1. No 110 items
  2. Yes 5 items
Mounting
  1. Stake 2 items
  2. Wall Mounted 113 items
Indoor Outdoor
  1. Indoor & Outdoor 85 items
  2. Outdoor 30 items
Suitable For
  1. Birds 5 items
  2. Coat 1 item
  3. Coats, Towels, Hats 2 items
  4. Hanging Flower Baskets 3 items
  5. Hanging Planters 1 item
  6. Hanging Plants 1 item
  7. Home 48 items
  8. Plants 31 items
  9. Plants, Bird Feeder, Windchime 1 item
  10. Plants, Bird Feeders, Windchimes 8 items
  11. Plants, Windchimes, Bird Feeders 5 items
  12. Shelf 1 item
  13. Shelves 6 items
  14. Wind Chimes 2 items
Subject
  1. Beach 1 item
  2. Bee 1 item
  3. Bereavement 3 items
  4. Bible Verse 2 items
  5. Black Lab 1 item
  6. Boxer Dog 62 items
  7. Butterfly 1 item
  8. Camping 1 item
  9. Cat 1 item
  10. Cats 1 item
  11. Christmas 3 items
  12. Dog 6 items
  13. Easter 1 item
  14. Fishing 1 item
  15. Fleur De Lis 2 items
  16. Home 1 item
  17. Inspiration 1 item
  18. Lake 5 items
  19. Lighthouses 1 item
  20. Sunflower 1 item
  21. United States 10 items
  22. Welcome 4 items
  23. Wine 2 items
  24. Yorkie 2 items
  25. You Need A Drink 1 item
Assembly Required
  1. No 115 items
Hook Style
  1. Antique 60 items
  2. Horseshoe 1 item
  3. Monkey Tails 18 items
  4. Traditional 35 items
  5. Western 1 item
Shoe Shaft Style
  1. Low Top 122 items
Manufacturer
  1. Flag Emotes 113 items
  2. Import Wholesales 5 items
  3. Maddison 4 items
Color
  1. Black 2 items
  2. Blue 7 items
  3. Bronze 1 item
  4. Brown 60 items
  5. Green 10 items
  6. Green, Yellow 10 items
  7. Multi-Color 2 items
  8. Multicolor 13 items
  9. Teal 13 items
  10. Verdigris 4 items
Us Shoe Size
  1. 13 122 items
Occasion
  1. Activewear, Casual 15 items
  2. Any 8 items
  3. Bereavement 72 items
  4. Christmas 2 items
  5. Easter 5 items
  6. Everyday 1 item
  7. Halloween 14 items
  8. Inspirational 1 item
  9. Summer 4 items
Lining Material
  1. Textile 122 items
Style
  1. Antique 2 items
  2. Antique Style 39 items
  3. Butterflies 7 items
  4. Country 1 item
  5. Farm 1 item
  6. French 2 items
  7. French Country 1 item
  8. Hummingbird 2 items
  9. Nautical 4 items
  10. Traditional 51 items
  11. Victorian 5 items
  12. Victorian Style 3 items
  13. Vintage/Retro 1 item
  14. Western 3 items
Heel Height
  1. 2.75 in 122 items
Upper Material
  1. Synthetic 122 items
Price
  1. $0.00 - $9.99 15 items
  2. $10.00 - $19.99 87 items
  3. $20.00 and above 20 items
Toe Shape
  1. Round Toe 122 items
Closure
  1. Lace Up 122 items
Heel Style
  1. Stiletto 122 items
Theme
  1. Animal & Birds 1 item
  2. Beach 2 items
  3. Bereavement 2 items
  4. Black Lab 2 items
  5. Boxer Dog 16 items
  6. Camping 1 item
  7. Cats 2 items
  8. Chihuahua 2 items
  9. Christmas 1 item
  10. Dogs 1 item
  11. Easter 1 item
  12. Emergency Services 1 item
  13. Farmhouse 44 items
  14. Fire & Rescue 1 item
  15. Fishing 1 item
  16. Fleur De Lis 2 items
  17. Floral 4 items
  18. Flowers 1 item
  19. Golden Retriever 1 item
  20. Halloween 1 item
  21. Heart 1 item
  22. Holiday 4 items
  23. Home 1 item
  24. Horses Horses 2 items
  25. Inspirational 1 item
  26. Lighthouses 1 item
  27. Nautical 1 item
  28. Outdoor, Sports, University, Fashion 10 items
  29. Scripture 1 item
  30. Vintage 1 item
  31. Welcome 10 items
  32. Wine 1 item
  33. Yorkshire Terrier 1 item
Shoe Width
  1. Standard 122 items
Insole Material
  1. Foam 122 items
Fabric Type
  1. Knit 122 items
Season
  1. Fall, Spring, Summer, Winter 122 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.