Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:490:\"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5\nquery: SELECT \n SQL_CACHE COUNT(DISTINCT(profiles.profile_id)) as category_count \n FROM vti_user_profiles profiles \n INNER JOIN vti_business_profiles bprofiles ON bprofiles.profile_id=profiles.profile_id\n WHERE profiles.status=1 AND (profiles.category_id=29) AND profiles.city_id IN ()\";s:5:\"%file\";s:94:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/inventory/inventory.module\" in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:490:\"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5\nquery: SELECT \n SQL_CACHE COUNT(DISTINCT(profiles.profile_id)) as category_count \n FROM vti_user_profiles profiles \n INNER JOIN vti_business_profiles bprofiles ON bprofiles.profile_id=profiles.profile_id\n WHERE profiles.status=1 AND (profiles.category_id=29) AND profiles.city_id IN ()\";s:5:\"%file\";s:94:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/inventory/inventory.module\" in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
VisitSFBayArea.com

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:213:\"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\nquery: SELECT * FROM vti_cities_master WHERE city_id =\";s:5:\"%file\";s:94:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/utilities/utilities.module\";s:5:\"%line\";i:699;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
SF Bay Area

By Region

By City

My Itinerary 430
Home » Stay » San Francisco » Chinatown

San Francisco Hotels

No matter your budget or your desired location, you'll find a San Francisco Bay Area hotel to meet your needs. Affordable, mid-range, luxury? Union Square, Nob Hill, Financial District? You'll find them all here. Beyond San Francisco? Our guide includes Marin, Sonoma, Napa, East Bay, Silicon Valley, Monterey, Sacramento, and more-all here at your fingertips, in one directory, in an easy-to-use format.

     
Show Stay on a map
Stay | Locations Star Rating

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:176:\"Missing argument 2 for variable_get(), called in /var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/listings/templates/listings.tpl.php on line 248 and defined\";s:5:\"%file\";s:57:\"/var/www/vhosts/visitsfbayarea.com/includes/bootstrap.inc\";s:5:\"%line\";i:502;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
  • SW Hotel DETAILS
    • SW Hotel
    • Star rating of Star rating of Star rating of

      • Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:179:\"Missing argument 4 for get_item_exists(), called in /var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/listings/templates/listings.tpl.php on line 339 and defined\";s:5:\"%file\";s:94:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/utilities/utilities.module\";s:5:\"%line\";i:819;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
    • ADD TO MY ITINERARY
    • San Francisco, California
      Looking for a small, elegant and sophisticated boutique hotel that puts you right at the center of everything San Francisco has to offer? Whether you're in town for business or pleasure, the SW Hotel is the perfect place to stay... more» 

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:176:\"Missing argument 2 for variable_get(), called in /var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/listings/templates/listings.tpl.php on line 248 and defined\";s:5:\"%file\";s:57:\"/var/www/vhosts/visitsfbayarea.com/includes/bootstrap.inc\";s:5:\"%line\";i:502;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
  • Grant Plaza Hotel DETAILS
    • Grant Plaza Hotel
    • Star rating of Star rating of

      • Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:179:\"Missing argument 4 for get_item_exists(), called in /var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/listings/templates/listings.tpl.php on line 339 and defined\";s:5:\"%file\";s:94:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/utilities/utilities.module\";s:5:\"%line\";i:819;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
    • ADD TO MY ITINERARY
    • San Francisco, California
      Location and value! The Grant Plaza Hotel in San Francisco has been rated by many as a "Best Buy" and is right in the heart of San Francisco. The garage is conveniently located two city blocks from the Grant Plaza Hotel... more» 
  • 1

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:386:\"date(): It is not safe to rely on the system\'s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone \'UTC\' for now, but please set date.timezone to select your timezone.\";s:5:\"%file\";s:88:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/events/events.module\";s:5:\"%line\";i:1307;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-fran in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:386:\"date(): It is not safe to rely on the system\'s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone \'UTC\' for now, but please set date.timezone to select your timezone.\";s:5:\"%file\";s:88:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/events/events.module\";s:5:\"%line\";i:1308;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-fran in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128

Warning: Duplicate entry '2147483647' for key 'PRIMARY' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:39:\"Invalid argument supplied for foreach()\";s:5:\"%file\";s:88:\"/var/www/vhosts/visitsfbayarea.com/sites/all/modules/Custom Modules/events/events.module\";s:5:\"%line\";i:1577;}', 3, '', 'https://www.visitsfbayarea.com/hotels/san-francisco/chinatown_3', '', '35.175.107.77', 1635269655) in /var/www/vhosts/visitsfbayarea.com/includes/database.mysql.inc on line 128
Upcoming Events
More Events
Copyright © 2000/2012 Destination Partners LLC. All Rights Reserved.
Destination Partners LLC provides portal website production, programming, maintenance and hosting services. Destination Partners is not responsible for content on external web site.
©2003-2010 Destination Partners LLC. All rights reserved. Use of this web site constitutes acceptance of the Destination Partners Terms of Use and Privacy Policy.