SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TW2 5DA' order by fulladdress
      
                                        TW2 5DA                              -                                           1,735,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW2 5DA                              -                                           1,325,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW2 5DA                              -                                           1,577,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW2 5DA                              -                                           2,152,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           2,225,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           2,339,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW2 5DA                              -                                           2,221,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           2,035,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           2,390,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           1,681,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        TW2 5DA                              -                                           2,522,000                
                  -                                           Freehold Detached property                 
              
                          
                                        TW2 5DA                              -                                           1,619,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        TW2 5DA                              -                                           845,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW2 5DA                              -                                           1,953,000                
                  -                                           Freehold Detached house                 
              
                          
                                        TW2 5DA                              -                                           832,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW2 5DA                              -                                           799,000                
                  -                                           Freehold Mid terrace property                 
              
                          
                                        TW2 5DA                              -                                           788,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW2 5DA                              -                                           453,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           821,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW2 5DA                              -                                           471,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           472,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           483,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           435,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           442,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           451,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           448,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           450,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           453,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           459,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           836,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        TW2 5DA                              -                                           454,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           432,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           822,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        TW2 5DA                              -                                           377,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           476,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           504,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           378,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        TW2 5DA                              -                                           483,000                
                  -                                           Leasehold Converted flat                 
              
                          
                                        TW2 5DA                              -                                           357,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           423,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        TW2 5DA                              -                                           494,000                
                  -                                           Leasehold Converted flat                 
              
                          
                                        TW2 5DA                              -                                           457,000                
                  -                                           Leasehold Converted flat