Lady with Anchor Fireplace

CUSTOMISE

THIS FIREPLACE

Style

Painted

Unpainted

Marble Slips

Grate

DOWNLOAD

Exterior width	1676 mm (66")
Exterior height	1435 mm (56 ½")
Interior width	1191 mm (46 ⅞")
Interior height	1105 mm (43 ½")
Jamb width*	1486 mm (58 ½")

* the outer width, taken across the legs

Lady with Anchor Georgian Fireplace

Price of chimneypiece: £2510

Long associated with Emma, Lady Hamilton, wife of the British ambassador to Naples and noted antiquarian, Sir William Hamilton, but better known as the amour of Lord Nelson.

The American writer Susan Sontag has referred to Hamilton's acquisition of a chimneypiece from his friends the Adams for use in his Naples residence. Emma Hamilton was frequently sketched by David Allan, drawing master of the Trustees Acacdemy in Edinburgh, during his time in Naples, and it is likely that this depiction is based on one of his sketch portraits of Emma in her 'attitudes'.

Thistle & Rose revived this pattern for the Captain's residence of the Royal & Ancient Golf Club in St Andrews.

For more information, please contact us.

(default) 7 queries took 83 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	41
2	SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 29 LIMIT 1	1	1	1
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` = 3 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` = 35	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` = 3	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` = (29) 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	36

(default) 7 queries took 83 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 = 29 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` = 3 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` = 35

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

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

457