Selected Property

Select * from (SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[propertyType],[beds],[displayAddress],[current_price],[current_status],[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[RM_REPORT_TODAY] where sale_or_rental=2 union all SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[property_type],[beds],[displayAddress],[price] as current_price,[listing_status] as current_status ,[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[Z_REPORT_TODAY] where sale_or_rental=2) t1 where postcode='IG2 7NQ'
Job

Perkins Road, Newbury Park, IG2 7NQ

IG2 7NQ
  • 2,500
  • Bungalow
  • Right Move
Job

Perkins Road

IG2 7NQ
  • 2,500
  • bungalow
  • Zoopla
Job

Ilford IG2

IG2 7NQ
  • 2,600
  • semi_detached
  • Zoopla