<%@LANGUAGE="VBSCRIPT"%> <% Dim combo__HomePick combo__HomePick = "1" if (Request.QueryString("HomeID") <> "") then combo__HomePick = Request.QueryString("HomeID") %> <% set combo = Server.CreateObject("ADODB.Recordset") combo.ActiveConnection = MM_conRemax_STRING combo.Source = "SELECT agents.AgentName, agents.AgentSurname, homes.* FROM agents, homes WHERE agents.AgentID = homes.AgentID and homes.HomeID = " + Replace(combo__HomePick, "'", "''") + "" combo.CursorType = 0 combo.CursorLocation = 2 combo.LockType = 3 combo.Open() combo_numRows = 0 %> <% Dim combo_2ndagent__HomePick combo_2ndagent__HomePick = "1" if (Request.QueryString("HomeID") <> "") then combo_2ndagent__HomePick = Request.QueryString("HomeID") %> <% set combo_2ndagent = Server.CreateObject("ADODB.Recordset") combo_2ndagent.ActiveConnection = MM_conRemax_STRING combo_2ndagent.Source = "SELECT agents.AgentName, agents.AgentSurname, agents.AgentID FROM agents, homes WHERE agents.AgentID = homes.AgentID2 and homes.HomeID = " + Replace(combo_2ndagent__HomePick, "'", "''") + "" combo_2ndagent.CursorType = 0 combo_2ndagent.CursorLocation = 2 combo_2ndagent.LockType = 3 combo_2ndagent.Open() combo_2ndagent_numRows = 0 %> Stratford Remax a-b realty
Go Back One Screen

<%=(combo.Fields.Item("HomeAddress").Value)%>, <%=(combo.Fields.Item("HomeCity").Value)%>, <%=(combo.Fields.Item("HomeProvince").Value)%>, <%=(combo.Fields.Item("HomePostal").Value)%>

Agent(s)
 <%=(combo.Fields.Item("AgentName").Value)%> <%=(combo.Fields.Item("AgentSurname").Value)%> <% If Not combo_2ndagent.EOF Or Not combo_2ndagent.BOF Then %>
 <%=(combo_2ndagent.Fields.Item("AgentName").Value)%>  <%=(combo_2ndagent.Fields.Item("AgentSurname").Value)%> <% End If ' end Not combo_2ndagent.EOF Or NOT combo_2ndagent.BOF %>
<% If (combo.Fields.Item("MainPic").Value) <> "" Then Response.Write("") Else Response.Write("") End if %>
Home Status:
  <%=(combo.Fields.Item("RemaxNumber").Value)%>
MLS #:
  <%=(combo.Fields.Item("MLSNumber").Value)%>
Price / Lease:
 <%= FormatCurrency((combo.Fields.Item("HomePrice").Value), 2, -2, -2, -2) %>
Taxes:
 <% If (combo.Fields.Item("HomeTaxes").Value) <> "0" Then Response.Write(" $") Response.Write(combo.Fields.Item("HomeTaxes").Value) Else Response.Write("") End if %>
Type:
  <%=(combo.Fields.Item("HomeType").Value)%>
Style:
  <%=(combo.Fields.Item("HomeStyle").Value)%>
Bedrooms:
  <%=(combo.Fields.Item("Bedrooms").Value)%>
Bathrooms:
  <%=(combo.Fields.Item("Bathrooms").Value)%>
Basement:
  <%=(combo.Fields.Item("Basement").Value)%>
Lot Size:
  <%=(combo.Fields.Item("LotSize").Value)%>
Heating:
  <%=(combo.Fields.Item("Heating").Value)%>
Exterior:
  <%=(combo.Fields.Item("Exterior").Value)%>
Garage:
  <%=(combo.Fields.Item("Garage").Value)%>
Driveway:
  <%=(combo.Fields.Item("Driveway").Value)%>
Video Tour:
   <% If (combo.Fields.Item("VideoTour").Value) <> "" Then Response.Write("") Response.Write("Click Here") Response.Write("") Else Response.Write("Not Available") End if %>

  " target="_blank"> <% If (combo.Fields.Item("Pic1").Value) <> "" Then Response.Write("") Else Response.Write("") End if %> " target="_blank"> <% If (combo.Fields.Item("Pic2").Value) <> "" Then Response.Write("") Else Response.Write("") End if %> " target="_blank"> <% If (combo.Fields.Item("Pic3").Value) <> "" Then Response.Write("") Else Response.Write("") End if %> " target="_blank"> <% If (combo.Fields.Item("Pic4").Value) <> "" Then Response.Write("") Else Response.Write("") End if %> " target="_blank"> <% If (combo.Fields.Item("Pic5").Value) <> "" Then Response.Write("") Else Response.Write("") End if %> " target="_blank"> <% If (combo.Fields.Item("Pic6").Value) <> "" Then Response.Write("") Else Response.Write("") End if %>

Basement Room Descriptions:
 <%=(combo.Fields.Item("BasementRooms").Value)%>
Level 1 Room Descriptions:
 <%=(combo.Fields.Item("Level1Rooms").Value)%>
Level 2 Room Descriptions:
 <%=(combo.Fields.Item("Level2Rooms").Value)%>
Features:
 <%=(combo.Fields.Item("Features").Value)%>
Other Details:
 <%=(combo.Fields.Item("OtherDetails").Value)%>

 

Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Remax AB Realty LTD. shall not be responsible for any typographical errors, misinformation, misprints and shall not be held totally harmless. Please call RE/MAX a-b Realty Ltd for more details, in Stratford at 519-273-2821 or in St. Marys at 519-284-4720.
<% combo.Close() %> <% combo_2ndagent.Close() %>