SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W12 9RP' order by fulladdress
W12 9RP - 2,700,000
- Freehold Semi-detached house
W12 9RP - 2,526,000
- Freehold Semi-detached house
W12 9RP - 2,622,000
- Freehold Semi-detached house
W12 9RP - 2,622,000
- Freehold Semi-detached house
W12 9RP - 3,102,000
- Freehold Detached house
W12 9RP - 2,503,000
- Freehold Detached house
W12 9RP - 2,287,000
- Freehold Semi-detached house
W12 9RP - 2,248,000
- Freehold Semi-detached house
W12 9RP - 2,678,000
- Freehold Detached house
W12 9RP - 1,944,000
- Freehold End terrace house
W12 9RP - 2,395,000
- Freehold Semi-detached house
W12 9RP - 2,716,000
- Freehold Semi-detached house
W12 9RP - 2,318,000
- Semi-detached house
W12 9RP - 1,606,000
- Freehold Semi-detached house
W12 9RP - 2,738,000
- Freehold Semi-detached house
W12 9RP - 1,867,000
- Freehold Semi-detached house
W12 9RP - 1,554,000
- Freehold Semi-detached house
W12 9RP - 1,396,000
- Freehold End terrace house
W12 9RP - 1,108,000
- Freehold Detached bungalow
W12 9RP - 1,030,000
- Freehold Detached house
W12 9RP - 1,376,000
- Freehold Terraced
W12 9RP - 2,493,000
- Freehold Semi-detached house
W12 9RP - 1,535,000
- Freehold End terrace house
W12 9RP - 693,000
- Freehold End terrace house
W12 9RP - 1,464,000
- Freehold Semi-detached house
W12 9RP - 2,841,000
- Freehold Semi-detached property
