search sale by lot and redwan code bug fix