• 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

ALL Products in Category (No Pagination):

IN STOCK: 145 | OUT OF STOCK: 1 | First In-Stock at position: 1 | Total Products: 146
Position ID SKU Name Stock Status
1 2 273707820000 Ornate Heart Shelf Bracket Decorative Rust Brown C IN STOCK
2 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK
3 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK
4 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br IN STOCK
5 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK
6 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK
7 12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK
8 22 254107820005 Wall Shelf Bracket Cast Iron Shelves Brace Ornate IN STOCK
9 166 273007820002 Seed Feeder Bird Bath Cast Iron Wall Mounted 9.75" IN STOCK
10 167 273007820005 Hanging Heart Shaped Love Bird Feeder Or Bath 5.5" IN STOCK
11 169 254007820000 Wall Shelf Bracket Decorative Cast Iron Brace Humm IN STOCK
12 170 012600410004 Wall Shelf Bracket Leaf Vine Pattern Cast Iron Bra IN STOCK
13 172 254107820029 Wall Shelf Bracket Brace Ornate Vine Brown Cast Ir IN STOCK
14 174 254107820031 Wall Shelf Bracket Ornate Vine Distressed White Ca IN STOCK
15 176 254107820004 Cast Iron Wall Shelf Bracket Brace Vine & Flower R IN STOCK
16 178 254107820025 Decorative Wall Shelf Bracket Simple Vine Rust Bro IN STOCK
17 179 197100410004 Wall Shelf Bracket - Ornate Pattern - Black Cast I IN STOCK
18 181 254107820016 Decorative Shelf Bracket - Ornate Lattice - Rust B IN STOCK
19 182 254107820018 Decorative Shelf Bracket - Hexagon Lattice - Rust IN STOCK
20 183 254107820019 Shelf Bracket Brace For Custom Shelving Leaf & Vin IN STOCK
... products 21 to 126 hidden ...
127 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK
128 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK
129 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK
130 320 256207820001 Garden Hose Guide Bird On Daisy Cast Iron Decorati IN STOCK
131 321 256207820002 Decorative Garden Hose Guide Bird On Rose Cast Iro IN STOCK
132 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK
133 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wide Verdigr IN STOCK
134 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard IN STOCK
135 326 019707820000 Nautical Black & White Lighthouse Wall Hook Decora IN STOCK
136 328 019707820009 Horse Head Western Wall Hook Rust Brown Cast Iron IN STOCK
137 329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Hanger Ocean IN STOCK
138 330 019707820004 Wall Hook Skeleton Key Coat Rack Antique Style 3 H IN STOCK
139 333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brown Decorati IN STOCK
140 334 019707820018 Horse Head Horseshoe Western Double Wall Hook Rust IN STOCK
141 335 019707820017 Wall Hook Coat Rack Birds On Fence 3 Cast Iron Hoo IN STOCK
142 729 276821288981 Women's Pippa Stretch Ankle Boots Taupe Zip Up Boo IN STOCK
143 751 286264927832 Men's Shaun Hybrid Dress Sneakers Low Top Shoes Sz IN STOCK
144 752 276822613745 Joybees Men's Chance Clogs Gray Sz 7 Slip On Sanda IN STOCK
145 753 286264953134 Women's Spencer Fashion Sneakers Cheetah Print Sho IN STOCK
146 2063 286391557901 Fitbit Sense 2 Health and Fitness Smartwatch FB521 IN STOCK

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 146

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Heel Height 2.75 in Remove This Item
  2. Shoe Width Standard 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. Bird Feeders 2 items
  6. Wall Hooks 13 items
Set Includes
  1. 1 Shelf Bracket 111 items
  2. Kickplate / toe kick 1 item
  3. Wall Mounted Hose Hanger 25 items
Outsole Material
  1. Rubber 146 items
Accents
  1. Bow, Rhinestone 1 item
  2. Heel 3 items
  3. Stripe 142 items
  4. Zipper 3 items
Calf Width
  1. Regular 137 items
Platform Height
  1. 1.25 in 137 items
