SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W8 4JG' order by fulladdress
W8 4JG - 4,668,000
- Freehold End terrace house
W8 4JG - 5,260,000
- Mid terrace property
W8 4JG - 5,580,000
- Freehold Mid terrace house
W8 4JG - 5,732,000
- Freehold Terraced
W8 4JG - 5,721,000
- Freehold Terrace property
W8 4JG - 5,703,000
- Freehold Terrace property
W8 4JG - 4,151,000
- Freehold Flat/Maisonette
W8 4JG - 4,876,000
- Freehold Mid terrace house
W8 4JG - 5,263,000
- Freehold Mid terrace house
W8 4JG - 4,946,000
- Freehold Mid terrace house
W8 4JG - 5,945,000
- Freehold Mid terrace house
W8 4JG - 5,550,000
- Freehold Detached house
W8 4JG - 5,316,000
- Freehold Detached house
W8 4JG - 6,029,000
- Freehold Terrace property
W8 4JG - 956,000
- Leasehold Converted flat
W8 4JG - 859,000
- Leasehold Converted flat
W8 4JG - 2,907,000
- Freehold Flat/Maisonette
W8 4JG - 1,255,000
- Freehold Flat/Maisonette
W8 4JG - 1,152,000
- Leasehold Converted flat
W8 4JG - 5,066,000
- Freehold Terrace property
