Griffins Fireplace

CUSTOMISE
THIS FIREPLACE
Style
Painted
Unpainted
Marble Slips
Grate
Download DOWNLOAD
Exterior width 1842 mm (72 ½")
Exterior height 1518 mm (59 ¾")
Interior width 1349 mm (53 ⅛")
Interior height 1178 mm (46 ⅜")
Jamb width* 1661 mm (65 ⅖")
* the outer width, taken across the legs

Griffins Georgian Fireplace

Price of chimneypiece: £34000 + vat


The fabled beasts had their origins in ancient times, and made a re-appearance during the Renaissance. They finally settled down as a popular neoclassical motif, particularly in plaster friezes and decorative ceilings, such as those at Paxton House, Berwickshire, attributed to Jobn Adam, and at Robert Adam's Harewood House.

For more information, please contact us.

(default) 14 queries took 95 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24241
2DESCRIBE `media`16161
3DESCRIBE `fireplaces`24241
4DESCRIBE `slips`992
5DESCRIBE `grates`221
6DESCRIBE `grate_images`771
7DESCRIBE `bullnoses`17171
8SELECT `Page`.`id`, `Page`.`title`, `Page`.`short_title`, `Page`.`parent_id`, `Page`.`type`, `Page`.`slug`, `Page`.`is_published`, (COUNT(`ParentPage`.`id`)-1) AS depth FROM `pages` AS `Page` INNER JOIN pages AS `ParentPage` ON (`Page`.`lft` BETWEEN `ParentPage`.`lft` AND `ParentPage`.`rght`) WHERE 1 = 1 GROUP BY `Page`.`id` ORDER BY `Page`.`lft` ASC 45745734
9SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 34 LIMIT 1111
10SELECT `Fireplace`.`id`, `Fireplace`.`exterior_width`, `Fireplace`.`exterior_height`, `Fireplace`.`interior_width`, `Fireplace`.`interior_height`, `Fireplace`.`jamb_width`, `Fireplace`.`max_slip_width`, `Fireplace`.`min_slip_width`, `Fireplace`.`default_slip_width`, `Fireplace`.`bullnose_width`, `Fireplace`.`unpainted_image_id`, `Fireplace`.`unpainted_hole_top`, `Fireplace`.`unpainted_hole_right`, `Fireplace`.`unpainted_hole_bottom`, `Fireplace`.`unpainted_hole_left`, `Fireplace`.`unpainted_hole_skirting`, `Fireplace`.`painted_image_id`, `Fireplace`.`painted_hole_top`, `Fireplace`.`painted_hole_right`, `Fireplace`.`painted_hole_bottom`, `Fireplace`.`painted_hole_left`, `Fireplace`.`painted_hole_skirting`, `Fireplace`.`line_image_id`, `Fireplace`.`thumb_image_id`, `UnpaintedImage`.`id`, `UnpaintedImage`.`model`, `UnpaintedImage`.`foreign_key`, `UnpaintedImage`.`filename`, `UnpaintedImage`.`ext`, `UnpaintedImage`.`mimetype`, `UnpaintedImage`.`filesize`, `UnpaintedImage`.`checksum`, `UnpaintedImage`.`dir`, `UnpaintedImage`.`height`, `UnpaintedImage`.`width`, `UnpaintedImage`.`description`, `UnpaintedImage`.`version`, `UnpaintedImage`.`ordering`, `UnpaintedImage`.`created`, `UnpaintedImage`.`updated`, `Page`.`id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`ordering`, `Page`.`type`, `Page`.`foreign_key`, `Page`.`slug`, `Page`.`title`, `Page`.`short_title`, `Page`.`content`, `Page`.`description`, `Page`.`main_image_id`, `Page`.`thumb_image_id`, `Page`.`thumb_text`, `Page`.`is_published`, `Page`.`is_locked`, `Page`.`is_for_sale`, `Page`.`is_sold`, `Page`.`show_thumbs`, `Page`.`created`, `Page`.`updated`, `Page`.`created_by`, `Page`.`updated_by` FROM `fireplaces` AS `Fireplace` LEFT JOIN `media` AS `UnpaintedImage` ON (`Fireplace`.`unpainted_image_id` = `UnpaintedImage`.`id`) LEFT JOIN `pages` AS `Page` ON (type = "Fireplace" AND `Page`.`foreign_key` = `Fireplace`.`id`) WHERE `Fireplace`.`id` = 8 LIMIT 1112
11SELECT `UnpaintedImage`.`id`, `UnpaintedImage`.`model`, `UnpaintedImage`.`foreign_key`, `UnpaintedImage`.`filename`, `UnpaintedImage`.`ext`, `UnpaintedImage`.`mimetype`, `UnpaintedImage`.`filesize`, `UnpaintedImage`.`checksum`, `UnpaintedImage`.`dir`, `UnpaintedImage`.`height`, `UnpaintedImage`.`width`, `UnpaintedImage`.`description`, `UnpaintedImage`.`version`, `UnpaintedImage`.`ordering`, `UnpaintedImage`.`created`, `UnpaintedImage`.`updated` FROM `media` AS `UnpaintedImage` WHERE `UnpaintedImage`.`id` = 50 111
12SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`ordering`, `Page`.`type`, `Page`.`foreign_key`, `Page`.`slug`, `Page`.`title`, `Page`.`short_title`, `Page`.`content`, `Page`.`description`, `Page`.`main_image_id`, `Page`.`thumb_image_id`, `Page`.`thumb_text`, `Page`.`is_published`, `Page`.`is_locked`, `Page`.`is_for_sale`, `Page`.`is_sold`, `Page`.`show_thumbs`, `Page`.`created`, `Page`.`updated`, `Page`.`created_by`, `Page`.`updated_by` FROM `pages` AS `Page` WHERE type = "Fireplace" AND `Page`.`foreign_key` = 8 111
13SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`filename`, `Image`.`ext`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`checksum`, `Image`.`dir`, `Image`.`height`, `Image`.`width`, `Image`.`description`, `Image`.`version`, `Image`.`ordering`, `Image`.`created`, `Image`.`updated` FROM `media` AS `Image` WHERE model = "Page" AND `Image`.`foreign_key` = (34) ORDER BY `Image`.`ordering` ASC 002
14SELECT `Page`.`id`, `Page`.`title`, `Page`.`short_title`, `Page`.`parent_id`, `Page`.`type`, `Page`.`slug`, `Page`.`is_published`, (COUNT(`ParentPage`.`id`)-1) AS depth FROM `pages` AS `Page` INNER JOIN pages AS `ParentPage` ON (`Page`.`lft` BETWEEN `ParentPage`.`lft` AND `ParentPage`.`rght`) WHERE 1 = 1 GROUP BY `Page`.`id` ORDER BY `Page`.`lft` ASC 45745746