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 7BJ' order by fulladdress
NW1 7BJ - 774,000
- Leasehold Flat/Maisonette
NW1 7BJ - 849,000
- Leasehold Purpose built flat
NW1 7BJ - 575,000
- Leasehold Flat/Maisonette
NW1 7BJ - 617,000
- Leasehold Purpose built flat
NW1 7BJ - 626,000
- Leasehold Purpose built flat
NW1 7BJ - 853,000
- Leasehold Flat/Maisonette
NW1 7BJ - 715,000
- Leasehold Purpose built flat
NW1 7BJ - 632,000
- Leasehold Flat/Maisonette
NW1 7BJ - 890,000
- Leasehold Flat/Maisonette
NW1 7BJ - 552,000
- Leasehold Purpose built flat
NW1 7BJ - 642,000
- Leasehold Flat/Maisonette
NW1 7BJ - 626,000
- Leasehold Flat/Maisonette
NW1 7BJ - 961,000
- Leasehold Flat/Maisonette
NW1 7BJ - 834,000
- Leasehold Purpose built flat
NW1 7BJ - 934,000
- Leasehold Flat/Maisonette
NW1 7BJ - 1,085,000
- Leasehold Flat/Maisonette
NW1 7BJ - 646,000
- Leasehold Flat/Maisonette
NW1 7BJ - 616,000
- Leasehold Flat/Maisonette
NW1 7BJ - 952,000
- Leasehold Flat/Maisonette
NW1 7BJ - 667,000
- Leasehold Purpose built flat
NW1 7BJ - 830,000
- Leasehold Flat/Maisonette
NW1 7BJ - 892,000
- Leasehold Flat/Maisonette
NW1 7BJ - 935,000
- Leasehold Flat/Maisonette
NW1 7BJ - 929,000
- Leasehold Purpose built flat
NW1 7BJ - 1,094,000
- Feudal Purpose built flat
NW1 7BJ - 810,000
- Leasehold Flat/Maisonette
NW1 7BJ - 603,000
- Leasehold Flat/Maisonette
NW1 7BJ - 620,000
- Leasehold Flat/Maisonette
NW1 7BJ - 863,000
- Leasehold Flat/Maisonette
NW1 7BJ - 646,000
- Leasehold Flat/Maisonette
NW1 7BJ - 598,000
- Leasehold Flat/Maisonette
NW1 7BJ - 829,000
- Leasehold Flat/Maisonette
NW1 7BJ - 843,000
- Leasehold Purpose built flat
NW1 7BJ - 810,000
- Leasehold Purpose built flat
NW1 7BJ - 982,000
- Leasehold Flat/Maisonette
NW1 7BJ - 847,000
- Leasehold Purpose built flat
NW1 7BJ - 615,000
- Leasehold Flat/Maisonette
NW1 7BJ - 976,000
- Leasehold Purpose built flat
NW1 7BJ - 1,036,000
- Leasehold Purpose built flat
NW1 7BJ - 949,000
- Leasehold Flat/Maisonette
NW1 7BJ - 626,000
- Leasehold Flat/Maisonette
NW1 7BJ - 610,000
- Leasehold Flat/Maisonette
NW1 7BJ - 638,000
- Leasehold Purpose built flat
NW1 7BJ - 959,000
- Leasehold Purpose built flat
NW1 7BJ - 877,000
- Leasehold Flat/Maisonette
NW1 7BJ - 1,024,000
- Leasehold Purpose built flat
NW1 7BJ - 920,000
- Leasehold Purpose built flat
NW1 7BJ - 1,227,000
- Leasehold Flat/Maisonette