$intOSY = $row["osy"];
$intTenure = $row["lease_free"];
$intStatus = $row["state_of_trade_id"];
$intType = $row["type_id"];
if ($intType == "1" || $intType == "2" || $intType == "5" || $intType == "7") {
$strLinkType = "House";
} elseif ($intType == "3" || $intType == "4" || $intType == "6") {
$strLinkType = "Apartment";
} elseif ($intType == "8") {
$strLinkType = "Commercial";
} elseif ($intType == "9") {
$strLinkType = "Live/Work";
}
$intArea = $row["area_id"];
$strLongDescription = format_description($row["longDescription"]);
$strDescription = format_strap($row["description"]);
$strGCH = $row["gch"];
$strDG = $row["doubleGlazed"];
$intReceptions = $row["receptions"];
$intBedrooms = $row["bedrooms"];
$intBathrooms = $row["bathrooms"];
$intGarden = $row["garden"];
$intParking = $row["parking"];
$strNotes = $row["notes"];
$strTotalArea = $row["total_area"];
$strImage0 = $row["image0"];
$strImage1 = $row["image1"];
$strImage2 = $row["image2"];
$strImage3 = $row["image3"];
$strImage4 = $row["image4"];
$strImage5 = $row["image5"];
$lease_free = $_POST["lease_free"];
$state_of_trade_id = $_POST["state_of_trade_id"];
$type_id = $_POST["type_id"];
$area_id = $_POST["area_id"];
if (!$_POST["description"]) {
// create temporary strap line
if ($_POST["bedrooms"]) {
$description = $_POST["bedrooms"] . ' Bed ';
}
$sqlD = "SELECT * FROM propType WHERE type_ID = {$type_id}";
$qD = $db->query($sqlD);
while ($rowD = $qD->fetchRow()) {
$description .= $rowD["type_Title"];
}
} else {
$description = trim(format_strap($_POST["description"]));
}
if (!$_POST["longDescription"]) {
$longDescription = '<p>Full details to follow</p>';
} else {
$longDescription = trim($_POST["longDescription"]);
}
$gch = $_POST["gch"];
$doubleGlazed = $_POST["doubleGlazed"];
$receptions = $_POST["receptions"];
$bedrooms = $_POST["bedrooms"];
$bathrooms = $_POST["bathrooms"];
$measure = $_POST["measure"];
$total_area = $_POST["total_area"];
$image0 = $_POST["image0"];
$image1 = $_POST["image1"];
