About Us    

Apartment Search   

Moving Resources   |   Corporate Housing (uk)    Contact Us  
   
corporate housing advantages of ERS corporate housing


Executive Roomspace - Prospero House
The City of London

 

 

 
PROPERTY INFORMATION
Description: Prospero House is a new development situated in the heart of London, meticulously refurbished with limestone, granite, slate and chrome, with hardwood flooring in entrance halls and reception rooms.

In The City, with easy access to Liverpool Street, London Bridge and Waterloo mainline stations.

Room Rates: Starting at gbp. 575 per week.

Facilities and services: Video Entry System, Intruder Alarm, Satellite TV, Lift.

Your Guarantee: The Executive Roomspace Satisfaction Guarantee states that if, on arrival, you find the accommodation is not to the standard you expect, we will provide you with an alternative apartment or a full refund, provided you advise us within 48 hours of arrival.

Reservations
"; $propname = $a; //----------------------------------------------------------------------------------------------------// //connect to database displying simple error message if problem and surpressing other errors using "@" $conn = @mysql_connect("212.74.13.50","chris.tas","nov180pang4") or die ("Unable to Connect to Database: " . mysql_error()); @mysql_select_db("tas") or die ("Unable to Select Database: " . mysql_error()); //----------------------------------------------------------------------------------------------------// $query = mysql_query("SELECT * FROM details WHERE PropertyName = '$propname'"); $details_array = mysql_fetch_array($query, MYSQL_ASSOC); //create associate array from sql query $propid = $details_array['PropertyID']; $query = mysql_query("SELECT * FROM apartment WHERE PropertyID = '$propid' ORDER BY ApartmentType"); while ($apartment_array = mysql_fetch_array($query, MYSQL_ASSOC)) { $query1 = mysql_query("SELECT * FROM seasons_index WHERE ApartmentID = '$apartment_array[ApartmentID]'"); while ($seasons_index_array = mysql_fetch_array($query1, MYSQL_ASSOC)) { $query2 = mysql_query("SELECT * FROM prices WHERE PriceID = '$seasons_index_array[PriceID]'"); while ($prices_array = mysql_fetch_array($query2, MYSQL_ASSOC)) { if ($prices_array["Price"] == NULL) { //do nothing } else { //echo "
"; $query3 = mysql_query("SELECT * FROM seasons WHERE SeasonID = '$seasons_index_array[SeasonsID]'"); while ($seasons_array = mysql_fetch_array($query3, MYSQL_ASSOC)) { $current_rates[] = date("M-d-Y", mktime(0, 0, 0, $seasons_array['FromMonth'], $seasons_array['FromDay'], $seasons_array['FromYear'])) . " - " . date("M-d-Y", mktime(0, 0, 0, $seasons_array['ToMonth'], $seasons_array['ToDay'], $seasons_array['ToYear'])) . //create time stamp and pass to date function " : " . $apartment_array['ApartmentType'] ." ". $prices_array['Quality'] ." ". $prices_array['Price'] . $apartment_array["Currency"] ." per ". $apartment_array['PricesPer']; //create array with rate infomation //echo "
"; } } } } } @$current_rates = array_reverse ($current_rates); //reverse array so prices for the current season are positioned first ---------------- SUPRESSED ERROR USING '@' echo "

Rates

\n

\n"; //echo $details_array['PropertyID']; //echo '

'; if ($details_array['PropertyID'] == NULL) { echo "

Sorry rates for this apartment are unavailable; please fill out our no obligation enquiry and one of our representatives will get back to you with as soon as possible.

"; } else { foreach ( $current_rates as $val ) { echo "\t" . $val . "
\n"; //echo rate information from array } echo "

\n
\n"; } echo ""; ?>


Disclaimer : Whilst every care has been taken in giving accurate information, relocationapartments.com
does not accept responsibility for omissions or errors.