<%Option Explicit dim oRcProperty1, oRcProperty2, oConn, sqlProperty1, sqlProperty2, pid1, pid2, pid3 dim pid4, pid5, pid6, pdline1, pdline2, pdline3, pdline4, pdline5, pdline6, image1 dim image2, image3 %> <% Set oRcProperty1=Server.CreateObject("Adodb.RecordSet") Set oRcProperty2=Server.CreateObject("Adodb.RecordSet") sqlProperty1 = "SELECT top 3 tblAddNewProperty.Property_Id AS tblAddNewProperty_Property_Id," sqlProperty1 = sqlProperty1 + "tblAddNewProperty.Property_Line_Description," sqlProperty1 = sqlProperty1 + "tblPropertyImage.Image_Path1" sqlProperty1 = sqlProperty1 + " FROM tblPropertyImage INNER JOIN tblAddNewProperty" sqlProperty1 = sqlProperty1 + " ON tblPropertyImage.Property_Id = tblAddNewProperty.Property_Id" sqlProperty1 = sqlProperty1 + " WHERE tblAddNewProperty.Property_Status='" & "active"&"'" sqlProperty1 = sqlProperty1 + " AND tblAddNewProperty.Property_For='" & "sale"&"'" sqlProperty1 = sqlProperty1 + " ORDER BY tblAddNewProperty.Id DESC" oRcProperty1.open sqlProperty1,oConn,3 pid1=oRcProperty1("tblAddNewProperty_Property_Id") image1=oRcProperty1("Image_Path1") pdline1=oRcProperty1("Property_Line_Description") oRcProperty1.movenext pid2=oRcProperty1("tblAddNewProperty_Property_Id") image2=oRcProperty1("Image_Path1") pdline2=oRcProperty1("Property_Line_Description") oRcProperty1.movenext pid3=oRcProperty1("tblAddNewProperty_Property_Id") image3=oRcProperty1("Image_Path1") pdline3=oRcProperty1("Property_Line_Description") sqlProperty2="select top 3 * from tblAddNewProperty where Property_For='rent' and Property_Status='active' order by Id desc" oRcProperty2.open sqlProperty2,oConn,3 pid4=oRcProperty2("Property_Id") pdline4=oRcProperty2("Property_Line_Description") oRcProperty2.movenext pid5=oRcProperty2("Property_Id") pdline5=oRcProperty2("Property_Line_Description") oRcProperty2.movenext pid6=oRcProperty2("Property_Id") pdline6=oRcProperty2("Property_Line_Description") %> Brian Thomas Partnership:U.K Property Services

Home  About Us

   Sales   |   Letting   |   Properties In Turkey   |   Mortgages   |   Insurance   |   Contact Us
     
 

Property Search

 
     
 

Buy

Let

 
 
   
 
   
 Type
   
 Beds (min)
   
 
   
 
     
   

 
Mortgages
   
  These are new times we're living in … especially when it comes to tailoring a Mortgage to suit your unique financial needs. The day of simply walking into your local bank and signing whatever mortgage document the loans officer stuck in front of you is officially over.

Consumers like you are now armed with a vast array of online information that puts you in the driver's seat when it comes to negotiating your mortgage.

 With a little time, and even less money, you can obtain your personal credit history, research various interest rates and features, and review your financial needs more fully. Assisted by Brian Thomas your good credit history can force a number of banks, trust companies and credit unions to come up with their best Mortgage offer. Call 020 8597 7699 or 020 8478 1500 today to findout more.

 
  There may be a fee for mortgage advice. A fee of up to 1.5% of the mortgage advance will be payable on completion. The level of this fee will depend upon your circumstances, but we estimate that it will typically be £2000.

Your home maybe repossessed if you do not keep up repayments on your mortgage.

Brian Thomas Financial Services Ltd is an appointed representative of The Mortgage Times Group Limited, 279 Tottenham Court Road, London, W1T 7RJ, which is authorised and regulated by the Financial Services Authority no 303007.

 
 
 
 
 
 
 
 
 
 
  Copyright © All rights reserved by Brian Thomas Partnership  - Website by www.ByteShop.co.uk
<% Set oRcProperty1=nothing Set oRcProperty2=nothing set oConn=nothing %>