Thistle & Rose Fireplace

CUSTOMISE

THIS FIREPLACE

Style

Painted

Unpainted

Marble Slips

Grate

DOWNLOAD

Exterior width	1721 mm (67 ¾")
Exterior height	1492 mm (58 ¾")
Interior width	1235 mm (48 ⅝")
Interior height	1073 mm (42 ¼")
Jamb width*	1527 mm (60 ⅛")

* the outer width, taken across the legs

Thistle & Rose Georgian Fireplace

Price of chimneypiece: £4000 + vat

Our eponymous classic, exquisitely detailed—a lion's mask is even hidden behind the Ionic captials, whose acanthus leaves are variations on a design which Robert Adam sketched in Diocletian's Palace in modern Croatia.

The thistle and rose captial blocks may have had some political significance as the symbolic union of the national flowers of Scotland and England. One the other hand, the rose was also a Jacobite emblem.

For more information, please contact us.

(default) 7 queries took 70 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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	457	457	35
2	SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 33 LIMIT 1	1	1	0
3	SELECT `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` = 7 LIMIT 1	1	1	1
4	SELECT `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` = 47	1	1	1
5	SELECT `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` = 7	1	1	1
6	SELECT `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` = (33) ORDER BY `Image`.`ordering` ASC	0	0	2
7	SELECT `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	457	457	30

(default) 7 queries took 70 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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

457

SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 33 LIMIT 1

SELECT `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` = 7 LIMIT 1

SELECT `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` = 47

SELECT `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` = 7

SELECT `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` = (33) ORDER BY `Image`.`ordering` ASC

457