SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN2 3PA' order by fulladdress
      
                                        BN2 3PA                              -                                           783,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        BN2 3PA                              -                                           673,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           671,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           685,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           709,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           675,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           769,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        BN2 3PA                              -                                           703,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           737,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           728,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           552,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           643,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           678,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           664,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           609,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           644,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           718,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           608,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           685,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           647,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           695,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           618,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           674,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           651,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           633,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        BN2 3PA                              -                                           686,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           630,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           681,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           267,000                
                  -                                           Leasehold Converted flat                 
              
                          
                                        BN2 3PA                              -                                           600,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        BN2 3PA                              -                                           714,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           606,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        BN2 3PA                              -                                           691,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        BN2 3PA                              -                                           687,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        BN2 3PA                              -                                           675,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        BN2 3PA                              -                                           710,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        BN2 3PA                              -                                           663,000                
                  -                                           Freehold Detached property                 
              
                          
                                        BN2 3PA                              -                                           566,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           669,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           335,000                
                  -                                           Freehold Converted flat                 
              
                          
                                        BN2 3PA                              -                                           599,000                
                  -                                           Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           567,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           616,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           610,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        BN2 3PA                              -                                           768,000                
                  -                                           Freehold Mid terrace house