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 7GN' order by fulladdress
W12 7GN - 797,000
- Leasehold Flat/Maisonette
W12 7GN - 733,000
- Leasehold Flat/Maisonette
W12 7GN - 706,000
- Feudal Flat/Maisonette
W12 7GN - 1,155,000
- Leasehold Flat/Maisonette
W12 7GN - 1,036,000
- Leasehold Flat/Maisonette
W12 7GN - 1,157,000
- Leasehold Flat/Maisonette
W12 7GN - 722,000
- Leasehold Purpose built flat
W12 7GN - 730,000
- Leasehold Flat/Maisonette
W12 7GN - 1,189,000
- Leasehold Flat/Maisonette
W12 7GN - 1,022,000
- Leasehold Flat/Maisonette
W12 7GN - 1,425,000
- Leasehold Flat/Maisonette
W12 7GN - 1,052,000
- Leasehold Purpose built flat
W12 7GN - 1,326,000
- Leasehold Flat/Maisonette
W12 7GN - 1,037,000
- Leasehold Flat/Maisonette
W12 7GN - 1,111,000
- Leasehold Flat/Maisonette
W12 7GN - 685,000
- Leasehold Flat/Maisonette
W12 7GN - 743,000
- Leasehold Flat/Maisonette
W12 7GN - 1,177,000
- Leasehold Flat/Maisonette
W12 7GN - 1,030,000
- Leasehold Flat/Maisonette
W12 7GN - 1,061,000
- Leasehold Flat/Maisonette
W12 7GN - 1,186,000
- Leasehold Flat/Maisonette
W12 7GN - 757,000
- Leasehold Flat/Maisonette
W12 7GN - 735,000
- Leasehold Flat/Maisonette
W12 7GN - 1,081,000
- Leasehold Flat/Maisonette
W12 7GN - 1,052,000
- Leasehold Flat/Maisonette
W12 7GN - 1,428,000
- Leasehold Purpose built flat
W12 7GN - 1,083,000
- Leasehold Flat/Maisonette
W12 7GN - 1,036,000
- Leasehold Purpose built flat
W12 7GN - 1,493,000
- Leasehold Flat/Maisonette
W12 7GN - 1,064,000
- Leasehold Flat/Maisonette
W12 7GN - 738,000
- Leasehold Flat/Maisonette
W12 7GN - 736,000
- Leasehold Flat/Maisonette
W12 7GN - 814,000
- Leasehold Flat/Maisonette
W12 7GN - 1,213,000
- Leasehold Flat/Maisonette
W12 7GN - 1,049,000
- Leasehold Flat/Maisonette
W12 7GN - 1,050,000
- Leasehold Flat/Maisonette
W12 7GN - 1,225,000
- Leasehold Flat/Maisonette
W12 7GN - 699,000
- Leasehold Flat/Maisonette
W12 7GN - 790,000
- Leasehold Flat/Maisonette
W12 7GN - 664,000
- Leasehold Flat/Maisonette
W12 7GN - 1,096,000
- Leasehold Flat/Maisonette
W12 7GN - 1,473,000
- Leasehold Flat/Maisonette
W12 7GN - 1,133,000
- Leasehold Flat/Maisonette
W12 7GN - 1,061,000
- Leasehold Flat/Maisonette
W12 7GN - 1,398,000
- Leasehold Purpose built flat
W12 7GN - 973,000
- Leasehold Flat/Maisonette
W12 7GN - 1,249,000
- Leasehold Flat/Maisonette
W12 7GN - 1,933,000
- Leasehold Flat/Maisonette
W12 7GN - 1,980,000
- Leasehold Flat/Maisonette
W12 7GN - 1,302,000
- Leasehold Flat/Maisonette
W12 7GN - 3,772,000
- Leasehold Flat/Maisonette