SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PO6 4SS' order by fulladdress
      
                                        PO6 4SS                              -                                           565,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           314,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           575,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           394,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           377,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           679,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           363,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           642,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           436,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           739,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           464,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           432,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           630,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           531,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           471,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           637,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           355,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           369,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           601,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           533,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           347,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           573,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           367,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           662,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           375,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           690,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           643,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           573,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           659,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        PO6 4SS                              -                                           426,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           477,000                
                  -                                           Freehold Purpose built flat                 
              
                          
                                        PO6 4SS                              -                                           558,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           400,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           390,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           695,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           437,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           746,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           461,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           749,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           593,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           556,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           680,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           514,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           702,000                
                  -                                           Freehold Detached house                 
              
                          
                                        PO6 4SS                              -                                           457,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           641,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           424,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           519,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           455,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           640,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           683,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           392,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           587,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           406,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           389,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        PO6 4SS                              -                                           394,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        PO6 4SS                              -                                           592,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        PO6 4SS                              -                                           451,000                
                  -                                           Freehold Terrace property