<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Session.LCID = 1033 %> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "True" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1__Mydato Recordset1__Mydato = "1/1/2005" If (Date() <> "") Then Recordset1__Mydato = Date() End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_rotoruanz_STRING Recordset1.Source = "SELECT ProdID, ProductName, DescripSmall, DateStart, DateFinish, Publish, DisplayOrder FROM Products WHERE DateFinish >= #" + Replace(Recordset1__Mydato, "'", "''") + "# AND Publish = " + Replace(Recordset1__MMColParam, "'", "''") + " AND ProductCategory Like '%gnztr-HWK%' ORDER BY DisplayOrder DESC" 'Recordset1.Source = "SELECT ProdID, ProductName, DescripSmall, DateStart, DateFinish, Publish, DisplayOrder FROM Products WHERE DateFinish >= #" + Replace(Recordset1__Mydato, "'", "''") + "# AND ProductCategory Like '%gnztr-HWK%' ORDER BY DisplayOrder DESC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim HLooper1__numRows HLooper1__numRows = -2 Dim HLooper1__index HLooper1__index = 0 Recordset1_numRows = Recordset1_numRows + HLooper1__numRows dim m m=1 dim s s=7 dim pagename pagename="Hot Accommodation Deals" %> Hot Hawkes Bay (GNZTR) Deals - RotoruaNZ.com » Rotorua's Official Website
You are here: Home « Rotorua « i-Site « Hot Deals « GNZTR « Bay of PlentySend this page to a friend Print this page

GNZTR - Hawkes Bay Hot Deals

Located on the East Coast of the North Island Hawke’s Bay offers a life less ordinary. From the golden sandy beaches and spectacular scenery in the north, to the country side and rural towns further south - not to mention the twin cities of Napier and Hastings in between, Hawke's Bay has a rich diversity of places to visit.

Thanks to its Mediterranean style climate, the region has long been on the global radar for producing some of the world’s truly great wines. With an abundance of wineries spread throughout the region, deep oranges, greens and yellows come to life throughout Autumn in Hawke’s Bay. Relax and enjoy sampling a sumptuous array of wines.

Warm Autumn days also help produce some of the best foods you’ll ever taste and the local farmers markets and Hawke’s Bay Food Trail offer you the chance to mix with the locals while tasting some of the delicious Autumn produce and artisan food products on offer. Take your time and savour every mouthful along the way.

Whether you are interested in history or adventure, Hawke’s Bay has something for you. The region is steeped Maori and European history, and the Art Deco and Spanish Mission architecture draws enthusiasts from all corners of the globe. While a range of activities are on offer from the natural beauty of Lake Waikaremoana, the Kaweka and Ruahine Mountain Ranges to the dramatic coastline of Cape Kidnappers and Central Hawke’s Bay.

Whether for the weekend or a week, it is a place to breathe deeper, relax for longer and enjoy all of the best things in life in one complete package.

<% If Not Recordset1.EOF Or Not Recordset1.BOF Then %>
<% startrw = 0 endrw = HLooper1__index numberColumns = 3 numrows = -1 while((numrows <> 0) AND (Not Recordset1.EOF)) startrw = endrw + 1 endrw = endrw + numberColumns %> <% While ((startrw <= endrw) AND (Not Recordset1.EOF)) %> <% startrw = startrw + 1 Recordset1.MoveNext() Wend %> <% numrows=numrows-1 Wend %>
<%=(Recordset1.Fields.Item("DescripSmall").Value)%> ">More detail and Order now > <% MM_authorizedUsers="admincontrol,adminisite" MM_grantAccess=false If Session("MM_Username") <> "" Then If (false Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If MM_grantAccess Then ' *** Show If User Logged In %> ">Edit <% End If ' *** Show If User Logged In %>
<% End If ' end Not Recordset1.EOF Or NOT Recordset1.BOF %> <% If Recordset1.EOF And Recordset1.BOF Then %>

No Hawkes Bay Hot Deals are currently available.

Please try again soon - we may be updating our Special Packages as you read this message.

Or try the i-SITE, Skyline, or Agrodome packages.

<% End If ' end Recordset1.EOF And Recordset1.BOF %>

 

Bay of Plenty Packages
Coromandel Packages
Rotorua Packages
Ruapehu Packages
Taupo Packages
Takarangi
<% Recordset1.Close() Set Recordset1 = Nothing %>