<?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>
<div id="nav3">
<?php
include "header.php";
?>
<?php
session_start();
if (isset($_SESSION["access_granted"]) && !$_SESSION["access_granted"] || !isset($_SESSION["access_granted"])) {
$_SESSION["status"] = "You need to log in first";
header("Location:login.php");
}
require_once "Dao.php";
$dao = new Dao();
$parcel = $_GET["Parcel"];
$estate = $dao->getDetails($parcel);
$estates = $dao->getEstate2($parcel);
$dao->saveUserSearch($_SESSION["email"], $estates["Address"]);
$googleLoc = $estates["Address"] . ", " . $estates["City_state"] . ", ID";
echo "<table>";
echo "<tr> ";
echo "<td> " . "Property Address" . ": " . $estates["Address"] . " </td>";
echo "<tr> ";
echo "<td> " . "Property Parcel Number" . ": " . $estates["Parcel"] . " </td>";
echo "</tr>";
echo "<tr>";
echo "<td> " . "Property Owner" . ": " . $estates["Primowner"] . " </td>";
echo "</tr>";
echo "<tr> ";
echo "<td> " . "Property Second Owner" . ": " . $estates["Secowner"] . " </td>";
echo "</tr>";
echo "<tr> ";