Award Winning
commercial property solutions

Property Search

Refine your search using the drop downs below
SELECT property_type_linker.propertyType AS PropTypeId, pp_tbl.Number, pp_tbl.Bullet_Point1, pp_tbl.Town, pp_tbl.District, pp_tbl.status_name, pp_tbl.Min_size, pp_tbl.Max_size, pp_tbl.Unit_name, pp_tbl.PhotoKey, pp_tbl.Dim_name FROM property_type_linker INNER JOIN pp_tbl ON property_type_linker.propertyNumber = pp_tbl.Number WHERE Number > 0 and (propertyType = 13) and min_size > 0 and (max_size > -5000 and max_size < 1000000000) and (Town = 'Isham') or number > 0 and (propertyType = 13) and min_size > 0 and (max_size > -5000 and max_size < 1000000000) and (District = 'Isham') or min_size <> max_size and max_size > 0 and min_size < 13000000 and (propertyType = 13) and (Town = 'Isham') Order by Updated DESC, number desc

Sorry, there are no properties available for your search, try broadening your search