Mellerstain Fireplace

CUSTOMISE
THIS FIREPLACE
Style
Painted
Unpainted
Marble Slips
Grate
Download DOWNLOAD
Exterior width 1632 mm (64 ¼")
Exterior height 1375 mm (54 ⅛")
Interior width 1159 mm (45 ⅝")
Interior height 1048 mm (41 ¼")
Jamb width* 1457 mm (57 ⅜")
* the outer width, taken across the legs

Mellerstain Georgian Fireplace.

Price of chimneypiece: £2920 + vat

A simple, spare design which epitomises the 'corrected style', with entwined dolphins over the urns on the capital block recalling those Adam had used on the dining room ceiling of one of his earliest country houses, Hatchlands, which had been inspired by fragments in the Villa Pamphili in Rome.

For more information, please contact us.

(default) 14 queries took 88 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24241
2DESCRIBE `media`16161
3DESCRIBE `fireplaces`24241
4DESCRIBE `slips`991
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 45745735
9SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 28 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` = 2 LIMIT 1111
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` = 32 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` = 2 112
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` = (28) ORDER BY `Image`.`ordering` ASC 001
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 45745740