John GoodwinJohn Goodwin Property Professionals

"; echo("" . $row['p_bedrooms']); if($row['p_bedrooms'] > 1) { echo(" Bedrooms "); } else { echo(" Bedroom "); } echo($row['p_housetype'] . " - "); if (($row['p_propertyclass']=="Residential Letting") or ($row['p_propertyclass']=="Commercial Letting") or ($row['p_propertyclass']=="Industrial Letting")) { echo '£'. number_format($row['p_rent']) ." " .$row['p_rentfrequency']; } else { echo( $row['p_pricetype'] . " £" . number_format($row['p_sellingprice'])); } if ($row['p_sstc'] == "T") { if (($row['p_status']=="Sold") or ($row['p_status']=="Let")) { if ($row['p_status']=="Sold") { echo " - Let"; } else { echo" - Let Pending"; } } else { if ($row['p_status']=="Sold") { echo" - Sold"; } else { echo" - SSTC"; } } } echo ("

"); if($numberofroompics > 0){ echo("
"); if(($row['p_picture']!="") && (file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row['p_picture'])))) { echo("\"Main"); } else { echo("\"Main"); } /*$sql_inner="SELECT * FROM rooms WHERE r_property_ref = '". $id . "' AND r_picture != '' AND r_roomname NOT LIKE '%floorplan%' AND r_roomname NOT LIKE '%EPC%' ORDER BY r_order"; $result_inner=mysql_query($sql_inner); while($row_inner=mysql_fetch_array($result_inner)) { if(file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row_inner['r_picture']))) { echo("\"""); } }*/ echo("
"); } else { if(($row['p_picture']!="") && (file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row['p_picture'])))) { echo("
\"Main
"); } else { echo("
\"Main
"); } } echo("

Property Summary

" . $row['p_adverttext'] . "

"); $sql_inner="SELECT * FROM rooms WHERE r_property_ref ='" . $id . "' AND r_roomname NOT LIKE '%floor plan%' ORDER BY r_order"; $result_inner=mysql_query($sql_inner); while($row_inner=mysql_fetch_array($result_inner)) { if(($row_inner['r_roomname']!="")&&($row_inner['r_description']!="")) { echo("

" . $row_inner['r_roomname'] . ""); if(!empty($row_inner['r_dimensions'])) { echo(" - " . $row_inner['r_dimensions']); } if((file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row_inner['r_picture'])))&&($row_inner['r_picture'] != "")) { echo("
\"""); } echo("

" . $row_inner['r_description'] . "

"); } } $sql_epc="SELECT * FROM rooms WHERE r_property_ref = '". $id . "' AND r_picture != '' AND r_roomname LIKE '%EPC%' ORDER BY r_order"; $result_epc=mysql_query($sql_epc); echo("
"); while($row_epc=mysql_fetch_array($result_epc)) { if(file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row_epc['r_picture']))) { echo("\"""); } } echo ("
"); $sql_floors="SELECT * FROM rooms WHERE r_property_ref = '". $id . "' AND r_picture != '' AND r_roomname LIKE '%floor plan%' ORDER BY r_order"; $result_floors=mysql_query($sql_floors); while($row_floors=mysql_fetch_array($result_floors)) { if(file_exists("./data/" . str_replace(".jpg","_fs.jpg",$row_floors['r_picture']))) { $imgsize = getimagesize("./data/".str_replace(".jpg","_fs.jpg",$row_floors['r_picture'])); if ($imgsize[1] >300) { $imgheight=300; } else { $imgheight=$imgsize[1]; } echo("

" . $row_floors['r_roomname'] . "
\""

"); } } if(file_exists("data/" . $id . "EnergyReport_fs.jpg")){ echo "
\"Energy
"; } echo("

The property details listed on this Web Site are subject to almost constant change and update. For the very latest information on the property seen on this site, please contact us immediately regarding the property you are interested in.

For clarification, we wish to inform prospective purchasers that we have listed the details of these properties as a general guide. We have not carried out a detailed survey nor tested the services, appliances or specific fittings. Room sizes should not be relied upon for carpets and furnishings.

"); } ?>