SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NW6 4PU' order by fulladdress
NW6 4PU - 1,190,000
- Leasehold Flat/Maisonette
NW6 4PU - 685,000
- Leasehold Purpose built flat
NW6 4PU - 1,033,000
- Leasehold Flat/Maisonette
NW6 4PU - 691,000
- Leasehold Purpose built flat
NW6 4PU - 672,000
- Leasehold Purpose built flat
NW6 4PU - 555,000
- Leasehold Purpose built flat
NW6 4PU - 1,232,000
- Leasehold Purpose built flat
NW6 4PU - 880,000
- Leasehold Flat/Maisonette
NW6 4PU - 745,000
- Leasehold Flat/Maisonette
NW6 4PU - 719,000
- Leasehold Semi-detached house
NW6 4PU - 898,000
- Leasehold Purpose built flat
NW6 4PU - 906,000
- Leasehold Flat/Maisonette
NW6 4PU - 719,000
- Leasehold Purpose built flat
NW6 4PU - 666,000
- Leasehold Flat/Maisonette
NW6 4PU - 575,000
- Leasehold Flat/Maisonette
NW6 4PU - 805,000
- Leasehold Purpose built flat
NW6 4PU - 664,000
- Leasehold Flat/Maisonette
NW6 4PU - 661,000
- Leasehold Flat/Maisonette
NW6 4PU - 647,000
- Leasehold Flat/Maisonette
NW6 4PU - 615,000
- Leasehold Purpose built flat
NW6 4PU - 640,000
- Leasehold Purpose built flat
NW6 4PU - 603,000
- Leasehold Flat/Maisonette
NW6 4PU - 736,000
- Leasehold Flat/Maisonette
NW6 4PU - 724,000
- Leasehold Purpose built flat