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

Bondend Lane, GLOUCESTER, GL4

GL4 8EJ
  • 950,000
  • Houses
  • Right Move
Job

Thistledown Road, Birmingham

B34 7EF
  • 230,000
  • Houses
  • Right Move
Job

Sunderland Terrace, Barnsley

S70 1UP
  • 90,000
  • Houses
  • Right Move
Job

Cromwell Road, Caversham, Reading

RG4 5EA
  • 395,000
  • Houses
  • Right Move
Job

17 Compton Road, Worcester. WR5 1DY

WR5 1DY
  • 250,000
  • Houses
  • Right Move
Job

Bricknell Avenue, Hull, HU5

HU5 4QG
  • 190,000
  • Houses
  • Right Move
Job

Mona Street, Amlwch

LL68 9AN
  • 225,000
  • Houses
  • Right Move
Job

Blamires Street, Bradford, BD7 4QZ

BD7 4QZ
  • 130,000
  • Houses
  • Right Move
Job

Eddystone Court, Wadebridge, PL27

PL27 7FH
  • 315,000
  • Flats / Apartments
  • Right Move