$output .= " <td><b>HOA Fee:</b> </td><td>\$" . number_format($data_listing[$db_hoa_fee]) . "</td>\n";
$output .= " <td><b>Agent Owned:</b> </td><td>" . $data_listing[$db_owner_agent_yn] . "</td>\n";
$output .= " <td><b>Rear Exposure:</b> </td><td>" . $data_listing[$db_zoning] . "</td></tr>\n";
$output .= " </table><br />\n";
$output .= " <table width='100%' border='0' cellpadding='1' cellspacing='0' style='font-family: Arial,Helvetica,sans-serif;font-size: 12px;color: #000;'>\n";
$output .= " <tr><td><b>Legal:</b> </td><td>" . $data_listing[$db_legal_descr] . "</td></tr>\n";
$output .= " </table><br />\n";
$output .= " <table width='100%' border='0' cellpadding='1' cellspacing='0' style='font-family: Arial,Helvetica,sans-serif;font-size: 12px;color: #000;'>\n";
if (!empty($row_lister[$db_firm_name])) {
$output .= " <tr><td colspan='3'><b>Courtesy of:</b> " . $row_lister[$db_firm_name] . "</td></tr>\n";
}
$output .= " <tr><td colspan='3'><b>For more information or to visit this property, Contact:</b></td></tr>\n";
$output .= " <tr><td>\n";
if (!empty($agent_name)) {
if (agent_photo_exists($display_agent)) {
$photo_src = agent_photo_exists($display_agent);
$img_info = getimagesize($abs_agents . $photo_src);
$output .= "<img src='" . $http_mugs . $photo_src . "' " . $img_info[3] . " alt='{$agent_name}' border='0' />\n";
} else {
if (firm_logo_exists($display_firm)) {
$photo_src = firm_logo_exists($display_firm);
$img_info = getimagesize($abs_agents . $photo_src);
$output .= "<img src='" . $http_mugs . $photo_src . "' " . $img_info[3] . " alt='" . $data_display_entity['firm_' . $db_firm_name] . "' border='0' />\n";
}
}
} else {
if (firm_logo_exists($display_firm)) {
$photo_src = firm_logo_exists($display_firm);
$img_info = getimagesize($abs_agents . $photo_src);
$output .= "<img src='" . $http_mugs . $photo_src . "' " . $img_info[3] . " alt='" . $data_display_entity['firm_' . $db_firm_name] . "' border='0' />\n";
}
if (!empty($row1['descr'])) {
echo stripslashes($row1['descr']);
}
echo " </td>\n";
echo "</tr>\n";*/
}
} else {
/* Otherwise display table of all agents in firm and office */
$cell_num = 1;
while ($row1 = $result1->fetch(PDO::FETCH_ASSOC)) {
if ($cell_num == 1) {
echo " <tr>\n";
}
echo " <td align='center' valign='top'>\n";
if (agent_photo_exists($row1[$db_agent_id])) {
$photo_src = agent_photo_exists($row1[$db_agent_id]);
$img_info = getimagesize($abs_agents . $photo_src);
echo "<a href='" . $_SERVER['PHP_SELF'] . "?agent_id=" . $row1[$db_agent_id] . "&{$str_url_vars}'><img src='" . $http_agents . $photo_src . "' " . $img_info[3] . " alt='" . $row1[$db_agent_fname] . " " . $row1[$db_agent_lname] . "' border='0' /></a><br />\n";
}
echo "<a href='" . $_SERVER['PHP_SELF'] . "?agent_id=" . $row1[$db_agent_id] . "&{$str_url_vars}'><strong>" . $row1[$db_agent_fname] . " " . $row1[$db_agent_lname];
echo "</strong></a><br />\n";
if (!empty($row1[$db_agent_email])) {
echo "<a href='mailto:" . $row1[$db_agent_email] . "'>Contact Me</a><br />\n";
}
if (!empty($row1[$db_agent_website])) {
// Check for http prefix
if (substr($row1[$db_agent_website], 0, 7) != "http://" || substr($row1[$db_agent_website], 0, 8) != "https://") {
$row1[$db_agent_website] = "http://" . $row1[$db_agent_website];
}
echo "<a href='" . $row1[$db_agent_website] . "' target='_blank'>Visit My Website</a>\n";
}