<%@LANGUAGE="VBSCRIPT"%> <% Dim rs_details__MMColParam rs_details__MMColParam = "1" if (Request.QueryString("ID") <> "") then rs_details__MMColParam = Request.QueryString("ID") %> <% set rs_details = Server.CreateObject("ADODB.Recordset") rs_details.ActiveConnection = MM_connCapRes_STRING rs_details.Source = "SELECT * FROM Property_Details WHERE ID = " + Replace(rs_details__MMColParam, "'", "''") + "" rs_details.CursorType = 0 rs_details.CursorLocation = 2 rs_details.LockType = 3 rs_details.Open() rs_details_numRows = 0 %> <% Dim rs_print__MMColParam rs_print__MMColParam = "1" If (Request.QueryString("ID") <> "") Then rs_print__MMColParam = Request.QueryString("ID") End If %> <% Dim rs_print Dim rs_print_numRows Set rs_print = Server.CreateObject("ADODB.Recordset") rs_print.ActiveConnection = MM_connCapRes_STRING rs_print.Source = "SELECT * FROM Property_Details WHERE ID = " + Replace(rs_print__MMColParam, "'", "''") + "" rs_print.CursorType = 0 rs_print.CursorLocation = 2 rs_print.LockType = 1 rs_print.Open() rs_print_numRows = 0 %> Capital Residence | Commission Free Property Sales | 0800 169 4090
<% if (rs_details.Fields.Item("Image1").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" onMouseDown="MM_openBrWindow('../upload/<%=(rs_details.Fields.Item("Image1").Value)%>','imagelooker','scrollbars=yes,resizable=yes,width=400,height=400')" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image1").Value) = "none" then %>
<% end if %> <% if (rs_details.Fields.Item("Image2").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image3").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image4").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image5").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image6").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image7").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image8").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image9").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %> <% if (rs_details.Fields.Item("Image10").Value) <> "none" then %>
','imagelooker','scrollbars=yes,resizable=yes,width=500,height=500')">" width="120" border="0">
<% end if %>

Property Details
Print page

<%=(rs_details.Fields.Item("Property_Town_or_Area").Value)%>, <%=(rs_details.Fields.Item("Property_County").Value)%>, <%=(rs_details.Fields.Item("Property_Postcode_or_Zip").Value)%>

£
<%=(rs_details.Fields.Item("Property_Price").Value)%>
<%=(rs_details.Fields.Item("Number_of_Bedrooms").Value)%> bedroom(s)
<%=(rs_details.Fields.Item("Property_Style").Value)%>


Property ID: CR<%=(rs_details.Fields.Item("PID").Value)%>

<%= Replace((rs_details.Fields.Item("Description").Value),vbCrLf, "
") %>


Bedrooms: <%=(rs_details.Fields.Item("Number_of_Bedrooms").Value)%>
Receptions:
<%=(rs_details.Fields.Item("Number_of_Receptions").Value)%>
Bathrooms:
<%=(rs_details.Fields.Item("Number_of_Bathrooms").Value)%>
Garages:
<%=(rs_details.Fields.Item("Number_of_Garages").Value)%>
Tenure:
<%=(rs_details.Fields.Item("Tenure").Value)%> <% if (rs_details.Fields.Item("Tenure").Value) = "leasehold" then %> with <%=(rs_details.Fields.Item("Years_Remaining").Value)%> years remaining. <% end if %>

Property Age: <%=(rs_details.Fields.Item("Property_Age").Value)%>
Garden: <%=(rs_details.Fields.Item("Garden").Value)%>
Location: <%=(rs_details.Fields.Item("Location").Value)%>
Area: <%=(rs_details.Fields.Item("Area").Value)%>
Garaging: <%=(rs_details.Fields.Item("Garaging").Value)%>
<% if (rs_details.Fields.Item("Commercial").Value) <> "Non Commercial" then %>
Commercial Type: <%=(rs_details.Fields.Item("Commercial").Value)%>

<% end if %>
PROPERTY FEATURES
<%=(rs_details.Fields.Item("Main_Feature1").Value)%>
<%=(rs_details.Fields.Item("Main_Feature2").Value)%>
<%=(rs_details.Fields.Item("Main_Feature3").Value)%>
<%=(rs_details.Fields.Item("Main_Feature4").Value)%>
<%=(rs_details.Fields.Item("Main_Feature5").Value)%>

Contact:
<%=(rs_details.Fields.Item("Name").Value)%>

Daytime Phone Number: <%=(rs_details.Fields.Item("Daytime_Phone").Value)%>
Evening Phone Number: <%=(rs_details.Fields.Item("Evening_Phone").Value)%>
Mobile Phone Number: <%=(rs_details.Fields.Item("Mobile_Phone").Value)%>


0800 169 4090
www.national-residence.com


<% rs_details.Close() %> <% rs_print.Close() Set rs_print = Nothing %>