SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W9 1AJ' order by fulladdress
W9 1AJ - 1,014,000
- Leasehold Purpose built flat
W9 1AJ - 978,000
- Leasehold Purpose built flat
W9 1AJ - 775,000
- Leasehold Purpose built flat
W9 1AJ - 1,088,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,181,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,314,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,220,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,431,000
- Leasehold Purpose built flat
W9 1AJ - 1,082,000
- Leasehold Flat/Maisonette
W9 1AJ - 966,000
- Leasehold Flat/Maisonette
W9 1AJ - 951,000
- Leasehold Purpose built flat
W9 1AJ - 1,747,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,859,000
- Leasehold Flat/Maisonette
W9 1AJ - 926,000
- Leasehold Purpose built flat
W9 1AJ - 1,195,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,083,000
- Leasehold Flat/Maisonette
W9 1AJ - 786,000
- Leasehold Purpose built flat
W9 1AJ - 980,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,197,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,044,000
- Leasehold Purpose built flat
W9 1AJ - 624,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,074,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,030,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,169,000
- Leasehold Flat/Maisonette
W9 1AJ - 803,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,020,000
- Leasehold Purpose built flat
W9 1AJ - 704,000
- Leasehold Purpose built flat
W9 1AJ - 670,000
- Leasehold Flat/Maisonette
W9 1AJ - 926,000
- Leasehold Flat/Maisonette
W9 1AJ - 803,000
- Leasehold Flat/Maisonette
W9 1AJ - 914,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,050,000
- Leasehold Flat/Maisonette
W9 1AJ - 709,000
- Leasehold Purpose built flat
W9 1AJ - 794,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,120,000
- Leasehold Purpose built flat
W9 1AJ - 1,183,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,332,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,360,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,002,000
- Leasehold Converted flat
W9 1AJ - 861,000
- Leasehold Purpose built flat
W9 1AJ - 1,292,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,078,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,239,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,016,000
- Leasehold Flat/Maisonette
W9 1AJ - 778,000
- Leasehold Purpose built flat
W9 1AJ - 1,146,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,157,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,403,000
- Leasehold Flat/Maisonette
W9 1AJ - 644,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,248,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,094,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,016,000
- Leasehold Purpose built flat
W9 1AJ - 1,398,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,098,000
- Leasehold Purpose built flat
W9 1AJ - 928,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,329,000
- Leasehold Flat/Maisonette
W9 1AJ - 454,000
- Leasehold Purpose built flat
W9 1AJ - 1,070,000
- Leasehold Purpose built flat
W9 1AJ - 1,202,000
- Leasehold Flat/Maisonette
W9 1AJ - 986,000
- Leasehold Flat/Maisonette
W9 1AJ - 662,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,086,000
- Leasehold Purpose built flat
W9 1AJ - 1,254,000
- Leasehold Flat/Maisonette
W9 1AJ - 796,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,154,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,157,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,068,000
- Leasehold Purpose built flat
W9 1AJ - 1,117,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,296,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,044,000
- Leasehold Purpose built flat
W9 1AJ - 986,000
- Leasehold Purpose built flat
W9 1AJ - 1,384,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,003,000
- Leasehold Purpose built flat
W9 1AJ - 1,062,000
- Leasehold Flat/Maisonette
W9 1AJ - 929,000
- Leasehold Purpose built flat
W9 1AJ - 729,000
- Leasehold Purpose built flat
W9 1AJ - 1,067,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,217,000
- Leasehold Flat/Maisonette
W9 1AJ - 782,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,198,000
- Feudal Flat/Maisonette
W9 1AJ - 1,226,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,388,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,013,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,010,000
- Leasehold Flat/Maisonette
W9 1AJ - 638,000
- Leasehold Purpose built flat
W9 1AJ - 1,422,000
- Leasehold Purpose built flat
W9 1AJ - 1,164,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,099,000
- Leasehold Flat/Maisonette
W9 1AJ - 808,000
- Leasehold Purpose built flat
W9 1AJ - 831,000
- Freehold Purpose built flat
W9 1AJ - 2,042,000
- Leasehold Flat/Maisonette
W9 1AJ - 1,534,000
- Leasehold Flat/Maisonette
W9 1AJ - 706,000
- Leasehold Purpose built flat
W9 1AJ - 950,000
- Leasehold Purpose built flat