SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW11 0NL' order by fulladdress
      
                                        TW11 0NL                              -                                           1,021,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           2,088,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,963,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,951,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,937,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,768,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,780,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           915,000                
                  -                                           Freehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           1,994,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           926,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           1,626,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        TW11 0NL                              -                                           1,779,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,913,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,849,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,843,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,940,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,919,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,869,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        TW11 0NL                              -                                           1,839,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           919,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           1,519,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,451,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,449,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           545,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           613,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           644,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           513,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           1,258,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW11 0NL                              -                                           642,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           495,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           600,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           649,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           645,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           621,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           552,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           621,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           1,197,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           656,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           660,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW11 0NL                              -                                           499,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW11 0NL                              -                                           1,552,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,457,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW11 0NL                              -                                           1,644,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,543,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,596,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,075,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           1,456,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,255,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,325,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           1,319,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 0NL                              -                                           1,541,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 0NL                              -                                           1,536,000                
                  -                                           Freehold End terrace house