Apsley House

Addresses donít come much grander than 'Number One London', the popular name for Apsley House, one of the most interesting visitor attractions in London. Home to the Duke of Wellington after his victory over Napoleon at Waterloo, the interior of the house has changed very little since the days of the Iron Duke.
It boasts one of the finest art collections in London, with paintings by Velazquez and Rubens as well as a wonderful collection of silver and porcelain. Pride of place goes to a massive nude statue of Napoleon. Why not include a stroll through nearby Hyde Park, and a visit to nearby Wellington Arch for a great value family day out in London.

  • Currently: Medium-level cloud, 17° C
  • Saturday: Medium-level cloud, 22° C
  • Sunday: Sunny intervals, 25° C

Failed to find events: SELECT DISTINCT e.st_date, e.tag, FROM_UNIXTIME( e.st_date, GET_FORMAT(DATETIME,'ISO')) AS dtstart, FROM_UNIXTIME( e.end_date, GET_FORMAT(DATETIME,'ISO')) AS dtend, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%D %M %Y') AS StartDate, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%k:%i') AS StartTime, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%D %M %Y') AS EndDate, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%k:%i') AS EndTime, e.eventname, e.locname, e.locpostcode, e.description, e.ticketurl, CASE WHEN e.town_id != t.id THEN '' WHEN e.town_id != tt.id THEN CASE WHEN l.id = 0 THEN CONCAT( s.Name, ', ', t.Name ) ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name, ', ', t.Name ) END END ELSE CASE WHEN l.id = 0 THEN s.Name ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name ) END END END AS Address, g.northing AS Latitude, g.easting AS Longitude, ( COALESCE( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis), 0 ) * 6367.0 / 1.852 ) AS Distance, e.status FROM angle_events.events AS e LEFT JOIN paf.geocode g ON e.locpostcode = g.postcode LEFT JOIN paf.streets s ON g.street_id = s.id LEFT JOIN paf.localities l ON g.locality_id = l.id LEFT JOIN paf.towns t ON g.town_id = t.id INNER JOIN paf.towns tt ON tt.id = 864 INNER JOIN paf.geocode tg ON tt.mappoint = tg.postcode WHERE (e.town_id = 864 OR ( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis ) * 6367.0 / 1.852 ) < 25) AND e.end_date > UNIX_TIMESTAMP() AND e.st_date < (UNIX_TIMESTAMP() + (182 * 86400) ) AND e.status > 0 AND e.tag LIKE '%apsleyhouse%' ORDER BY e.st_date ASC limit 100