• 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'))
 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 ALL Products (Stock Status Check):

IN STOCK: 35 | OUT OF STOCK: 0
ID SKU Name Stock Status
773 273407820003 Heart Shaped Trivet Ornate Decorative Cast Iron Fl IN STOCK (1)
775 273407820005 Square Trivet Black Cast Iron Decorative Ornate Di IN STOCK (1)
777 273407820002 Cast Iron Trivet Round Ornate Heart Scrollwork Des IN STOCK (1)
776 273407820001 Decorative Cast Iron Trivet Ornate Heart Design Ro IN STOCK (1)
29 254107820012 Decorative Shelf Bracket Ornate Leaf Brace Rust Br IN STOCK (1)
780 203707820000 Decorative Cast Iron Trivet Chilli Peppers Kitchen IN STOCK (1)
794 IWSTS0018 Cast Iron Footprint Stepping Stones - Garden Pathw IN STOCK (1)
793 269907820001 Butterfly Stepping Stone Verdigris Cast Iron 11" W IN STOCK (1)
410 276793574596 Women's Marsha Ankle Boots Zip Up Pointed Toe - B IN STOCK (1)
770 276821346666 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
779 203707820001 Tea Kettle Trivet Ornate Decorative Cast Iron Kitc IN STOCK (1)
784 266107820000 Welcome To My Garden Hummingbird Stepping Stone Pl IN STOCK (1)
781 274207820000 Cast Iron Nautical Anchor Trivet Hot Plate Rustic IN STOCK (1)
30 197100410009 Wall Shelf Bracket Brace Black Cast Iron Scrolling IN STOCK (1)
33 254007820008 Hummingbird Wall Shelf Bracket Cast Iron Brace Cra IN STOCK (1)
416 286234217652 Women's Boots with Memory Foam Insole - Celina Bla IN STOCK (1)
846 286278494687 Allegra K Women's Lace Mesh Floral Embroidered Sti IN STOCK (1)
849 286278436738 Women's Aurora Water Shoes Black Sz 6 IN STOCK (1)
28 254107820022 Wall Shelf Bracket Brown Cast Iron Brace Custom Sh IN STOCK (1)
785 272507820003 Heart & Foot Prints Welcome Plaque Cast Iron Stepp IN STOCK (1)
24 254107820001 Decorative Angle Bracket Cast Iron Shelf Brace Gol IN STOCK (1)
788 246407820002 LARGE Turtle Stepping Stone Paver Decorative Cast IN STOCK (1)
32 254107820002 Angle Bracket Cast Iron Wall Shelf Brace Decorativ IN STOCK (1)
415 276793633196 Women's Chunky Heel Boots - Dolly Black Stylish & IN STOCK (1)
774 273907820001 Decorative Cast Iron Trivet Owl Hot Pad Kitchen De IN STOCK (1)
778 203707820002 Decorative Cast Iron Fish Trivet Kitchen Decor Hot IN STOCK (1)
783 237107820001 Decorative Welcome Stepping Stone Plaque Footprint IN STOCK (1)
16 254007820004 Wall Shelf Bracket Brace Fleur De Lis Verdigris Ca IN STOCK (1)
17 254007820007 Fleur De Lis Wall Shelf Bracket Cast Iron Ornate B IN STOCK (1)
782 229207820000 Decorative Sitting Green Frog Stepping Stone Cast IN STOCK (1)
787 229207820002 Decorative Cast Iron Yard & Garden Stepping Stone IN STOCK (1)
31 254007820001 Decorative Cast Iron Wall Shelf Bracket Brace Bird IN STOCK (1)
792 246407820003 Decorative Baby Turtles Stepping Stone Rust Cast I IN STOCK (1)
762 286251265340 Dearfoams Women's Pumpkin Slide Slippers Jack-O-La IN STOCK (1)
879 286280138492 Women's Sterling Chelsea Boots Zip Up Ankle Bootie 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-35 of 35

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Lining Material Polyester Remove This Item
  2. Insole Material Memory Foam Remove This Item
Clear All
Shopping Options
Category
  1. Stepping Stones 9 items
  2. Trivets 9 items
Set Includes
  1. 1 Shelf Bracket 8 items
  2. Shelf Brackets 1 item
  3. Wall Mounted Hose Hanger 25 items
Outsole Material
  1. EVA 25 items
  2. Leather & Rubber 6 items
  3. Rubber 1 item
  4. Suede 3 items
Accents
  1. Elastic 1 item
  2. Floral Pattern 2 items
  3. Heel Strep 23 items
  4. Logo 6 items
  5. Silver Toe 3 items
  6. Zipper 1 item
Calf Width
  1. Regular 34 items
Platform Height
  1. 1.25 in 34 items
Primary Color
  1. Black 15 items
  2. Brown 14 items
  3. Cream 1 item
  4. Distressed Brown 2 items
  5. Gold 1 item
  6. Multicolor 2 items
