SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='M28 1GZ' order by fulladdress
       
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Leasehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           344,000                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           343,000                
-                                           Leasehold Mid terrace house                 
                  
                                        M28 1GZ                              -                                           343,000                
-                                           Freehold Mid terrace house                 
                  
                                        M28 1GZ                              -                                           346,000                
-                                           Leasehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           306,000                
-                                           Leasehold Mid terrace house                 
                  
                                        M28 1GZ                              -                                           336,000                
-                                           Leasehold Terrace property                 
                  
                                        M28 1GZ                              -                                           317,000                
-                                           Leasehold End terrace house                 
                  
                                        M28 1GZ                              -                                           557,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           556,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           513,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           529,000                
-                                           Leasehold Detached property                 
                  
                                        M28 1GZ                              -                                           552,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           577,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           517,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           531,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           541,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           520,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           689,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           467,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           528,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           402,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           528,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           512,000                
-                                           Leasehold Detached property                 
                  
                                        M28 1GZ                              -                                           441,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           514,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           525,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           547,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           467,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           544,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           521,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           699,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           398,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           507,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           426,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           518,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           500,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           486,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           503,000                
-                                           Leasehold Semi-detached property                 
                  
                                        M28 1GZ                              -                                           498,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           556,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           520,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           487,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           484,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           514,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           513,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           561,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           532,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           536,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           521,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           508,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           512,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           568,000                
-                                           Leasehold Detached property                 
                  
                                        M28 1GZ                              -                                           513,000                
-                                           Freehold Detached house                 
                  
                                        M28 1GZ                              -                                           496,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           533,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           510,000                
-                                           Leasehold Detached property                 
                  
                                        M28 1GZ                              -                                           559,000                
-                                           Leasehold Detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house                 
                  
                                        M28 1GZ                              -                                           0                
-                                           Freehold Semi-detached house