Find the latest houses and flats for sale in Greenwich SE10!. This page presents the most recently-added properties available to buy in Greenwich. Use the links in the sidebar to see results filtered by price.
connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
//property block
echo “
echo “
if (strpos($row[“status”], ‘rent’) !== false) {echo “£” . $row[‘price’]. ” per week“;}
else
{echo “£” . number_format($row[‘price’]). ““;}
if ($row[‘price_modifier’]!=””) {echo ” (“. str_replace(“_”, ” “, $row[‘price_modifier’]). “)“;}
echo “
“;
if (strpos($row[“status”], ‘rent’) !== false) {echo “To Rent
“;}
else
{echo “For Sale
“;}
$myaddress = “”;
if ($row[‘street_name’]!=””) {$myaddress = $row[‘street_name’];}
else
{$myaddress = $row[‘displayable_address’];}
if ($myaddress=”London”) {$myaddress = $row[‘displayable_address’];}
$myaddress = str_replace(“London”,””,$myaddress);
$myaddress = str_replace(“SE10″,””,$myaddress);
$myaddress = str_replace(“Greenwich”,””,$myaddress);
$myaddress = str_replace(“,”,” “,$myaddress);
$myaddress = str_replace(” “,” “,$myaddress);
echo “” . $myaddress. ““;
if ($row[‘num_bedrooms’]>0)
{echo “” . $row[‘num_bedrooms’]. ” bed ” . $row[‘property_type’]. ““;}
echo “
” . $row[“agent_name”]. ““;
echo “
Online since ” . $row[‘first_published_date’]. ““;
echo “
“;
}
} else {
echo “0 results”;
}
$conn->close();
?>