SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW6 2QF' order by fulladdress
SW6 2QF - 1,406,000
- Leasehold Flat/Maisonette
SW6 2QF - 647,000
- Leasehold Purpose built flat
SW6 2QF - 727,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,230,000
- Leasehold Flat/Maisonette
SW6 2QF - 566,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,225,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,456,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,750,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,233,000
- Leasehold Flat/Maisonette
SW6 2QF - 658,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,261,000
- Leasehold Flat/Maisonette
SW6 2QF - 676,000
- Feudal Purpose built flat
SW6 2QF - 726,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,231,000
- Leasehold Flat/Maisonette
SW6 2QF - 2,086,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,539,000
- Leasehold Flat/Maisonette
SW6 2QF - 636,000
- Leasehold Purpose built flat
SW6 2QF - 528,000
- Leasehold Flat/Maisonette
SW6 2QF - 609,000
- Leasehold Flat/Maisonette
SW6 2QF - 743,000
- Leasehold Flat/Maisonette
SW6 2QF - 805,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,256,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,642,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,420,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,322,000
- Leasehold Flat/Maisonette
SW6 2QF - 2,566,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,370,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,306,000
- Leasehold Flat/Maisonette
SW6 2QF - 575,000
- Leasehold Flat/Maisonette
SW6 2QF - 1,199,000
- Leasehold Flat/Maisonette