SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NW1 6EW' order by fulladdress
NW1 6EW - 1,137,000
- Leasehold Flat/Maisonette
NW1 6EW - 908,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,233,000
- Leasehold Flat/Maisonette
NW1 6EW - 766,000
- Leasehold Flat/Maisonette
NW1 6EW - 739,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,299,000
- Leasehold Purpose built flat
NW1 6EW - 757,000
- Leasehold Purpose built flat
NW1 6EW - 1,010,000
- Leasehold Flat/Maisonette
NW1 6EW - 759,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,337,000
- Leasehold Purpose built flat
NW1 6EW - 1,428,000
- Leasehold Purpose built flat
NW1 6EW - 1,321,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,090,000
- Leasehold Flat/Maisonette
NW1 6EW - 772,000
- Leasehold Purpose built flat
NW1 6EW - 1,238,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,527,000
- Feudal Purpose built flat
NW1 6EW - 810,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,684,000
- Leasehold Flat/Maisonette
NW1 6EW - 765,000
- Leasehold Flat/Maisonette
NW1 6EW - 954,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,292,000
- Leasehold Purpose built flat
NW1 6EW - 723,000
- Leasehold Purpose built flat
NW1 6EW - 1,275,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,278,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,298,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,264,000
- Feudal Purpose built flat
NW1 6EW - 1,467,000
- Leasehold Purpose built flat
NW1 6EW - 1,266,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,341,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,301,000
- Leasehold Purpose built flat
NW1 6EW - 1,292,000
- Leasehold Purpose built flat
NW1 6EW - 1,287,000
- Leasehold Purpose built flat
NW1 6EW - 2,097,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,930,000
- Leasehold Flat/Maisonette
NW1 6EW - 2,256,000
- Leasehold Purpose built flat
NW1 6EW - 762,000
- Leasehold Flat/Maisonette
NW1 6EW - 872,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,220,000
- Leasehold Purpose built flat
NW1 6EW - 1,205,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,097,000
- Leasehold Purpose built flat
NW1 6EW - 1,187,000
- Leasehold Flat/Maisonette
NW1 6EW - 696,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,233,000
- Leasehold Purpose built flat
NW1 6EW - 1,227,000
- Leasehold Purpose built flat
NW1 6EW - 1,128,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,133,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,390,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,186,000
- Leasehold Purpose built flat
NW1 6EW - 1,803,000
- Leasehold Flat/Maisonette
NW1 6EW - 797,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,189,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,413,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,339,000
- Leasehold Purpose built flat
NW1 6EW - 1,097,000
- Freehold Purpose built flat
NW1 6EW - 1,476,000
- Leasehold Purpose built flat
NW1 6EW - 1,039,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,329,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,089,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,226,000
- Leasehold Flat/Maisonette
NW1 6EW - 864,000
- Leasehold Flat/Maisonette
NW1 6EW - 863,000
- Leasehold Flat/Maisonette
NW1 6EW - 1,313,000
- Leasehold Flat/Maisonette
