Property Listing
Warning: array_keys(): The first argument should be an array in /home/.sites/119/site80/web/components/com_mambelfish/classes/mambelfish.class.php on line 164
Warning: Invalid argument supplied for foreach() in /home/.sites/119/site80/web/components/com_mambelfish/classes/mambelfish.class.php on line 164
Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM mos_hp_properties AS p, mos_hp_companies AS c\n LEFT JOIN mos_hp_agents AS a ON p.agent = a.id\n LEFT JOIN mos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN mos_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id AND 1 AND p.id=\'200\'\nORDER BY p.name asc\nLIMIT 0, 9999
Warning: Invalid argument supplied for foreach() in /home/.sites/119/site80/web/components/com_hotproperty/functions.hotproperty.php on line 83
Warning: Invalid argument supplied for foreach() in /home/.sites/119/site80/web/components/com_hotproperty/hotproperty.html.php on line 609
Send enquiry / Make an appointment
|
