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 DEC 4 @ 11am

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

CLICK PDF ICON FOR
VENUE INFORMATION

CLICK PDF ICON FOR
CATALOGUE PDF (3MB)

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

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 80 Hornsey Lane, Highgate N6 5lU Sold £625,000
LOT 2	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House Part Of 25 Woodlands Park Road, Harringay N15 3RU Sold £257,000
LOT 3	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 28b Grunaisan Road, Finchley N3 1LU AVAILABLE £210,000
LOT 4	CLICK PICTURE FOR MORE DETAILS	Leasehold Flat Investment Flat 4, 61 Finchley Lane, Hendon NW4 1BY Sold £210,000
LOT 5	CLICK ON PICTURE FOR MORE DETAILS	Vacant Freehold Garage Adjacent 53 Wharton Street, Kings Cross WC1X 9PA WITHDRAWN REFER
LOT 6	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Site With Planning Consent 73a Nightingale Road, Wood Green N22 8PT Sold Prior £140,000
LOT 7	CLICK ON PICTURE FOR MORE DETAILS	Ground Floor Office And Garage For Sale Freehold 24 Fillebrook Avenue, Enfield EN1 3BB REFER
LOT 8	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Mews Building 4 Roseberry Mews, Muswell Hill N10 2LG Sold Prior £265,000
LOT 9	CLICK ON PICTURE FOR MORE DETAILS	Vacant Freehold House 20 Gibbs Green, Edgware, Middlesex HA8 9RH AVAILABLE REFER
LOT 10	CLICK ON PICTURE FOR MORE DETAILS	Freehold Investment 347 and 347a, 349 and 349a, 351 and 351a, 357 and 357a, 359 and 359a, 361 and 361a, 367 and 367a, 369 and 369a Holloway Road, Holloway N7 0RN Sold £780,000
LOT 11	CLICK ON PICTURE FOR MORE DETAILS	Long Leasehold Investment 375b Holloway Road, Holloway N7 Sold £780,000
LOT 12	CLICK ON PICTURE FOR MORE DETAILS	LATE ENTRY - LOT 12 LEASEHOLD FLAT INVESTMENT 85 HIND HOUSE, HARVIST ESTATE, HOLLOWAY N7 7NB WITHDRAWN

	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.