Marble Slips

Grates

Manufacture

History of Fanlights

Facsimile Georgian Fireplaces

Bird's Nest

Mellerstain

Lady with Anchor

Plough Boy

Shepherd Boy

Urns & Swags

Thistle & Rose

Griffins

Eagle Victrix

Greek Maidens

Gothic

Corinthian

Antique Fireplaces

Home > Fireplaces > Facsimile Georgian Fireplaces >

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) 14 queries took 90 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	24	24	2
2	DESCRIBE `media`	16	16	2
3	DESCRIBE `fireplaces`	24	24	2
4	DESCRIBE `slips`	9	9	1
5	DESCRIBE `grates`	2	2	2
6	DESCRIBE `grate_images`	7	7	1
7	DESCRIBE `bullnoses`	17	17	2
8	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	37
9	SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 33 LIMIT 1	1	1	0
10	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
11	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	0
12	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
13	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	1
14	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	38

(default) 14 queries took 90 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `media`

DESCRIBE `fireplaces`

DESCRIBE `slips`

DESCRIBE `grates`

DESCRIBE `grate_images`

DESCRIBE `bullnoses`

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