• 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: 73 | OUT OF STOCK: 4
ID SKU Name Stock Status
3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK (0)
11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe Grill Rotis OUT OF STOCK (0)
3117 286550852026 Funko Pop! Vinyl: Indiana Jones - Indiana Jones #1 IN STOCK (1)
11961 286566328311 Kenwood KFC 1666R 6.5 Inch Coaxial Car Speakers 30 IN STOCK (1)
11962 286565954268 Pioneer A-Series TS-A653FH 6.5" 2-Way 340 W Max Po IN STOCK (1)
11963 286563364559 Pioneer 2-Way Speaker TS-G650 300W Max 6 1/2 / 6 3 IN STOCK (1)
11965 286556227610 The Object of Beauty DVD Movie Full Screen John Ma IN STOCK (1)
11966 286556269735 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11967 286560717312 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11968 286560727712 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK (1)
11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK (0)
11970 286563566917 Genuine Dyson Wall Mount Docking Station for V11 / IN STOCK (1)
11971 286566095118 Core Innovations - Amplified Bar HDTV Indoor Anten IN STOCK (1)
11972 286568323356 Baby Monitor VTech DM221 Digital Audio Talk Back I IN STOCK (1)
11973 286568347758 CyberPower 650VA Battery Back-Up System 360W - Bla IN STOCK (1)
13279 286571172223 Pioneer TS-WX1010A - 10" Active Sealed subwoofer w IN STOCK (1)
13400 286571370525 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK (1)
14633 286573689044 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK (1)
19014 286581315080 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK (1)
20802 286584503041 Vava EVOLVE Split View Screen Baby Monitor (2x 720 IN STOCK (1)
23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Smart LED Lig IN STOCK (1)
1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK (1)
2404 277064207987 Carrie Underwood My Gift First-Ever Christmas Albu IN STOCK (1)
2405 277064611176 Yogasleep Rohm Portable White Noise Machine Travel IN STOCK (1)
2406 277066203475 CASETiFY - Ultra Impact Bounce Case for Apple AirP IN STOCK (1)
3071 277069846799 CASETiFY - Mirror Airpods Case for Apple AirPods P OUT OF STOCK (0)
3072 277069870238 Kate Spade New York - Protective Case Apple Airpod IN STOCK (1)
3085 277074520169 Yogasleep Hushh White Noise Machine Portable Sound 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)
3113 277093424276 FUNKO POP! MOVIES: The Last Crusade - Henry Jones IN STOCK (1)
3112 277093398774 FUNKO POP! MOVIES: Raiders of the Lost Ark - Arnol IN STOCK (1)
3111 277093334750 SUPER7 RUN DMC Joseph "RUN" Simmons ReAction Figur IN STOCK (1)
11956 277098598300 The Real Mccoy DVD Action Crime Kim Basinger Val K IN STOCK (1)
14741 277115995062 CoComelon My First Sing-Along Boombox Music Toy Mi IN STOCK (1)
1823 829800250004 Longaberger Traditions Handle Tie Collectible Acce IN STOCK (1)
1833 218107280003 Holiday Home Snowman Pattern Mug China Tableware C IN STOCK (1)
1834 268507820000 Lady Bug Hide A Key Box Distressed Brown Cast Iron IN STOCK (1)
1835 198507820000 Welcome Garden Sign Pink Flowers Black Cast Iron Y IN STOCK (1)
1842 137607820000 Aluminum Sign You Need A Beer Home Bar Man Cave Wa IN STOCK (1)
2374 286476757005 Ooni Digital Infrared Thermometer Pizza Oven Calib IN STOCK (1)
2377 286477126573 Cyberpower SE450G1 450 VA Battery Backup UPS 8-Out IN STOCK (1)
2373 286476641474 Bromic BH3130010-1 On/Off Switch for Electric and IN STOCK (1)
2381 286485819828 MOBICam HDX Smart HD Pan & Tilt Wi-Fi Baby Monitor IN STOCK (1)
2380 286479184706 Yardbird Harriet Sofa Cover CVHA100 Beige Outdoor IN STOCK (1)
2379 286479095271 Yardbird - Harriet Fixed and Swivel Chair Cover - IN STOCK (1)
2398 286514389783 The Raid: Redemption [New 4K UHD Blu-ray] Ltd Ed, IN STOCK (1)
2396 286514205283 Absolutely Fabulous: Absolutely All of It! New DVD IN STOCK (1)
2397 286514279050 Horror Hall of Fame Movie 5 DVD Boxset 26 Classic IN STOCK (1)
2408 286523721442 Blue's Clues Wall Stickers Kids Bedroom Decor Nick IN STOCK (1)
2409 286524824693 Nickelodeon Rug Rats Kids Bedroom Wall Decor Stick IN STOCK (1)
3105 286536199218 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
3102 286533522689 Looking Glass DVD Movie, 2018 Nicolas Cage Brand N IN STOCK (1)
3093 277079003347 Blumhouse's The Craft: Legacy DVD Movie The Ritual IN STOCK (1)
1824 273907820000 Cast Iron Skillet Wall Hanging Holstein Dairy Cow IN STOCK (1)
3110 277091711997 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
3114 277093437505 Funko Pop! Pin Star Wars Max Rebo SE Target Exclus IN STOCK (1)
11958 277105767269 Sahara - Universal Mouse Pad with Wireless Chargin IN STOCK (1)
11957 277103109122 Snake Eyes (DVD, 1999, Sensormatic) Nicolas Cage G IN STOCK (1)
11959 277108023030 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
11960 277108609311 Pioneer TS-A30S4 1400 Watt 12" 4 Ohm Car Audio Sub IN STOCK (1)
1861 144907820000 Aluminum Sign Kitchen Rules Wall Hanging Plaque 12 IN STOCK (1)
2371 163807820004 Aluminum Sign Firemans Cross Diamond Plate Firefig IN STOCK (1)
2386 286497320411 Matchbox Twenty Where Light Goes Vinyl LP Alternat IN STOCK (1)
2383 286491389772 MOBICam Pro 2 Pk Smart HD Pan Tilt Wi-Fi Baby Moni IN STOCK (1)
2389 286498061560 LSU Tigers Stickers Wall Art Self-Adhesive Diecut IN STOCK (1)
2392 286502060821 Gamma Photon Outdoor Pickleballs High-Vis Yellow U IN STOCK (1)
2394 286513849072 Funko Pop! Deluxe: Jabba's Skiff: Luke Skywalker - IN STOCK (1)
2393 286502109409 Farberware Professional Secure Fit Funnel Removabl IN STOCK (1)
2402 286515110514 Judy Blume Welcome to the Hilarious World of Fudge IN STOCK (1)
2403 286515151853 THE BEST OF PENTATONIX CHRISTMAS [10/25] NEW CD Se IN STOCK (1)
2399 286514692829 Dr. Strangelove: Or How I Learned To..Love The Bom IN STOCK (1)
3099 286533381922 Fitbit Charge 5 Fitness and Health Tracker Smart W IN STOCK (1)
3100 286533401449 Blue Beetle (DVD, 2023) Brand New Sealed DC Comics IN STOCK (1)
3101 286533471775 The Forgiven (DVD, 2017 Widescreen) New Factory Se IN STOCK (1)
3106 286538461512 Splendor in the Grass [New DVD] NTSC Format Sealed IN STOCK (1)
3107 286538539841 My Foolish Heart DVD Movie Full Frame New Sealed 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-77 of 77

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Finish Glossy Remove This Item
  2. Lining Material Wool Remove This Item
