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 4QB' order by fulladdress
NW1 4QB - 2,107,000
- Leasehold Purpose built flat
NW1 4QB - 1,473,000
- Leasehold Flat/Maisonette
NW1 4QB - 2,160,000
- Leasehold Purpose built flat
NW1 4QB - 1,216,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,633,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,164,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,197,000
- Leasehold Flat/Maisonette
NW1 4QB - 801,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,443,000
- Feudal Purpose built flat
NW1 4QB - 814,000
- Feudal Purpose built flat
NW1 4QB - 944,000
- Leasehold Purpose built flat
NW1 4QB - 767,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,311,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,307,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,454,000
- Leasehold Purpose built flat
NW1 4QB - 1,238,000
- Leasehold Flat/Maisonette
NW1 4QB - 2,401,000
- Leasehold Purpose built flat
NW1 4QB - 1,433,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,234,000
- Leasehold Purpose built flat
NW1 4QB - 1,063,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,176,000
- Leasehold Flat/Maisonette
NW1 4QB - 894,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,268,000
- Leasehold Purpose built flat
NW1 4QB - 1,068,000
- Leasehold Purpose built flat
NW1 4QB - 846,000
- Leasehold Flat/Maisonette
NW1 4QB - 877,000
- Leasehold Flat/Maisonette
NW1 4QB - 913,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,330,000
- Leasehold Flat/Maisonette
NW1 4QB - 2,078,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,365,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,469,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,474,000
- Leasehold Flat/Maisonette
NW1 4QB - 1,879,000
- Leasehold Flat/Maisonette