<%@LANGUAGE="VBSCRIPT"%> <% Dim rs_open_house__MMColParam rs_open_house__MMColParam = "0" If (Request("MM_EmptyValue") <> "") Then rs_open_house__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_open_house Dim rs_open_house_numRows Set rs_open_house = Server.CreateObject("ADODB.Recordset") rs_open_house.ActiveConnection = MM_conRemax_STRING rs_open_house.Source = "SELECT HomeID, HomeCategory, HomeAddress, HomeCity, OPDate, OPTime, OPTime2 FROM homes WHERE OPDate <> '" + Replace(rs_open_house__MMColParam, "'", "''") + "' ORDER BY OPDate ASC, OPTime2 ASC" rs_open_house.CursorType = 0 rs_open_house.CursorLocation = 2 rs_open_house.LockType = 1 rs_open_house.Open() rs_open_house_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_open_house_numRows = rs_open_house_numRows + Repeat1__numRows %>
Careers Mortgage Info Links & Resources Maps Contact Us Home

 




<% If Not rs_open_house.EOF Or Not rs_open_house.BOF Then %>

Open Houses Near You

<% While ((Repeat1__numRows <> 0) AND (NOT rs_open_house.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_open_house.MoveNext() Wend %>
Date: <%= DoDateTime((rs_open_house.Fields.Item("OPDate").Value), 1, 1033) %>
Time: <%=(rs_open_house.Fields.Item("OPTime").Value)%>  <%=(rs_open_house.Fields.Item("OPTime2").Value)%>
Address: ? <%= "HomeID=" & rs_open_house.Fields.Item("HomeID").Value %>"> <%=(rs_open_house.Fields.Item("HomeAddress").Value)%>
City: <%=(rs_open_house.Fields.Item("HomeCity").Value)%>
<% End If ' end Not rs_open_house.EOF Or NOT rs_open_house.BOF %>

 

<% If rs_open_house.EOF And rs_open_house.BOF Then %>

Open Houses Near You

We currently do not have any Open Houses listed on our site.

Please check back soon.

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

Privacy Act     |   Relocation Package   |   Complete Moving Checklist

Disclaimer: All information is deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RE/MAX a-b Realty Ltd. brokerage shall not be responsible for any typographical errors, misinformation, misprints and shall 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 or in Woodstock st 519-536-7535.

         
<% rs_open_house.Close() Set rs_open_house = Nothing %>