ERROR: Unknown column 'article_id' in 'on clause'
---
SELECT count(article_id) AS allcount FROM hot_articles, hot_categories LEFT JOIN traveldir.hotels ON article_id=id WHERE system='all' AND status=1 AND rating<=2 AND article_categoryid=category_id AND article_state=1 AND category_id='61'
---
Unknown column 'article_id' in 'on clause'Unknown column 'article_id' in 'on clause'Unknown column 'article_id' in 'on clause'ERROR: Unknown column 'article_id' in 'on clause'
---
SELECT count(article_id) AS allcount FROM hot_articles, hot_categories LEFT JOIN traveldir.hotels ON article_id=id WHERE system='all' AND status=1 AND rating<=2 AND article_categoryid=category_id AND article_state=1 AND category_id='61'
---
Unknown column 'article_id' in 'on clause' 2 Star Hotels in New York - New York Cheap Hotel Reservation
Home · About · Articles · Find · Hotels · Maps · Link to us · Contact
Read First
Traveldir.org presents New York hotels, hostels, resorts, apartments and other accommodation properties. You can find discount room rates or cheap hotels in New York if you wish to make a hotel reservation online. You can also submit a hotel review or rate hotels you recently stayed in.
Currency Exchange
into
Measurement Conversion
=
Bookmark using any bookmark manager!
You are here:
Home > North America > United States > New York > Hotels
Hotels > North America > United States > New York > New York > 2 star

show all hotels · 5 star only · 4 star only · 3 star only · 2 star and below

See also: New York Start Page · New York Travel Articles · New York Hotel List

Click here to bookmark this site: Bookmark Hotels & Travel Guide
New York Hotels - 2 star
Hotels > North America > United States > New York > New York > 2 star

2 star hotels in New York:
Sohotel Sohotel 2 star

Welcome to a historic hotel with moderate rates. The Sohotel is the oldest hotel in NYC is located in lower Manhattan only a few steps from Little Italy and China Town. · From Sohotel you can walk to about 100 different restaurants and you can enjoy nearby museums, art galleries, theaters, shops, m ...
Hotel New York Inn 2 star
Morningside Inn 2 star
Milford Plaza Hotel 2 star
Regency Inn & Suites 2 star
Marrakech Hotel 2 star
Days Hotel New York City Broadway 2 star
Hotel The Salisbury 2 star
Hotel The Portland Square 2 star
Broadway Hotel & Hostel 2 star
Hotel Imperial Court 2 star
Hotel Chelsea Star 2 star
Alcove Studio 2 star
Best Western Convention Center 2 star
Hotel 17 2 star
Wolcott Hotel 2 star
Pan American Hotel 2 star
Best Western Kennedy Airport 2 star
Holiday Inn Express Queens/Midtown Tunnel 2 star
Holiday Inn Express New York City Fifth Avenue 2 star
Days Inn Brooklyn 2 star
Latham Hotel 1 star
Manhattan Broadway Hotel 1 star
Windsor Hotel 2 star
Edison Hotel 2 star
Hotel Stanford 2 star
Hotel Alexander 2 star
Gershwin Hotel 2 star
Days Inn Broadway at 94th Street 2 star
Hotel Amsterdam Inn 2 star
Hotel Extended Stay Mini Suites of Minetta 2 star
Hotel Grand Union 2 star
Hotel 31 2 star
Comfort Inn Brooklyn 2 star
Hotel La Quinta Inn 2 star
Hotel Days Inn Jamaica - JFK Airport 2 star
JC's New York Hotel 2 star
Hotel Union Square Inn 2 star
Hotel Howard Johnson Inn Suffern 2 star
Hotel StarLite Motel 2 star
Hotel Riverside Studios 1 star
Americana Inn 2 star
Thirty Thirty Hotel 2 star
Super 8 Motel Long Island City 2 star
WooGo Encore Midtown Apartments 2 star
Ramada Adria Conference Center Bayside 2 star
Newton Hotel 2 star
Days Inn Hicksville Long Island 2 star
Harlem Ymca Hotel 2 star
Ramada Hotel Yonkers 2 star
www.traveldir.org