Primary Color
  1. Black 4 items
  2. Blue 6 items
  3. Bronze 1 item
  4. Brown 69 items
  5. Cheetah 1 item
  6. Distressed White 5 items
  7. Green 6 items
  8. Multi Colored 2 items
  9. Multi-Color 2 items
  10. Multicolor 6 items
  11. Rust 5 items
  12. Rust Brown 5 items
  13. Teal 32 items
  14. Verdigris 2 items
Shape
  1. C Hook 2 items
  2. Foot Print 1 item
  3. J Hook 42 items
  4. S Hook 17 items
  5. Tractor 45 items
  6. Triangle 30 items
Item Weight
  1. 0.937500 1 item
  2. 1 lb 14 items
  3. 1 lbs 1 item
  4. 1.5 1 item
  5. 1.5 lb 3 items
  6. 1.5 lbs 9 items
  7. 10 oz 1 item
  8. 13 oz 1 item
  9. 14 Oz 2 items
  10. 2 lb 7 items
  11. 2 lbs 4 items
  12. 2.5 lb 19 items
  13. 2.5 lbs 1 item
  14. 2.937500 1 item
  15. 3 lb 6 items
  16. 3 lbs 4 items
  17. 3 Oz 11 items
  18. 3.062500 1 item
  19. 3.312500 1 item
  20. 3.812500 1 item
  21. 3lbs. 1 item
  22. 4 lb 2 items
  23. 4 lbs 2 items
  24. 4 Oz 13 items
  25. 5 lb 4 items
  26. 5 lbs 1 item
  27. 5 oz 20 items
  28. 5.875000 1 item
  29. 6 oz 2 items
  30. 9 Oz 9 Oz 1 item
  31. 9 oz 1 item
Finish
  1. Distressed 3 items
  2. Distressed Brown 1 item
  3. Glossy 1 item
  4. Matte 42 items
  5. Painted 90 items
Product Line
  1. BearPaw 1 item
  2. Junie 4 items
  3. Troy 141 items
Room
  1. Any 126 items
  2. Any Room 7 items
  3. Bathroom 3 items
  4. Kitchen 1 item
Personalized
  1. No 132 items
  2. Yes 5 items
Mounting
  1. Hanging 13 items
  2. Stake 2 items
  3. Wall Mount 1 item
  4. Wall Mounted 121 items
Indoor Outdoor
  1. Indoor & Outdoor 101 items
  2. Outdoor 36 items
Suitable For
  1. Birds 19 items
  2. Coat 4 items
  3. Coats, Towels, Hats 5 items
  4. Custom Shelves 1 item
  5. Hanging Flower Baskets 3 items
  6. Hanging Planters 1 item
  7. Hanging Plants 1 item
  8. Home 48 items
  9. Keys 1 item
  10. Plants 31 items
  11. Plants, Bird Feeder, Windchime 1 item
  12. Plants, Bird Feeders, Windchimes 8 items
  13. Plants, Windchimes, Bird Feeders 5 items
  14. Shelf 1 item
  15. Shelves 6 items
  16. 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 68 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 26 items
  22. Welcome 4 items
  23. Wine 2 items
  24. Yorkie 2 items
  25. You Need A Drink 1 item
Assembly Required
  1. No 137 items
Hook Style
  1. Antique 60 items
  2. Horseshoe 1 item
  3. Monkey Tails 18 items
  4. Nautical 1 item
  5. Tail 1 item
  6. Traditional 55 items
  7. Western 1 item
Shoe Shaft Style
  1. Ankle 3 items
  2. Low Top 143 items
Manufacturer
  1. Fitbit 1 item
  2. Flag Emotes 117 items
  3. Import Wholesales 5 items
  4. Kendra 1 item
  5. Maddison 19 items
  6. Shaun 2 items
  7. Spencer 1 item
Color
  1. Black 4 items
  2. Black, White, Red 1 item
  3. Blue 7 items
  4. Bronze 1 item
  5. Brown 78 items
  6. Cheetah 1 item
  7. Gray 1 item
  8. Green 10 items
  9. Green, Yellow 10 items
  10. Multi-Color 2 items
  11. Multicolor 13 items
  12. Taupe 1 item
  13. Teal 13 items
  14. Verdigris 4 items
