About Us    

Apartment Search   

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

Executive Roomspace - Cramer House
London - Marylebone High Street

Description:Cramer House is a newly-built property of split-level, one-bedroom, duplex apartments, occupying two floors with private internal staircase and separate cloakroom.

The property is furnished to a very high standard, a lift serves all floors.

A few minutes walk north of Bond Street tube station, ideal for Oxford Street shopping, Harley Street and Marylebone High Street. There are numerous restaurants and shops in the area and Baker Street tube is also just a short walk away.

Facilities and services: Each apartment has washer/drier, microwave oven, TV, video. There are a limited number of private, underground parking spaces which can be booked subject to availability.

Room Rates: Starting at gbp. 650 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.

"; $propname = $a; //----------------------------------------------------------------------------------------------------// //connect to database displying simple error message if problem and surpressing other errors using "@" $conn = @mysql_connect("","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 "



\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"; } echo ""; ?>

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