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

Longmead Drive, Fiskerton, NG25

NG25 0UP
  • 1,950
  • Houses
  • Right Move
Job

21 Greg St, Reddish, SK5 7LB

SK5 7LB
  • 1,150
  • Not Specified
  • Right Move
Job

Wimpole Road, Colchester

CO1 2BX
  • 1,100
  • Houses
  • Right Move
Job

York Road Ilford IG1

  • 1,800
  • Zoopla
Job

St. James Gardens, Wembley, Middlesex HA0

HA0 4LH
  • 2,600
  • Flats / Apartments
  • Right Move
Job

Bundle Hill, Halesowen

B63 4AR
  • 795
  • Flats / Apartments
  • Right Move
Job

Queens Drive, London, N4

N4 2HW
  • 1,800
  • Flats / Apartments
  • Right Move
Job

The Vale London NW11

NW11 8TL
  • 3,995
  • Houses
  • Right Move
Job

Orchard Gardens, Teignmouth, TQ14

TQ14 8DP
  • 695
  • Flats / Apartments
  • Right Move
Job

Eastern Road N22

  • 1,400
  • Zoopla