Stavenhagenhaus (Q7604812)

  • matcher place: Hamburg-Nord (relation 30352), Hamburg (relation 62782), Hamburg (relation 2618040)
  • view on Wikidata
  • Wikipedia: Arabic, English, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: 1703 establishments in the Holy Roman Empire, Baroque architecture in Hamburg, Berenberg-Gossler family, Buildings and structures in Hamburg-Nord, Castles in Hamburg, Heritage sites in Hamburg, Houses completed in 1703, Manor houses in Germany
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,53.60940,9.97290)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)["castle_type"="manor"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)["castle_type"="manor"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)["castle_type"="manor"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)["castle_type"="stately"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)["castle_type"="stately"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)["castle_type"="stately"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)["historic"="archaeological_site"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)["historic"="archaeological_site"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)["historic"="archaeological_site"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[historic=castle][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[historic=castle][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[historic=castle][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[historic=ruins][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[historic=ruins][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[historic=ruins][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)["historic"="tower_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)["historic"="tower_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)["historic"="tower_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.60940,9.97290)[place=locality][name];
    way(around:1000,53.60940,9.97290)[place=locality][name];
    rel(around:1000,53.60940,9.97290)[place=locality][name];
    node(around:1000,53.60940,9.97290)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.60940,9.97290)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.60940,9.97290)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Frustberg House, also known as the Tiefbrunn House, is a former property and a baroque brick manor house at Frustberg in the Hamburg borough of Groß Borstel. The property became a summer residence for wealthy Hamburg citizens from 1651. The current house was built in the early 18th century by the cloth merchant Eybert Tiefbrunn, and his coat of arms is still found over the main entrance door, with the year 1703 inscribed. The building is a rare example of a baroque brick building from the era. In the 19th century, the property included an estate of 605 hectare (6050 decare) land, and the manor house was surrounded by 7 hectare (70 decare) park.

Summary from Português / Portuguese Wikipedia (ptwiki)

A Casa Frustberg, também conhecida como Casa Tiefbrunn, é uma antiga propriedade e uma mansão barroca de tijolos em Frustberg, no bairro de Groß Borstel em Hamburgo. A propriedade tornou-se uma residência de verão para ricos cidadãos de Hamburgo a partir de 1651. A casa atual foi construída no início do século XVIII pelo comerciante de tecidos Eybert Tiefbrunn, e seu brasão ainda é encontrado na porta de entrada principal, com o ano de 1703 inscrito. O edifício é um exemplo raro de um edifício de tijolos barrocos da época. No século XIX a propriedade incluía um terreno de 605 hectares (6050 decares) e a mansão era cercada por um parque de 7 hectares (70 decares).

Wikidata location: 53.6094, 9.9729 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Stavenhagenhaus (OSM)exact location match [show tags]
name: Stavenhagenhaus
image: http://commons.wikimedia.org/wiki/File:Stavenhagenhuus_-_Oostgevel.jpg
amenity: community_centre
ref:dsa: 20896
building: yes
heritage: 4
historic: heritage
old_name: Altes Schrödersches Herrenhaus
wikidata: Q7604812
addr:city: Hamburg
start_date: 1703
addr:street: Frustbergstraße
addr:suburb: Groß Borstel
addr:country: DE
dsa:criteria: Baudenkmal
addr:postcode: 22453
addr:housenumber: 4
heritage:operator: dsa

wikidata match: Q7604812

Search criteria from Wikidata

view with query.wikidata.org

residential building (Q11755880) building:use=residential, building=residential
product (Q2424752) product
building (Q41176) building=yes, building
residence (Q699405) amenity=shelter
manor house (Q879050) castle_type=manor, historic=manor

Search criteria from categories

Castles in Hamburg historic=castle, tourism=attraction, place=locality, building=ruins, historic=ruins, historic=archaeological_site, building=castle, historic=tower_house
Houses completed in 1703 historic=manor, building=country_house
Manor houses in Germany castle_type=stately, historic=manor, building=country_house