Us Shoe Size
  1. 12 1 item
  2. 13 141 items
  3. 7 1 item
  4. 7.5 1 item
  5. 8 2 items
Department
  1. Adult 3 items
  2. Adults 122 items
  3. Kids 1 item
  4. Men 2 items
  5. Unisex Adults 1 item
  6. Women 17 items
Occasion
  1. Activewear 1 item
  2. Activewear, Casual 30 items
  3. Activewear, Casual, Travel, Workwear 1 item
  4. Any 8 items
  5. Bereavement 76 items
  6. Business 1 item
  7. Casual 3 items
  8. Christmas 2 items
  9. Easter 5 items
  10. Everyday 1 item
  11. Formal, Party/Cocktail, Travel, Wedding 1 item
  12. Halloween 14 items
  13. Inspirational 1 item
  14. Party/Cocktail 1 item
  15. Summer 4 items
  16. Travel 3 items
Lining Material
  1. Textile 146 items
Style
  1. Antique 3 items
  2. Antique Style 53 items
  3. Bootie 1 item
  4. Butterflies 7 items
  5. Clog 1 item
  6. Country 1 item
  7. Farm 1 item
  8. Flat 1 item
  9. French 2 items
  10. French Country 1 item
  11. Hummingbird 2 items
  12. Nautical 7 items
  13. Sneaker 2 items
  14. Traditional 51 items
  15. Victorian 6 items
  16. Victorian Style 3 items
  17. Vintage/Retro 1 item
  18. Western 3 items
Upper Material
  1. Faux Suede 1 item
  2. Mesh 1 item
  3. Synthetic 144 items
Price
  1. $0.00 - $9.99 23 items
  2. $10.00 - $19.99 101 items
  3. $20.00 - $29.99 21 items
  4. $70.00 and above 1 item
Toe Shape
  1. Almond Toe 1 item
  2. Round Toe 144 items
  3. Square Toe 1 item
Closure
  1. Lace Up 142 items
  2. Slip On 2 items
  3. Tie 1 item
  4. Zip 1 item
Heel Style
  1. Block 4 items
  2. Stiletto 142 items
Theme
  1. 80s, 90s, City 1 item
  2. Animal & Birds 1 item
  3. Beach 2 items
  4. Bereavement 2 items
  5. Black Lab 2 items
  6. Boxer Dog 16 items
  7. Camping 1 item
  8. Cats 2 items
  9. Cheetah Print 1 item
  10. Chihuahua 2 items
  11. Christmas 1 item
  12. City, Outdoor, Sports, Work 1 item
  13. Dogs 1 item
  14. Easter 1 item
  15. Emergency Services 1 item
  16. Farmhouse 45 items
  17. Fire & Rescue 1 item
  18. Fishing 1 item
  19. Fleur De Lis 2 items
  20. Floral 4 items
  21. Flowers 1 item
  22. Golden Retriever 1 item
  23. Halloween 1 item
  24. Heart 1 item
  25. Holiday 4 items
  26. Home 1 item
  27. Horses Horses 2 items
  28. Inspirational 1 item
  29. Lighthouses 1 item
  30. Mermaids 1 item
  31. Nautical 1 item
  32. Outdoor 1 item
  33. Outdoor, Sports, University, Fashion 25 items
  34. Rhinestones 1 item
  35. Scripture 1 item
  36. Seahorse 1 item
  37. Skeleton Key 1 item
  38. Vintage 1 item
  39. Welcome 10 items
  40. Wine 1 item
  41. Yorkshire Terrier 1 item
Insole Material
  1. Foam 141 items
  2. Memory Foam 5 items
Fabric Type
  1. Knit 145 items
  2. Shearling 1 item
Season
  1. Fall 2 items
  2. Fall, Spring, Summer 1 item
  3. Fall, Spring, Summer, Winter 143 items
  4. Spring 2 items
  5. Summer 2 items
  6. 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.