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

Aire Quay, Hunslet, LS10

LS10 1GA
  • 1,200
  • Flats / Apartments
  • Right Move
Job

- Unit, Taj House, 220 - 222 Cowley Road, OX4

OX4 1UQ
  • 815
  • Houses
  • Right Move
Job

Elizabeth Court, Bathurst Walk, Richings Park, SL0

SL0 9DQ
  • 1,350
  • Flats / Apartments
  • Right Move
Job

Potters Lane, Send, Woking, GU23

GU23 7AL
  • 7,000
  • Houses
  • Right Move
Job

Sheriff Park, Leith, Edinburgh, EH6

EH6 6DX
  • 925
  • Flats / Apartments
  • Right Move
Job

F2 28-32 New Station Rd, Fishponds, Bristol, Bristol, BS16

BS16 3RS
  • 1,077
  • Flats / Apartments
  • Right Move
Job

Northgate Street, Colchester, Essex, CO1

CO1 1HA
  • 950
  • Flats / Apartments
  • Right Move
Job

Broadmead Avenue, NORTHAMPTON

NN3 2QX
  • 1,300
  • Houses
  • Right Move
Job

Surrey, TW18

TW18 4JT
  • 2,040
  • Flats / Apartments
  • Right Move
Job

The Square, Shrewsbury

SY1 1LA
  • 1,350
  • Flats / Apartments
  • Right Move
Job

Cardiff, Cardiff, CF11

CF11 9AF
  • 1,100
  • Flats / Apartments
  • Right Move
Job

Banister Road, Kensal Rise, London, W10

W10 4BH
  • 495
  • Flats / Apartments
  • Right Move
Job

KA10 6AN
  • 1,400
  • Zoopla
Job

James Street, Lincoln, LN2

LN2 1QE
  • 2,900
  • Houses
  • Right Move
Job

Goodwyn Avenue, Mill Hill, NW7

NW7 3RJ
  • 1,700
  • Flats / Apartments
  • Right Move
Job

Green Cross Lane, Churt, Surrey, GU10

GU10 2ND
  • 4,750
  • Houses
  • Right Move