<%@language=vbscript%> <% varid = "" if request("id") <> "" then varid = "and id like '"&request("id")&"' " end if %> <% 'response.write "got this far baby" 'response.end %> <% set Recordset2 = Server.CreateObject("ADODB.Recordset") Recordset2.ActiveConnection = MM_skiptonwebproperty_STRING Recordset2.Source = "SELECT ID, address, town, bedrooms, price, sold_stc, entrydate,oiro, hide_price,alt_price_text FROM details where agent like 'www.procter-brothers.co.uk' "&varid&" and not suspended order by price desc " Recordset2.CursorType = 0 Recordset2.CursorLocation = 2 Recordset2.LockType = 3 Recordset2.Open() Recordset2_numRows = 0 %> <% Dim Repeat2__numRows Repeat2__numRows = 13 Dim Repeat2__index Repeat2__index = 0 Recordset2_numRows = Recordset2_numRows + Repeat2__numRows %> Procter Brothers (Bradford Ltd) - Master Builders : Property Development, Property Developers, Glusburn, North Yorkshire

Home

Developments

About Us

Contact

Property

<% dim soldstc dtmdte = date dtmnew = dateAdd("d",-7,dtmdte) While NOT Recordset2.EOF soldstc = cint(Recordset2.Fields.Item("sold_stc").Value) %> .asp<% if soldstc="-1" then response.write("?s=1")%>'"> <% Recordset2.MoveNext() Wend %>

<% if (Recordset2.Fields.Item("price").Value) <> "999999999" and (Recordset2.Fields.Item("price").Value) <> "99999999" then if (Recordset2.Fields.Item("hide_price").Value) then response.write ("" & Recordset2.Fields.Item("alt_price_text").Value & "
") else if (Recordset2.Fields.Item("oiro").Value) then response.write("Price region: ")%> <%=FormatCurrency((Recordset2.Fields.Item("price").Value), -0, -2, -2, -2) %>
<% end if end if %> <%=(Recordset2.Fields.Item("town").Value)%>
<%=(Recordset2.Fields.Item("bedrooms").Value)%> Bedrooms

.jpg" height=71>

.asp<% if soldstc="-1" then response.write("?s=1")%>"> <% if soldstc="0" then %>

<% else %>

<% end if %>

<%=(Recordset2.Fields.Item("address").Value)%>
<%=(Recordset2.Fields.Item("town").Value)%>.asp<% if soldstc="-1" then response.write("?s=1")%>">
View Details ť

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

Sorry, we currently have no property available for sale. Please check back soon.

<% End If ' end Recordset2.EOF And Recordset2.BOF recordset2.close() %>

^top^

Procter Bros (Bradford) Ltd 1 The Old Corn Mill Glusburn North Yorkshire BD20 8DW	Telephone: 01535 633443 Fax: 01535 636322 Web: www.procter-brothers.co.uk Email: sales@procter-brothers.co.uk
Registered in England & Wales Registered No 935978 Registered Office 1 The Old Corn Mill, Glusburn, North Yorkshire BD20 8DW
website by Skiptonweb