Drivers & Norris - Properties for Sale North London

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

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

FOR SALE

TO LET

COMMERCIAL

AUCTIONS

MANAGEMENT

SURVEYS

MORTGAGES

OVERSEAS

COMPANY

Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors

Auction sale OCT 16 @ 11am

To receive details of the current auction as soon as they are released or if you have a property you would like to include in the sale REGISTER WITH US CLICK HERE

NEW VENUE
The Highbury Suite, The Emirates Stadium, London N5 1BU - West Entrance

CLICK PDF ICON FOR
VENUE INFORMATION

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 Vacant House 24 Hercules Street, Holloway N7 6AS Sold £516,000
LOT 2	CLICK ON PICTURE FOR MORE DETAILS	Long Leasehold Roof Space Above 354-356 Camden Road, Holloway N7 0LG Withdrawn
LOT 3	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Lock Up Shop 285 Hornsey Road, Upper Holloway N19 4HN Available £120,000
LOT 4	CLICK PICTURE FOR MORE DETAILS	Freehold Shop And Residential Upper Parts With Potential (subject to consents) 29a High Street, Potters Bar, Herts Available refer
LOT 5	CLICK ON PICTURE FOR MORE DETAILS	Freehold Shop And Residential Upper Parts With Potential (subject to consents) 31 High Street, Potters Bar, Herts Available refer
LOT 6	CLICK ON PICTURE FOR MORE DETAILS	Freehold Part Vacant Industrial Building Granyte House, Delamare Road, Cheshunt EN8 9SP Sold £600,000
LOT 7	CLICK ON PICTURE FOR MORE DETAILS	Freehold Site With Planning For Three Bedroom House 158 London Road, Bishops Stortford, Herts CM23 3LQ Available £150,000
LOT 8	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Woodland Midfi eld Lane, Roydon, Essex CM19 5EA WITHDRAWN
LOT 9	CLICK ON PICTURE FOR MORE DETAILS	Freehold Shop Investment 330c Holloway Road, Holloway N7 Sold £315,000
LOT 10	CLICK ON PICTURE FOR MORE DETAILS	Share Of Freehold Vacant Flat With Potential (subject to consents) Ground Floor Flat 13 Darville Road, Stoke Newington N16 7PT Available £238,000
LOT 11	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 8 Northwood Hall, Hornsey Lane, Highgate N6 5RF Sold £180,000
LOT 12	CLICK ON PICTURE FOR MORE DETAILS	Industrial Investment Unit 13 Shaftesbury Road, Upper Edmonton N18 1UB Sold £150,000
LOT 13	CLICK ON PICTURE FOR MORE DETAILS	Freehold Site With Development Potential (subject to necessary consents) Land At Friday Grove, Hawkshead Road, Brookmans Park, Hertfordshire Available £1,000,000
LOT 14	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 9 Lillingstone House, Harvist Estate, Hornsey Road, Holloway N7 7LX WITHDRAWN
LOT 15	CLICK ON PICTURE FOR MORE DETAILS	Vacant Leasehold Flat 73a Kingsdown Road, Upper Holloway N19 4LD WITHDRAWN
LOT 16	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 78b Stroud Green Road, Finsbury Park N4 3EN WITHDRAWN
LOT 17	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House 14 Westoe Road, Lower Edmonton N9 0SH Sold £193,000
LOT 18	CLICK ON PICTURE FOR MORE DETAILS	VACANT FREEHOLD FORMER PIT ST MARYS LANE, HERTINGFORDBURY, HERTS SG14 Available £450,000

	REGISTER WITH US
	CURRENT AUCTION
AUCTION DATES 2008
	FEBRUARY 15
	APRIL 24
	JULY 17
	OCTOBER 16
	DECEMBER 4
	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 Highbury Suite,
The Emirates Stadium,
London N5 1BU -

West Entrance

WHICH IS WITHIN 5 MINUTES
WALK OF
HOLLOWAY ROAD TUBE STATION.