Clear All
Shopping Options
Category
  1. Signs 6 items
Set Includes
  1. Kickplate / toe kick 77 items
Outsole Material
  1. Suede 77 items
Accents
  1. Buckle 9 items
  2. Glow-In-The-Dark, Hooded 67 items
  3. Thick Laces 1 item
Calf Width
  1. Regular 77 items
Platform Height
  1. 1.25 in 77 items
Primary Color
  1. Beige 16 items
  2. Black 36 items
  3. Blue 2 items
  4. Brown 4 items
  5. Chestnut 4 items
  6. Clear 1 item
  7. Gray 4 items
  8. Light Blue 1 item
  9. Multicolor 6 items
  10. Silver 1 item
  11. White 2 items
Shape
  1. Foot Print 77 items
Item Weight
  1. 5.875000 77 items
Product Line
  1. BearPaw 77 items
Room
  1. Any Room 77 items
Personalized
  1. No 77 items
Mounting
  1. Wall Mounted 77 items
Indoor Outdoor
  1. Indoor & Outdoor 77 items
Suitable For
  1. Coats, Towels, Hats 77 items
Subject
  1. Beer 2 items
  2. Cows 3 items
  3. Dachshund 2 items
  4. Darts 1 item
  5. Firefighting 67 items
  6. Floral 1 item
  7. You Need A Drink 1 item
