About Us    

Apartment Search   

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


Executive Roomspace - Queensgate
South Kensington

 

 

 

 
PROPERTY INFORMATION
Description: Executive Roomspace Queensgate is a recently converted, stucco-fronted building, in a wide and prestigious, tree-lined, residential road in Kensington, offering a selection on one bedroom apartments.

Located just 5 minutes from South Kensington Underground station and 10 minutes from Gloucester Road Tube, the Natural History as well as Victoria & Albert Museums are within short walking distance as is Harrods and the shops of Knightsbridge.

By Underground, Heathrow can be reached within 45 minutes and the West End within 10 minutes.

Room Rates: Starting at gbp. 475 per week.

Facilities and services: Lift, laundry-room, entry-phone, washing machine and dryer, maid service, cable TV, fully-equipped and furnished to the highest standard.

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.