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

Stratford Road, Salisbury

SP1 3JL
  • 150,000
  • Flats / Apartments
  • Right Move
Job

Kenilworth Walk Bedford MK41

MK41 8LH
  • 275,000
  • terraced
  • Zoopla
Job

Linton Street, Keighley

BD22 6NT
  • 190,000
  • Houses
  • Right Move
Job

Station Road, Brent Knoll

TA9 4BH
  • 430,000
  • Houses
  • Right Move
Job

Crossfield Grove, Stockport, SK2

SK2 7EQ
  • 425,000
  • Houses
  • Right Move
Job

Buckland Monachorum, Yelverton

PL20 7LL
  • 575,000
  • Bungalows
  • Right Move
Job

Clyffard Crescent, Newport

  • 215,000
  • Right Move
Job

Coleby Road, West Halton, Scunthorpe

DN15 9AP
  • 75,000
  • Flats / Apartments
  • Right Move
Job

Caldecott Road, Abingdon, OX14

OX14 5EZ
  • 573,000
  • Houses
  • Right Move