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 4ND' order by fulladdress
NW1 4ND - 6,690,000
- Leasehold Terrace property
NW1 4ND - 7,805,000
- Mid terrace house
NW1 4ND - 4,068,000
- Leasehold Terrace property
NW1 4ND - 8,161,000
- Leasehold Mid terrace house
NW1 4ND - 9,261,000
- Leasehold Mid terrace house
NW1 4ND - 7,028,000
- Mid terrace property
NW1 4ND - 9,578,000
- Leasehold Terraced
NW1 4ND - 8,042,000
- Leasehold Terrace property
NW1 4ND - 6,418,000
- Leasehold Detached property
NW1 4ND - 8,828,000
- Freehold Terrace property
NW1 4ND - 9,736,000
- Leasehold Mid terrace house
NW1 4ND - 8,711,000
- Leasehold Terrace property
NW1 4ND - 4,423,000
- Leasehold Detached property
NW1 4ND - 7,526,000
- Leasehold Terrace property
NW1 4ND - 2,784,000
- Freehold Terrace property
NW1 4ND - 5,894,000
- Leasehold Mid terrace house
NW1 4ND - 6,346,000
- Leasehold Mid terrace house
NW1 4ND - 5,494,000
- Leasehold Terrace property
NW1 4ND - 5,959,000
- Leasehold Terrace property
NW1 4ND - 6,385,000
- Leasehold End terrace house
NW1 4ND - 7,336,000
- Leasehold End terrace house
NW1 4ND - 10,037,000
- Leasehold Semi-detached house
NW1 4ND - 6,334,000
- Leasehold Terraced
NW1 4ND - 746,000
- Leasehold Flat/Maisonette
NW1 4ND - 6,988,000
- Leasehold Mid terrace house
NW1 4ND - 5,707,000
- Leasehold Flat/Maisonette
