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 3JD' order by fulladdress
      
                                        IG10 3JD                              -                                           2,468,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,906,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,625,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,078,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,788,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,835,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,187,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,956,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,813,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,200,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,960,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,315,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,294,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,662,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,328,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           1,696,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,412,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,137,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           4,106,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           3,522,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,373,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,464,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           2,087,000                
                  -                                           Freehold Detached house                 
              
                          
                                        IG10 3JD                              -                                           1,784,000                
                  -                                           Freehold Detached property                 
              
                          
                                        IG10 3JD                              -                                           2,838,000                
                  -                                           Freehold Detached property                 
              
                          
                                        IG10 3JD                              -                                           2,414,000                
                  -                                           Freehold Detached property