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

Stoneleigh Avenue, Enfield

EN1 4HH
  • 375,000
  • Houses
  • Right Move
Job

Rhodfa Elgwern, Denbigh

LL16 3JQ
  • 299,950
  • Houses
  • Right Move
Job

Chadville Gardens, Romford, RM6

RM6 5UB
  • 475,000
  • Bungalows
  • Right Move
Job

72 Keighley Road, Skipton, BD23 2RA

BD23 2RA
  • 215,000
  • Houses
  • Right Move
Job

St. Bernard's Road London E6

E6 1PG
  • 450,000
  • terraced
  • Zoopla
Job

Cross Lane Andover SP10

SP10 3JE
  • 310,000
  • semi_detached
  • Zoopla