SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG10 4JG' order by fulladdress
      
                                        IG10 4JG                              -                                           1,302,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,382,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,012,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,282,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,117,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           950,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,052,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,127,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,033,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,537,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,187,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,064,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,021,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,182,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,108,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,065,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,270,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,321,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,252,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,238,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,232,000                
                  -                                           Freehold Semi-detached property                 
              
                          
                                        IG10 4JG                              -                                           1,263,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,063,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,148,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,305,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,389,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,332,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,303,000                
                  -                                           Freehold Semi-detached house                 
              
                          
                                        IG10 4JG                              -                                           1,166,000                
                  -                                           Freehold Semi-detached house