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 7EF' order by fulladdress
W8 7EF - 4,947,000
- Freehold Flat/Maisonette
W8 7EF - 4,236,000
- Freehold Mid terrace house
W8 7EF - 5,171,000
- Mid terrace house
W8 7EF - 5,578,000
- Freehold Mid terrace house
W8 7EF - 6,715,000
- Freehold Mid terrace house
W8 7EF - 6,474,000
- Freehold Mid terrace house
W8 7EF - 6,492,000
- Freehold Detached house
W8 7EF - 5,419,000
- Mid terrace house
W8 7EF - 5,368,000
- Freehold Mid terrace house
W8 7EF - 5,273,000
- Freehold Terraced
W8 7EF - 5,382,000
- Freehold Terraced
W8 7EF - 1,076,000
- Freehold Flat/Maisonette
W8 7EF - 7,109,000
- Freehold Terraced
W8 7EF - 6,448,000
- Freehold Mid terrace house
W8 7EF - 6,243,000
- Freehold Semi-detached house
W8 7EF - 7,917,000
- Freehold Mid terrace house
W8 7EF - 5,452,000
- Mid terrace house
W8 7EF - 6,243,000
- Freehold Mid terrace house
W8 7EF - 5,510,000
- Freehold Terrace property
W8 7EF - 434,000
- Freehold Flat/Maisonette
W8 7EF - 3,521,000
- Leasehold Mid terrace house
