<div id="main">
<?php
$estates = $dao->getForeclosureDates();
echo "<table>";
echo "<tr> ";
echo "<th> " . "Address " . " </th>";
echo "<th> " . "City " . " </th>";
echo "<th> " . "Owed on Note " . " </th>";
echo "<th> " . "Assessed At " . " </th>";
echo "<th> " . "Owner " . " </th>";
echo "<th> " . "Auction Place " . " </th>";
echo "<th> " . "Auction Time " . " </th>";
echo "<th> " . "Detailed Information " . " </th>";
echo "</tr> ";
foreach ($estates as $estate) {
$house = $dao->getPropertyParcelNum($estate["address"]);
$assessed = $dao->getEstate2($house["Parcel"]);
echo "<tr> ";
echo "<td> " . $estate["address"] . " </td>";
echo "<td> " . $estate["city"] . " </td>";
echo "<td> " . $estate["Morg_amoun"] . " </td>";
echo "<td> " . $assessed["Totalvalue"] . " </td>";
echo "<td> " . $estate["Owner"] . " </td>";
echo "<td> " . $estate["Auction_plac"] . " </td>";
echo "<td> " . $estate["Auction_time"] . " </td>";
echo "<td><a href='detail.php?Parcel=" . $house["Parcel"] . "'>" . " More Data" . "</a></td>";
echo "</tr> ";
}
echo "</table>";
?>
<br>