SELECT Distinct  [UPRN],[postcode]      ,[fulladdress]      ,[propertyIndicators]      ,[EstimatedSalesLow]      ,[EstimatedSalesHigh]      ,[EstimatedRentalsLow]      ,[EstimatedRentalsHigh]      ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice]  FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW14 8QF' order by fulladdress
      
                                        SW14 8QF                              -                                           1,483,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,461,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           632,000                
                  -                                           Leasehold Converted flat                 
              
                          
                                        SW14 8QF                              -                                           751,000                
                  -                                           Leasehold Flat/Maisonette                 
              
                          
                                        SW14 8QF                              -                                           1,572,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,525,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,506,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,551,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,513,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,574,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,531,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,488,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        SW14 8QF                              -                                           1,511,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,423,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,494,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,534,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,493,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,489,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,416,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,395,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,527,000                
                  -                                           Freehold Terrace property                 
              
                          
                                        SW14 8QF                              -                                           1,487,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,406,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,521,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,546,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,492,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,553,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,328,000                
                  -                                           Leasehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,476,000                
                  -                                           Leasehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,523,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,541,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,533,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,502,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,494,000                
                  -                                           Freehold Mid terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,474,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           822,000                
                  -                                           Freehold End terrace house                 
              
                          
                                        SW14 8QF                              -                                           1,629,000                
                  -                                           Freehold Mid terrace house