About Us    

Apartment Search   

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


Executive Roomspace - Sovereign House
London - West End/Fitzrovia

 
PROPERTY INFORMATION
Description: All apartments in Sovereign House are newly decorated in this modern building. Most 2-bedroom apartments also have 2 bathrooms.

Centrally situated, 5 minutes north of Oxford Street, there is excellent access to West End shopping and entertainment, as well as The City business district. Closest Tube is Warren Street or Goodge Street.

Facilities and services: Washing machine, Dishwasher, Microwave, Entry-phone, Maid Service.

Room Rates: Starting at gbp. 625 per week.

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.