prepare($updateQuery)) { $stmt->bind_param('i',$ID); $stmt->execute(); $stmt->close(); } ## get property array $query="SELECT * FROM ".$table." WHERE ID=?"; if ($stmt = $mysqli->prepare($query)) { $stmt->bind_param('i',$ID); $stmt->execute(); $result = $stmt->get_result(); $rowcount=mysqli_num_rows($result); if ($rowcount>0) { while ($row = $result->fetch_assoc()) { $data[] = $row; //SET THJE TYPE OF PROPERTY sale/rent $listingType=$row['subCat']; } $stmt->close(); } else { header('Location:404.php'); exit; } } ##get the alt images ## get property array if ($stmt = $mysqli->prepare("SELECT * FROM propertyImages WHERE propertyID=?")) { $stmt->bind_param('i',$ID); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $dataImg[] = $row; } $stmt->close(); } switch ($data[0]['category']) { case 'FS': $status = "For Sale"; $activeStatus='Active'; $colour='primary'; break; case 'SD': $status = "Sold"; $colour='red'; $activeStatus='Off Market'; break; case 'UO': $status = "Under Offer"; $colour='indigo'; $activeStatus='Pending'; break; case 'TL': $status = "To Let"; $colour='primary'; $activeStatus='Active'; break; case 'LET': $status = "LET"; $colour='red'; $activeStatus='Off Market'; break; case 'UA': $status = "Under Application"; $colour='indigo'; $activeStatus='Pending'; break; case 'AS': $status = "Available Soon"; $colour='indigo'; $activeStatus='Coming Soon'; break; } if ($listingType=='sale') { $salePrice = $data[0]['prefix'] . " £" . $data[0]['price']; } else { $salePrice = "£" . $data[0]['price'] . $data[0]['prefix']; } //echo '
';print_r($dataImg);echo '
'; ?> Kintrye Property Company - <? echo strToUpper($data[0]['subCat']); ?> Schedule Ref: <? echo $data[0]['refNo']; ?>
0) { for ($x=0; $x<=count($dataImg)-1; $x++) { ?>
0) {?>
Gallery 01
0) { for ($x=0; $x<=count($dataImg)-1; $x++) { ?>
Gallery 02

Description


".$data[0]['info2'];} ?> ".$data[0]['info3'];} ?>

Key Information

Type

Year Built

Heating

Garden

Bedrooms

Bathrooms

Parking

Status

Features

Floor Plans

Floor Plans

Property Attachments

Home Report

Home Report

Download

How to download
To access & download the Home Report for this property, please first fill in our information request form.

Once complete & sent to us, the download will become immediately available.

Property Video Tour

Location

],"className":"marker","backgroundImage":"images/googlle-market-01.png","backgroundRepeat":"no-repeat","width":"30px","height":"40px"}]'>


Emilia McMillan
Emilia McMillan Proprietor