SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (6) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816157 AND UNIX_TIMESTAMP(ends_on) >= 1765816157 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (2) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816157 AND UNIX_TIMESTAMP(ends_on) >= 1765816157 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (6) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816157 AND UNIX_TIMESTAMP(ends_on) >= 1765816157 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id = 4 AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15
SELECT xyz.* FROM hotel_newswire_categories AS xyz ORDER BY name ASC LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (13) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816157 AND UNIX_TIMESTAMP(ends_on) >= 1765816157 ORDER BY id LIMIT 0,15
SELECT xyz.*,fk_categories.name AS category, fk_categories.name AS fk_category,fk_categories.seo_url AS category_seo_url,fk_categories.seo_url AS fk_category_seo_url,authors.profile_image_path AS author_image,authors.title AS author_title,authors.company AS author_company,CONCAT(authors.first_name, ' ', authors.last_name) AS author_name,brstatus.name AS status FROM business_review AS xyz LEFT JOIN business_review_categories AS fk_categories ON xyz.fk_category_id = fk_categories.category_id LEFT JOIN authors ON xyz.fk_author_id = authors.author_id LEFT JOIN business_review_status AS brstatus ON xyz.fk_status_id = brstatus.status_id WHERE xyz.fk_status_id = 8 AND xyz.month = 12 AND xyz.year = 2025 ORDER BY date_of_release ASC LIMIT 5,15
SELECT xyz.*,categories.name AS category, categories.name AS fk_category,categories.seo_url AS category_seo_url,authors.profile_image_path AS author_image,authors.title AS author_title,authors.company AS author_company,CONCAT(authors.first_name, ' ', authors.last_name) AS author_name,brstatus.name AS status FROM business_review AS xyz LEFT JOIN business_review_categories AS categories ON xyz.fk_category_id = categories.category_id LEFT JOIN authors ON xyz.fk_author_id = authors.author_id LEFT JOIN business_review_status AS brstatus ON xyz.fk_status_id = brstatus.status_id WHERE xyz.fk_status_id IN (9) AND WEEK(xyz.date_of_release, 6) <= 51 AND WEEK(xyz.ending_date, 6) >=51 AND YEAR(xyz.ending_date) = 2025 ORDER BY date_of_release DESC LIMIT 0,1
SELECT xyz.*,hotel_newswire_categories.name AS category,hotel_newswire_categories.seo_url AS category_seo_url,hotel_newswire_status.name AS status FROM hotel_newswire AS xyz LEFT JOIN hotel_newswire_categories ON hotel_newswire_categories.category_id = xyz.fk_category_id LEFT JOIN hotel_newswire_status ON hotel_newswire_status.status_id = xyz.fk_status_id WHERE (xyz.date_of_release = '2025-12-15') AND featured=1 AND xyz.fk_status_id IN (1,2) ORDER BY xyz.date_of_release DESC LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (15) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816158 AND UNIX_TIMESTAMP(ends_on) >= 1765816158 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (6) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816158 AND UNIX_TIMESTAMP(ends_on) >= 1765816158 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (6) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816158 AND UNIX_TIMESTAMP(ends_on) >= 1765816158 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (11) AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id = 3 AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (1) AND fk_status_id = 1 AND DATE(NOW()) >= starts_on AND DATE(NOW()) <= ends_on ORDER BY RAND() LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (15) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816158 AND UNIX_TIMESTAMP(ends_on) >= 1765816158 ORDER BY id LIMIT 0,15
SELECT xyz.*,banner_types.name AS type,banners_status.name AS status FROM banners AS xyz LEFT JOIN banner_types ON xyz.fk_type_id = banner_types.id LEFT JOIN banners_status ON xyz.fk_status_id = banners_status.id WHERE fk_type_id IN (11) AND fk_status_id = 1 AND UNIX_TIMESTAMP(starts_on) <= 1765816158 AND UNIX_TIMESTAMP(ends_on) >= 1765816158 ORDER BY id LIMIT 0,15
HOTEL EXECUTIVE
☰
✕

Children's Package at The Hotel Plaza Athenee, NY

“Pillows and Penguins” Children's Package (Available for children 15 or under)

. February 02, 2010

FEBRUARY 2, 2010 -

50% OFF SECOND ROOM

From January - March & July - August 2010

  • Accommodations for two adults and up to two children in two connecting Guestrooms or a Two-Bedroom Suite

  • Children's gift bag including a New York taxi, New York coloring book, crayons, Yankee's baseball cap, plush penguin, and other gift items.

  • Up to 4 tickets to the Central Park Zoo, 1 block away from the hotel.

  • Milk and cookies at turndown

January 1 - March 31, 2010 & July - August 2010
$870 for two connecting King bedded rooms
$1,600 for a Classic Two Bedroom Suite

Package price is per night, does not include taxes and is subject to availability.
(50% off second room included in above rates)

Business Contact:

Subscribe to our newsletter
for more Hotel Newswire articles

Related News

Choose a Social Network!

The social network you are looking for is not available.

Close
Coming up in March 1970...

Click here to Subscribe






Copyright © 1996-2026. All content on HotelExecutive.com. All Rights Reserved.