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 jos_hp_properties AS p, jos_hp_companies AS c\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_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\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW()) AND p.id=\'56\'\nORDER BY p.name asc\nLIMIT 0, 9999
Warning: Invalid argument supplied for foreach() in /home/malaysianp/domains/malaysianpropertypartners.com/public_html/components/com_hotproperty/functions.hotproperty.php on line 80
Beachfront Resort Development - 40% per annum returns
Warning: Invalid argument supplied for foreach() in /home/malaysianp/domains/malaysianpropertypartners.com/public_html/components/com_hotproperty/hotproperty.html.php on line 590
Disclaimer These particulars are intended as a general guide only and do not constitute any part of an offer or contract. All descriptions, dimensions, references to condition and necessary permissions for use and occupation, and other details are given without responsibility. Intending purchasers or tenants should satisfy themselves as to the accuracy of all statements and representations before entering into any agreement. No employee or partner of Mercantile and Gentry or its affiliates has authority to make or give any representation or warranty in relation to the property.
