<% 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 North London Property15th February 2007 at the

London Voluntary Sector Resource Centre
356 Holloway Road
London, N7
commencing at 11 am

CALL THE AUCTION TEAM FOR
A FREE MARKET APPRAISAL ...
020 7607 5001
auction@drivers.co.uk

SUCCESSFULLY AUCTIONING PROPERTY SINCE 1852

LOT
GUIDE
LOT 1 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD PART VACANT HOUSE
AS THREE FLATS
56 ST GEORGES AVENUE, TUFNELL PARK N7

Sold £531,000
LOT 2 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD HOUSE INVESTMENT
88 SOUTHFIELD ROAD, PONDERS END,
ENFIELD EN3

Available £225,000
LOT 3 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD SITE WITH DEVELOPMENT
POTENTIAL (SUBJECT TO NECESSARY
CONSENTS)
SITE ADJACENT TO 43 MERCERS ROAD,
TUFNELL PARK N7

Sold £271,000
LOT 4 CLICK PICTURE

FOR MORE DETAILS

FREEHOLD SHOP WITH FOUR SELF
CONTAINED FLATS PART VACANT
INVESTMENT
479 HORNSEY ROAD, HORNSEY RISE N19

Available Refer
LOT 5 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD HOUSE WITH POTENTIAL
390A SEVEN SISTERS ROAD,
FINSBURY PARK N4

Sold £342,000

LOT 6 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD PART VACANT HOUSE
INVESTMENT
35 SOUTH STREET, PONDERS END,
ENFIELD EN3

Sold £225,000
LOT 7 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD SHOP WITH TWO FLATS
INVESTMENT
324 NEASDEN LANE, NEASDEN NW10

Sold Prior £650,000
 LOT 8 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD GROUND RENT INVESTMENT
SECURED UPON
11 BEECHWOOD GARDENS, PARK ROYAL
NW10

Sold £14,000
 LOT 9 CLICK ON PICTURE

FOR MORE DETAILS

LEASEHOLD VACANT FLAT
309 WEST GREEN ROAD,
SOUTH TOTTENHAM N15

Available Refer
LOT 10 CLICK ON PICTURE

FOR MORE DETAILS

MEWS BUILDING WITH CONSENT FOR
RESIDENTIAL CONVERSION
5 ROSEBERY MEWS, MUSWELL HILL N10 2LG

Sold £263,000
LOT 11 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD SHOP AND RESIDENTIAL
INVESTMENT
77 DENMARK HILL, LONDON SE5

Sold £551,000
LOT 12 CLICK ON PICTURE

FOR MORE DETAILS

FREEHOLD PAIR OF SEMI DETACHED BUNGALOWS WITH
PLANNING CONSENT FOR DEMOLITION AND THE ERECTION
OF EIGHT APARTMENTS
36/38 EVERSLEY PARK ROAD,
WINCHMORE HILL N21

Sold £1,200,000
LOT 13 CLICK ON PICTURE

FOR MORE DETAILS		 LONG LEASEHOLD VACANT MAISONETTE

29 HILLFIELD HOUSE, GROSVENOR AVENUE, HIGHBURY N5 2NS

Sold £233,000
LOT 14 CLICK ON PICTURE

FOR MORE DETAILS		 LONG LEASEHOLD INVESTMENT FLAT

12 CHESHIRE HOUSE, CAMERON CLOSE, EDMONTON N18 2HR

Sold £90,000


North London Property
 CURRENT AUCTION
AUCTION DATES 2008
North London Property FEBRUARY 15
North London Property APRIL 24
North London Property JULY 17
North London Property OCTOBER 16
North London Property DECEMBER 4
North London Property GUIDANCE NOTES

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