About Us    

Apartment Search   

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


Executive Roomspace - Oaks Square
Epsom, Surrey

 
PROPERTY INFORMATION
Description: Located in the heart of the Epsom Lifestyle Centre, containing restaurants, health club, bars, shopping and library. A 2 minute walk from the mainline rail station, connecting directly with London Waterloo and London Victoria as well as other South Eastern train services. Epsom Racecourse, Ashley Centre and the Playhouse Theatre are all nearby.

Room Rates: Starting at gbp. 625 per week.

Facilities and services: Wooden floors, terrace, triple glazing, washing-machine, dishwasher, microwave, entryphone and Maid Service. Fully furnished and ready for immediate occupation.

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.