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 9PD' order by fulladdress
      
                                        TW11 9PD                              -                                           1,865,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW11 9PD                              -                                           1,377,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 9PD                              -                                           1,275,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW11 9PD                              -                                           1,714,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW11 9PD                              -                                           1,853,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 9PD                              -                                           1,449,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,316,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,191,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW11 9PD                              -                                           1,584,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,593,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW11 9PD                              -                                           1,496,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,524,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,581,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,604,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,253,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW11 9PD                              -                                           1,413,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,322,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,379,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,544,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,210,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,237,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW11 9PD                              -                                           1,455,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,525,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,564,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,584,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,348,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW11 9PD                              -                                           1,369,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,997,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW11 9PD                              -                                           1,532,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,500,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,376,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,400,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,118,000                
                  -                                           Freehold Detached bungalow                 
              
                          
                                        TW11 9PD                              -                                           1,330,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,415,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,393,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,448,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,475,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,508,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,370,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW11 9PD                              -                                           1,341,000                
                  -                                           Freehold Semi-detached house