DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 199' at line 10 Travel Information and Hotel Reservations
San Francisco, United States The Mayflower Hotel is a classical old world hotel with hand painted murals, situated in a central location near Union Square, Chinatown and Grace Cathedral. It is a newly renovated boutique hotel on the slope of Nob Hill featuring comfortable surroundings. Many of the tastefully decorated rooms in this historic hotel have spectacular views of San Francisco. Each room is en-suite (shower and tub) with ample storage space. Guests can control each room?s temperature, and there are ceiling fans for guests? comfort. All rooms include modern amenities such as cable Television, complimentary DSL/wireless Internet connection, microwave and refrigerator for the guest?s convenience. Each morning of your stay, you can enjoy a complimentary continental breakfast! The hotel is in a great location, close to the cable cars leading to Fisherman?s wharf and the greater surrounding area of San Francisco. Mayflower Hotel: Where Union Square meets the slope of Nob Hill... PLEASE NOTE: OUR QUAD ROOMS CONSIST OF TWO DOUBLE BEDS. If necessary we can put a roll away in a triple room. Rates are NOT inclusive of tax.
