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

24th April

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 RESIDENTIAL INVESTMENT 30 CHURCH CRESCENT, MUSWELL HILL N10 Sold £950,000
LOT 2	CLICK ON PICTURE FOR MORE DETAILS	LEASEHOLD PENTHOUSE 10 TOLLINGTON HOUSE, HOLLOWAY ROAD UPPER HOLLOWAY N19 WITHDRAWN PRIOR
LOT 3	CLICK ON PICTURE FOR MORE DETAILS	VACANT LEASEHOLD FLAT 2A DORSET ROAD, SOUTH TOTTENHAM N15 WITHDRAWN PRIOR
LOT 4	CLICK PICTURE FOR MORE DETAILS	LAND WITH POTENTIAL (SUBJECT TO PLANNING) LAND AT STAG LANE, CHORLEYWOOD, HERTS WITHDRAWN PRIOR
LOT 5	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD VACANT HOUSE 46 FRASER ROAD, EDMONTON N9 WITHDRAWN PRIOR
LOT 6	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD RURAL PARCEL OF LAND AND AGRICULTURAL SHEDS STANSTEAD ROAD, STANDON, ESSEX Available £55,000
LOT 7	CLICK ON PICTURE FOR MORE DETAILS	VACANT FLAT WITH SHARE OF FREEHOLD UPPER FLAT 36 BELMONT ROAD, TOTTENHAM N15 WITHDRAWN PRIOR
LOT 8	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD PARCEL OF LAND REAR OF 8-12 BRECKNOCK ROAD, HOLLOWAY N7 Sold £6,000
LOT 9	CLICK ON PICTURE FOR MORE DETAILS	LOT 9 SITE WITH DEVELOPMENT POTENTIAL (SUBJECT TO CONSENTS) SITE ADJACENT TO 1 CAMBRIDGE GARDENS, WINCHMORE HILL N21 Sold £240,000
LOT 10	CLICK ON PICTURE FOR MORE DETAILS	LEASEHOLD FLAT INVESTMENT 13 PIPER WAY, VICARAGE LANE, ILFORD, ESSEX IG1 Available £190,000
LOT 11	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD SHOP AND TWO FLATS PART VACANT INVESTMENT 268 PHILIP LANE, SOUTH TOTTENHAM N15 Sold £341,000
LOT 12	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD SHOP INVESTMENT 172 SEVEN SISTERS ROAD, HOLLOWAY N7 Sold £420,000
LOT 13	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD VACANT HOUSE 5 ARAN MEWS, BARNSBURY GROVE, HOLLOWAY N7 Available £470,000
LOT 14	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD HOUSE INVESTMENT 27 NORTHDOWN ROAD, HATFIELD, HERTS AL10 Available refer
LOT 15	CLICK ON PICTURE FOR MORE DETAILS	LONG LEASEHOLD TENANTED FLAT 34 LIVINGSTONE HOUSE, HARVIST ESTATE, HORNSEY ROAD, HOLLOWAY N7 WITHDRAWN PRIOIR
LOT 16	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD SHOP INVESTMENT 208 HORNSEY ROAD, HOLLOWAY N7 Sold £ 325,000
LOT 17	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD WOODLAND BANCROFT WOOD, WHITE STUBBS LANE, BROXBOURNE, HERTS EN10 Sold £11,000
LOT 18	CLICK ON PICTURE FOR MORE DETAILS	LEASEHOLD VACANT FLAT 37 PARKHURST COURT, WARLTERS ROAD, HOLLOWAY N7 Sold £226,000
LOT 19	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD VACANT HOUSE 299 ST ANN’S ROAD, HARINGEY N15 Sold £300,000
LOT 20	CLICK ON PICTURE FOR MORE DETAILS	FREEHOLD VACANT HOUSE 45 LATIMER ROAD, FOREST GATE E7 Sold £276,000
LOT 21	CLICK ON PICTURE FOR MORE DETAILS	LATE ENTRY - LOT 21 VACANT LEASEHOLD FLAT 73A KINGSDOWN ROAD, UPPER HOLLOWAY N19 WITHDRAWN PRIOR

	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 LONDON RESOURCE CENTRE
356 HOLLOWAY ROAD
LONDON N.7.

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