A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/realestate.php

Line Number: 154

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/thecondo/public_html/system/libraries/Exceptions.php:166)

Filename: codeigniter/Common.php

Line Number: 356

Database Error

A Database Error Occurred

Error Number: 1064

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 re_complex.complex_is_featured = 1 GROUP BY `re_complex`.`ComplexNm` ORDER B' at line 8

SELECT * FROM (`re_complex`) LEFT JOIN `re_neighborhood` ON `re_neighborhood`.`id_neigh` = `re_complex`.`Neighborhood` LEFT JOIN `re_cities` ON `re_cities`.`id_city` = `re_neighborhood`.`id_city` LEFT JOIN `re_regions` ON `re_cities`.`id_region` = `re_regions`.`id_region` LEFT JOIN `gallery` ON `re_complex`.`id_complex` = `gallery`.`parent_id` AND gallery.parent_type = 2 AND gallery.isfirst = 1 WHERE `re_complex`.`id_website` = 116 AND `re_complex`.`Neighborhood` = AND re_complex.complex_is_featured = 1 GROUP BY `re_complex`.`ComplexNm` ORDER BY `re_complex`.`ComplexNm` asc