Soziales Wohnen in Wohngruppen
Kolpinghäuser bieten Wohnraum und Hilfe
SELECT *, label AS label, ctrl_show = true AS is_active FROM house h WHERE 1 AND ( true AND ctrl_show = true AND ( `type_socialhousing` = 1 ) ) ORDER BY address_city
DataItemList Object
(
[arrDataItems:protected] => Array
(
[145] => VKH_House Object
(
[arrStoredData:protected] => Array
(
)
[queryString:protected] =>
[parameterString:protected] =>
[userAgent:protected] =>
[referrer:protected] =>
[arrFieldLabels:protected] => Array
(
)
[id:protected] => 145
[arrData:protected] => Array
(
[dedupe] => 1
[id] => 145
[label] => Kolpinghaus Bern
[label_place] =>
[organisation] => Verein Kolpinghaus Bern
[membernumber] => 17500
[address_street] => Mattenhofstr. 32
[address_postcode] => 3007
[address_city] => Bern
[address_country] => Schweiz
[phone] => +41(31) 3819 870
[fax] =>
[email] => kolpinghaus-bern@bluewin.ch
[website] => www.kolpinghaus-bern.ch
[website_house] =>
[website_restaurant] =>
[website_hotel] =>
[website_familyhotel] =>
[website_congresshotel] =>
[website_housing] =>
[website_socialhousing] =>
[geocode_accuracy] => 0
[geocode_lat] => 46.9438402
[geocode_lon] => 7.4289788
[geocode_zoom] => 0
[content_title] =>
[content_intro] =>
[content_lage] =>
[image_overview] =>
[image_detailmain] =>
[image_hotel] =>
[image_logo] =>
[image_house] => img_house.jpg
[text_beschreibung] =>
[ctrl_position] => 0
[ctrl_show] => 1
[type_house] => 1
[type_restaurant] => 0
[type_hotel] => 0
[type_familyhotel] => 0
[type_congresshotel] => 1
[type_housing] => 0
[type_socialhousing] => 1
[is_active] => 1
)
[arrTableFields:protected] => Array
(
)
[arrActionHandler:protected] => Array
(
)
[arrRelations:protected] => Array
(
)
[arrSavedData:protected] => Array
(
)
[files] => DataItemFiles Object
(
[website:protected] =>
[baseFilesDir:protected] => house
[dataItem:protected] => VKH_House Object
*RECURSION*
[storagemode:protected] => 1
)
[format] => json
)
[55] => VKH_House Object
(
[arrStoredData:protected] => Array
(
)
[queryString:protected] =>
[parameterString:protected] =>
[userAgent:protected] =>
[referrer:protected] =>
[arrFieldLabels:protected] => Array
(
)
[id:protected] => 55
[arrData:protected] => Array
(
[dedupe] => 1
[id] => 55
[label] => Kolpinghaus Hannover
[label_place] =>
[organisation] => Kolpinghaus Hannover e.V.
[membernumber] => 11790
[address_street] => Escherstr. 12
[address_postcode] => 30159
[address_city] => Hannover
[address_country] => Deutschland
[phone] => (0511)1317636
[fax] => (0511)1319497
[email] => kolpinghaus@kolpinghaus-hannover.de
[website] => www.kolpinghaus-hannover.de
[website_house] =>
[website_restaurant] =>
[website_hotel] =>
[website_familyhotel] =>
[website_congresshotel] =>
[website_housing] =>
[website_socialhousing] =>
[geocode_accuracy] => 0
[geocode_lat] => 52.3763659
[geocode_lon] => 9.727715
[geocode_zoom] => 0
[content_title] =>
[content_intro] =>
[content_lage] =>
[image_overview] =>
[image_detailmain] =>
[image_hotel] =>
[image_logo] =>
[image_house] =>
[text_beschreibung] =>
[ctrl_position] => 0
[ctrl_show] => 1
[type_house] => 0
[type_restaurant] => 0
[type_hotel] => 1
[type_familyhotel] => 0
[type_congresshotel] => 1
[type_housing] => 1
[type_socialhousing] => 1
[is_active] => 1
)
[arrTableFields:protected] => Array
(
)
[arrActionHandler:protected] => Array
(
)
[arrRelations:protected] => Array
(
)
[arrSavedData:protected] => Array
(
)
[files] => DataItemFiles Object
(
[website:protected] =>
[baseFilesDir:protected] => house
[dataItem:protected] => VKH_House Object
*RECURSION*
[storagemode:protected] => 1
)
[format] => json
)
[94] => VKH_House Object
(
[arrStoredData:protected] => Array
(
)
[queryString:protected] =>
[parameterString:protected] =>
[userAgent:protected] =>
[referrer:protected] =>
[arrFieldLabels:protected] => Array
(
)
[id:protected] => 94
[arrData:protected] => Array
(
[dedupe] => 1
[id] => 94
[label] => Kolpinghaus Neuss
[label_place] =>
[organisation] => Kath. Gesellenhaus GmbH
[membernumber] => 13280
[address_street] => Burggraben 1
[address_postcode] => 41460
[address_city] => Neuss
[address_country] => Deutschland
[phone] => (02131) 225-0
[fax] => (02131) 225-225
[email] => neusskolpinghaus@aol.com
[website] => www.kolpinghaus-neuss.de
[website_house] =>
[website_restaurant] =>
[website_hotel] =>
[website_familyhotel] =>
[website_congresshotel] =>
[website_housing] =>
[website_socialhousing] =>
[geocode_accuracy] => 0
[geocode_lat] => 51.2017877
[geocode_lon] => 6.6899052
[geocode_zoom] => 0
[content_title] =>
[content_intro] =>
[content_lage] =>
[image_overview] =>
[image_detailmain] =>
[image_hotel] =>
[image_logo] =>
[image_house] =>
[text_beschreibung] =>
[ctrl_position] => 0
[ctrl_show] => 1
[type_house] => 1
[type_restaurant] => 0
[type_hotel] => 0
[type_familyhotel] => 0
[type_congresshotel] => 1
[type_housing] => 1
[type_socialhousing] => 1
[is_active] => 1
)
[arrTableFields:protected] => Array
(
)
[arrActionHandler:protected] => Array
(
)
[arrRelations:protected] => Array
(
)
[arrSavedData:protected] => Array
(
)
[files] => DataItemFiles Object
(
[website:protected] =>
[baseFilesDir:protected] => house
[dataItem:protected] => VKH_House Object
*RECURSION*
[storagemode:protected] => 1
)
[format] => json
)
[96] => VKH_House Object
(
[arrStoredData:protected] => Array
(
)
[queryString:protected] =>
[parameterString:protected] =>
[userAgent:protected] =>
[referrer:protected] =>
[arrFieldLabels:protected] => Array
(
)
[id:protected] => 96
[arrData:protected] => Array
(
[dedupe] => 1
[id] => 96
[label] => Kolpinghaus Nordhorn
[label_place] =>
[organisation] => Kolpinghaus Nordhorn e.V.
[membernumber] => 13290
[address_street] => Stadtring 34
[address_postcode] => 48527
[address_city] => Nordhorn
[address_country] => Deutschland
[phone] => (05921) 156 96
[fax] => (05921) 799 61
[email] => kolpinghaus.nordhorn@ewetel.net
[website] =>
[website_house] =>
[website_restaurant] =>
[website_hotel] =>
[website_familyhotel] =>
[website_congresshotel] =>
[website_housing] =>
[website_socialhousing] =>
[geocode_accuracy] => 0
[geocode_lat] => 52.4376717
[geocode_lon] => 7.0630074
[geocode_zoom] => 0
[content_title] =>
[content_intro] =>
[content_lage] =>
[image_overview] =>
[image_detailmain] =>
[image_hotel] =>
[image_logo] =>
[image_house] =>
[text_beschreibung] =>
[ctrl_position] => 0
[ctrl_show] => 1
[type_house] => 1
[type_restaurant] => 0
[type_hotel] => 0
[type_familyhotel] => 0
[type_congresshotel] => 0
[type_housing] => 1
[type_socialhousing] => 1
[is_active] => 1
)
[arrTableFields:protected] => Array
(
)
[arrActionHandler:protected] => Array
(
)
[arrRelations:protected] => Array
(
)
[arrSavedData:protected] => Array
(
)
[files] => DataItemFiles Object
(
[website:protected] =>
[baseFilesDir:protected] => house
[dataItem:protected] => VKH_House Object
*RECURSION*
[storagemode:protected] => 1
)
[format] => json
)
[141] => VKH_House Object
(
[arrStoredData:protected] => Array
(
)
[queryString:protected] =>
[parameterString:protected] =>
[userAgent:protected] =>
[referrer:protected] =>
[arrFieldLabels:protected] => Array
(
)
[id:protected] => 141
[arrData:protected] => Array
(
[dedupe] => 1
[id] => 141
[label] => Kolpinghaus Wuppertal-Elberfeld
[label_place] =>
[organisation] => Kolpinghaus Wuppertal-Elberfeld e.V.
[membernumber] => 15830
[address_street] => Laurentiusstr. 4-6
[address_postcode] => 42103
[address_city] => Wuppertal-Elberfeld
[address_country] => Deutschland
[phone] => (0202) 300 847
[fax] => (0202) 495 87 44
[email] => grotebeverborg@web.de
[website] => http://kolping-wuppertal.de/
[website_house] =>
[website_restaurant] =>
[website_hotel] =>
[website_familyhotel] =>
[website_congresshotel] =>
[website_housing] =>
[website_socialhousing] =>
[geocode_accuracy] => 0
[geocode_lat] => 51.2565496
[geocode_lon] => 7.1401821
[geocode_zoom] => 0
[content_title] =>
[content_intro] =>
[content_lage] =>
[image_overview] =>
[image_detailmain] =>
[image_hotel] =>
[image_logo] =>
[image_house] =>
[text_beschreibung] =>
[ctrl_position] => 0
[ctrl_show] => 1
[type_house] => 1
[type_restaurant] => 0
[type_hotel] => 0
[type_familyhotel] => 0
[type_congresshotel] => 0
[type_housing] => 0
[type_socialhousing] => 1
[is_active] => 1
)
[arrTableFields:protected] => Array
(
)
[arrActionHandler:protected] => Array
(
)
[arrRelations:protected] => Array
(
)
[arrSavedData:protected] => Array
(
)
[files] => DataItemFiles Object
(
[website:protected] =>
[baseFilesDir:protected] => house
[dataItem:protected] => VKH_House Object
*RECURSION*
[storagemode:protected] => 1
)
[format] => json
)
)
)
DataItemFilter Object
(
[mode:protected] => 1
[showAll:protected] =>
[sqlLabel:protected] =>
[sqlWhere:protected] =>
[sqlOrder:protected] => address_city
[arrFilterParams:protected] => Array
(
[type_socialhousing] => 1
)
[startDate:protected] =>
[endDate:protected] =>
[year:protected] =>
)
Haus
www
Bern (1)
Hannover (1)
Neuss (1)
Nordhorn (1)
Wuppertal-Elberfeld (1)