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

Next auction 9th December at 10.30 at the London Voluntary Sector Resource Centre.

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

CLICK ICON FOR
CATALOGUE PDF

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

SUCCESSFULLY AUCTIONING PROPERTY SINCE 1852

LOT		RESULTS
LOT 1	CLICK ON PICTURE FOR MORE DETAILS	Freehold Part Vacant House As Three Flats 56 St Georges Avenue, Tufnell Park N7 0HD Sold £505,000
LOT 2	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 16 Station Close, Finchley N3 2SE Available £205,000
LOT 3	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House 44 Canons Brook, Harlow CM19 4EF WITHDRAWN PRIOR
LOT 4	CLICK PICTURE FOR MORE DETAILS	Freehold Pair Of Adjoining Houses With Planning Consent 102 – 104 Victoria Road, Darlington Dl1 5JW Available £350,000
LOT 5	CLICK ON PICTURE FOR MORE DETAILS	Long Leasehold Vacant Flat 6a Manor Croft Parade, Turners Hill, Cheshunt, Herts EN8 8LA Available £140,000
LOT 6	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Chalet Bungalow 32 First Avenue, Eastchurch, Sherness ME12 4JW Available £225,000
LOT 7	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House Garston, Coronation Road, Salcombe, Devon TQ8 8EA SOLD £350,000
LOT 8	CLICK ON PICTURE FOR MORE DETAILS	Vacant Freehold Garage Adjacent 53 Wharton Street, Kings Cross WC1X 9PA Available £175,000
LOT 9	CLICK ON PICTURE FOR MORE DETAILS	Long Leasehold Vacant Flat 83 Braithwaite House, Bunhill Row, London EC1Y 8NQ Available £295,000
LOT 10	CLICK ON PICTURE FOR MORE DETAILS	Long Leasehold Flat Investment 45 Grove House, Waverley Grove, Finchley N3 3PU WITHDRAWN PRIOR
LOT 11	CLICK ON PICTURE FOR MORE DETAILS	Ground Floor Offi ce And Garage For Sale Freehold 24 Fillebrook Avenue, Enfi eld EN1 3BB Available £160,000
LOT 12	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House 32 Digby Crescent, Finsbury Park, N4 2HR Sold £708,000
LOT 13	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Vacant Flat 28 Angel Close, Edmonton N18 2UA Sold £91,000
LOT 14	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Site Rear Of Northampton Grove, Islington N1 SOLD £12,500
LOT 15	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant House 9 Fletton Road, Bounds Green N11 2QL WITHDRAWN PRIOR
LOT 16	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD VACANT CHALET BUNGALOW 130 SUNNYBANK ROAD, POTTERS BAR, HERTS EN6 2NQ SOLD £250,000
LOT 17	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD VACANT HOUSE 41 RUSSELL ROAD, WALTHAMSTOW E17 6QY SOLD £250,000
LOT 18	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD INVESTMENT PROPERTY 61 AMHURST ROAD, HACKNEY E8 1LL Available £350,000

	REGISTER WITH US
	CURRENT AUCTION
AUCTION DATES 2008
	FEBRUARY 14
	APRIL 17
	JULY 8
	OCTOBER 7
	DECEMBER 9
	GUIDANCE NOTES

	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.