Toggle Nav
My Cart
Search
Advanced Search

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'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status` ON e.entity_id = stock_status.product_id AND stock_status.website_id = 0
 LEFT JOIN (SELECT `cpsl`.`parent_id`, MAX(stock_child.stock_status) AS `max_stock` FROM `catalog_product_super_link` AS `cpsl`
 LEFT JOIN `cataloginventory_stock_status` AS `stock_child` ON cpsl.product_id = stock_child.product_id AND stock_child.website_id = 0 GROUP BY `cpsl`.`parent_id`) AS `config_stock` ON e.entity_id = config_stock.parent_id ORDER BY CASE 
                WHEN e.type_id = "configurable" THEN IFNULL(config_stock.max_stock, 0)
                ELSE IFNULL(stock_status.stock_status, 0)
            END DESC

First 20 Products (Stock Status Check):

IN STOCK: 182 | OUT OF STOCK: 1 | First In-Stock at position: 1
# ID SKU Name Stock Status
1 773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
2 774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
3 775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
4 776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
5 777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
6 778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
7 779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
8 780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK (1)
9 781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic IN STOCK (1)
10 782 229207820000 Decorative Sitting Green Frog Stepping Stone Cast IN STOCK (1)
11 783 237107820001 Decorative Welcome Stepping Stone Plaque Footprint IN STOCK (1)
12 784 266107820000 Welcome To My Garden Hummingbird Stepping Stone Pl IN STOCK (1)
13 785 272507820003 Heart & Foot Prints Welcome Plaque Cast Iron Stepp IN STOCK (1)
14 787 229207820002 Decorative Cast Iron Yard & Garden Stepping Stone IN STOCK (1)
15 788 246407820002 LARGE Turtle Stepping Stone Paver Decorative Cast IN STOCK (1)
16 792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
17 793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
18 794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
19 1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
20 1193 276301204436 Baby Proofing American Electrical Outlet Safety Co IN STOCK (1)
21 1677 820107820015 Ornate Garden Hose Holder - Heavy Duty Metal Wall IN STOCK (1)
22 1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wall Mount D IN STOCK (1)
23 1690 254107820030 Wall Shelf Bracket Ornate Scroll White Cast Iron R IN STOCK (1)
24 1693 276955627052 Women's Marcia Lace up Heels with Memory Foam Inso IN STOCK (1)
25 1703 273107820002-1 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
26 1704 273107820002 Nautical Ship Anchor Cast Iron Shelf Bracket 7.75" IN STOCK (1)
27 1705 254107820003-1 Wall Shelf Bracket Cast Iron Brace Vine & Leaf Ver IN STOCK (1)
28 1706 272607820008 S-Hook Plant Hanger Flower Basket Decor Rustic Bro IN STOCK (1)
29 1720 254107820007 Ornate Cast Iron Shelf Bracket Decorative Corner S IN STOCK (1)
30 1724 246407820001 13" Brown Cast Iron Turtle Stepping Stone Decorati IN STOCK (1)
31 1726 272907820017 Unicorn Garden Flag Rainbow Yard Banner – "Unico IN STOCK (1)
32 1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
33 1728 274007820000 Slow Down Garden Flag Caution Children At Play Dou IN STOCK (1)
34 1729 261207820000 Funny Aluminum Sign No Poop Heads Allowed Men Man IN STOCK (1)
35 1730 273207820013 Don't Be A Poop Head Emoji Clean Up After Dog Gard IN STOCK (1)
36 1731 000007830114 NASCAR Kasey Kahne Wall Appliques Decal Racing Sti IN STOCK (1)
37 1733 272907820015 Thankful Grateful Blessed Fall Leaves Garden Flag IN STOCK (1)
38 1734 163807820003 Aluminum Sign Firemans Cross White Firefighting Pl IN STOCK (1)
39 1735 273807820002 Welcome American Garden Flag Emotes Double Sided A IN STOCK (1)
40 1736 322207820000 Fish Pocket Beer Bottle Opener Handheld Brown Cast IN STOCK (1)
41 1737 273707820003 Happy Easter Spring Flowers Birds Garden Flag Emot IN STOCK (1)
42 1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
43 1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
44 1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
45 1791 273907820002 Frog Hide A Key Box Distressed Brown Cast Iron Gar IN STOCK (1)
46 1819 144307820001 Personalized Man Cave Aluminum Sign Custom Dartboa IN STOCK (1)
47 1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK (1)
48 1824 273907820000 Cast Iron Skillet Wall Hanging Holstein Dairy Cow IN STOCK (1)
49 1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK (1)
50 1876 229207820004 Cast Iron Plaque Sign - Beware Of The Dog - Black IN STOCK (1)
51 1880 285024495455 Please Close The Gate Cast Iron Plaque Sign Black IN STOCK (1)
52 1882 TGLSPG0001 Electric Salt & Pepper Grinder Set - Adjustable Co IN STOCK (1)
53 2043 266207820000 Welcome Stepping Stone Cast Iron Lawn Garden Decor IN STOCK (1)
54 2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK (1)
55 2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK (1)
56 2059 286382333221 Womens Paulina Kitten Heel Sling Back Pointed Toe IN STOCK (1)
57 2061 254107820032 White Cast Iron Shelf Bracket Ornate Scroll Wall M IN STOCK (1)
58 2065 286393541437 Women's Mel Rhinestone Mesh Ballet Flats Silver / IN STOCK (1)
59 2074 254007820011 Cast Iron Shelf Bracket Fleur De Lis Distressed Wh IN STOCK (1)
60 2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK (1)
61 2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK (1)
62 2084 254107820003 Wall Shelf Bracket Decorative Cast Iron Brace Vine IN STOCK (1)
63 2088 273207820012 Funny Garden Flag Roses Are Red So Is My Wine Doub IN STOCK (1)
64 2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
65 2359 272907820016 Welcome To Our Home Garden Flag – Seasonal Outdo IN STOCK (1)
66 2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK (1)
67 2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK (1)
68 2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK (1)
69 2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe IN STOCK (1)
70 2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK (1)
71 2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK (1)
72 2 273707820000 Ornate Heart Shelf Bracket Decorative Rust Brown C IN STOCK (1)
73 5 254007820003 Fleur De Lis & Vine Shelf Bracket Cast Iron Brace IN STOCK (1)
74 6 254107820011 Decorative Shelf Bracket Flower Leaf Brace Distres IN STOCK (1)
75 7 254007820002 Wall Shelf Bracket Fleur De Lis Cast Iron Brace Br IN STOCK (1)
76 8 254107820010 Decorative Cast Iron Wall Shelf Bracket Brace DIY IN STOCK (1)
77 10 254107820009 Cast Iron Wall Shelf Bracket Ornate Brace 10" Deep IN STOCK (1)
78 12 254207820000 Nautical Shelf Bracket Clamshell Beach Shell Brace IN STOCK (1)
79 16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
80 17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
81 22 254107820005 Wall Shelf Bracket Cast Iron Shelves Brace Ornate IN STOCK (1)
82 24 254107820001 Decorative Angle Bracket Cast Iron Shelf Brace Gol IN STOCK (1)
83 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK (1)
84 198 930907820006 Cast Iron Dinner Bell Love Birds Distressed Brown IN STOCK (1)
85 200 930907820001 Cast Iron Dinner Bell Moose Welcome Sign Outdoor D IN STOCK (1)
86 201 930907820007 Cast Iron Dinner Bell Ornate Vine Doorbell Porch D IN STOCK (1)
87 203 930907820005 Cast Iron Dinner Bell Butterfly Floral Vine Doorbe IN STOCK (1)
88 204 930907820004 Cast Iron Dinner Bell Green Farm Tractor Colorful IN STOCK (1)
89 205 930907820008 Cast Iron Dinner Bell Rooster & Flowers Colorful D OUT OF STOCK (0)
90 221 272907820006 Welcome Garden Flag Pink Dogwood Tree Double Sided IN STOCK (1)
91 222 273207820004 Yorkie Garden Flag Beware Of Dog Yard Decor Funny IN STOCK (1)
92 223 273807820001 Firefighting Garden Flag Fire & Rescue Double Side IN STOCK (1)
93 224 272907820009 Welcome Garden Flag Sunflower Floral Double Sided IN STOCK (1)
94 225 273207820001 Custom Dog Garden Flag Personalized Pet Photo & Na IN STOCK (1)
95 226 273507820001 Welcome To The Lake Garden Flag Cabin Double Sided IN STOCK (1)
96 227 273807820000 Fire & Rescue Garden Flag Firemans Cross Firefight IN STOCK (1)
97 228 272907820004 Welcome Garden Flag Yellow Tulips Double Sided Yar IN STOCK (1)
98 229 273607820003 Halloween Garden Flag Trick Or Treat Double Sided IN STOCK (1)
99 230 272907820007 Welcome Friends Garden Flag Orange Flower Yard Dec IN STOCK (1)
100 231 272907820010 Welcome Garden Flag Floral Decor Orange Green Flow IN STOCK (1)
101 232 272907820011 Bible Verse Garden Flag Deuteronomy 31:6 Be Strong IN STOCK (1)
102 233 272907820000 Welcome Garden Flag Monarch Butterfly Double Sided IN STOCK (1)
103 234 272907820002 WTF Where's The Fish Garden Flag Double Sided Yard IN STOCK (1)
104 235 272707820000 Beach Life Rocks Garden Flag Live Laugh Love Doubl IN STOCK (1)
105 236 272807820001 Welcome Garden Flag Lighthouse Yard Banner Beach D IN STOCK (1)
106 237 272807820004 Custom Pet Bereavement Garden Flag Emotes Forever IN STOCK (1)
107 238 273607820001 Happy Halloween Garden Flag Witches Trick Or Treat IN STOCK (1)
108 239 273207820002 Garden Flag Wine A Bit Funny Drinking Yard Banner IN STOCK (1)
109 240 272907820003 Welcome Garden Flag Purple & White Tulips Double S IN STOCK (1)
110 241 272807820003 Fleur De Lis Garden Flag Emotes Double Sided Welco IN STOCK (1)
111 242 273707820001 Happy Easter Garden Flag Wreath Bunny Eggs Double IN STOCK (1)
112 243 273207820010 Funny Dog Garden Flag Beware Of Dog Black Lab Labr IN STOCK (1)
113 244 273207820003 Cat Garden Flag Spoiled Cats Live Here Double Side IN STOCK (1)
114 245 272807820000 Beach Life Garden Flag Colorful Shells Double Side IN STOCK (1)
115 246 272907820001 Bible Verse Garden Flag Psalm 62:5 My Soul Double IN STOCK (1)
116 247 274007820001 Merry Christmas Garden Flag Winter Double Sided Ya IN STOCK (1)
117 248 273607820002 Halloween Garden Flag Happy Haunting Trick Or Trea IN STOCK (1)
118 249 272907820005 Welcome Garden Flag Pink Flowers Yard Banner Decor IN STOCK (1)
119 250 273207820000 Funny Cat Garden Flag Beware Of Cat Double Sided Y IN STOCK (1)
120 251 273207820011 Funny Black Lab Puppy Garden Flag Beware Of Dog Do IN STOCK (1)
121 252 272907820013 He Is Risen Garden Flag Easter Yard Banner Double IN STOCK (1)
122 253 272907820018 Home Is Where The Heart Is Floral Garden Flag Emot IN STOCK (1)
123 254 274107820003 Happy Campers Garden Flag Double Sided Camping Yar IN STOCK (1)
124 255 272907820012 Inspirational Garden Flag Psalm 34:4 I Sought The IN STOCK (1)
125 256 274007820002 Merry Christmas Garden Flag Flannel Evergreen Tree IN STOCK (1)
126 257 272807820002 Bereavement Garden Flag Forever Loved Heart In Sky IN STOCK (1)
127 258 273207820014 Funny Boxer Garden Flag Beware Of Dog Double Sided IN STOCK (1)
128 260 272607820000 Oak Tree Leaf & Acorn Plant Hanger Decorative Cast IN STOCK (1)
129 261 273107820000 Fleur De Lis Plant Hanger Ornate Cast Iron flower IN STOCK (1)
130 262 272607820007 Blooming Flower S Style Plant Hook Cast Iron Flowe IN STOCK (1)
131 263 273307820000 Duck Family Plant Hanger Flower Basket Hook Colorf IN STOCK (1)
132 267 255707820013 Bluejay S Style Plant Hook Cast Iron Flower Basket IN STOCK (1)
133 268 255707820011 Butterfly Plant Hanger Bracket Flower Pot Basket H IN STOCK (1)
134 272 272607820002 Plant Hanger Hanging Pot Flower Basket Hook Grape IN STOCK (1)
135 273 255707820014 Chickadee Bird S Style Plant Hook Cast Iron Flower IN STOCK (1)
136 274 272607820006 Rose Flower Bloom S Style Plant Hook Cast Iron Flo IN STOCK (1)
137 275 019707820011 Triple Wall Hook For Coat Hat & Scarf Or Bath Towe IN STOCK (1)
138 276 019707820014 Cast Iron Wall Hook Rack Ornate Victorian 4 Key Ho IN STOCK (1)
139 279 255700410004 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
140 280 273007820000 Decorative Rooster Plant Hanger Flower Hook Colorf IN STOCK (1)
141 281 273107820003 Cast Iron Plant Hanger Basket Hook Ornate Fleur De IN STOCK (1)
142 282 255700410002 Cast Iron Plant Hanger Ornate Pattern 10" Long Yar IN STOCK (1)
143 284 255707820020 Plant Hanger Chickadee Bird Cast Iron Flower Baske IN STOCK (1)
144 285 255707820012 Hummingbird S Style Plant Hook Cast Iron Flower Ba IN STOCK (1)
145 286 273007820001 Crowing Rooster Cast Iron Plant Hanger Farm Flower IN STOCK (1)
146 287 255707820007 Cast Iron S Style Plant Hook Hummingbird flower ba IN STOCK (1)
147 289 273007820004 Plant Hanger Bird Bath Feeder Cast Iron Hanging Fl IN STOCK (1)
148 290 272607820004 Decorative Plant Hanger Cast Iron Flower Basket Ho IN STOCK (1)
149 291 255707820021 Pixie Fairy Cast Iron Plant Hanger Verdigirs 9" De IN STOCK (1)
150 292 110102740002 Hummingbird Plant Hanger Cast Iron Flower Basket H IN STOCK (1)
151 293 255707820002 Decorative Plant Hanger Ornate Victorian Cast Iron IN STOCK (1)
152 294 255707820000 Plant Hanger Decorative Hummingbird Cast Iron Flow IN STOCK (1)
153 295 255707820003 Hummingbird Plant Hanger Flower Hook Decorative Ve IN STOCK (1)
154 297 272607820010 Plant Hanger Vine Brown Flower Basket Pot Hook Hol IN STOCK (1)
155 298 255707820016 Love Birds Cast Iron Decorative Plant Hanger Flowe IN STOCK (1)
156 299 255707820017 Birds In Tree Decorative Plant Hanger Cast Iron Fl IN STOCK (1)
157 300 272607820001 Rustic Cast Iron Plant Hanger Bracket Floral Desig IN STOCK (1)
158 301 110100410001 Cast Iron Plant Hanger Basket Hook Pixie Fairy Rus IN STOCK (1)
159 302 263907820000 Cast Iron S Style Plant Hook Flower Hanger Dragonf IN STOCK (1)
160 303 110100410004 Decorative Chickadee Bird Design Cast Iron Plant H IN STOCK (1)
161 304 255707820006 Decorative Watering Can Cast Iron Plant Hanger Hoo IN STOCK (1)
162 305 019707820016 Monkey Wall Hook Rack With 4 Cast Iron Hooks 10.25 IN STOCK (1)
163 308 820107820011 Garden Hose Holder Frogs On Lily Pads Cast Iron Ha IN STOCK (1)
164 309 820107820008 Welcome Garden Hose Holder Reel Butterflies & Flow IN STOCK (1)
165 310 820102740000 Cast Iron Garden Hose Holder Floral & Spade Patter IN STOCK (1)
166 311 820107820010 Garden Hose Holder Reel Cast Iron Hanger Birds On IN STOCK (1)
167 312 820107820006 Garden Water Hose Holder Rose Flower Hanger Reel IN STOCK (1)
168 313 820107820009 Cast Iron Garden Hose Holder Love Birds Garden Hos IN STOCK (1)
169 314 820107820014 Garden Hose Holder Hanger - Black Cast Iron Floral IN STOCK (1)
170 315 820107820012 Garden Water Hose Holder Birds In Tree Cast Iron H IN STOCK (1)
171 316 820107820003 Garden Hose Holder Gnome & Bunny Rabbit Distressed IN STOCK (1)
172 318 820107820013 Wall Mount Garden Hose Holder Floral & Spade Verdi IN STOCK (1)
173 319 820107820000 Garden Hose Holder Cast Iron Hanger Reel Watering IN STOCK (1)
174 322 820107820002 Garden Hose Holder Water Pail Bucket Verdigris Cas IN STOCK (1)
175 324 IWHSH0020 Garden Hose Holder Birds On Branch 9" Wide Verdigr IN STOCK (1)
176 325 820100410001 Hose Holder Reel Cast Iron Horse & Horseshoe Yard IN STOCK (1)
177 326 019707820000 Nautical Black & White Lighthouse Wall Hook Decora IN STOCK (1)
178 328 019707820009 Horse Head Western Wall Hook Rust Brown Cast Iron IN STOCK (1)
179 329 019700410014 Mermaid Wall Hook Rust Cast Iron Coat Hanger Ocean IN STOCK (1)
180 330 019707820004 Wall Hook Skeleton Key Coat Rack Antique Style 3 H IN STOCK (1)
181 333 019707820003 Seahorse Wall Hook Ocean Decor Rust Brown Decorati IN STOCK (1)
182 334 019707820018 Horse Head Horseshoe Western Double Wall Hook Rust IN STOCK (1)
183 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 183

Set Descending Direction
Page
per page
  1. Mounting Wall Mounted Remove This Item
  2. Manufacturer Flag Emotes Remove This Item
Clear All
Shopping Options
Compare Products
You have no items to compare.
My Wish List
Last Added Items
You have no items in your wish list.
Copyright © 2023-present Chillicothe Market All rights reserved.