SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CB5 8NZ' order by fulladdress
      
                                        CB5 8NZ                              -                                           606,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           392,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           901,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           655,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           596,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           581,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           586,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           618,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           617,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           371,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           402,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           397,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           524,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           393,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           925,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           592,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           585,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           583,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           660,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           600,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           602,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           403,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           405,000                
                  -                                           Feudal Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           892,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           586,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           879,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           1,310,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           654,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           584,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           588,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           394,000                
                  -                                           Leasehold Purpose built flat                 
              
                          
                                        CB5 8NZ                              -                                           589,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           781,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           756,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           1,051,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           584,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           410,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           329,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           384,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        CB5 8NZ                              -                                           559,000                
                  -                                           Leasehold Flat/Maisonette