<% GOTOIT = REquest("GOTOIT") IF GOTOIT = "SearchFor" then Session("PRice")= REquest("Price") Session("HoldType") = Request("HoldType") Session("HeadlineSize") = Request("HeadlineSize") ' = PurchaseType in PropertyInfo ' ssql = "Select * From PropertyType Where TypeID = " & Session("HoldType") 'set srs = Server.createobject("ADODB.recordset") 'srs.open ssql,oconn,1,3,adcmdtext 'Session("HoldTypeWord") = srs("PropertyType") 'srs.close select case Session("HoldType") case 0 Session("HoldTypeWord")="TO LET" P = "(Tenure =0) " case 1 Session("HoldTypeWord")="FOR SALE" P = "(Tenure =1) " End select PRopertyType = REquest("PRopertyType") If Len(PropertyType)=0 then errcnt1 = "Please Select a property Type from the list below" end if sqlBuild = "Select * From PropertyInfo Where " SqlBuild = SqlBuild & P & " AND (" PropertyCategory = PropertyType PIR= " PropertyCategory = " PC = PropertyCategory PCl = instr(PC,"11") if PCl>0 then ' response.write "yep" PC = " PropertyCategory Like '%%' " PIR = "" Else PC = Replace(PropertyCategory,", ", " OR PropertyCategory=") end if 'Now Look at the sort order variable and decide what order to sort If SearchResOrder = "HighToLow" then vSearchRes = " ORDER BY AskingPrice DESC, AskingRent DESC" end if If SearchResOrder = "LowToHigh" then vSearchRes =" ORDER BY AskingPrice , AskingRent" end if 'Now deal with Headline size If Session("HeadlineSize") > 0 then Headline = " AND (HeadlineSize >=" & Session("HeadlineSize") & ")" End if Session("SQL") = sqlBuild & PIR & PC & ")" & Headline & " AND (Retired=0)" & vSearchRes ' Response.write PRopertyType if request("g") =1 then noprop = "Sorry we have no proprties meeting your request" end if If LEn(errcnt1)=0 then response.redirect "searchres2.asp" end if end if If Request.Servervariables("REMOTE_ADDR") ="82.38.1.36" then Response.write Session("SQL") & "
" Response.write errcnt1 end if %> Drivers & Norris - Properties for Sale North London
 


Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors
Property Holloway Highgate Crouch End Islington Angel

COMPANY

ESTATE AGENTS | AUCTIONEERS | SURVEYORS & VALUERS

407/409 HOLLOWAY ROAD LONDON N7 6HP
TEL: 020 7607 5001 FAX: 020 7609 5031
WEB: www.drivers.co.uk
EMAIL : info@drivers.co.uk
FOR SALE Property for sale in North London TO LET Property to let in North London COMMERCIAL Commercial Property North London Shops Offices Industrial Premises AUCTIONS Property Auctions London MANAGEMENT Property Management London SURVEYS Surveyors London MORTGAGES Mortages Online London property OVERSEAS Overseas Property Spanish Villas Apartments London Agent COMPANY Overseas Property Spanish Villas Apartments London Agent


North London Property Drivers & Norris Partners, Associate Partners and Consultants


North London PropertyHistory

North London PropertyPartners

North London PropertyJobs

David Nicholls joined Drivers & Norris in the estate agency department, in 1969, working as assistant to Albert Hollington, a partner and the residential properties sales manager. He subsequently took over from Mr Hollington and became a partner in 1981, taking responsibility for the Agency Department which covers the disposal of residential and commercial properties by way of private treaty and auctions. He is a Fellow of the National Association of Estate Agents.

Mark Smith joined Drivers & Norris as an associate partner on 1 April 1986 and became a partner in 1991. He is now responsible for the Professional Services Department. He was previously with the Greater London Council employed in the District Surveyor's Office (Building Control). While at the Greater London Council he achieved his ONC and HNC in civil engineering and then took a degree course in building surveying. He is a member of the Royal Institution of Chartered Surveyors.


Carl Coade joined Drivers &Norris in 1989.He was appointed an associate partner in 2002 and is now responsible for the running of the Residential Sales Department.He began his career with John Grant &Co,who had several offices across North London.He is an associate member of the National Association of Estate Agents.

Jason O ’Connell joined Drivers &Norris in September 1990 as an assistant in the Property Management Department.He became a residential lettings negotiator in 1992 and progressed to residential lettings manager in 2001.He was appointed an associate partner in 2004 and is responsible for the running of the Residential Lettings Department.He is an individual member of the Association of Residential Letting Agents.
Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors
<% If ISObject(Oconn) then oconn.close set oconn = nothing End if %>