query
RESULTSET
query
  AMENITIES BUILDING BUILDINGNAME CONFIRMATIONID LASTUPDATE POLICIES POLICYID RESVCONFMSG VIRTUALTOURURL WEBSHORTDESCRIPTION
1 [empty string] JSR Juniper Springs Resort 6 2008-10-29 18:07:46.77 We are pleased to confirm your accommodations for Juniper Springs Resort. Please review this confirmation and print it out to present to the Front Desk upon check-in. Mammoth Vacations is happy to assist you in reserving activities for your stay. Please call us at 800.MAMMOTH or e-mail 800mammoth@mammoth-mtn.com. Juniper Springs Resort Services - Located on the Mammoth Area Shuttle Blue Line - Steps away from Little Eagle Lodge - New in-hotel Rental Shop - Outdoor hot tubs and pool - Fitness rooms - Underground parking - Daily Grind Coffee Shop - 24-hour Front Desk and concierge - Ski/snowboard storage Directions: Follow Hwy 203 into the town of Mammoth Lakes. Turn left at the second stoplight, Minaret Road. Take Minaret Road to Meridian Blvd, where you'll turn right and continue until Meridian ends at Juniper Springs Resort. Policies Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Sorry, no pets allowed. Deposit & Cancellation Polices: Juniper Springs Resort Policies are based on arrival date and per room reserved Summer: May 1, 2008- November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. Resort Fee Policy: $20 resort fee will be added to your stay per night. For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Thank you for making your reservation with Mammoth Vacations and selecting Mammoth Mountain Resort Lodging. We look forward to having you as a guest. 6 Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Sorry, no pets allowed. Deposit & Cancellation Polices: Juniper Springs Resort Policies are based on arrival date and per room reserved Summer: May 1, 2008- November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Resort Fee Policy: $20 resort fee will be added to your stay per night. [empty string] Upscale condos and townhomes close to town make up Mammoth's premier ski-in and ski-out resort, an alpine getaway that is ideal for families. Juniper Springs Resort was recently named one of Conde Nast Traveler's Top 50 Ski Resort properties. Slopeside access at Eagle Lodge approximately Thanksgiving through April.
2 [empty string] MMI Mammoth Mountain Inn 5 2008-10-29 18:07:46.77 We are pleased to confirm your accommodations for Mammoth Mountain Inn. Please review this confirmation and print it out to present to the Front Desk upon check-in. Mammoth Vacations is happy to assist you in reserving activities for your stay. Please call us at 800.MAMMOTH or e-mail 800mammoth@mammoth-mtn.com. Mammoth Mountain Inn Services - Steps away from Mammoth's Main Lodge - New in-hotel ski and snowboard Rental Shop - Mountainside Grill and Dry Creek Bar - Sierra General Store - Hot tubs and heated outdoor pool - Underground parking available - 24-hour Front Desk - Bell staff - Ski/snowboard storage - Located on the Mammoth Area Shuttle Red Line Directions: Follow Hwy 203 into the town of Mammoth Lakes. Turn right at the second stoplight, Minaret Road. Take Minaret Road to the Ski Area (about four miles). When you reach the Ski Area, where the Main Lodge is on your left, look for the sign to your right for Mammoth Mountain Inn. Turn right at the sign and follow the driveway up to the Mammoth Mountain Inn. Policies Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Dogs are permitted for overnight stays with a deposit and nightly fee Deposit & Cancellation Polices: Mammoth Mountain Inn. Policies based on arrival date and are per room reserved Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. Resort Fee Policy: A $20 resort fee will be added to your stay per night For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Thank you for making your reservation with Mammoth Vacations and selecting Mammoth Mountain Resort Lodging. We look forward to having you as a guest. 5 Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Dogs are permitted for overnight stays with a deposit and nightly fee Deposit & Cancellation Polices: Mammoth Mountain Inn. Policies based on arrival date and are per room reserved Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Resort Fee Policy: A $20 resort fee will be added to your stay per night [empty string] On Mammoth Mountain at 9,000 feet, the Mammoth Mountain Inn is a great place to base your vacation if you fancy waking up right on the mountain itself. Hotel rooms and and condos all with easy slopeside access.
3 [empty string] TAM Tamarack Lodge & Resort 8 2008-10-29 18:07:46.77 We are pleased to confirm your accommodations for Tamarack Lodge and Resort. Please review this confirmation and print it out to present to the Front Desk upon check-in. Mammoth Vacations is happy to assist you in reserving activities for your stay. Please call us at 800.MAMMOTH or e-mail 800mammoth@mammoth-mtn.com. Tamarack Lodge and Resort Services - Located on the shores of Twin Lakes - Tamarack Cross Country Ski Center - The Lakefront Restaurant (Reservations: 760.934.2442) - Cabins have efficiency kitchens or larger and private bathroom(s) - Towels and linens provided with daily cabin refresh - Office hours: 7am to 10pm Directions: From Hwy 395, follow Hwy 203 into the town of Mammoth Lakes. Continue straight through three stoplights on Hwy 203/ Main Street until Main Street turns into Lake Mary Road. Continue up Lake Mary Road for about three miles. Turn right at Twin Lakes. Tamarack Lodge is .25 mile down on the left. Policies Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Late arrivals and early departure will be charged. Pets allowed only in summer for additional fees. Deposit & Cancellation Polices: Tamarack Lodge & Resort Policies are based on arrival date and are per room reserved. Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. Resort Fee Policy: A $20 resort fee will be added to your stay per night For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Thank you for making your reservation with Mammoth Vacations and selecting Mammoth Mountain Resort Lodging. We look forward to having you as a guest. 8 Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Late arrivals and early departure will be charged. Pets allowed only in summer for additional fees. Deposit & Cancellation Polices: Tamarack Lodge & Resort Policies are based on arrival date and are per room reserved. Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Resort Fee Policy: A $20 resort fee will be added to your stay per night [empty string] An historic lakeside retreat with cabins and lodge rooms on the shore of Twin Lakes, providing direct access to groomed cross country trails in the winter and fishing and hiking in the summer. Rated one of Sunset Magazine's Top 10 Lakeside Resorts.
4 [empty string] VIL The Village Lodging 7 2008-10-29 18:07:46.77 We are pleased to confirm your accommodations for The Village Lodging. Please review this confirmation and print it out to present to the Front Desk upon check-in. The Village Lodging Central Check-in is located on Forest Trail in the Grand Sierra building. Mammoth Vacations is happy to assist you in reserving activities for your stay. Please call us at 800.MAMMOTH or e-mail 800mammoth@mammoth-mtn.com. The Village Lodging Services - Located on the Mammoth Area Shuttle Red, Green and Blue Lines - Direct Ski Area access via Village Gondola (winter only) - Full Skier Services at the Mountain Center - Dining and Shopping - Hot tubs and outdoor pool - Underground parking - 24-hour Front Desk - Ski/snowboard storage Directions: Follow Hwy 203 into the town of Mammoth Lakes. Turn right at the second stoplight, Minaret Road. Take Minaret Road to Forest Trail, and turn left. Take another left into The Village Lodging Central Check-in at Grand Sierra. Policies Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Sorry, no pets allowed. Deposit & Cancellation Polices: The Village Lodging Policies are based on arrival date and are per room reserved Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. Resort Fee Policy: A $20 resort fee will be added to your stay per night For Group reservations, please contact your group leader. Note: For arrivals after April 19, 2009, rates and policies are subject to change. Thank you for making your reservation with Mammoth Vacations and selecting Mammoth Mountain Resort Lodging. We look forward to having you as a guest. 7 Check-in time is 4:00 pm and check-out time is 11:00 am. Rates may be subject to change without notice. All accommodations are non-smoking. If a package has been purchased, any unused portion cannot be refunded or credited for any reason including weather and personal injury. Sorry, no pets allowed. Deposit & Cancellation Polices: The Village Lodging Policies are based on arrival date and are per room reserved Summer: May 1, 2008 - November 13, 2008 Winter: November 14, 2008 - April 19, 2009 (excluding Holiday) A deposit of the first night's room and tax is required at the time your reservation is made. You may cancel or change up to 14 days in advance of arrival date during winter or 2 days in advance of arrival date during summer with a $30 change/cancellation fee. Cancellations or changes within 14 days of arrival in winter or 2 days of arrival in summer will result in full forfeiture of the deposit. Holiday: December 21, 2008 - January 5, 2009 Reservations made prior to November 1, 2008 require an advanced deposit of the first night's room and tax. You may change or cancel prior to November 1, 2008 with a $30 change/cancellation fee. On November 1, 2008 the remaining balance of the reservation is due in full and automatically charged to the credit card on file. Reservations made on or after November 1, 2008 will be charged in full. Cancellations or changes will result in the forfeiture of the entire stay. Note: For arrivals after April 19, 2009, rates and policies are subject to change. For Group reservations, please contact your group leader. Resort Fee Policy: A $20 resort fee will be added to your stay per night [empty string] Mammoth's home base is happening - begin and end your day at the social center of town. Experience a higher level of condo luxury with gondola access to the slopes, plus shopping and dining options at your front door. Rated one of Conde Nast Traveler’s Top 50 Ski Resort properties. Gondola access to Canyon Lodge approximately Thanksgiving through April.
CACHED false
EXECUTIONTIME 0
SQL SELECT * from V1Building

Juniper Springs Resort

Juniper Springs Resort

Upscale condos and townhomes close to town make up Mammoth's premier ski-in and ski-out resort, an alpine getaway that is ideal for families. Juniper Springs Resort was recently named one of Conde Nast Traveler's Top 50 Ski Resort properties. Slopeside access at Eagle Lodge approximately Thanksgiving through April.

Mammoth Mountain Inn

Mammoth Mountain Inn

On Mammoth Mountain at 9,000 feet, the Mammoth Mountain Inn is a great place to base your vacation if you fancy waking up right on the mountain itself. Hotel rooms and and condos all with easy slopeside access.

Tamarack Lodge & Resort

Tamarack Lodge & Resort

An historic lakeside retreat with cabins and lodge rooms on the shore of Twin Lakes, providing direct access to groomed cross country trails in the winter and fishing and hiking in the summer. Rated one of Sunset Magazine's Top 10 Lakeside Resorts.

The Village Lodging

The Village Lodging

Mammoth's home base is happening - begin and end your day at the social center of town. Experience a higher level of condo luxury with gondola access to the slopes, plus shopping and dining options at your front door. Rated one of Conde Nast Traveler’s Top 50 Ski Resort properties. Gondola access to Canyon Lodge approximately Thanksgiving through April.