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=3 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=3 AND article_categoryid=category_id AND article_state=1 AND category_id='61'
---
Unknown column 'article_id' in 'on clause' 3 Star Hotels in New York - New York Budget 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 > 3 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 - 3 star
Hotels > North America > United States > New York > New York > 3 star

3 star hotels in New York:
Hotel Metro 3 star
Warwick Hotel 3 star
Washington Jefferson Hotel 3 star
The Quality Hotel Times Square 3 star
Hotel 373 3 star
Wellington Hotel 3 star
Belleclaire Hotel 3 star
Comfort Inn Long Island City 3 star
Hotel Azure 3 star
New Yorker Ramada Plaza 3 star
Hotel Red Roof Inn Manhattan 3 star
Hotel La Quinta Manhattan 3 star
Hotel Park 79 3 star
Comfort Inn Midtown 3 star
Hotel Super 8 Times Square 3 star
Hotel Ramada Inn Eastside 3 star
Hotel The Lombardy 3 star
Ameritania Hotel 3 star
Comfort Inn Manhattan Hotel 3 star
Broadway Plaza 3 star
Hotel Pennsylvania 3 star
The Mansfield Hotel 3 star
The Tudor Hotel 3 star
Clarion Hotel Park Avenue 3 star
The Roger Smith Hotel 3 star
Club Quarters Downtown 3 star
Radisson Lexington Hotel 3 star
Park Central Hotel 3 star
Affinia Manhattan Hotel 3 star
Affinia 50 Hotel 3 star
Affinia Gardens Hotel 3 star
On The Avenue Hotel 3 star
Affinia Dumont Hotel 3 star
Eastgate Tower Hotel 3 star
Shelburne Murray Hill 3 star
Beacon Hotel 3 star
Washington Square Hotel 3 star
Holiday Inn Express Brooklyn 3 star
Hotel Holiday Inn Manhattan Downtown/Soho 3 star
Best Western Seaport Inn 3 star
Best Western Woodbury Inn 3 star
Club Quarters Midtown - Times Square 3 star
Hotel Wales 3 star
Hotel Helmsley Middletowne 3 star
Hotel 41 at Times Square 3 star
Novotel New York - Times Square 3 star
Amsterdam Court Hotel 3 star
Studio 75 3 star
www.traveldir.org