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 7HP' order by fulladdress
NW1 7HP - 662,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,643,000
- Freehold Mid terrace house
NW1 7HP - 1,554,000
- Freehold Mid terrace house
NW1 7HP - 1,799,000
- Freehold Mid terrace house
NW1 7HP - 1,814,000
- Freehold Semi-detached property
NW1 7HP - 1,532,000
- Freehold Terrace property
NW1 7HP - 1,602,000
- Freehold Terrace property
NW1 7HP - 542,000
- Leasehold Purpose built flat
NW1 7HP - 759,000
- Leasehold Purpose built flat
NW1 7HP - 946,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,764,000
- Freehold Mid terrace house
NW1 7HP - 1,385,000
- Freehold Mid terrace house
NW1 7HP - 697,000
- Leasehold Flat/Maisonette
NW1 7HP - 662,000
- Leasehold Purpose built flat
NW1 7HP - 598,000
- Leasehold Flat/Maisonette
NW1 7HP - 685,000
- Leasehold Flat/Maisonette
NW1 7HP - 957,000
- Leasehold Flat/Maisonette
NW1 7HP - 733,000
- Leasehold Flat/Maisonette
NW1 7HP - 633,000
- Leasehold Flat/Maisonette
NW1 7HP - 852,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,036,000
- Leasehold Converted flat
NW1 7HP - 639,000
- Leasehold Purpose built flat
NW1 7HP - 1,191,000
- Leasehold Purpose built flat
NW1 7HP - 763,000
- Leasehold Purpose built flat
NW1 7HP - 1,206,000
- Leasehold Flat/Maisonette
NW1 7HP - 721,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,175,000
- Leasehold Converted flat
NW1 7HP - 1,292,000
- Leasehold Converted flat
NW1 7HP - 1,169,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,292,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,316,000
- Leasehold Flat/Maisonette
NW1 7HP - 702,000
- Leasehold Purpose built flat
NW1 7HP - 917,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,122,000
- Leasehold Flat/Maisonette
NW1 7HP - 655,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,086,000
- Leasehold Converted flat
NW1 7HP - 772,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,176,000
- Leasehold Flat/Maisonette
NW1 7HP - 641,000
- Leasehold Purpose built flat
NW1 7HP - 699,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,273,000
- Leasehold Flat/Maisonette
NW1 7HP - 679,000
- Leasehold Converted flat
NW1 7HP - 1,152,000
- Leasehold Flat/Maisonette
NW1 7HP - 631,000
- Leasehold Purpose built flat
NW1 7HP - 1,184,000
- Leasehold Flat/Maisonette
NW1 7HP - 1,159,000
- Leasehold Purpose built flat
NW1 7HP - 707,000
- Leasehold Flat/Maisonette
