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)

Oceania Vacations<< New Zealand Vacations<< Bay of Plenty Vacations<< Mount Maunganui Vacations<<

Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views

‹ ›

Pavilion Beachfront Accommodation Apartments

1 Bedroom Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views Sleeps 2
Rates: 0-0 per night. Minimum Rental - 3 nights.

Amenities
Attractions
Rates
Reviews
Inquire

Pavilion is situated on the Main Mount Surf Beach under the Famous Mount Mauao Mountain. The Pavilion has licensed Minidars, Balconies all with sea views and free carparking. We have an onsite Restaurant and all the famous beach cafes and Hotpools adjacent to the Pavilion 5 Star complex. Easy walk to the main Mount shopping centre, restaurants, clubs and the Port. Transport, bus, Taxis, Airport, and Rental cars are all available. Just a 10 minute drive to Tauranga City. Come and experience us.

● 1 TVs

● Smoking Permitted

● Views

● Hot Tub

● Washer Dryer

● Central Air

● Microwave

● Hair Dryer

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Elevator

● Resident Staff

● Maid Service Available

● Parking Available

● Public Transportation Near

● Beach Front

● Seaside

2 Bedroom	3 Bedroom	Penthouse A	Penthouse B
Queen Bed, 2-Twin Beds, Sleeper Sofa - Queen, Private Bath, TV, DVD, VCR.	Queen Bed, 2-Twin Beds, Private Bath, TV, DVD, VCR.	Queen Bed, 2-Twin Beds, Private Bath, TV, DVD, VCR.	Queen Bed, 2-Twin Beds, Sleeper Sofa - Queen, Private Bath, TV, DVD, VCR.

Some with own spa pools and air conditioning

Pricing for Luxury Apartment, Golf, Mountain and Sea Views in Mount Maunganui New Zealand are quoted in NZD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy:
Deposit Required for Luxury Apartment, Golf, Mountain and Sea Views : Credit Card

Member of Tauranga Chamber of commerce

Write a Review

Mount Maunganui New Zealand Local Attractions

Fishing, walking, parasaliling, deep sea fishing, canoeing, clubs, shopping, hiking, jetboating, sight seeing, plane and helicopter rides, tours, cafe's, restaurants

Mount Maunganui Local Attractions
Golf	Nearby	Lake	Over 20 Miles
Downhill Skiing	Over 20 Miles	Snowmobiles	Over 20 Miles
Biking	Nearby	Horseback Riding	Nearby
Restaurants	Nearby	Nightlife	Nearby
Museums	Nearby	Hang Gliding	Nearby
Deep Sea Fishing	Nearby	Fishing - Other	Nearby
Sailing	Nearby	Hunting	Nearby
Boating	Nearby	Race Track-Horse	Nearby
Public Gardens	Nearby	Tennis	Nearby
Beach	Nearby	Cross Country Skiing	Over 20 Miles
Ice Skating	Over 20 Miles	Hiking	Nearby
Wineries	Nearby	Theaters	Nearby
Art Galleries	Nearby	Mountain Climbing	Nearby
River Rafting	Nearby	Fly Fishing	Over 20 Miles
Kayaking	Nearby	Scuba Diving	Nearby
Swimming	Nearby	Casino	Over 20 Miles
Marina	Nearby

Pavilion Beachfront Accommodation Apartments is a Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views in Bay of Plenty New Zealand

Bay of Plenty Cities:
Mount Maunganui,
Waihau Bay

Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views

Pavilion Beachfront Accommodation Apartments

1 Bedroom Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views Sleeps 2 Rates: 0-0 per night. Minimum Rental - 3 nights.

1 Bedroom Mount Maunganui Luxury Apartment, Golf, Mountain and Sea Views Sleeps 2
Rates: 0-0 per night. Minimum Rental - 3 nights.