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


PROPERTY AUCTIONS ESTATE AGENTS | AUCTIONEERS | SURVEYORS & VALUERSAUCTIONS

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 Property for sale in North London FOR SALE Property for sale in North London TO LET Property to let in North London COMMERCIAL Commercial Property North London Shops Offices Industrial Premises AUCTIONS Property Auctions London MANAGEMENT Property Management London SURVEYS Surveyors London MORTGAGES Mortages Online London property OVERSEAS Overseas Property Spanish Villas Apartments London Agent COMPANY Overseas Property Spanish Villas Apartments London Agent

Content on this page requires a newer version of Adobe Flash Player.

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


AUCTION RESULTS
DECEMBER 9 2008

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


LOT
RESULTS

LOT 1

CLICK ON PICTURE


FOR MORE DETAILS

Leasehold Vacant Flat
133 Boleyn Road, East Ham E6 1QA

SOLD £75,000

LOT 2

 CLICK ON PICTURE

FOR MORE DETAILS

Leasehold Flat Investment
15 Sycamore Close, Edmonton N9 9XT

Available £110,000

LOT 3

CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant House
20 Harcombe Road, Stoke Newington N16 0SA

SOLD £350,000

LOT 4

 CLICK PICTURE

FOR MORE DETAILS

Leasehold Vacant Flat
6 Sherard Court, Manor Gardens, London N7 6FA

Available £260,000

LOT 5

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Rural Parcel of Land
Stortford Road, Standon, Essex

Available £20,000

LOT 6

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Garage with access driveway
Ramsey Mews, Monsell Road, Finsbury Park
N4 2YA

Sold £46,000

LOT 7

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold House Investment
19 St Davids Road, East Cowes PO32 6ED

Available £60,000

 LOT 8

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant House As Five Flats
53 Fairfield Road, Edmonton N18 2QP

Available £425,000

 LOT 9

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Shop and Upper Part Investment
87 Blackstock Road, Finsbury Park N4 2JW

Available £520,000

LOT 10

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant Development Site
Site at 2 Wicklow Street, Kings Cross, London
WC1X 9JL

Available £325,000

LOT 11

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant House
83 Monmouth Road, Edmonton N9 0JD

Available £215,000

LOT 12

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant Cottage
Kirkham Cottage, Kirkham Street, Paignton,
Devon TQ3 3AX

Available £120,000

LOT 13

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Vacant Commercial Premises
With Upper Parts
101 Morning Lane, Hackney, E9 6ND

Available £220,000

LOT 14

 CLICK ON PICTURE

FOR MORE DETAILS

Freehold Commercial Investment
With Upper Part
49a And 50 St Peters Road, Great Yarmouth,
Norfolk, NR30 3AA

Available £135,000

LOT 15

 CLICK ON PICTURE

FOR MORE DETAIL

Leasehold Vacant Flat
73a Kingsdown Road, Upper Holloway N19 4LD

Withdrawn

LOT 16

LEGAL DOCS

 LOT 16

LEASEHOLD VACANT FLAT
6 DRUMMER LODGE, KINLOCH STREET, HOLLOWAY N7 7LJ

Withdrawn

LOT 17

LEGAL DOCS

 LOT 16

LEASEHOLD FLAT
FLAT 24 MARTLESHAM, ADAMS ROAD, TOTTENHAM, N17

Available £80,000

LOT 18

LEGAL DOCS

 LOT 16

FREEHOLD VACANT LIVE/WORK PREMISES
2 BRIDGE ROAD, EDMONTON N9 0NN

Available £164,000


North London Property REGISTER WITH US
North London Property
 CURRENT AUCTION
AUCTION DATES 2008
North London Property FEBRUARY 14
North London Property APRIL 17
North London Property JULY 8
North London Property OCTOBER 14
North London Property DECEMBER 9
North London Property GUIDANCE NOTES
North London Property 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
Drivers & Norris Estate Agents London Residential And Commercial Sales and Lettings, Property Auctions, Surveyors And Mortgage Advisors