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 Boutique Hotel

‹ ›

Ridge Country Retreat

10 Bedroom Mount Maunganui Boutique Hotel Sleeps 22
Rates: 750-230 NZD per night. Minimum Rental - 1 night.

Amenities
Attractions
Rates
Reviews
Inquire

Situated in the privacy of 35 acres of native bush in the scenic Papamoa Hills overlooking the stunning Pacific Ocean, Ridge Country Retreat has been designed to specifically to cater to both pampering the soul and the body. Designed to make the most of the majestic scenery surrounding it, every conceivable comfort requirement has been taken care of.

● 13 TVs

● Smoking Permitted

● Views

● Jacuzzi - Outside

● Hot Tub

● Shared Swimming Pool

● Wood Fireplace

● Hair Dryer

● Iron

● Internet Access

● Linens Included

● Breakfast Included

● Resident Staff

● Maid Service Available

● Parking Available

● Shared Jacuzzi

● Washer Dryer

Villas

King Bed, Private Bath, TV, DVD, Queen Bed.

Corporate functions room
Outside open stone fireplace with BBQ on site
15m geothermal lap pool & spa pool
massage and therapy room
library
on-site parking
helipad
local courtesy transfer
bush walks

Start Mo/Da/Yr	End Mo/Da/Yr	Nightly	Weekly	Monthly
3/4/2012	12/21/2012	300
12/22/2012	2/4/2013	750
2/5/2013	3/3/2013	600

Pricing for Boutique Hotel in Mount Maunganui New Zealand are quoted in NZ

Check in time 3 PM
Check out time 11 AM
Payment methods accepted:
Cancellation Policy: Cancellation Policy:
7 -14 days prior to arrival 25%
1 -7 days prior to arrival 100%
Cancellation fees apply to total period booked
__________________________________________________________
Deposit Required for Boutique Hotel : 25% of total stay

Member of Tauranga Chamber of commerce

Write a Review

Mount Maunganui New Zealand Local Attractions

strolls along native bush walks
sandy east coast beaches
bayfair shopping centre
kiwifruit orchards
golf club with rural views, 3km
deep sea fishing; harbour cruises
dolphin watching; jet boating
Tauranga City, 15 minute drive
Mt Maunganui beach, 10 minute drive
Rotorua thermal villages & trout fishing, 40 minute drive
cafes/restaurants with Japanese, Thai, Turkish, Chinese, Italian, Mediterranean & New Zealand cuisine

Mount Maunganui Local Attractions
Golf	1-5 Miles	Biking	1-5 Miles
Horseback Riding	5-10 Miles	Restaurants	Nearby
Nightlife	Nearby	Hang Gliding	1-5 Miles
Deep Sea Fishing	Nearby	Fishing - Other	Nearby
Sailing	Nearby	Hunting	Nearby
Boating	Nearby	Public Gardens	1-5 Miles
Beach	Nearby	Hiking	Nearby
Wineries	1-5 Miles	Theaters	1-5 Miles
Art Galleries	1-5 Miles	Mountain Climbing	1-5 Miles
River Rafting	1-5 Miles	Fly Fishing	10-20 Miles
Kayaking	1-5 Miles	Scuba Diving	1-5 Miles
Swimming	Nearby	Marina	Nearby
Rain Forest	1-5 Miles

Ridge Country Retreat is a Mount Maunganui Boutique Hotel in Bay of Plenty New Zealand

Bay of Plenty Cities:
Mount Maunganui,
Waihau Bay

Mount Maunganui Boutique Hotel

Ridge Country Retreat

10 Bedroom Mount Maunganui Boutique Hotel Sleeps 22 Rates: 750-230 NZD per night. Minimum Rental - 1 night.

10 Bedroom Mount Maunganui Boutique Hotel Sleeps 22
Rates: 750-230 NZD per night. Minimum Rental - 1 night.