Select top 16 * 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=1 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=1) t1 Order By NewID()
LE15 8RN - 1,250,000
- Character Property
- Right Move
BL7 0JZ - 1,500,000
- Houses
- Right Move
FY4 1DH - 65,000
- Flats / Apartments
- Right Move
SA4 8AD - 87,500
- Flats / Apartments
- Right Move
BH17 8QY - 185,000
- Flats / Apartments
- Right Move
L7 2PZ - 110,000
- Houses
- Right Move
