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 5NP' order by fulladdress
NW1 5NP - 1,655,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,539,000
- Leasehold Flat/Maisonette
NW1 5NP - 2,146,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,357,000
- Leasehold Purpose built flat
NW1 5NP - 1,348,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,474,000
- Leasehold Purpose built flat
NW1 5NP - 1,594,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,354,000
- Leasehold Purpose built flat
NW1 5NP - 1,290,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,768,000
- Feudal Purpose built flat
NW1 5NP - 1,058,000
- Leasehold Purpose built flat
NW1 5NP - 1,554,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,290,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,018,000
- Freehold Purpose built flat
NW1 5NP - 1,978,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,286,000
- Leasehold Converted flat
NW1 5NP - 1,236,000
- Leasehold Purpose built flat
NW1 5NP - 904,000
- Leasehold Flat/Maisonette
NW1 5NP - 608,000
- Leasehold Converted flat
NW1 5NP - 1,137,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,455,000
- Leasehold Purpose built flat
NW1 5NP - 1,584,000
- Leasehold Flat/Maisonette
NW1 5NP - 999,000
- Leasehold Purpose built flat
NW1 5NP - 576,000
- Leasehold Flat/Maisonette
NW1 5NP - 630,000
- Leasehold Purpose built flat
NW1 5NP - 1,278,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,442,000
- Leasehold Flat/Maisonette
NW1 5NP - 601,000
- Leasehold Flat/Maisonette
NW1 5NP - 557,000
- Leasehold Purpose built flat
NW1 5NP - 1,349,000
- Leasehold Purpose built flat
NW1 5NP - 1,388,000
- Leasehold Purpose built flat
NW1 5NP - 1,288,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,360,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,364,000
- Leasehold Flat/Maisonette
NW1 5NP - 619,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,607,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,429,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,419,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,088,000
- Leasehold Purpose built flat
NW1 5NP - 1,395,000
- Leasehold Purpose built flat
NW1 5NP - 1,447,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,395,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,149,000
- Leasehold Purpose built flat
NW1 5NP - 941,000
- Leasehold Purpose built flat
NW1 5NP - 1,315,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,331,000
- Leasehold Purpose built flat
NW1 5NP - 1,322,000
- Leasehold Flat/Maisonette
NW1 5NP - 787,000
- Leasehold Flat/Maisonette
NW1 5NP - 832,000
- Leasehold Purpose built flat
NW1 5NP - 1,517,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,448,000
- Leasehold Flat/Maisonette
NW1 5NP - 1,187,000
- Leasehold Purpose built flat
NW1 5NP - 1,270,000
- Leasehold Flat/Maisonette
