<%@LANGUAGE="VBSCRIPT"%> <% Dim rs_distinct__AgentPick rs_distinct__AgentPick = "11" if (Request.QueryString("AgentID") <> "") then rs_distinct__AgentPick = Request.QueryString("AgentID") %> <% set rs_distinct = Server.CreateObject("ADODB.Recordset") rs_distinct.ActiveConnection = MM_conRemax_STRING rs_distinct.Source = "SELECT HomeID, HomeAddress FROM homes WHERE (AgentID = " + Replace(rs_distinct__AgentPick, "'", "''") + " or AgentID2 = " + Replace(rs_distinct__AgentPick, "'", "''") + ") and homes.HomeCategory = 'Homes of Distinction'" rs_distinct.CursorType = 0 rs_distinct.CursorLocation = 2 rs_distinct.LockType = 3 rs_distinct.Open() rs_distinct_numRows = 0 %> <% Dim rs_comm__AgentPick rs_comm__AgentPick = "11" if (Request.QueryString("AgentID") <> "") then rs_comm__AgentPick = Request.QueryString("AgentID") %> <% set rs_comm = Server.CreateObject("ADODB.Recordset") rs_comm.ActiveConnection = MM_conRemax_STRING rs_comm.Source = "SELECT HomeID, HomeAddress FROM homes WHERE (AgentID = " + Replace(rs_comm__AgentPick, "'", "''") + " or AgentID2 = " + Replace(rs_comm__AgentPick, "'", "''") + ") and homes.HomeCategory = 'Commercial'" rs_comm.CursorType = 0 rs_comm.CursorLocation = 2 rs_comm.LockType = 3 rs_comm.Open() rs_comm_numRows = 0 %> <% Dim rs_agri__AgentPick rs_agri__AgentPick = "11" if (Request.QueryString("AgentID") <> "") then rs_agri__AgentPick = Request.QueryString("AgentID") %> <% set rs_agri = Server.CreateObject("ADODB.Recordset") rs_agri.ActiveConnection = MM_conRemax_STRING rs_agri.Source = "SELECT HomeID, HomeAddress FROM homes WHERE (AgentID = " + Replace(rs_agri__AgentPick, "'", "''") + " or AgentID2 = " + Replace(rs_agri__AgentPick, "'", "''") + ") and homes.HomeCategory = 'Agricultural'" rs_agri.CursorType = 0 rs_agri.CursorLocation = 2 rs_agri.LockType = 3 rs_agri.Open() rs_agri_numRows = 0 %> <% Dim rs_new__AgentPick rs_new__AgentPick = "11" if (Request.QueryString("AgentID") <> "") then rs_new__AgentPick = Request.QueryString("AgentID") %> <% set rs_new = Server.CreateObject("ADODB.Recordset") rs_new.ActiveConnection = MM_conRemax_STRING rs_new.Source = "SELECT HomeID, HomeAddress FROM homes WHERE (AgentID = " + Replace(rs_new__AgentPick, "'", "''") + " or AgentID2 = " + Replace(rs_new__AgentPick, "'", "''") + ") and homes.HomeCategory = 'New Homes'" rs_new.CursorType = 0 rs_new.CursorLocation = 2 rs_new.LockType = 3 rs_new.Open() rs_new_numRows = 0 %> <% Dim rs_res__AgentPick rs_res__AgentPick = "11" if (Request.QueryString("AgentID") <> "") then rs_res__AgentPick = Request.QueryString("AgentID") %> <% set rs_res = Server.CreateObject("ADODB.Recordset") rs_res.ActiveConnection = MM_conRemax_STRING rs_res.Source = "SELECT HomeID, HomeAddress FROM homes WHERE (AgentID = " + Replace(rs_res__AgentPick, "'", "''") + " or AgentID2 = " + Replace(rs_res__AgentPick, "'", "''") + ") and homes.HomeCategory = 'Residential'" rs_res.CursorType = 0 rs_res.CursorLocation = 2 rs_res.LockType = 3 rs_res.Open() rs_res_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 rs_distinct_numRows = rs_distinct_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Repeat2__numRows = -1 Dim Repeat2__index Repeat2__index = 0 rs_comm_numRows = rs_comm_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Repeat3__numRows = -1 Dim Repeat3__index Repeat3__index = 0 rs_agri_numRows = rs_agri_numRows + Repeat3__numRows %> <% Dim Repeat4__numRows Repeat4__numRows = -1 Dim Repeat4__index Repeat4__index = 0 rs_new_numRows = rs_new_numRows + Repeat4__numRows %> <% Dim Repeat5__numRows Repeat5__numRows = -1 Dim Repeat5__index Repeat5__index = 0 rs_res_numRows = rs_res_numRows + Repeat5__numRows %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> Remax-ab realty- stratfordhomes.ca

Ken Eaton & Sandra Morris
Teamed Together 2 Serve You Better

Close This Window   |  Back To Home Page

Click on a listing below to see more details.

<% If Not rs_distinct.EOF Or Not rs_distinct.BOF Then %>
Homes of Distinction Listing(s)
<% While ((Repeat1__numRows <> 0) AND (NOT rs_distinct.EOF)) %> " class="content1"><%=(rs_distinct.Fields.Item("HomeAddress").Value)%>
 <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_distinct.MoveNext() Wend %>

<% End If ' end Not rs_distinct.EOF Or NOT rs_distinct.BOF %> <% If Not rs_comm.EOF Or Not rs_comm.BOF Then %>
Commercial & Investment Listing(s)
<% While ((Repeat2__numRows <> 0) AND (NOT rs_comm.EOF)) %> " class="content1"><%=(rs_comm.Fields.Item("HomeAddress").Value)%>
<% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rs_comm.MoveNext() Wend %>

<% End If ' end Not rs_comm.EOF Or NOT rs_comm.BOF %> <% If Not rs_agri.EOF Or Not rs_agri.BOF Then %>
Agricultural Listing(s)
<% While ((Repeat3__numRows <> 0) AND (NOT rs_agri.EOF)) %> " class="content1"><%=(rs_agri.Fields.Item("HomeAddress").Value)%>
<% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 rs_agri.MoveNext() Wend %>

<% End If ' end Not rs_agri.EOF Or NOT rs_agri.BOF %> <% If Not rs_new.EOF Or Not rs_new.BOF Then %>
New Homes Listing(s)
<% While ((Repeat4__numRows <> 0) AND (NOT rs_new.EOF)) %> " class="content1"><%=(rs_new.Fields.Item("HomeAddress").Value)%>
<% Repeat4__index=Repeat4__index+1 Repeat4__numRows=Repeat4__numRows-1 rs_new.MoveNext() Wend %>

<% End If ' end Not rs_new.EOF Or NOT rs_new.BOF %> <% If Not rs_res.EOF Or Not rs_res.BOF Then %>
Residential Listing(s)
<% While ((Repeat5__numRows <> 0) AND (NOT rs_res.EOF)) %> " class="content1"><%=(rs_res.Fields.Item("HomeAddress").Value)%>
<% Repeat5__index=Repeat5__index+1 Repeat5__numRows=Repeat5__numRows-1 rs_res.MoveNext() Wend %>

<% End If ' end Not rs_res.EOF Or NOT rs_res.BOF %>

 

<% rs_distinct.Close() %> <% rs_comm.Close() %> <% rs_agri.Close() %> <% rs_new.Close() %> <% rs_res.Close() %>