MySQL server has gone away SQL=SELECT m.* FROM jos_menu AS m\nWHERE menutype=\'mainmenu\' AND published=\'1\' AND access <= \'0\'\nORDER BY parent,ordering Colonial Real Estate - Property Listing
Property Listing
MySQL server has gone away 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())\nAND p.featured=\'1\'\nORDER BY f.ordering ASC\nLIMIT 0, 3MySQL server has gone away SQL=SELECT COUNT(*) AS total FROM jos_hp_properties AS p\nLEFT JOIN jos_hp_prop_types AS t ON t.id=p.type\nWHERE p.published=1 AND p.approved=\'1\' AND t.published=1\n AND p.featured=1\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())
Search Property:  Advanced Search

Property Types