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

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

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 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
AUCTION DETAILS

Freehold Part Vacant Commercial
Premises With Upper Parts
30 St James’s Street, Walthamstow E17 7PF

A commercial unit on the ground floor currently trading as a public house. With three self contained flats above one vacant, two let producing £1,460 pcm. Situated in a densely populated residential area within immediate access of St James’s Street mainline station together with Blackhorse Road underground station approximately half a mile.

Details as follows:
(approximate dimensions)
Second Floor Flat
3 Rooms
Kitchen
Bathroom
First Floor Flat
2 rooms
Kitchen
Bathroom
First Floor (Studio)
Room including kitchen area
Bathroom
Ground Floor
Public House depth 41’6”
(12.65m) x width 16’6”
(5.05m)
Store room 10’9” (3.30m)
x 7’3” (2.20m)
2 x WCs
Exterior
Small yard with rear
pedestrian access

Offered Freehold With Full Vacant Possession Upon Completion
Vendors Solicitors: Richard West Freeman Christofi LLP, 236 Hoe
Street, Walthamstow, London E17 3AY Ref; Mr R West
Tel: 020-8521-6235
Local Authority: London Borough of Waltham Forest
Viewing: By appointment with Auctioneers

N.B. Please note that these are not quoting prices but are an indication of the lowest price which may be acceptable, and they are liable to change at any time.

 

NOTE: THE AUCTIONEERS, AT THEIR SOLE DISCRETION, RESERVE THE RIGHT TO CALL FOR ALL SUCCESSFUL BIDDERS TO PAY THE 10% DEPOSIT BY BANKERS DRAFT , INTENDING BUYERS WISHING TO PAY BY CHEQUE MUST MAKE PRIOR ARRANGEMENTS WITH THE AUCTIONEERS. IN THE EVENT OF A SUCCESSFUL BIDDER TENDERING A CHEQUE FOR THE 10% DEPOSIT WITHOUT HAVING MADE PRIOR ARRANGEMENTS WITH THE AUCTIONEERS THE LATTER RESERVE THE RIGHT TO OFFER THE PROPERTY TO THE UNDER-BIDDER, OR IN THE ALTERNATIVE, TO RE-OFFER THE PROPERTY BY AUCTION AND TO CLAIM ANY LOSS WHICH MAY RESULT AGAINST THE ORIGINAL BIDDER. N.B. ALL SIZES ARE APPROXIMATE AND MEASURED TO THE NEAREST 3', AS STANDARD. METRIC EQUIVALENTS ARE ROUNDED TO THE NEAREST 0.05M ON THE ABOVE BASIS. Prospective purchasers wishing to make arrangements to bid by telephone or proxy, must contact the auctioneers, a minimum of 3 working days BEFORE the date of Auction.


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