Rund 300 Immobilien zur Auswahl

Sie suchen ein Haus oder eine Wohnung in Idstein, Hattersheim oder Frankfurt? Vielleicht aber auch in Bad Vilbel, Bad Soden oder Wiesbaden? Prüfen Sie unser Angebot an Immobilien auf der Suche nach Ihrem neuen Zuhause. Mehr als 300 kompetent gebaute Eigentumswohnungen und Häuser im gesamten Rhein-Main-Gebiet warten auf Ihre Auswahl.

Ihre Auswahl

Sie suchen:

Ort und Straße:

Sortierung:


There was an error with the database query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tx_realty_objects.house_type = 2 LIMIT 0,1' at line 1 The last built query: SELECT COUNT(*) AS oelib_counter FROM tx_realty_objects INNER JOIN tx_realty_cities ON tx_realty_objects.city = tx_realty_cities.uid WHERE 1=1 AND tx_realty_objects.deleted=0 AND tx_realty_objects.t3ver_state<=0 AND tx_realty_objects.pid<>-1 AND tx_realty_objects.hidden=0 AND tx_realty_objects.starttime<=1464604200 AND (tx_realty_objects.endtime=0 OR tx_realty_objects.endtime>1464604200) AND tx_realty_cities.deleted=0 AND house_type = 2 AND tx_realty_objects.city = 2 AND tx_realty_objects.project_id = AND tx_realty_objects.house_type = 2 LIMIT 0,1

#0 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/oelib/class.tx_oelib_db.php(395): tx_oelib_db::select('COUNT(*) AS oel...', 'tx_realty_objec...', '1=1 AND tx_real...', '', '', '0,1')
#1 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/oelib/class.tx_oelib_db.php(363): tx_oelib_db::selectMultiple('COUNT(*) AS oel...', 'tx_realty_objec...', '1=1 AND tx_real...', '', '', '0,1')
#2 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/oelib/class.tx_oelib_db.php(465): tx_oelib_db::selectSingle('COUNT(*) AS oel...', 'tx_realty_objec...', '1=1 AND tx_real...')
#3 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1_AbstractListView.php(641): tx_oelib_db::count('tx_realty_objec...', '1=1 AND tx_real...')
#4 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1_AbstractListView.php(234): tx_realty_pi1_AbstractListView->createLimitStatement('1=1 AND tx_real...')
#5 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1_AbstractListView.php(191): tx_realty_pi1_AbstractListView->initListView()
#6 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1_AbstractListView.php(176): tx_realty_pi1_AbstractListView->fillListRows()
#7 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1.php(232): tx_realty_pi1_AbstractListView->render(Array)
#8 /www/www.dietmar-buecher.de/htdocs/typo3conf/ext/realty/pi1/class.tx_realty_pi1.php(128): tx_realty_pi1->getHtmlForCurrentView()
#9 [internal function]: tx_realty_pi1->main('', Array)
#10 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(6585): call_user_func_array(Array, Array)
#11 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_user.php(55): tslib_cObj->callUserFunction('tx_realty_pi1->...', Array, '')
#12 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_User->render(Array)
#13 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(600): tslib_cObj->cObjGetSingle('USER', Array, 'plugin.tx_realt...')
#14 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_case.php(52): tslib_cObj->cObjGetSingle('< plugin.tx_rea...', NULL, 'realty_pi1')
#15 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_Case->render(Array)
#16 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(562): tslib_cObj->cObjGetSingle('CASE', Array, '20')
#17 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_contentobjectarray.php(48): tslib_cObj->cObjGet(Array)
#18 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_ContentObjectArray->render(Array)
#19 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_case.php(52): tslib_cObj->cObjGetSingle('COA', Array, 'list')
#20 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_Case->render(Array)
#21 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(600): tslib_cObj->cObjGetSingle('CASE', Array, 'tt_content')
#22 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_content.php(140): tslib_cObj->cObjGetSingle('<tt_content', NULL, '')
#23 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_Content->render(Array)
#24 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/content/class.tslib_content_template.php(189): tslib_cObj->cObjGetSingle('CONTENT', Array, 'marks.MCOL')
#25 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(615): tslib_content_Template->render(Array)
#26 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_content.php(562): tslib_cObj->cObjGetSingle('TEMPLATE', Array, '10')
#27 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/class.tslib_pagegen.php(259): tslib_cObj->cObjGet(Array)
#28 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/pagegen.php(74): TSpagegen::renderContent()
#29 /www/www.dietmar-buecher.de/htdocs/typo3/sysext/cms/tslib/index_ts.php(353): include('/www/www.dietma...')
#30 /www/www.dietmar-buecher.de/htdocs/index.php(76): require('/www/www.dietma...')
#31 {main}