<% 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

AUCTIONS

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 : auction@drivers.co.uk
HOME Property for sale in North London 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


Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors AUCTION YOUR PROPERTY WITH DRIVERS AND NORRIS !

IF YOU ARE SEEKING THE CERTAINTY OF AN IMMEDIATE SALE AND OBTAINING THE BEST POSSIBLE PRICE THEN CONSIDER THE ADVANTAGES OF SELLING BY AUCTION !

The AUCTION market is BOOMING
BE PART OF IT!

AUCTIONING YOUR PROPERTY IS THE MOST TRANSPARENT AND EFFECTIVE METHOD OF SALE - PARTICULARLY FOR TRUSTS AND EXECUTORS AS THE PROPERTY IS EXPOSED FOR SALE IN A PUBLIC FORUM.

WE CONSIDER PROPERTIES WITH:

  • STRUCTURAL DEFECTS
  • SHORT LEASES
  • PART POSSESSION
  • LEGAL PROBLEMS
  • DERELICT/REDUNDANT
  • ENFORCEMENT NOTICES
  • PLANNING ISSUES
  • "HOPE VALUE"
  • ETC ETC........

Once entered into our AUCTION your property will be widely advertised in a wide range of publications together with the premier trade magazine the ESTATES GAZETTE. All viewings leading up to the AUCTION will be accompanied and the full colour catalogue will be distributed to more than two thousand applicants registered with us.

REMEMBER ONCE THE AUCTIONEER'S GAVEL FALLS-YOUR PROPERTY IS SOLD AND CONTRACTS ARE EXCHANGED THERE AND THEN WITH A TEN PER CENT DEPOSIT PAID...LIKE TO KNOW MORE?

FOR A FREE MARKET APPRAISAL CALL THE AUCTION TEAM NOW! WE ARE CURRENTLY TAKING INSTRUCTIONS FOR OUR NEXT AUCTION (click here)


North London PropertyNext auction OCTOBER 7th 11am

VENUE
THE LONDON RESOURCE CENTRE
356 HOLLOWAY ROAD
LONDON N.7.

SUCCESSFULLY AUCTIONING PROPERTY SINCE 1852
020 7607 5001

 

North London Property REGISTER WITH US
North London Property
CURRENT AUCTION
AUCTION DATES 2008
North London Property FEBRUARY 14
North London Property APRIL 17
North London Property JULY 8
North London Property OCTOBER 7
North London Property DECEMBER 4
North London Property GUIDANCE NOTES
North London Property RESULTS FROM 2007

WE HOLD AUCTION SALES APPROXIMATELY EVERY 2 MONTHS OFFERING A VARIETY OF RESIDENTIAL AND COMMERCIAL PROPERTIES IN LONDON AND THROUGHOUT THE COUNTRY.

OUR CURRENT VENUE IS

THE LONDON RESOURCE CENTRE
356 HOLLOWAY ROAD
LONDON N.7.

WHICH IS WITHIN 5 MINUTES
WALK OF
HOLLOWAY ROAD TUBE STATION.
Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors