Your name:	*
And email:	*
Telephone:
Arrival:
# nights:
# Adults:		#Children:
Additional comments:

Message:

SELECT CityID, MinimumNightlyRentalTypes.Name AS MinimumNightlyRental, PropertyTypes.Name as Type, Users.FirstName, Users.LastName, Users.PrimaryTelephone, Users.Country AS OwnerCountry, Users.Email, Users.Username, Users.Address AS OwnerAddress, Users.EveningTelephone, Users.DaytimeTelephone, Users.MobileTelephone, Users.Website, Users.City AS OwnerCity, Users.State AS OwnerState, Users.Zip AS OwnerZip, Users.Registered, Users.IfPayTravelAgents, Users.DateCreated, Cities.City, StateProvinces.StateProvince, Countries.Country, Regions.Region, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Smoking Permitted')) THEN 'Yes' ELSE 'No' END AS Smoking, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Pet Friendly')) THEN 'Yes' ELSE 'No' END AS PetFriendly, Properties.ID, Properties.UserID, Properties.Name, Properties.TypeID, Properties.Address, Properties.CityID, Properties.IfShowAddress, Properties.PaymentMethod ,Properties.NumBedrooms, Properties.NumBaths, Properties.NumSleeps,Properties.MinNightRate,Properties.HiNightRate,Properties.MinRateCurrency,Properties.Name2, Properties.MinimumNightlyRentalID, Properties.NumTVs, Properties.NumVCRs, Properties.NumCDPlayers, Properties.Description, Properties.Amenities, Properties.LocalAttractions, Properties.Rates, Properties.CancellationPolicy, Properties.DepositRequired, Properties.IfMoreThan7PhotosAllowed, Properties.IfFinished, Properties.IfApproved, CASE WHEN EXISTS (SELECT * FROM Invoices WHERE (Invoices.PropertyID = Properties.ID) AND (PaymentAmount >= InvoiceAmount) AND (GETDATE() <= RenewalDate)) THEN 1 ELSE 0 END AS IfPaid, Properties.DateAdded, Properties.DateStartViewed, Properties.VirtualTour, Properties.RatesTable, Properties.PricesCurrency, Properties.CheckIn, Properties.CheckOut, Properties.LodgingTax, Properties.TaxIncluded, Properties.DateAvailable, Properties.IfDiscounted, Properties.IfLastMinuteCancellations, Properties.LastMinuteComments, Properties.HomeExchangeCityID1, Properties.HomeExchangeCityID2, Properties.HomeExchangeCityID3, Properties.HomeExchangeComments FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID INNER JOIN StateProvinces ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID INNER JOIN Regions ON Countries.RegionID = Regions.ID INNER JOIN Users ON Properties.UserID = Users.ID LEFT OUTER JOIN MinimumNightlyRentalTypes ON Properties.MinimumNightlyRentalID = MinimumNightlyRentalTypes.ID LEFT OUTER JOIN PropertyTypes ON Properties.TypeID = PropertyTypes.ID LEFT JOIN PropertyCategories ON PropertyCategories.ID=PropertyTypes.Category WHERE (Properties.ID = @PropertyID)

Europe Vacations<< Germany Vacations<< Bavaria Vacations<< Marktschellenberg Vacations<<

Marktschellenberg Boutique Hotel

‹ ›

Hotel Lampllehen

12 Bedroom Marktschellenberg Boutique Hotel Sleeps 12
Rates: 60-35 EUR per night. Minimum Rental - 1 night.

Amenities
Attractions
Rates
Reviews
Inquire

Between Salzburg and Berchtesgaden, romantic, quiet. Speciality restaurant with wood fire, very nice terrace.

● 12 TVs

● Views

● Sauna

● Wood Fireplace

● BBQ Grill

● Breakfast Included

● Parking Available

● Hair Dryer

● Iron

● Internet Access

● Ski In Ski Out

Salzburg, Berchtesgaden, Eagle´s Nest, Koenigs lake only 15 min. by car or bus.

Marktschellenberg Germany Local Attractions

Eagle´s Nest, Salt mine, Koenigs lake, Salzburg

Marktschellenberg Local Attractions
Golf	5-10 Miles	Lake	5-10 Miles
Downhill Skiing	5-10 Miles	Biking	Nearby
Horseback Riding	Nearby	Restaurants	Nearby
Nightlife	5-10 Miles	Museums	5-10 Miles
Fishing - Other	Nearby	Hunting	Nearby
Castle	5-10 Miles	Public Gardens	5-10 Miles
Tennis	1-5 Miles	Cross Country Skiing	Nearby
Ice Skating	1-5 Miles	Theaters	5-10 Miles
Art Galleries	5-10 Miles	Mountain Climbing	Nearby
River Rafting	Nearby	Fly Fishing	Nearby
Kayaking	Nearby	Casino	10-20 Miles

Rates from € 32 to € 59 per night
Children till 10 years - 50% on the third bed

Pricing for Boutique Hotel in Marktschellenberg Germany are quoted in Euros

Check in time 4 PM
Check out time 10 AM
Payment methods accepted:
Cancellation Policy:
Deposit Required for Boutique Hotel : Credit card no. and valid date for guarrantie

Write a Review

Hotel Lampllehen is a Marktschellenberg Boutique Hotel in Bavaria Germany

Marktschellenberg Boutique Hotel

Hotel Lampllehen

12 Bedroom Marktschellenberg Boutique Hotel Sleeps 12 Rates: 60-35 EUR per night. Minimum Rental - 1 night.

12 Bedroom Marktschellenberg Boutique Hotel Sleeps 12
Rates: 60-35 EUR per night. Minimum Rental - 1 night.