Database Error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1, 1' at line 6SELECT photo.medium, property.* FROM property LEFT JOIN photo ON (property.id_property = photo.id_property AND photo.is_main = 1) WHERE 1 = 1 AND appraisal = 0 AND status = 1 LIMIT -1, 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1, 1' at line 6 Sales, Station road , Harrow , HA3
  London Properties
 
Property Search
 
 
Rent Buy
Maximum price
Bedrooms
Area

Search Results
18 properties found matching your criteria
Properties per page. Show all
  Sort According to :
 
  Jump to:
 
GO
   
 
LATEST PROPERTY
Leasehold
 
Click here to find how
much your property is
WORTH?
 
Online Quote
Station road , Harrow , HA3
Price: £325,000
Tenure: Leasehold
 
Photo Gallery - click to view
 
Download Brochure   Download Floorplan   Enquiry
Purpose built second floor flat
Two bedrooms
Light and airy reception

 
Interested in this property?
Call: Harrow Weald Branch +44(0)20 8861 4615
Other properties
in your search

- click to jump