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 5LQ' order by fulladdress
NW1 5LQ - 1,288,000
- Leasehold Flat/Maisonette
NW1 5LQ - 848,000
- Leasehold Flat/Maisonette
NW1 5LQ - 845,000
- Leasehold Flat/Maisonette
NW1 5LQ - 1,440,000
- Leasehold Flat/Maisonette
NW1 5LQ - 941,000
- Leasehold Purpose built flat
NW1 5LQ - 941,000
- Leasehold Flat/Maisonette
NW1 5LQ - 1,341,000
- Leasehold Purpose built flat
NW1 5LQ - 880,000
- Leasehold Flat/Maisonette
NW1 5LQ - 916,000
- Leasehold Flat/Maisonette
NW1 5LQ - 915,000
- Leasehold Flat/Maisonette
NW1 5LQ - 905,000
- Leasehold Flat/Maisonette
NW1 5LQ - 1,170,000
- Leasehold Flat/Maisonette
NW1 5LQ - 929,000
- Leasehold Purpose built flat
NW1 5LQ - 0
- Leasehold Flat/Maisonette
NW1 5LQ - 732,000
- Leasehold Flat/Maisonette
NW1 5LQ - 831,000
- Leasehold Flat/Maisonette
NW1 5LQ - 639,000
- Leasehold Flat/Maisonette
NW1 5LQ - 858,000
- Leasehold Flat/Maisonette
NW1 5LQ - 721,000
- Leasehold Flat/Maisonette
NW1 5LQ - 882,000
- Leasehold Purpose built flat
NW1 5LQ - 797,000
- Leasehold Flat/Maisonette
NW1 5LQ - 778,000
- Leasehold Flat/Maisonette