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

Saville Row Bromley BR2

BR2 7DX
  • 450,000
  • terraced
  • Zoopla
Job

Commercial Street, MAESTEG

CF34 9HJ
  • 50,000
  • Flats / Apartments
  • Right Move
Job

Rowhill Avenue Aldershot Hampshire GU11

GU11 3LP
  • 400,000
  • semi_detached
  • Zoopla
Job

Nascot Street, Watford, WD17

WD17 4RB
  • 550,000
  • Houses
  • Right Move
Job

Cedar Close, Walsall

WS5 4LJ
  • 230,000
  • Houses
  • Right Move
Job

St Georges Lane, Holcombe, EX7

EX7 0GJ
  • 545,000
  • Houses
  • Right Move
Job

West Clandon Surrey GU4

GU4 7UE
  • 1,895,000
  • detached
  • Zoopla
Job

Melbourne Way, Newport

  • 400,000
  • Right Move