Assembly Required
  1. No 77 items
Hook Style
  1. Traditional 77 items
Shoe Shaft Style
  1. Ankle 9 items
  2. Low Top 68 items
Manufacturer
  1. ARTISAN 1 item
  2. BBC Warner 2 items
  3. Bromic 1 item
  4. CASETiFY 2 items
  5. Cocomelon 1 item
  6. Core Innovations 1 item
  7. CyberPower 2 items
  8. Decor 1 item
  9. Dyson 2 items
  10. Farberware 1 item
  11. Fitbit 5 items
  12. Flag Emotes 3 items
  13. Funko 9 items
  14. Gamma 1 item
  15. Govee 1 item
  16. Holiday Home 1 item
  17. Import Wholesales 6 items
  18. International Wallcoverings 1 item
  19. Kamado Joe 1 item
  20. kate spade new york 1 item
  21. Kenwood 6 items
  22. Longaberger 1 item
  23. MOBI 3 items
  24. Ooni 1 item
  25. Pioneer 5 items
  26. Sahara 1 item
  27. Sony Pictures 5 items
  28. Sony Pictures Home Entertainment 1 item
  29. Super7 1 item
  30. Traeger Industries 1 item
  31. Vava 1 item
  32. VTech 1 item
  33. Warner 1 item
  34. Warner Archives 2 items
  35. Yardbird 2 items
  36. Yogasleep 2 items
Color
  1. Beige 16 items
  2. Black 35 items
  3. Blue 2 items
  4. Brown 4 items
  5. Chestnut 4 items
  6. Clear 1 item
  7. Gray 4 items
  8. Light Blue 1 item
  9. Multicolor 7 items
  10. Silver 1 item
  11. White 2 items
Us Shoe Size
  1. 4 1 item
  2. 6 20 items
  3. 7.5 40 items
  4. S 7/8 16 items
Department
  1. Adult 3 items
  2. Adults 7 items
  3. Kids 18 items
  4. Men 16 items
  5. Women 33 items
Occasion
  1. Activewear, Casual 1 item
  2. Christmas 9 items
  3. Easter 67 items
Style
  1. ABIS_DVD 16 items
  2. Black & White 2 items
  3. Classic 2 items
  4. Classic Rock, Hard Rock 3 items
  5. Country 4 items
  6. Decorative 26 items
  7. LP 12 items
  8. Novelty 1 item
  9. Platform 11 items
Heel Height
  1. High (3-3.9 in) 77 items
Upper Material
  1. Faux Suede 1 item
  2. Suede 16 items
  3. Synthetic 60 items
Price
  1. $0.00 - $99.99 70 items
  2. $100.00 - $199.99 5 items
  3. $200.00 and above 2 items
Toe Shape
  1. Round Toe 77 items
Closure
  1. Pull On 1 item
  2. Slip On 36 items
  3. Zip 40 items
Heel Style
  1. Stiletto 77 items
Theme
  1. Adventure 1 item
  2. Bar & Club 1 item
  3. Beer, Bar & Club 1 item
  4. Dogs 2 items
  5. Emergency Services 12 items
  6. Farm 3 items
  7. Flowers 1 item
  8. Kitchen 1 item
  9. Man Cave 1 item
  10. Movies 31 items
  11. Movies, Sci-Fi 23 items
Shoe Width
  1. M 16 items
  2. Medium 9 items
  3. Standard 52 items
Insole Material
  1. Cushioned Faux Sherpa Insole 16 items
  2. Memory Foam 61 items
Fabric Type
  1. Shearling 77 items
Season
  1. Fall, Spring, Summer, Winter 1 item
  2. Fall, Winter 67 items
  3. Spring, Summer 9 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.