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 Shop And Upper Part Investment 2 Drayton Park, Highbury N5 1NU SOLD
LOT 2	CLICK ON PICTURE FOR MORE DETAILS	Freehold Part Vacant Investment 18 Turle Road, Finsbury Park N4 3LZ SOLD
LOT 3	CLICK ON PICTURE FOR MORE DETAILS	Freehold Light Industrial Investment 8 Craven Park Road, South Tottenham N15 6AB SOLD
LOT 4	CLICK PICTURE FOR MORE DETAILS	Freehold House Investment As Two Flats 9 Eade Road, Finsbury Park N4 1JD WITHDRAWN
LOT 5	CLICK ON PICTURE FOR MORE DETAILS	Share Of Freehold Flat Investment First Floor Flat 107 Avondale Road, Tottenham N15 3SR WITHDRAWN
LOT 6	CLICK ON PICTURE FOR MORE DETAILS	Share Of Freehold Flat Investment Ground Floor Flat 107 Avondale Road, Tottenham N15 3SR WITHDRAWN
LOT 7	CLICK ON PICTURE FOR MORE DETAILS	Freehold House Investment 146 Hermitage Road, Finsbury Park N4 1NL WITHDRAWN
LOT 8	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Vacant Flat 416a Hornsey Road, Upper Holloway N19 4EB WITHDRAWN
LOT 9	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant House 164 Green Street, Enfield, Middlesex EN1 7LB WITHDRAWN
LOT 10	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Flat Investment 1b Broadwater Road, Tottenham N17 6ER AVAILABLE
LOT 11	CLICK ON PICTURE FOR MORE DETAILS	Freehold Detached House With Potential For Alternative Uses 73 Melbourne Road, Ibstock, Leicestershire LE67 6NN AVAILABLE
LOT 12	CLICK ON PICTURE FOR MORE DETAILS	Leasehold Vacant Flat 78 Shaftesbury Court, Shaftesbury Street, Islington N1 7HN AVAILABLE
LOT 13	CLICK ON PICTURE FOR MORE DETAILS	Freehold Ground Rent Investment 137 Fairbridge Road, Archway N19 3HF SOLD
LOT 14	CLICK ON PICTURE FOR MORE DETAILS	Freehold Vacant Site Auburnville, Carthagena Estates, Broxbourne EN10 6TA AVAILABLE
LOT 15	CLICK ON PICTURE FOR MORE DETAIL	Pair Of Adjoining Freehold Shops With Upper Parts 359/361 Ballards Lane, North Finchley N12 8LJ AVAILABLE
LOT 16	CLICK ON PICTURE FOR MORE DETAIL	Freehold House Investment 47 Glasslyn Road, Crouch End N8 8RJ SOLD
LOT 17	CLICK ON PICTURE FOR MORE DETAIL	Freehold Investment House 110 Sussex Way, Holloway N7 6RR SOLD
LOT 18	CLICK ON PICTURE FOR MORE DETAIL	Freehold House Investment 75 College Street, Camborne, Cornwall TR14 7JY AVAILABLE
LOT 19	CLICK ON PICTURE FOR MORE DETAIL	Freehold Parcel Of Woodland Cherry Tree Orchard, Land East Of Bakers Lane, Tolleshunt Major, Nr Malden, Essex SOLD
LOT 20	CLICK ON PICTURE FOR MORE DETAIL	Freehold Residential Investment With Development Potential The Old Vicarage, 23a Vicarage Park, Plumstead, London SE18 7SX AVAILABLE
LOT 21	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant House Orchard Lea, Hailey Lane, Hailey, Hertford SG13 7NY SOLD
LOT 22	CLICK ON PICTURE FOR MORE DETAIL	hare Of Freehold Vacant Flat Top Floor Flat 1 Ferme Park Road, Stroud Green N4 4EB WITHDRAWN
LOT 23	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant Development Site Adjacent To 32 Cloudesley Place, Islington N1 0HZ AVAILABLE
LOT 24	CLICK ON PICTURE FOR MORE DETAIL	Freehold Land Investment Plot No SHX50, Land Off Oxford Lane, Sible Hedingham, Braintree, Essex AVAILABLE
LOT 25	CLICK ON PICTURE FOR MORE DETAIL	Freehold Land Investment Plot SHW177, Land Off Oxford Lane, Sible Hedingham, Braintree, Essex AVAILABLE
LOT 26	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant House 120 Meadway, Barnet, Herts EN5 5JX WITHDRAWN
LOT 27	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant House 122 Meadway, Barnet, Herts EN5 5JX WITHDRAWN
LOT 28	CLICK ON PICTURE FOR MORE DETAIL	Freehold Residential Building And Land Milkwood Farm, Dixons Hill Close, North Mymms, Herts Al9 7EF SOLD
LOT 29	CLICK ON PICTURE FOR MORE DETAIL	Freehold Development Site With Planning Consent Moray Mews, Finsbury Park N7 7DY SOLD
LOT 30	CLICK ON PICTURE FOR MORE DETAIL	Freehold Storage Premises Rear Of 36 South Avenue, Southend On Sea, Essex SS2 5JB SOLD
LOT 31	CLICK ON PICTURE FOR MORE DETAIL	Freehold Vacant House 73 Forest Road, Freezywater, Enfield, Middlesex EN3 6SU SOLD
LOT 32	CLICK ON PICTURE FOR MORE DETAIL	Freehold Development Site Formerly known as Hester Annex, Rear Of 291-301 White Hart Lane, Tottenham N17 7BT AVAILABLE
LOT 33	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD DEVELOPMENT SITE 85- 88 BRENT TERRACE, CRICKLEWOOD NW2 1BY AVAILABLE
LOT 34	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD VACANT HOUSE 2A MACFARLANE ROAD, SHEPHERDS BUSH W1 2JZ SOLD
LOT 35	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD DEVELOPMENT SITE 39 SUN HILL AND 19 CORONATION AVENUE ROYSTON, HERTS SG8 9AX WITHDRAWN
LOT 36	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD COMMERCIAL PREMISES WITH UPPER PARTS 30 ST JAMES’S STREET, WALTHAMSTOW E17 7PF AVAILABLE
LOT 37	CLICK ON PICTURE FOR MORE DETAIL	FREEHOLD VACANT HOUSE 30 HAROLD ROAD, CROUCH END N8 7DE SOLD

	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 Highbury Suite,
The Emirates Stadium,
London N5 1BU -

West Entrance

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