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 4QA' order by fulladdress
NW1 4QA - 5,004,000
- Leasehold Flat/Maisonette
NW1 4QA - 4,995,000
- Leasehold Converted flat
NW1 4QA - 3,958,000
- Leasehold Flat/Maisonette
NW1 4QA - 4,566,000
- Leasehold Flat/Maisonette
NW1 4QA - 2,819,000
- Leasehold Flat/Maisonette
NW1 4QA - 4,429,000
- Leasehold Terrace property
NW1 4QA - 4,064,000
- Leasehold Flat/Maisonette
NW1 4QA - 3,692,000
- Leasehold Flat/Maisonette
NW1 4QA - 3,209,000
- Leasehold Flat/Maisonette
NW1 4QA - 4,903,000
- Leasehold Flat/Maisonette
NW1 4QA - 3,651,000
- Leasehold Converted flat
NW1 4QA - 4,446,000
- Leasehold Flat/Maisonette
NW1 4QA - 3,311,000
- Leasehold Flat/Maisonette
NW1 4QA - 2,524,000
- Leasehold Flat/Maisonette
NW1 4QA - 3,578,000
- Leasehold Flat/Maisonette
NW1 4QA - 2,538,000
- Leasehold Flat/Maisonette
NW1 4QA - 5,910,000
- Leasehold Flat/Maisonette
NW1 4QA - 5,888,000
- Leasehold Flat/Maisonette
NW1 4QA - 5,266,000
- Leasehold Terraced
NW1 4QA - 3,750,000
- Leasehold Terraced
NW1 4QA - 3,547,000
- Leasehold Semi-detached house
NW1 4QA - 3,711,000
- Leasehold Semi-detached house
NW1 4QA - 3,535,000
- Semi-detached house
NW1 4QA - 5,464,000
- Leasehold Flat/Maisonette