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 1RF' order by fulladdress
NW6 1RF - 1,696,000
- Freehold End terrace house
NW6 1RF - 1,614,000
- Freehold Mid terrace house
NW6 1RF - 1,690,000
- Freehold Mid terrace house
NW6 1RF - 1,559,000
- End terrace house
NW6 1RF - 1,408,000
- Freehold Terraced
NW6 1RF - 1,518,000
- Freehold Mid terrace house
NW6 1RF - 1,634,000
- Freehold Mid terrace house
NW6 1RF - 1,660,000
- Freehold Mid terrace house
NW6 1RF - 1,614,000
- Freehold Terraced
NW6 1RF - 1,536,000
- Freehold Mid terrace house
NW6 1RF - 2,024,000
- Freehold Terrace property
NW6 1RF - 1,536,000
- Freehold Mid terrace house
NW6 1RF - 1,599,000
- Freehold Mid terrace house
NW6 1RF - 1,618,000
- Freehold Terrace property
NW6 1RF - 1,681,000
- Freehold Mid terrace house
NW6 1RF - 1,599,000
- Freehold Mid terrace house
NW6 1RF - 1,953,000
- Freehold Terraced
NW6 1RF - 1,791,000
- Freehold Mid terrace house
NW6 1RF - 1,726,000
- Freehold Mid terrace house
NW6 1RF - 1,670,000
- Freehold Terraced
NW6 1RF - 1,577,000
- Freehold Mid terrace house
NW6 1RF - 1,629,000
- Freehold Terrace property
NW6 1RF - 1,711,000
- Freehold End terrace house
NW6 1RF - 1,711,000
- Freehold End terrace house
NW6 1RF - 1,518,000
- Freehold Flat/Maisonette
NW6 1RF - 1,782,000
- Freehold Mid terrace house
NW6 1RF - 1,646,000
- Freehold Mid terrace house
NW6 1RF - 1,734,000
- Freehold Mid terrace house
NW6 1RF - 1,667,000
- Freehold Mid terrace house
NW6 1RF - 1,746,000
- Freehold Mid terrace house
NW6 1RF - 1,716,000
- Freehold Mid terrace house
NW6 1RF - 1,609,000
- Freehold End terrace house
NW6 1RF - 1,346,000
- Freehold Converted flat
NW6 1RF - 1,645,000
- Freehold Terrace property
NW6 1RF - 1,650,000
- Freehold Mid terrace house
NW6 1RF - 1,680,000
- Freehold Mid terrace house
NW6 1RF - 1,626,000
- Freehold End terrace house
NW6 1RF - 1,925,000
- Freehold Mid terrace house
NW6 1RF - 1,682,000
- Freehold Mid terrace house
NW6 1RF - 1,675,000
- Freehold Mid terrace house
NW6 1RF - 1,677,000
- Freehold Mid terrace house
NW6 1RF - 1,529,000
- Freehold Detached house
NW6 1RF - 1,680,000
- Freehold Mid terrace house
NW6 1RF - 1,737,000
- Freehold Mid terrace house