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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 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) <= 1765815755 AND UNIX_TIMESTAMP(ends_on) >= 1765815755 ORDER BY id LIMIT 0,15
HOTEL EXECUTIVE
☰
✕

Waterford Hotel Group to Manage the Lord Jeffery Inn

Inn Undergoing $14 Million Restoration and Renovation, Opening Spring 2011

. November 17, 2010

WATERFORD, CT - November 16, 2010 - Waterford Hotel Group has been selected to provide hotel management services for the Lord Jeffery Inn located in Amherst, Massachusetts. Additionally, Waterford is providing pre-opening services while the Lord Jeffery Inn is closed for a $14 million restoration and renovation project. The Lord Jeffery Inn is owned by the Amherst Inn Company, an affiliate of Amherst College, and is slated to reopen in the spring of 2011.

For more than 80 years, the Lord Jeffery Inn has been an integral part of Amherst and the surrounding community. The 46,000 square foot Lord Jeffery Inn was built in the 1920s and includes 49 rooms, a restaurant, a ballroom, and flexible meeting space. The extensive renovation will provide interior enhancements and a modernization of the facility, while maintaining its historic New England charm. “Waterford Hotel Group has a wealth of experience with a diverse portfolio of managed properties, ranging from a historic inn to full-service hotels. They bring a level of expertise to the Lord Jeffery Inn that will allow us to embrace and maintain the history of the facility, while at the same time providing first-class accommodations, superior service, and fine dining to our patrons,” commented Peter Shea, President of the Amherst Inn Company and Treasurer of Amherst College.

“We look forward to working with the Amherst Inn Company in reintroducing the Lord Jeffery Inn to the community as the premier destination for lodging, dining, corporate meetings, and social events,” stated Rob Winchester, President and COO of Waterford Hotel Group, Inc.

About Waterford Hotel Group

Waterford Hotel Group, Inc., with headquarters in Waterford, CT, currently manages 27 properties in nine states, representing more than 3,600 rooms. Waterford Hotel Group has experience operating virtually every type of hotel property, including limited services properties, all-suite hotels, conference centers, and large full service and resort properties. The company's approach to hotel development and operations is hands-on, and features frequent site visits and constant communication with customers and partners. Additionally, Waterford Hotel Group offers centralized accounting, financial reporting, strategic marketing, human resources, and day-to-day operations management systems to increase market share and profitability at all properties. For more information, visit the company's website at www.waterfordhotelgroup.com.

Business Contact:

Lisa Beers
T: 860-701-9621
E: lbeers@waterfordhotelgroup.com

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...