How to use Distinct when working with ROWNUMBER in SQL-Server

DECLARE @H_name VARCHAR(50)
SET @H_name = 'Electric'
 
select distinct House_Info.Image_Behcode,House_Info.Image_Header,House_Info.Name,substring(House_Info.[Service1]+'-'+House_Info.[Service2]+'-'+House_Info.[Service3]+'-'+House_Info.[Service4]+'-'+House_Info.[Service5]+'-'+House_Info.[Service5],0,46)+'...'as Description,substring(House_Info.[Description],0,45)+'...'  As Description2  ,SUBSTRING(House_Info.[Address],0,26)+'...' as Address,MAX(House_p.[Date]) as [Maxdate]
into #Temp
from House_Info
Inner Join  House_p  ON House_Info.Behcode = House_p.Behcode
where House_Info.H_name=@H_name
group by House_Info.address,House_Info.Name,House_Info.Image_Behcode,House_Info.Image_Header,House_Info.Service1,House_Info.Service2,House_Info.Service3,House_Info.Service4,House_Info.Service5,House_Info.Description
order by [Maxdate] desc
 
 
      SELECT ROW_NUMBER() OVER
      (
                 order by [Maxdate] desc
                       
      )AS RowNumber, *
      INTO #Results
      FROM #Temp
          
      --SELECT @RecordCount = COUNT(*)
      --FROM #Results
                
      SELECT * FROM #Results
      --WHERE (RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1)
          
         
      DROP TABLE #Results
      DROP TABLE #Temp