Selected Property

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=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 Order By NewID()
Job

Tower Street, Barnsley

S70 1QS
  • 85
  • House / Flat Share
  • Right Move
Job

Newton Road, Yeovil, BA20

BA20 1FE
  • 750
  • Flats / Apartments
  • Right Move
Job

Menlove Ave, Allerton, Liverpool

L18 1LS
  • 2,700
  • Houses
  • Right Move
Job

Farrar Road, Bangor

LL57 2DU
  • 125
  • House / Flat Share
  • Right Move
Job

Kicks Hill, Middlezoy

TA7 0NU
  • 1,500
  • Houses
  • Right Move
Job

Amersham Vale, New Cross, SE14

SE14 6LD
  • 1,700
  • Flats / Apartments
  • Right Move