• 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: 230 | OUT OF STOCK: 7 | First In-Stock at position: 3 | Total Products: 237
Position ID SKU Name Stock Status
1 3116 286550850989 Funko POP! #1352 Indiana Jones SALLAH Vinyl Figure OUT OF STOCK
2 11974 286568410736 Kamado Joe JoeTisserie 24 inch Big Joe Grill Rotis OUT OF STOCK
3 911 286297875467 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK
4 14 254107820000 Wall Shelf Bracket Decorative Cast Iron Brace Orna IN STOCK
5 15 254107820020 Wall Shelf Bracket Brace With Plant Hanger Flower IN STOCK
6 18 254107820017 Decorative Cast Iron Wall Shelf Bracket Ornate Vin IN STOCK
7 19 254107820008 Wall Shelf Bracket Large Fleur De Lis Cast Iron Br IN STOCK
8 23 254007820009 Wall Shelf Bracket Ribbon Fleur De Lis Verdigris C IN STOCK
9 25 254007820010 Wall Shelf Bracket Cast Iron Brace Fleur De Lis Di IN STOCK
10 26 254107820027 Wall Shelf Bracket Distressed White Ornate Cast Ir IN STOCK
11 27 254107820028 Wall Shelf Bracket Distressed Brown Ornate Brace 1 IN STOCK
12 900 286295192457 Bearpaw Retro Super Shorty Size 4 Youth Suede Wool IN STOCK
13 901 286294130286 Traeger Timberline Outdoor Kitchen Trim Kit Black IN STOCK
14 916 276841802932 Otterbox Elevation 20 Tumbler Thermal Lid Screw To IN STOCK
15 951 273407820004 Decorative Trivet Square Cast Iron Hot Pad Kitchen IN STOCK
16 953 257407650009 Real Sand Castle Figurine 118 4" Tall Collectible IN STOCK
17 1128 198507820001 Double Sided Hanging Welcome Sign Squirrel Eating IN STOCK
18 1129 163807820002 Firefighting Aluminum Sign Firemans St Florian Mal IN STOCK
19 1130 019700410016 Cast Iron Wall Hook Rack Antique Skeleton Key 3 Ho IN STOCK
20 1138 144307820002 Aluminum Sign You Need A Drink Home Bar Man Cave B IN STOCK
... products 21 to 217 hidden ...
218 11961 286566328311 Kenwood KFC 1666R 6.5 Inch Coaxial Car Speakers 30 IN STOCK
219 11962 286565954268 Pioneer A-Series TS-A653FH 6.5" 2-Way 340 W Max Po IN STOCK
220 11963 286563364559 Pioneer 2-Way Speaker TS-G650 300W Max 6 1/2 / 6 3 IN STOCK
221 11964 286553822204 Alex Men S 7/8 Chestnut Suede Cushion Faux Sherpa IN STOCK
222 11965 286556227610 The Object of Beauty DVD Movie Full Screen John Ma IN STOCK
223 11966 286556269735 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
224 11967 286560717312 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
225 11968 286560727712 Kenwood - Road Series 12" Single Voice Coil 4-Ohm IN STOCK
226 11969 286563505562 OEM Dyson V15 Detect Laser Slim Fluffy Optic Clean OUT OF STOCK
227 11970 286563566917 Genuine Dyson Wall Mount Docking Station for V11 / IN STOCK
228 11971 286566095118 Core Innovations - Amplified Bar HDTV Indoor Anten IN STOCK
229 11972 286568323356 Baby Monitor VTech DM221 Digital Audio Talk Back I IN STOCK
230 11973 286568347758 CyberPower 650VA Battery Back-Up System 360W - Bla IN STOCK
231 13279 286571172223 Pioneer TS-WX1010A - 10" Active Sealed subwoofer w IN STOCK
232 13400 286571370525 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK
233 14633 286573689044 Kenwood KSC-PSW8 8" Class-D Compact Powered Subwoo IN STOCK
234 14741 277115995062 CoComelon My First Sing-Along Boombox Music Toy Mi IN STOCK
235 19014 286581315080 Wireless Meat Thermometer Meater Plus Digital Exte IN STOCK
236 20802 286584503041 Vava EVOLVE Split View Screen Baby Monitor (2x 720 IN STOCK
237 23561 286589557366 Govee RGBIC LED Strip Lights, 16.4ft Smart LED Lig 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 237

Set Descending Direction
Page
per page
Shop By
Now Shopping by
  1. Lining Material Wool Remove This Item
  2. Toe Shape Round Toe Remove This Item
Clear All
Shopping Options
Category
  1. Hose Holders 1 item
  2. Garden Flags 10 items
  3. Doorbells 2 items
  4. Wall Hooks 1 item
  5. Stepping Stones 4 items
  6. Signs 19 items
Set Includes
  1. 1 Shelf Bracket 7 items
  2. Kickplate / toe kick 223 items
  3. Shelf Brackets 1 item
  4. Wall Mounted Hose Hanger 1 item
Outsole Material
  1. Suede 237 items
Accents
  1. big girls 6 items
  2. Buckle 97 items
  3. Flower 22 items
  4. Glow-In-The-Dark, Hooded 71 items
  5. Logo 16 items
  6. Rhinestone 1 item
  7. Studded 2 items
  8. Thick Laces 20 items
  9. Tie Strap 1 item
  10. wool lining 6 items
  11. Zipper 1 item
Calf Width
  1. Regular 232 items
Platform Height
  1. 1.25 in 232 items
Primary Color
  1. Beige 35 items
  2. Black 70 items
  3. Blue 2 items
  4. Brown 75 items
  5. Chestnut 5 items
  6. Clear 1 item
  7. Distressed White 1 item
  8. Gray 4 items
  9. Light Beige Brown 1 item
  10. Light Blue 1 item
  11. Multicolor 13 items
  12. Navy Blue 2 items
  13. Silver 6 items
  14. Tan 1 item
  15. White 16 items
  16. White, Black 1 item
  17. Yellow 3 items
Shape
  1. Foot Print 224 items
  2. Triangle 8 items
Item Weight
  1. 1 lb 1 item
  2. 1.5 lbs 1 item
  3. 2 lb 4 items
  4. 3 lbs 2 items
  5. 5.875000 224 items
Finish
  1. Distressed Brown 2 items
  2. Glossy 77 items
  3. Matt 36 items
  4. Painted 117 items
Product Line
  1. BearPaw 237 items
Room
  1. Any 8 items
  2. Any Room 224 items
Personalized
  1. No 232 items
Mounting
  1. Wall Mounted 232 items
Indoor Outdoor
  1. Indoor & Outdoor 232 items
Suitable For
  1. Coats, Towels, Hats 224 items
  2. Shelves 7 items
  3. Wall Shelf, Mail Box Mount 1 item
Subject
  1. American Flag 5 items
  2. Barbies 5 items
  3. Beer 3 items
  4. Beware Of Dog 3 items
  5. Child Safety 2 items
  6. Close The Gate 49 items
  7. Coffee 6 items
  8. Cows 7 items
  9. Dachshund 2 items
  10. Darts 1 item
  11. Dog 7 items
  12. Dora The Explorer 4 items
  13. Fall 2 items
  14. Fire & Rescue 10 items
  15. Firefighting 67 items
  16. Floral 1 item
  17. Foot Print 6 items
  18. Princess 1 item
  19. Snail 16 items
  20. Unicorns 2 items
  21. Video Games 1 item
  22. Welcome 18 items
  23. Wine 13 items
  24. You Need A Drink 1 item
Assembly Required
  1. No 229 items
  2. Yes 3 items
Hook Style
  1. Traditional 232 items
Shoe Shaft Style
  1. Ankle 109 items
  2. Low Top 128 items
Manufacturer
  1. ALEX 1 item
  2. Allegra K 2 items
  3. Amazon 1 item
  4. Apple 2 items
  5. ARTISAN 1 item
  6. Baby Einstein 1 item
  7. BBC Warner 2 items
  8. Brewster 2 items
  9. BRIELLE 1 item
  10. Bromic 1 item
  11. CASETiFY 2 items
  12. Cocomelon 1 item
  13. Core Innovations 1 item
  14. Courtney 1 item
  15. Cracker Jack 8 items
  16. CyberPower 5 items
  17. Darla 1 item
  18. Dearfoams 2 items
  19. Decor 1 item
  20. Devin 1 item
  21. Disney 1 item
  22. Dr. Scholl's 1 item
  23. Dyson 2 items
  24. Farberware 1 item
  25. Fitbit 8 items
  26. Flag Emotes 54 items
  27. Floortex 1 item
  28. Funko 11 items
  29. Gamma 1 item
  30. Google 1 item
  31. Govee 1 item
  32. Hasbro 1 item
  33. Heyday 2 items
  34. Holiday Home 3 items
  35. Hyde & EEK! Boutique 1 item
  36. Import Wholesales 28 items
  37. International Wallcoverings 1 item
  38. Intex 1 item
  39. JBL 1 item
  40. Joshua 2 items
  41. Journee Collection 1 item
  42. Kamado Joe 1 item
  43. kate spade new york 1 item
  44. Kenwood 6 items
  45. Longaberger 1 item
  46. Maryanne 4 items
  47. McFarlane Toys 5 items
  48. Metra 2 items
  49. Misty 2 items
  50. MOBI 3 items
  51. Mr. Sandman 1 item
  52. Ooni 1 item
  53. Otterbox 2 items
  54. Peerless 1 item
  55. Pioneer 5 items
  56. Playtex Baby 1 item
  57. Rawlings 1 item
  58. Rocketfish 2 items
  59. Rubie's 1 item
  60. Sahara 2 items
  61. Sanus 5 items
  62. Seagram's 1 item
  63. Simpli Home 1 item
  64. Sony Legacy 1 item
  65. Sony Pictures 5 items
  66. Sony Pictures Home Entertainment 1 item
  67. Super7 1 item
  68. ToyBiz 1 item
  69. Traeger Industries 2 items
  70. Unknown 2 items
  71. Vava 1 item
  72. Victrola 2 items
  73. VTech 1 item
  74. Warner 1 item
  75. Warner Archives 2 items
  76. Withit 2 items
  77. WWE 1 item
  78. Yardbird 3 items
  79. Yogasleep 2 items
Color
  1. Beige 29 items
  2. Black 80 items
  3. Blue 2 items
  4. Brown 47 items
  5. Chestnut 5 items
  6. Clear 2 items
  7. Gray 8 items
  8. Green 5 items
  9. Light Beige Brown 1 item
  10. Light Blue 1 item
  11. Multicolor 14 items
  12. Navy Blue 2 items
  13. Pink 3 items
  14. Red 6 items
  15. Red, Black 1 item
  16. Silver 4 items
  17. Tan 1 item
  18. Teal 2 items
  19. Verdigris 2 items
  20. White 18 items
  21. White, Black 1 item
  22. Yellow 3 items
Us Shoe Size
  1. 10 4 items
  2. 11 1 item
  3. 13 1 item
  4. 4 25 items
  5. 5 1 item
  6. 6 83 items
  7. 7 1 item
  8. 7.5 70 items
  9. 8 3 items
  10. 8.5 6 items
  11. 8.5 WD 1 item
  12. 9 W 1 item
  13. 9.5 4 items
  14. Kids 2-3 3 items
  15. Kids 4-5 5 items
  16. S 7/8 17 items
  17. W 9.5-10.5 11 items
Department
  1. Adult 39 items
  2. Adults 32 items
  3. Adults, Kids, Teens 2 items
  4. Girls 9 items
  5. Kids 19 items
  6. Men 18 items
  7. Unisex Adults 15 items
  8. Unisex Kids 5 items
  9. Women 98 items
Occasion
  1. Activewear 11 items
  2. Activewear, Casual 14 items
  3. All Occasions 3 items
  4. Any 14 items
  5. Business, Casual, Formal, Party/Cocktail, Travel, Wedding 1 item
  6. Business, Casual, Party/Cocktail, Wedding 1 item
  7. Casual 6 items
  8. Casual, Travel 1 item
  9. Casual, Workwear 24 items
  10. Christmas 19 items
  11. Easter 94 items
  12. Fall 4 items
  13. Formal, Party/Cocktail, Travel, Wedding 36 items
  14. Summer 9 items
Style
  1. ABIS_DVD 16 items
  2. Antique 6 items
  3. Antique Style 7 items
  4. Beach 1 item
  5. Black & White 2 items
  6. Bootie 7 items
  7. Classic 2 items
  8. Classic Rock, Hard Rock 10 items
  9. Complete Outfit 1 item
  10. Country 10 items
  11. Decorative 28 items
  12. Firefighting 1 item
  13. Flat 2 items
  14. Flats and Slip Ons 15 items
  15. French Country 4 items
  16. Heels 2 items
  17. Kid's 1 item
  18. Long Sleeve 8 items
  19. LP 12 items
  20. Mule 1 item
  21. Nautical 34 items
  22. Not Available 1 item
  23. Novelty 1 item
  24. Onesie 2 items
  25. Platform 12 items
  26. Rustic 1 item
  27. Rustic/Primitive 7 items
  28. Slide 6 items
  29. Slide Slippers 1 item
  30. Slingback 2 items
  31. Slip-On 5 items
  32. Sneaker 8 items
  33. Strappy 11 items
  34. T-Strap 2 items
  35. Traditional 2 items
  36. Victorian 3 items
  37. Victorian Style 3 items
Heel Height
  1. High (3-3.9 in) 237 items
Upper Material
  1. 100% Nylon 21 items
  2. 100% Polyester 3 items
  3. Beads 6 items
  4. Faux Leather 6 items
  5. Faux Leather upper; Rubber sole 2 items
  6. Faux Suede 21 items
  7. Man Made Material 2 items
  8. Not Available 18 items
  9. Suede 23 items
  10. Synthetic 135 items
Price
  1. $0.00 - $99.99 229 items
  2. $100.00 - $199.99 6 items
  3. $200.00 and above 2 items
Closure
  1. Lace Up 18 items
  2. Pull On 26 items
  3. Slip On 149 items
  4. Tie 1 item
  5. Zip 43 items
Heel Style
  1. Stiletto 237 items
Theme
  1. Adventure 1 item
  2. Animals 1 item
  3. Bar & Club 1 item
  4. Bar & Club, Humor, Novelty 2 items
  5. Barbie 5 items
  6. Beach 1 item
  7. Beer, Bar & Club 1 item
  8. Beware Of Dog 1 item
  9. Cartoons 4 items
  10. Chickens 2 items
  11. Children 1 item
  12. Close The Gate 6 items
  13. Coffee 3 items
  14. College 25 items
  15. Comics, Television 2 items
  16. DC Super Heroes 9 items
  17. Developmental Activities 2 items
  18. Disney, Cartoons, Princesses/Fairies 1 item
  19. Dogs 2 items
  20. Emergency Services 13 items
  21. Equestrian 1 item
  22. Fall 1 item
  23. Farm 3 items
  24. Firefighting 10 items
  25. Fleur De Lis 9 items
  26. Flowers 1 item
  27. French Bulldog 1 item
  28. Halloween, Holiday, Bones, Glow-In-The-Dark, Matching Family Pajamas, Skeleton, Spooky 1 item
  29. Holiday 4 items
  30. Humor 1 item
  31. Kitchen 1 item
  32. Man Cave 1 item
  33. Movies 33 items
  34. Movies, Sci-Fi 23 items
  35. Nautical 15 items
  36. Outdoor 6 items
  37. Racing 1 item
  38. Rhinestones 16 items
  39. Skull 3 items
  40. Sports 8 items
  41. Squirrel 1 item
  42. Turtles 1 item
  43. Unicorns 2 items
  44. United States 2 items
  45. Video Games 1 item
  46. Vintage 3 items
  47. Welcome 4 items
  48. Wine 1 item
Shoe Width
  1. M 17 items
  2. Medium 99 items
  3. Standard 96 items
  4. W 24 items
  5. WD 1 item
Insole Material
  1. Cushioned Faux Sherpa Insole 17 items
  2. Memory Foam 214 items
  3. Wool 6 items
Fabric Type
  1. Shearling 237 items
Season
  1. Fall 6 items
  2. Fall, Spring, Summer 16 items
  3. Fall, Spring, Summer, Winter 21 items
  4. Fall, Winter 71 items
  5. Spring 6 items
  6. Spring, Summer 123 items
  7. Winter 6 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.