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='SO23 0LB'
SO23 0LB - 1,667
- Flats / Apartments
- Right Move
SO23 0LB - 1,650
- Flats / Apartments
- Right Move
SO23 0LB - 825
- House / Flat Share
- Right Move
SO23 0LB - 1,475
- Flats / Apartments
- Right Move
SO23 0LB - 1,300
- Flats / Apartments
- Right Move
SO23 0LB - 1,667
- Flats / Apartments
- Right Move
SO23 0LB - 1,500
- Flats / Apartments
- Right Move
SO23 0LB - 1,695
- Flats / Apartments
- Right Move
SO23 0LB - 1,500
- Flats / Apartments
- Right Move
SO23 0LB - 1,495
- Flats / Apartments
- Right Move
SO23 0LB - 1,600
- Flats / Apartments
- Right Move
SO23 0LB - 775
- House / Flat Share
- Right Move
SO23 0LB - 1,650
- Flats / Apartments
- Right Move
SO23 0LB - 1,650
- Flats / Apartments
- Right Move
SO23 0LB - 1,700
- Flats / Apartments
- Right Move