OAK

OAK

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1535' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1535' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1535' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY `e`.`entity_id` DESC LIMIT 9SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1535' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY `e`.`entity_id` DESC LIMIT 9

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
Shop by

Shopping Options

Price
  1. -
Colours
  1. Black (3)
  2. White (17)
  3. Brown (2)
  4. Cream (1)
  5. Dark Brown (4)
  6. Grey (48)
  7. Taupe (10)
  8. Charcoal (8)
  9. Sonoma Oak (3)
  10. Stone (14)
  11. Oak (188)
  12. Oyster (8)
  13. Antique Grey (15)
  14. Light Oak (27)
  15. Midnight Blue (6)
Type
  1. Mirrors (13)
  2. Stools (6)
  3. Dressers (10)
  4. Sliding Robes (1)
  5. Wardrobes (27)
  6. Chests (31)
  7. Bedside Lockers (17)
  8. Kids Beds (3)
  9. Bunk Beds (1)
  10. Blanket Box (5)
  11. Sideboards (17)
  12. Bar Stools (2)
  13. Dining Chairs (31)
  14. Dining Tables (36)
  15. Corner (5)
  16. Nest Tables (14)
  17. Benches (2)
  18. Display Cabinets (8)
  19. Lamp Table (5)
  20. Coffee Table (20)
  21. Bedframe (11)
  22. Console Table (20)
  23. Bookcase (14)
  24. TV Unit (17)
  25. End Table (12)
  26. Shelf Unit (4)
  27. DVD Rack (1)
  28. Telephone Stand (4)
Brand
  1. Vida Living (61)
  2. Annaghmore (153)
  3. Honey B (25)
  4. World Furniture (4)
  5. Wholesale Beds (45)
  6. Rauch (3)
  7. Julian Bowen (1)
Size
  1. 6ft Bed (1)
  2. 4ft 6in Bed (2)
  3. 5ft Bed (2)
  4. 3ft Bed (1)
  5. 271 w x 210 h x 62 d cms (1)
  6. 226 w x 210 h x 62 d cms (1)
  7. 181 w x 210 h x 62 d cms (2)
  8. 6 Door - 271 w x 212 h x 56 d cms (1)
  9. 5 Door - 226 w x 212 h x 56 d cms (1)
  10. 4 Door - 181 w x 212 h x 56 d cms (1)
  11. 3 Door - 136 w x 212 h x 56 d cms (1)

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
Show More Products