800.686.5242
30 Inch Parsons Barstool with Nail heads (Crimson Red eco Leather)
Mouse Over main Image to Enlarge
30 Inch Parsons Barstool with Nail heads (Crimson Red eco Leather)
previous           next                            
  • SKU No.
  • :
  • 34017
  • Compare at
  • :
  • $240.00
  • Our Price
  • :
  • $150.99
  • You Save
  • :
  • 37%
  • Quantity
  • :
  • 13 in Stock

30 Inch Parsons Barstool with Nail heads (Crimson Red eco Leather)

Features:

  •  Crimson Red Eco Leather.
  •  Espresso Finish Legs.

Specifications:

  • Max.Overall Size: 17.25" x 24.5" x 47".
  • Cube: 6.98.
  • Seat Height: 30".
  • Weight: 26 lbs.


Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6303' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6304' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6306' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6315' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6342' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6352' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34018) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6303' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6304' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6306' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6315' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6342' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6352' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34019) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6303' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6304' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6306' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6315' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6342' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6352' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34020) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6303' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6304' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6306' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6315' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6342' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132

Warning: [MYSQL] Warning (1292): Truncated incorrect DOUBLE value: '33473-6352' [QUERY] SELECT DISTINCT p.products_id,p.url_tag as urlTag, replace(p.products_model," ","") as model, m.manufacturers_name, p.manufacturers_id FROM products p LEFT JOIN product_attributes pa ON p.products_id = pa.products_id LEFT JOIN templates_boxes tb ON pa.id = tb.id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status =1 AND pd.language_id =1 AND p.products_quantity >0 AND p.products_sku_number in (34021) in /home/spiderof/public_html/includes/classes/database/mysqli.php on line 132