Shape
  1. Butterfly 1 item
  2. Foot Print 3 items
  3. Frog 5 items
  4. J Hook 14 items
  5. Triangle 9 items
  6. Turtle 2 items
Item Weight
  1. 1.5 lb 2 items
  2. 1.5 lbs 14 items
  3. 2 lb 6 items
  4. 2 lbs 1 item
  5. 4.5 lb 3 items
  6. 5 lb 1 item
  7. 5.875000 3 items
  8. 6 lbs 4 items
Finish
  1. Distressed 1 item
  2. Matte 6 items
  3. Painted 27 items
Product Line
  1. Junie 32 items
  2. Troy 3 items
Room
  1. Any 8 items
  2. Any Room 25 items
  3. Bathroom 1 item
Personalized
  1. No 34 items
Mounting
  1. Wall 1 item
  2. Wall Mounted 33 items
Indoor Outdoor
  1. Indoor & Outdoor 15 items
  2. Outdoor 19 items
Suitable For
  1. Coats, Towels, Hats 25 items
  2. Custom Shelves 4 items
  3. Shelves 5 items
Subject
  1. Boxer Dog 14 items
  2. Butterfly 1 item
  3. Close The Gate 6 items
  4. Foot Print 3 items
  5. Frog 7 items
  6. Turtle 2 items
  7. United States 1 item
Assembly Required
  1. No 32 items
  2. Yes 2 items
Hook Style
  1. Traditional 34 items
Shoe Shaft Style
  1. Ankle 4 items
  2. Low Top 31 items
Manufacturer
  1. Carla 3 items
  2. Dearfoams 1 item
  3. Flag Emotes 21 items
  4. Issa 2 items
  5. Kev 1 item
  6. Persephone 1 item
  7. Unos 6 items
Color
  1. Black 7 items
  2. Bronze 1 item
  3. Brown 12 items
  4. Cream 2 items
  5. Gold 1 item
  6. Green 3 items
  7. Light Green 1 item
  8. Multi-Color 1 item
  9. Multicolor 2 items
  10. Verdigris 3 items
  11. White 2 items
Us Shoe Size
  1. 13 5 items
  2. 6 2 items
  3. 8 1 item
  4. 8.5 1 item
  5. 9 2 items
  6. 9.5 1 item
  7. L 9-10 22 items
  8. XL 11-12 1 item
Department
  1. Adults 9 items
  2. Women 26 items
Occasion
  1. Activewear, Casual 6 items
  2. All Occasions 14 items
  3. Any 6 items
  4. Business 5 items
  5. Casual 9 items
  6. Formal 2 items
  7. Party/Cocktail 4 items
  8. Travel 5 items
  9. Wedding 2 items
  10. Workwear 2 items
Style
  1. ankle boots 1 item
  2. Antique 5 items
  3. Antique Style 1 item
  4. Bootie 2 items
  5. Boots 1 item
  6. French Country 1 item
  7. Mule 2 items
  8. Nautical 10 items
  9. Rustic 1 item
  10. Slide 2 items
  11. Traditional 7 items
  12. Vintage/Retro 2 items
Heel Height
  1. 3.25 in 3 items
  2. Flat (Under 1 in) 23 items
  3. High (3-3.9 in) 3 items
  4. Mid (2-2.9 in) 6 items
Upper Material
  1. Beads 6 items
  2. Faux Leather 2 items
  3. Faux Suede 1 item
  4. Lace Mesh 2 items
  5. Not Available 1 item
  6. Polyester 23 items
Price
  1. $0.00 - $9.99 8 items
  2. $10.00 - $19.99 20 items
  3. $20.00 and above 7 items
Toe Shape
  1. Pointed Toe 4 items
  2. Round Toe 25 items
  3. Square Toe 6 items
Closure
  1. Lace Up 6 items
  2. Pull On 1 item
  3. Slip On 25 items
  4. Zip 3 items
Heel Style
  1. Approximately 1.75 Inches Block Heel 1 item
  2. Block 25 items
  3. Kitten 6 items
  4. Stiletto 3 items
Theme
  1. Animals 1 item
  2. Birds 2 items
  3. Butterflies 2 items
  4. Classic 1 item
  5. Cooking 1 item
  6. Cowgirl, Cowgirl Core, Western, Cowgirlcore, Cowgirl Couture 3 items
  7. Fish 1 item
  8. Fleur De Lis 3 items
  9. Floral 1 item
  10. Flower 2 items
  11. Frog 1 item
  12. Gothic 1 item
  13. Halloween 2 items
  14. Hummingbirds 1 item
  15. Love & Hearts 1 item
  16. Nautical 5 items
  17. Owl 4 items
  18. Teapot 1 item
  19. Turtle 1 item
  20. Vines 1 item
Shoe Width
  1. Medium 1 item
  2. Standard 34 items
Fabric Type
  1. Knit 9 items
  2. Shearling 26 items
Season
  1. Fall 27 items
  2. Fall, Spring, Summer 6 items
  3. Spring 4 items
  4. Summer 4 items
  5. Winter 26 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.