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 9LA' order by fulladdress
W12 9LA - 480,000
- Leasehold Converted flat
W12 9LA - 1,016,000
- Freehold Mid terrace house
W12 9LA - 798,000
- Freehold Mid terrace house
W12 9LA - 1,177,000
- Freehold Mid terrace house
W12 9LA - 1,017,000
- Freehold Mid terrace house
W12 9LA - 1,110,000
- Freehold Mid terrace house
W12 9LA - 1,138,000
- Freehold Mid terrace house
W12 9LA - 1,065,000
- Mid terrace house
W12 9LA - 516,000
- Leasehold Converted flat
W12 9LA - 1,136,000
- Freehold Mid terrace house
W12 9LA - 1,000,000
- Mid terrace house
W12 9LA - 1,116,000
- Leasehold Mid terrace house
W12 9LA - 1,061,000
- Freehold Mid terrace house
W12 9LA - 626,000
- Leasehold Converted flat
W12 9LA - 462,000
- Share of freehold Flat/Maisonette
W12 9LA - 1,252,000
- Freehold Mid terrace house
W12 9LA - 1,232,000
- Freehold Mid terrace house
W12 9LA - 1,023,000
- Freehold Mid terrace house
W12 9LA - 1,375,000
- Freehold Mid terrace house
W12 9LA - 1,155,000
- Freehold Mid terrace house
W12 9LA - 1,287,000
- Freehold Mid terrace house
W12 9LA - 822,000
- Leasehold Terrace property
W12 9LA - 1,087,000
- Freehold Mid terrace house
W12 9LA - 1,259,000
- Freehold Mid terrace house
W12 9LA - 1,088,000
- Mid terrace house
W12 9LA - 595,000
- Leasehold Converted flat
W12 9LA - 1,102,000
- Freehold Terraced
W12 9LA - 933,000
- Freehold Mid terrace house
W12 9LA - 1,038,000
- Freehold Mid terrace house
W12 9LA - 593,000
- Freehold Flat/Maisonette
W12 9LA - 1,039,000
- Freehold Terrace property
W12 9LA - 1,103,000
- Freehold Terrace property
W12 9LA - 1,108,000
- Freehold End terrace house
W12 9LA - 971,000
- Freehold Mid terrace house
