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

IN STOCK: 75 | OUT OF STOCK: 0
ID SKU Name Stock Status
953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK (1)
1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK (1)
1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK (1)
1164 229207820005 Please Close The Gate Sign Decorative Plaque Cast IN STOCK (1)
1165 274207820001 Chicken Trivet Decorative Cast Iron Hot Pad 7.75" IN STOCK (1)
1173 275453524384 Vintage Cracker Jack Gumball prize charm Man on R IN STOCK (1)
1172 275453521123 Vintage Cracker Jack Gumball prize charm celluloid IN STOCK (1)
1678 930907820002 Rustic Cast Iron Welcome Bell Vintage Wall Mount D IN STOCK (1)
1727 019700410046 Cast Iron Wall Hook Rack Fish Bone Skeleton Hooks IN STOCK (1)
1724 246407820001 13" Brown Cast Iron Turtle Stepping Stone Decorati IN STOCK (1)
1740 142307820000 Aluminum Sign Coffee Cappuccino Mocha Espresso Fra IN STOCK (1)
1738 273007820003 Cast Iron Pedestal Bird Feeder Bath 8" Wide Decora IN STOCK (1)
1739 930907820000 Cast Iron Horse Dinner Bell – Rustic Brown Wall IN STOCK (1)
1744 261207820002 Funny Aluminum Sign No Poop Heads Allowed Man & Wo IN STOCK (1)
1750 277025938599 Yardbird Fire Table Cover CVFTRERB Rectangular Bei IN STOCK (1)
1756 277037812053 Genuine Amazon Alexa Voice Remote (3rd Gen) with T IN STOCK (1)
1758 277039604836 Nick JR Dora The Explorer Wall Sticker Decal Nicke IN STOCK (1)
1755 277037180702 SaharaCase - Office Mouse Pad with Wireless Chargi IN STOCK (1)
1768 277056810230 The Jimi Hendrix Experience Electric Ladyland Dbl IN STOCK (1)
1767 277056763782 The Jimi Hendrix Experience Electric Ladyland Dbl IN STOCK (1)
1766 163807820000 Firefighting Firemans Cross Hanging Wall Plaque Ru IN STOCK (1)
1775 277061995342 MICHAEL BUBLE' - "Michael Buble' Christmas" Christ IN STOCK (1)
1822 266107820001 Funny Dachshund Sign Don't Trip Over My Wiener Dog IN STOCK (1)
1819 144307820001 Personalized Man Cave Aluminum Sign Custom Dartboa IN STOCK (1)
1823 829800250004 Longaberger Traditions Handle Tie Collectible Acce IN STOCK (1)
14 254107820000 Wall Shelf Bracket Decorative Cast Iron Brace Orna IN STOCK (1)
15 254107820020 Wall Shelf Bracket Brace With Plant Hanger Flower IN STOCK (1)
1872 272207820000 Large Rolling Plant Caddy Fleur De Lis IN STOCK (1)
1873 273607820000 Decorative Cast Iron Rooster Trivet Kitchen Decor IN STOCK (1)
1874 197107820000 Turtle Hide A Key Box Distressed Brown Cast Iron G IN STOCK (1)
1875 284109859464 Disney’s Baby Mickey Mouse Wall Border ABC Nurse IN STOCK (1)
1269 019707820007 Skeleton Key Style Wall Hook Coat Rack Victorian 4 IN STOCK (1)
2051 286367402132 Decorative Cast Iron Snail Stepping Stone – Gard IN STOCK (1)
2057 197100410002 Cast Iron Shelf Bracket Fleur-de-Lis Wall Brace De IN STOCK (1)
2053 286367593981 New England Patriots Rawlings Cooler Tote Holds 30 IN STOCK (1)
2080 237107820000 Human Footprint Stepping Stone Pair Feet Cast Iron IN STOCK (1)
2363 019707820019 Decorative Double Wall Hook Love Birds Rust Brown IN STOCK (1)
2360 019707820020 Rustic Cast Iron Antler Wall Hook Rack Deer Lodge IN STOCK (1)
2367 019707820006 Cast Iron Skeleton Key Wall Hook Rack – 3 Hook R IN STOCK (1)
1791 273907820002 Frog Hide A Key Box Distressed Brown Cast Iron Gar IN STOCK (1)
1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK (1)
1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK (1)
1166 198507820003 Double Sided Hanging Welcome Sign Ornate Cast Iron IN STOCK (1)
1167 274811615606 Harley Quinn Costume Girl M (8-10) DC Super Hero G IN STOCK (1)
1174 275453537797 Vintage Cracker Jack Gumball prize charm faded pur IN STOCK (1)
1175 275458939770 vintage Cracker Jack Gumball charm prize toy: Gree IN STOCK (1)
1176 275458944602 vintage Cracker Jack Gumball charm prize toy: Red IN STOCK (1)
1180 275459274008 vintage Cracker Jack charm prize Metallized Plasti IN STOCK (1)
1177 275458949486 vintage Cracker Jack charm prize Boy on Bicycle (m IN STOCK (1)
1179 275459221209 vintage Cracker Jack charm prize Silvery Plastic P IN STOCK (1)
1737 273707820003 Happy Easter Spring Flowers Birds Garden Flag Emot IN STOCK (1)
1736 322207820000 Fish Pocket Beer Bottle Opener Handheld Brown Cast IN STOCK (1)
1743 322207820002 Wall Mounted Skull Beer Bottle Opener Cast Iron Ho IN STOCK (1)
1752 277032581994 CyberPower 1500VA Battery Back-Up System UPS 10 Ou IN STOCK (1)
1754 277036995257 Sanus BSA-IWP701-W1 In-Wall Power Kit AV Cable Man IN STOCK (1)
1751 277029661358 Barbie Toy Wall Stickers Girls Bedroom Decals Deco IN STOCK (1)
1764 277047254859 10" Twin Intex Standard Dura-Beam Airbed Mattress IN STOCK (1)
1760 277040873020 Computer Chair Floor Mat 30 x 48 inches Clear Floo IN STOCK (1)
1763 277046740996 Simpli Home Grafton Round Pouf 20" x 20" x 14" Tea IN STOCK (1)
1772 277059334344 TO LIVE AND DIE IN LA New Sealed 4K Ultra HD UHD W IN STOCK (1)
1773 277059755739 4 LED Reading Light Dimmable Quad Light - Withit - IN STOCK (1)
1769 277056857730 Ultraman Blu-ray - Ultraman: Complete Series 02 Ne IN STOCK (1)
951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK (1)
19 254107820008 Wall Shelf Bracket Large Fleur De Lis Cast Iron Br IN STOCK (1)
18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK (1)
23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis Verdigris C IN STOCK (1)
27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 IN STOCK (1)
1868 198507820002 Flamingo Welcome Plaque Brown Cast Iron Beach Them IN STOCK (1)
900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK (1)
2066 286393686543 Victrola Eastwood Signature Record Player With Blu IN STOCK (1)
2081 272607820003 13.75" Cast Iron Plant Hanger Bracket – Decorati IN STOCK (1)
2358 255707820018 Cast Iron Plant Hanger Bracket Hummingbird Vine Ho IN STOCK (1)
2364 148107820000 Video Gaming Aluminum Sign Gamer Zone Characters C IN STOCK (1)
2366 261207820001 Funny Aluminum Sign No Poop Heads Allowed Women Ho IN STOCK (1)
2365 273207820008 French Bulldog Beware Of Dog Double Sided Funny Pe 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-75 of 75

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Primary Color Brown Remove This Item
  2. Lining Material Wool Remove This Item
Clear All
Shopping Options
Category
  1. Garden Flags 2 items
  2. Doorbells 2 items
  3. Wall Hooks 1 item
  4. Stepping Stones 3 items
  5. Signs 10 items
Set Includes
  1. 1 Shelf Bracket 5 items
  2. Kickplate / toe kick 68 items
  3. Shelf Brackets 1 item
  4. Wall Mounted Hose Hanger 1 item
Outsole Material
  1. Suede 75 items
Accents
  1. big girls 3 items
  2. Buckle 42 items
  3. Flower 6 items
  4. Logo 7 items
  5. Thick Laces 17 items
  6. wool lining 3 items
Calf Width
  1. Regular 75 items
Platform Height
  1. 1.25 in 75 items
Shape
  1. Foot Print 69 items
  2. Triangle 6 items
Item Weight
  1. 1 lb 1 item
  2. 2 lb 3 items
  3. 3 lbs 2 items
  4. 5.875000 69 items
Finish
  1. Distressed Brown 2 items
  2. Glossy 4 items
  3. Matt 17 items
  4. Painted 52 items
Product Line
  1. BearPaw 75 items
Room
  1. Any 6 items
  2. Any Room 69 items
Personalized
  1. No 75 items
Mounting
  1. Wall Mounted 75 items
Indoor Outdoor
  1. Indoor & Outdoor 75 items
Suitable For
  1. Coats, Towels, Hats 69 items
  2. Shelves 5 items
  3. Wall Shelf, Mail Box Mount 1 item
Subject
  1. American Flag 4 items
  2. Barbies 5 items
  3. Beer 1 item
  4. Close The Gate 5 items
  5. Coffee 4 items
  6. Cows 4 items
  7. Dachshund 2 items
  8. Darts 1 item
  9. Dog 3 items
  10. Dora The Explorer 4 items
  11. Fire & Rescue 10 items
  12. Foot Print 3 items
  13. Snail 6 items
  14. Unicorns 1 item
  15. Video Games 1 item
  16. Welcome 17 items
  17. Wine 3 items
  18. You Need A Drink 1 item
Assembly Required
  1. No 72 items
  2. Yes 3 items
Hook Style
  1. Traditional 75 items
Shoe Shaft Style
  1. Ankle 45 items
  2. Low Top 30 items
Manufacturer
  1. Amazon 1 item
  2. Brewster 2 items
  3. Cracker Jack 8 items
  4. CyberPower 1 item
  5. Disney 1 item
  6. Flag Emotes 24 items
  7. Floortex 1 item
  8. Holiday Home 2 items
  9. Import Wholesales 20 items
  10. Intex 1 item
  11. Longaberger 1 item
  12. Maryanne 1 item
  13. Mr. Sandman 1 item
  14. Rawlings 1 item
  15. Rubie's 1 item
  16. Sahara 1 item
  17. Sanus 1 item
  18. Simpli Home 1 item
  19. Sony Legacy 1 item
  20. Unknown 1 item
  21. Victrola 1 item
  22. Withit 2 items
  23. Yardbird 1 item
Color
  1. Beige 2 items
  2. Black 12 items
  3. Brown 42 items
  4. Clear 1 item
  5. Gray 1 item
  6. Green 5 items
  7. Multicolor 1 item
  8. Red 6 items
  9. Red, Black 1 item
  10. Teal 2 items
  11. Verdigris 1 item
  12. White 1 item
Us Shoe Size
  1. 10 1 item
  2. 13 1 item
  3. 4 19 items
  4. 6 41 items
  5. 7.5 10 items
  6. Kids 4-5 3 items
Department
  1. Adult 29 items
  2. Adults 17 items
  3. Adults, Kids, Teens 2 items
  4. Girls 3 items
  5. Kids 1 item
  6. Unisex Adults 2 items
  7. Unisex Kids 3 items
  8. Women 18 items
Occasion
  1. Activewear 9 items
  2. Activewear, Casual 6 items
  3. All Occasions 3 items
  4. Any 4 items
  5. Casual 3 items
  6. Casual, Workwear 6 items
  7. Christmas 12 items
  8. Easter 22 items
  9. Fall 1 item
  10. Formal, Party/Cocktail, Travel, Wedding 3 items
  11. Summer 6 items
Style
  1. Antique 1 item
  2. Antique Style 6 items
  3. Beach 1 item
  4. Bootie 3 items
  5. Classic Rock, Hard Rock 10 items
  6. Complete Outfit 1 item
  7. Country 4 items
  8. Decorative 2 items
  9. Firefighting 1 item
  10. Flats and Slip Ons 3 items
  11. French Country 2 items
  12. Kid's 1 item
  13. Long Sleeve 8 items
  14. Nautical 16 items
  15. Novelty 1 item
  16. Rustic 1 item
  17. Rustic/Primitive 6 items
  18. Slip-On 2 items
  19. Strappy 1 item
  20. Victorian 3 items
  21. Victorian Style 2 items
Heel Height
  1. High (3-3.9 in) 75 items
Upper Material
  1. 100% Nylon 3 items
  2. Beads 3 items
  3. Faux Suede 17 items
  4. Not Available 1 item
  5. Suede 3 items
  6. Synthetic 48 items
Price
  1. $0.00 - $99.99 74 items
  2. $100.00 and above 1 item
Toe Shape
  1. Round Toe 75 items
Closure
  1. Lace Up 7 items
  2. Pull On 20 items
  3. Slip On 48 items
Heel Style
  1. Stiletto 75 items
Theme
  1. Bar & Club 1 item
  2. Bar & Club, Humor, Novelty 2 items
  3. Barbie 5 items
  4. Beach 1 item
  5. Cartoons 4 items
  6. Chickens 2 items
  7. Close The Gate 2 items
  8. Coffee 1 item
  9. College 6 items
  10. DC Super Heroes 9 items
  11. Dogs 2 items
  12. Firefighting 10 items
  13. Fleur De Lis 7 items
  14. French Bulldog 1 item
  15. Holiday 3 items
  16. Man Cave 1 item
  17. Outdoor 3 items
  18. Rhinestones 1 item
  19. Skull 3 items
  20. Sports 1 item
  21. Squirrel 1 item
  22. Turtles 1 item
  23. Unicorns 1 item
  24. United States 1 item
  25. Video Games 1 item
  26. Vintage 3 items
  27. Welcome 2 items
Shoe Width
  1. Medium 42 items
  2. Standard 27 items
  3. W 6 items
Insole Material
  1. Memory Foam 72 items
  2. Wool 3 items
Fabric Type
  1. Shearling 75 items
Season
  1. Fall 3 items
  2. Fall, Spring, Summer 7 items
  3. Fall, Spring, Summer, Winter 17 items
  4. Spring 3 items
  5. Spring, Summer 48 items
  6. Winter 3 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.