<%@LANGUAGE="VBSCRIPT"%> <% Dim agents__MMColParam agents__MMColParam = "1" if (Request.QueryString("AgentID") <> "") then agents__MMColParam = Request.QueryString("AgentID") %> <% set agents = Server.CreateObject("ADODB.Recordset") agents.ActiveConnection = MM_conRemax_STRING agents.Source = "SELECT * FROM agents WHERE AgentID = " + Replace(agents__MMColParam, "'", "''") + "" agents.CursorType = 0 agents.CursorLocation = 2 agents.LockType = 3 agents.Open() agents_numRows = 0 %> <% Dim rs_distinct__AgentPick rs_distinct__AgentPick = "Null" 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 = "Null" 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 = "Null" 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 = "Null" 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 = "Null" 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 Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_distinct_numRows = rs_distinct_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 rs_comm_numRows = rs_comm_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 rs_agri_numRows = rs_agri_numRows + Repeat3__numRows %> <% Dim Repeat4__numRows Dim Repeat4__index Repeat4__numRows = -1 Repeat4__index = 0 rs_new_numRows = rs_new_numRows + Repeat4__numRows %> <% Dim Repeat5__numRows Dim Repeat5__index Repeat5__numRows = -1 Repeat5__index = 0 rs_res_numRows = rs_res_numRows + Repeat5__numRows %> <% Dim MM_paramName %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_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) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' 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
   




       
<%=(agents.Fields.Item("AgentName").Value)%> <%=(agents.Fields.Item("AgentSurname").Value)%>


<% If (agents.Fields.Item("AgentImage").Value) <> "" Then Response.Write "" Else Response.Write("") End if %>

<%=(agents.Fields.Item("Designation").Value)%>
 In Real Estate Since:
<%=(agents.Fields.Item("AgentYear").Value)%>
  Areas of Specializations:
<%=(agents.Fields.Item("Specializations").Value)%>
  Districts Serviced:
<%=(agents.Fields.Item("Districts").Value)%>
  RE/MAX Awards/Designations:
<% If (agents.Fields.Item("AwardMiracle").Value) = "Yes" Then Response.Write("Childrens Miracle Network") Else Response.Write("") End if %> <% If (agents.Fields.Item("AwardPresident").Value) = "Yes" Then Response.Write(", ") Response.Write("Remax President's Club") Else Response.Write("") End if %> <% If (agents.Fields.Item("AwardExecutive").Value) = "Yes" Then Response.Write(", ") Response.Write("Remax Executive Club") Else Response.Write("") End if %> <% If (agents.Fields.Item("Award100").Value) = "Yes" Then Response.Write(", ") Response.Write("Remax 100% Club") Else Response.Write("") End if %> <% If (agents.Fields.Item("AwardFame").Value) = "Yes" Then Response.Write(", ") Response.Write("Hall of Fame") Else Response.Write("") End if %> <% If (agents.Fields.Item("AwardPlatinum").Value) = "Yes" Then Response.Write(", ") Response.Write("Remax Platinum Award") Else Response.Write("") End if %> <% If (agents.Fields.Item("AwardUltimate").Value) = "Yes" Then Response.Write(", ") Response.Write("Remax Lifetime Achievement") Else Response.Write("") End if %>
   Service Clubs/Other Interests:
<%=(agents.Fields.Item("OtherInterest").Value)%>
   E-Mail:
"><%=(agents.Fields.Item("EmailAddress").Value)%>
   Website:
" target="_blank"><%=(agents.Fields.Item("WebsiteURL").Value)%>
" target="_blank"><%=(agents.Fields.Item("WebsiteURL2").Value)%>
Office: <%=(agents.Fields.Item("BusNumber").Value)%>   Fax: <%=(agents.Fields.Item("FaxNumber").Value)%>

General Information:
<%=(agents.Fields.Item("GeneralInfo").Value)%>

<% If (agents.Fields.Item("AwardMiracle").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("AwardPresident").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("AwardExecutive").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("Award100").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("AwardFame").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("AwardPlatinum").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>   <% If (agents.Fields.Item("AwardUltimate").Value) = "Yes" Then Response.Write("") Else Response.Write("") End if %>

<% 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="content"><%=(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="content"><%=(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="content"><%=(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="content"><%=(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="content"><%=(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 %>
[ back one screen ]


 

 

   

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